Jump to content

MIB

Registered Users - Approved
  • Posts

    20
  • Joined

Converted

  • FusionPro Products
    No

MIB's Achievements

Apprentice

Apprentice (3/14)

  • First Post Rare
  • Collaborator Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later

Recent Badges

10

Reputation

  1. Sorry, I corrected a small mistake in the stacking numbers in the last update. I have looked through most of the posts on here regarding impositioning and stacking and I still can't find a way for the output to match the stacking I outlined in my last update. It clearly shows the stack that I want in increments of 140 from left to right, but it still ignores it. Is this a limitation? Also noticed that numbers are missing on the output file when imposing
  2. Thanks Step. That fixed that particular issue. So, now it starts with the correct first number. The main issue still remains. When I have set the stack as follows 1 141 281 421 561 701 841 981 1121 1261 1401 1541 1681 1821 1961 2101 2241 2381 When I run my job, it displays 63751 63775 63799 63823 and so on in 24 increments What I want is 63751 63891 64031 64171 and so on in 140 increments
  3. Unfortunately not. The starting nr. in the output is 65,179 when it should be 63,751. 63,751 isn't even in the composed document. See the output it created in the attached PDFExample_Coupon.pdf
  4. Hi, I have created a 7 page coupon that I want to impose. The first 2 pages have the same number and then it increments by 1 from 2nd page to page 6, then the last page is blank. I use a rule on the first 6 pages to achieve this. Example Coupon 1 Coupon 2 Page 1 - Nr.1 Page 8 - Nr.6 Page 2 - Nr.1 Page 9 - Nr.6 Page 3 - Nr.2 Page 10 - Nr.7 Page 4 - Nr.3 Page 11 - Nr.8 Page 5 - Nr.4 Page 12 - Nr.9 Page 6 - Nr.5 Page 13 - Nr.10 Page 7 - Blank Page 14 - Blank This all works when you don't impose. Now when I create an imposition using FPI, I have 2 horizontal by 9 vertical. I want it to stack 140. When I select Stack in the first column in FPI, I type in 140, then horizontal and then vertical and it displays corrrectly on the Front sheet imposition image in FPI. Even though I state a start number ie. 1 as the first record, it will display a totally different starting number when I have composed the file. In fact that coupon number does not appear in the file!! See the attached Output PDF of what I want to achieve in the output. It's the first 8 pages If I place the stack in the last column in FPI, it doesn't deliver what I want, but at least the starting number is correct. I tried indefinite stack, but still no luck. Any ideas, clues? I have attached the FP file in the ZIP with the FPI. Examples.pdf Example-FPCoupon.zip
  5. Thanks Brad. I saw that in another post. But the problem is still there with the fonts. Hopefully, support can resolve it.
  6. FusionPro v9.2.31 on MAX OS X v10.9.4 FusionPro v9.1 on Windows 7 Professional I have the same problem on both. I have stayed on v9.1 on Windows as I work with older versions of EFI's Digital Storefront.
  7. Yes. %%[ Error: invalidfileaccess; OffendingCommand: file ]%% Stack: (w) (DL_Form_0367f2b0) %%[ Flushing: rest of job (to end-of-file) will be ignored ]%% %%[ Warning: PostScript error. No PDF file produced. ] %%
  8. Unfortunately, that's the same result. Can't distill it without an error. Also on the Fiery, it displays 1 page with part of the page and the Postscript error. It should be 172 pages.
  9. Tried it without font subsetting. No change. It doesn't distill if I want to view it as a PDF. It displays %%[ Error: invalidfileaccess; OffendingCommand: file ]%% Stack: (w) (DL_Form_0ff7bff0) %%[ Flushing: rest of job (to end-of-file) will be ignored ]%% %%[ Warning: PostScript error. No PDF file produced. ] %% Have sent the files to support, but thought I would ask here as well.
  10. Have created a document which previews correctly when composing to PDF and when composing to PostScript, with embed fonts and subset fonts enabled, it composes without error. However, when I try to print the PostScript file it on the EFI controller it displays Undefined command : SHOW, which tells me there is a font issue. I ended up replacing the fonts with standard fonts such as Arial and then it worked without issue. We're using PS for tray selection. My system is stable. It works without crashing, so appears to be no font corruptions etc. Any ideas? Suggestions?
  11. Thanks Dan. Then my rule will definitely not work as you say you can only call the page once and I want call it more than once. I want to repeat a page for each record in the XDF that matches the condition, which in this case if the 'expirydate' in XDF is = 1 then call the 'offer' page, which will be the same background for all matches, (so in effect duplicates but will contain variable data on each one taken from both DB1 and the XDF. I've noticed that I did the wrong if --- if (result > 0 && result < 1). I should simply say if (result ==1) then call the page. So for each record in DB1, it will check the XDF if the field data matches in both databases. If it does, it will then display that information ie. 'accounttype'. So in my example AccID 300 has 3 accounts in the XDF. It then runs the condition on 'expirydate' for each account that AccID 300 has. Then each one that fulfils that condition will add a page that has a new offer. So in my example below, the result I'm aiming for is that there is always a 1 page PDF for all records in DB1 and if they have matchings records in the XDF that meet the condition as explained above, the result based on the data below should be, assuming current month is September (09): AccID 100 - 2 pages (1 std + 1 offer) AccID 200 - 1 page (1 std) AccID 300 - 4 pages (1 std + 3 offers) DB1 AccID 100 200 300 XDF (DB2) AccID Expiry 100 30-10-2014 200 20-08-2015 300 30-10-2014 300 10-10-2014 300 15-10-2014 Hopefully that has clarified it?
  12. Okay, I've played around with different scenarios and added return commands to view the data, so the logic seems to work. But, of course I can't see how the page selection works until I compose the document. Whatever I do it won't select the 'Offer' page more than once if the Account holder has more than one account expiry date in the external DB that matches the condition more than once (ie. expiry date is within 1 month. So, totally stuck now. Any advice appreciated. XDF = new ExternalDataFileEx("Accounts.txt", "\t"); var returnStr = ""; currentmonth = DateFromString(Field("SendDate")); var numRecsDB2 = XDF.recordCount; { for (var recordWalker = 1; recordWalker <= numRecsDB2; recordWalker++) { if (XDF.GetFieldValue(recordWalker, 'AccID') == Field('AccID')) { expiry = Trim('\t' + XDF.GetFieldValue(recordWalker, 'Expiry')); if (expiry != "") { expirydate = DateFromString(expiry); cm = FormatDate (currentmonth, "m"); ed = FormatDate (expirydate, "m"); result += (recordWalker, ed - cm); result += '\n'; } if (result > 0 && result < 1) { FusionPro.Composition.SetBodyPageUsage ("Offer", true) } } returnStr += Trim('\t' + XDF.GetFieldValue(recordWalker, 'Accounttype')); returnStr += '\n'; } } } return (returnStr); DB1 AccID 100 200 300 XDF (DB2) AccID Expiry 100 30-10-2014 200 20-08-2015 300 30-10-2014 300 10-10-2014 300 15-10-2014 400 So for AcciD 100, that record will have an extra page called 'Offer' assuming current date 29-09-2014 AccID 200 will not AccID 300 should get the same page called 'Offer' 3 times as the accounts expire within 1 month AccID 400 does not get an extra page as its empty All work apart from AccID 300 where I only get one 'Offer' page Thanks in advance!
  13. Hi, everything works really well. It pulls in info from an external DB for each customer. But now I want to start inserting pages based on expiry dates in the external database. I have added an IF statement (see below) to compare the expiry date in the external database with the current date that is in the first DB connected to FusionPro. If 1 month or less away, I want to insert a special page that has a new offer. I have added this page to the FusionPro document and given it a Page name "Offer". It will also include some simple variable data on it. It works to the Point where each customer who has one account (1 record) in the external DB, it inserts the Offer page. But if the customer has several accounts (records) in the external DB and more than one is about to expire, it will insert the page based on the first record it finds in the external database, but will ignore the next record that also has 1 month less to expire. Any ideas? XDF = new ExternalDataFileEx("BarnDB.txt", "\t"); var returnStr = "" var currentmonth = DateFromString(Field("SendDate")) var numRecsExtDF = XDF.recordCount; { for (var recordWalker = 1; recordWalker <= numRecsExtDF; recordWalker++) { // if (XDF.GetFieldValue(recordWalker, 'AccID') == Field('AccID')) { var expiry = XDF.GetFieldValue(recordWalker, 'Expiry') if (expiry != "") { expirydate = DateFromString(expiry); var cm = FormatDate (currentmonth, "m"); var bd = FormatDate (expirydate, "m"); var result = bd - cm; } if (result > 0 && result < 2) { FusionPro.Composition.SetBodyPageUsage("Offer", true); } } } } return returnStr;
  14. Thanks Murrayc! When I changed \t to \c to use the comma delimited file, it didn't work, but it does work with \t when I create a tab delimited file.
  15. Hi, I have 2 databases where in one database (which is directly linked to the Acrobat document via FusionPro) I have customer information where each customer has a unique Account Number ie. under the heading "AccID". In the 2nd database, it is external and in the same folder as the 1st database and the Fusionpro Acrobat document. The heading "AccID" is also listed here, but also contains other data ie. SavingsType So, what I want to do is create a rule where I presume I use ExternalDataFileEx funtion to grab the data under the heading "SavingsType" when the "AccID" in the first database matches the "AccID" in the second database and then display that on the document page. Example DB 1 "AccID" "Custname" 000011 James Smith 203030 Carl Wilson Example DB 2 "AccID" "SavingsType" 200001 Easy Saver 000011 High Interest 002000 Interest MAX 203030 Platinum Account Have looked at various examples, but still haven't managed to pull it of. Thanks in advance!
×
×
  • Create New...