PDA

View Full Version : Variable Input with Multiple Size Output with Multiple Quantities


Joanne Edison-Brown
January 23rd, 2013, 05:06 PM
Hello;

I am hoping somebody out there can help me figure out how to do this task I've been given to set up for one of our clients. I have usually been able to figure out how to get something done, even though I am not very familiar with Javascript, by leaning heavily on this forum and researching specific function calls but in this case, I am pretty lost. I am simply trying to do too many unfamiliar things at once.

The client would like to upload a .csv file or similar into Marcom. In the data are five fields to do with a type of sticker they need to print. Fields are:

BackgroundImage TextLine1 TextLine2 Textline3 Price Quantity

A data set might look something like this:

BackgroundImage TextLine1 TextLine2 Textline3 Price Quantity
Blue.pdf lorem ipsum dolor $2.50 50
Blue.pdf sit amet cons $2.35 22
Red.pdf adip elit sed $1.49 11
Red.pdf do eiusmod tempor $5.99 63

I've started by using BodyPageUsage rules get FusionPro to use a particular template page for each kind of sticker, based on the BackgroundImage in order to lay out the TextLines and Price with the right fonts and positioning for each sticker type. Where I am really, really getting stuck is getting each sticker to repeat itself the correct number of times, imposed on a sheet in columns, for each record in the data set.

To make matters more exciting, each sticker is a different size but I'll cross that bridge after I solve the main issue. My sales department would like to present an "all in one" orderable product whereby the client uploads the data set and we get a series of 8.5 x 11 pages with multiple repeated stickers for print and cut.

I have crawled through what feels like most of this forum looking for how to accomplish this and I've found a lot of very helpful bits and pieces but I cannot seem to assemble it all together into a single working set of rules. If anyone has the time to help me out with this, I'd appreciate it. I am currently using FusionPro 7.x.

esmith
January 24th, 2013, 09:10 AM
Where I am really, really getting stuck is getting each sticker to repeat itself the correct number of times, imposed on a sheet in columns, for each record in the data set.
If the implication is that you want to step each record multiple times on the same sheet, my guess is that you want to use a repeatable component with which I unfortunately don't have experience.

To make matters more exciting, each sticker is a different size
Sounds like using 2 pages, one for each size, would be much easier than trying to mix two items with different dimensions on one page, especially if using the repeatable components above.

P.S. If this is a repeatable composition scenario, I would appreciate the solver posting a sample job of how to pull it off for my benefit as well as the original poster's. :)