arnowals Posted February 29, 2016 Share Posted February 29, 2016 Hello, I have a problem with Fusion Pro, and hope that someone can help me. We want to print variable numbers on 4 different positions. We don't have to generate the numbers. (the numbers are all supplied) The numbers will be printed on a digital printer. With Fusion pro we want to draw 4 text frames in a pdf document (where the numbers will be printed) how can we get the numbers successively in the 4 text frames ready for print???? Best regards, Arno Wals Quote Link to comment Share on other sites More sharing options...
step Posted February 29, 2016 Share Posted February 29, 2016 We want to print variable numbers on 4 different positions. We don't have to generate the numbers. (the numbers are all supplied) So you have 1 page with 4 text frames and each text frame should return 1-4 for the first record and 5-8 for the second record and so forth? When you say that the numbers are already supplied, can you elaborate on how they are supplied? If you are printing numbers 1-20, do you have 20 records with one field or do you have 5 records with 4 fields (one for each text frame)? If it's that latter, you could just assign each of the record's fields to its respective frame. If it's the former, is altering your template so that it only has one text frame and then imposing each record 4up an option? If not, you can still make this work with a little coding but it would be easier to help if I knew what your data/template looked like. Could you collect your template and upload it to the forum? Quote Link to comment Share on other sites More sharing options...
arnowals Posted March 1, 2016 Author Share Posted March 1, 2016 Hello i have made a picture of a printed sheet wich is our template also. (see attachment, you can also see the numbers) Indeed we have 4 textframes for 1 page, each text frame should return 1-4 for the first record and 5-8 for the second record and so forth thats correct. The numbers are supplied in excel, the main issue is that we have about 480.000 numbers to print divided in 4 textframes. (thats a lot of numbers) How can we get these numbers successively in Fusion Pro. Hope that my explanation is clear? Quote Link to comment Share on other sites More sharing options...
Leosmith Posted March 1, 2016 Share Posted March 1, 2016 Hi, I believe you need to get your data in usable format with 1 record with 4 cells. to do this: Copy the data from the first column 3 more times. Delete 1 cell from column 2, 2 cells from column 3 and 3 cells from column 4. You should end up with 1 2 3 4 2 3 4 5 3 4 5 6 ...and so on. Color the first four rows different colors in excel. highlight the first four records and use the format painter by going to end of records - selecting all and format. All your rows should be color formatted. Filter on the color that has the sequencing you want and remove excess. results after filter should be. 1234 5678 9101112 and so on. Quote Link to comment Share on other sites More sharing options...
dreimer Posted March 1, 2016 Share Posted March 1, 2016 Nice trick Leo Quote Link to comment Share on other sites More sharing options...
step Posted March 1, 2016 Share Posted March 1, 2016 Hello i have made a picture of a printed sheet wich is our template also. (see attachment, you can also see the numbers) Indeed we have 4 textframes for 1 page, each text frame should return 1-4 for the first record and 5-8 for the second record and so forth thats correct. The numbers are supplied in excel, the main issue is that we have about 480.000 numbers to print divided in 4 textframes. (thats a lot of numbers) I see. The easiest thing to do is to create a template that is just the top 1/4th of that artwork with one text frame that returns the coupon number and impose it 4up (1 column, 4 rows) when you're composing it. But I guess if you're adamant about using the 4 up template, you could create a global array that holds your coupon values and shift the first value for each text frame. Create an OnJobStart callback rule that looks like this: var field = 'Coupon'; // Name of the field holding the coupon number var ex = new ExternalDataFileEx(PrimaryInputFile(),','); coupons = []; var recs = ex.recordCount; for (var i=1; i<=recs; i++) coupons.push(ex.GetFieldValue(i, field)); FusionPro.Composition.composeAllRecords = false; FusionPro.Composition.endRecordNumber = recs/4; And the rule that each text frame would return would look like this (make sure that "Re-evaluate this rule for every text flow" is checked): return coupons.shift() || ''; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.