Jump to content

Murrayc ARCAS

Registered Users - Approved
  • Posts

    4
  • Joined

Converted

  • Location
    Regina

Converted

  • Occupation
    Director of IT

Converted

  • FusionPro Products
    Yes

Converted

  • FusionPro VDP software version
    Desktop 9.3.36

Converted

  • OS
    Windows 10

Converted

  • Acrobat Version
    Acrobat DC

Murrayc ARCAS's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

10

Reputation

  1. please disregard previous post, it turned out to be an issue with the original PDF background, nothing to do with FusionPro.
  2. I am having an odd problem, and wondered if anyone was aware of something similar. We need to print a client's T4 statements, and we start with a duplex form provided by the government of Canada (T4a-17e ) I then create data, and a Fusion pro layout. the screen view shows just fine, but when we compose the VDP file, If I compose more than 1 record, some of the boxes in the PDF background do not print. We do not have any Fusion Pro resources over tob of the boxes, they just don't print anyway. ! record composed gives all the boxes just fine, any time I compose 2 or more records worth of PDFs, some boxes do not show up when printed. I have collected the job using sample data, and was wondering if anyone has seen similar issues with VDP or not. G5002_SPP_2017_T4a_BATCHES.zip
  3. Sorry if this has been asked and answered before, but I searched on 'Pro DC' and didnt find anything. Adobe Creative Cloud wants me to update from Pro XI to Pro DC. Are there any known issues with this, or should I just refuse the update?
  4. I think this is what you want. I find that FP can use ( in your example ) DB1 through ODBC just fine, but you will need to use ExternalDataFileEx for DB2 for DB2 you need to open the file, and remember that columns, if referenced by the number, not name, start their numbering at 0. What I do below is just bring the relevant row(s) into a tabbed line, with a newline at the end of the row. This way I simply return the recordwalker contents to a text box, and set the tabs for that text box as I need them. I assume you may have more than one row in DB2 with the same AccID, and this is why you are not using only one file. 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 000011 Easy Saver The above would return : 000011 High Interest 000011 Easy Saver for AccID 000011 Copy and paste the text below into a an empty Javascript rule, and you should be good to go XDF = new ExternalDataFileEx("..\\DB2.txt", "\t"); var returnStr = "" var numRecsExtDF = XDF.recordCount; { // this will go through the entire DB2.txt file, from first row to last for (var recordWalker = 1; recordWalker <= numRecsExtDF; recordWalker++) { // If the value of the first column in XDF equals the value of your current record's value for AccID, then start grabbing the field values you want // build to suit, but this works for me. // Note: you can use XDF.GetFieldValue(recordWalker, 0) or XDF.GetFieldValue(recordWalker, 'AccID') interchangeably, whichever you prefer if (XDF.GetFieldValue(recordWalker, 0) == Field('AccID')) { returnStr += XDF.GetFieldValue(recordWalker, 'AccID'); returnStr += '\t' + XDF.GetFieldValue(recordWalker, 'SavingsType'); returnStr += '\n'; } } } return returnStr;
×
×
  • Create New...