FusionPro Output by Qty Sets

Started by Slappy, February 04, 2025, 07:06:21 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Slappy

This may be a foolish attempt but, I have let's say 4000 records & I want to be able to output them (imposed) in non-equal sets. They have a unique code on each but it doesn't matter which codes go in which sets. So for Example:

Set 1 – Qty 125
Set 2 – Qty 55
Set 3 – Qty 30
Set 4 – Qty 45
Set 5 – Qty 200

Additionally I have a 2nd spreadsheet with the Locations info ea Qty will ship to & have been messing with having those locations appear on the slug area & also as a Slip Sheet at the beginning of each set. Moderate success there.

Basically I'm trying to save bindery from having to hand-count out the sets for each Location. And it should be doable - right?
A little diddie 'bout black 'n cyan...two reflective colors doin' the best they can.

Slappy

TL;DR

I suppose I could just "math" the location sets & output put them all manually with a description in the file names, but where's the fun in that??
A little diddie 'bout black 'n cyan...two reflective colors doin' the best they can.

scottrsimons

If you put in your data a field called "keycode" or something like that, you could create a new Rule in FusionPro called 'OnRecordStart'.

if (FieldChanged("Keycode"))
 FusionPro.Composition.OpenNewOutputFile("FileName"+Field("Keycode")+"."+FusionPro.Composition.outputFormatExtension);

And this rule will create a new file each time the field "keycode" changes.

I am not 100% if it will work with Impositions or not. Can't remember if I've done that or not. I'm old.
"Your superior intellect is no match for our puny weapons!" - Homer J. Simpson

Slappy

Hmmmmm, been banging away at it on & off today - can't get a split output. Generates this error when Composing, still creates a PDF, just of the entire data set in one file. Attaching a small section of the data set too.
A little diddie 'bout black 'n cyan...two reflective colors doin' the best they can.

Slappy

Ah, I just changed it to use that code snippet in "OnRecordStart" instead & added the "Output each page as its own Record" Rule too. Now I get 3 Distinct PDFs - but it's not seeing the other five sets that are defined in the data...

Closer.
A little diddie 'bout black 'n cyan...two reflective colors doin' the best they can.

DCurry

I don't miss FusionPro. Sure it's powerful and can do an awful lot and is a lot of bang for the buck, but you have to know JavaScript to really make it sing.

It's been a decade or more since I've used it, but I remember loading fonts was a pain and working directly in Acrobat sucked. 
Prinect • Signa Station • XMPie

Build a man a fire, and he'll be warm for a night. But set a man on fire, and he'll be warm for the rest of his life!

DigiCorn

I've worked with FusionPro and I've worked with XMPie and believe you me, FP is so much easier to deal with it's not even funny. Yeah, you do have to script a bit to do some special stuff, and it's not as powerful as XMPie, but if you're working with a small amount of records you can run it all locally instead of uploading to here and downloading from there. Also, you can preview while you're working instead of having to jump through a bunch of hoops first.
I don't feel tardy...

DCurry

I'm currently using XMPie and find it infinitely easier. It's just the desktop version so no uploading files anywhere. It can be a little slow for bigger jobs that way but after having used it for the past year or so I really like it. 

Funny you say that FP is not as powerful as XMPie. I think they are about the same but maybe the server version has more abilities. 
Prinect • Signa Station • XMPie

Build a man a fire, and he'll be warm for a night. But set a man on fire, and he'll be warm for the rest of his life!

DigiCorn

FP is good for, say, up to 50,000... maybe 100,000 records. XMPie is good for stuff bigger than that. If you have a local XMPie server, than that's good... but the price tag is probably about 10x higher than FP.
I don't feel tardy...

scottrsimons

Quote from: Slappy on February 05, 2025, 12:50:49 PMAh, I just changed it to use that code snippet in "OnRecordStart" instead & added the "Output each page as its own Record" Rule too. Now I get 3 Distinct PDFs - but it's not seeing the other five sets that are defined in the data...

Closer.
It might be that the two rules are fighting each other, or your keycode field only has three options. When working on a job like this, I dup my data file, and then in the dup I use Excel to remove all duplicates in the keycode field. And test with that data. That way, I only have a few lines of data, and I should have the same number of outputs. If not it's quicker and easier to track down the issue.

If you want, send or post both of the rules and a slimmed-down data set, and I will test them.
"Your superior intellect is no match for our puny weapons!" - Homer J. Simpson