rsheldon

Good Morning Everyone, I am having issues with an external database composing records when using FusionPro Server. I am using Mac OS 10.15.7, Adobe Acrobat DC 2021, FusionPro VDP Designer 12.0.2. I have and onjob start rule that pulls in the external database (see below) externalDF = new ExternalDataFileEx('196176_IDM_22NB JAN NEWSLETTER FINAL DATA.txt', '\t'); if(externalDF.valid != true) { Print('Failed to link to the external data file in OnJobStart'); } When I preview on screen, everything looks correct, however when I compose a record or several records, the external database does not print. What am I missing? Thank You, Rob Sheldon

Good Afternoon, Up until recently, when I created a multiple output file, I allowed FusionPro to add the appendix number to the file (i.e., 19214_MARCOM_S01-1). My Production Manager would like to see the record count in the file name (i.e., 19214_MARCOM_S01_records 1-1000, followed by the next set of records 19214_MARCOM_S01_1001-2000 and so on.) How do I achieve this? I am currently running Mac OS 10.15.7, Adobe Acrobat Pro DC version2021, FusionPro® VDP Designer 12.0.2. Thank You, Rob

Thanks Dan, The error that pops up when I try to use the font Zapf Dingbat says "Unable to change the elected text to font "Zapf Dingbats". Do you want to insert a variable to change the font instead? Yes or No. I was able to use Wingdings. I composed a few records and when I went to look at the PDF I got a warning about the font Times Roman containing invalid encoding, some characters may not display. Haven't had this before, is it because I am now using FusionPro server?

Any thoughts on the font issue, I also tried Zapf dingbats and that did not work either.

Thank you for the Screenshot...

Good Morning, I am running FusionPro 12.0.2 in Acrobat Pro DC on Mac OS 10.13.6. I have loaded my fonts from Suitcase Fusion 6 and loaded them into FusionPro, restarted both Acrobat and FusionPro and the font Monotype Sorts which is a .ttf font does not show in the variable text editor font selection. I also have an issue with the preview selector only allowing 100 records to preview, I have not tried to compose the file which is 13,000 plus records but have a feeling that I will not be able to compose the complete file.

I have added the length rule to my initial rule and everything seems to work. I have reached out to the mailhouse that created the routing number and asked them to remove the check digit. The total mail count is 500k and would like the responsibility of the data to be on the mailhouse.

Normally I use the alpha, which is supplied by my internal Mailing department. In this instance, I am being supplied a list by an outside vendor. The routing number is 12 digits instead of 11 causing the overall field count to be 32, which results in an error, the routing string bad length

Hello, I do not have a reply to this post, just another question concerning the routing number. I am getting a routing number error, the routing number consists of 12 digits. From what I am seeing, there is the Zip, Zip+4, DP and a check digit. What do I need to do to create a usable IMB barcode? I am currently running OS 10.12.6, using arobat 11.0.15 and FusionPro 9.3.15. The rule I am using is: var trackingStr = "00" + Field("SRVTYPEID") + Field("MAILERID") + Field("IMBSEQ"); return EncodeOneCodeBarcode(trackingStr, Field("Z4, ZIP+4/D"), 14); The SRVTYPEID is 271, Mailer ID is 006002, IMBSEQ is 616463872 and the routing number is 12672512581 Thanks in advance, Rob

Thank you David, I had to change the Len portion of the rule but removing the "." and then searching the length works. I have tested on names like A.J., Ed, Al, A., A. Jacqui, etc.

Good Morning, I am using VDP Creator 9.3.15 in Acrobat 11.0.13 on a Mac OS 10.10.5. The problem I am having is creating a rule that searches the first name field for any letter and a . and replaces with the field prefix and field last name. currently I have a rule that is written: { if (Len(Field("FIRST NAME"))<=2) return "Dear "+ToTitleCase(Field("PREFIX"))+"."+" "+Field("LAST NAME")+","; else if (Field("FIRST NAME")!="") return "Dear "+Field("FIRST NAME")+","; else return "Dear "+ToTitleCase(Field("PREFIX"))+"."+" "+Field("LAST NAME")+","; } This works, but if the first name is "Al" or "AC", the rule returns prefix and last, but my client would like the first name

Thanks Dan, This works...sometimes you can't see the forest through the trees. Thanks as always for getting me out of a tough spot.

I apologize, I forgot to mention that I am using a Mac 10.8.5 running Acrobat 10.1.14 with FusionPro 9.1.0

Good Afternoon All, I am trying to create a full service IMB using the font USPSIMBCompact. My original attempt to create this barcode was: var trackingStr = "00" + Field("MAILERID") + Field("SRVTYPEID") + Field("IMBSEQ"); return MakeOneCodeBarcode(trackingStr, Field("Z4, ZIP-4D"), 14); But my result used the font IDAutomationState. I know this is part of the coding in the return MakeOneCodeBarcode. I then tried to format the font by converting to javascript, as seen in the amended code below: var Var1 = "00" + Field("MAILERID") + Field("SRVTYPEID") + Field("IMBSEQ"); var Var2 = "Z4, ZIP-4D"; var Var3 = ""; var v_tracking = "5"; var v_font = "USPSIMBCompact.ttf"; var fontTag = false; var Var4 = ""; if (Var1.length != 20) ReportWarning("The tracking number is not the correct length of 20 characters in record number " + CurrentRecordNumber() + "."); if (Var2 != "") { if ((Field(Var2).length != 0) && (Field(Var2).length != 5) && (Field(Var2).length != 9) && (Field(Var2).length != 11)) ReportWarning("The routing number is not the correct length of 0, 5, 9, or 11 characters in record number " + CurrentRecordNumber() + "."); RoutingNum=Field(Var2); } else RoutingNum=""; return '<tracking newsize="' + v_tracking + '">' + MakeIntelligentMailBarcode(Var1, RoutingNum, Var3, fontTag, v_font, Var4) + "</tracking>"; This code works except the font is 10pt and I need it to be 14pt. I do not see where I can change the font size in the code. Also the font USPSIMBCompact does not preview or compose. Any help would be greatly appreciated! Thanks, Rob Sheldon

I need to know if we can round up or down based on the decimal for another job now. Can someone please let me know? i.e., $10.02 to $10 or $10.50 to $11.

Thanks Dan for taking a look at this for me. I have reached out to a caging house as well. This is where they check the scanline. I figured if they couldn't tell me, I am in deep deep trouble. From what I was reading in the scanline instructions: A = 3o, B = 31, C = 32 all the way to Z = 55, but I am still lost.

Good Afternoon Dan, The Scanline is an alphanumeric string of text like the sample I gave. It uses the font OCR A. So yes, just a string of text, no barcode. I have received a few scanlines from other clients, but they come in already formatted in excel. Unfortunately with this one, I am creating from 2 fields in the database. The instructions I received are in the attached .xls file Scanline.zip

Good Afternoon Everyone, I am not sure that this is the correct forum to be on, but I will ask anyway. I am using VDP 9.1 in Acrobat 10.1 on iOS 10.8.5. I have a client that has sent in a database that I need to create a Scanline using 2 fields. The data is alphanumeric, and I need to create a Check Digit using a Mod10 with weights of 2, 1, 2, 1. Sample data is: Field 1 Field 2 CON135627 U14B1DDBMR The result is 0CON135627 U14B1DDBMR8, with 8 being the check digit. I am so confused

Thank You Alex and Dan for the quick reply. Alex, you asked if I used the "Insert Picture Rule", what I had done was to bring in all my resources and used a switch graphic rule. The job I am working on is a reoccurring job where I usually just import new data. This time however, the variable images were not previewing in Acrobat prior to composition. After composition of the file, all graphics previewed. Dan, you asked about composition. I composed the file in VDP to a pdf and everything previewed. I did not receive any error messages. I did add a path in the advanced tab, and I did get the previews to work in acrobat. Funny, I never had to do this before. The other interesting thing is that I get the same issue (no preview), even with a brand new job. From this point on, I guess I will have to set the path in the Advanced tab. Thank You, Rob:)

Good Afternoon everyone, I am running VDP 9.1 on a Mac (OS 10.8.5) using Acrobat 11. I am having issues previewing variable graphics. The files compose correctly. I have read posts saying to add the images to the same folder that holds VDP template. This works if there are only a few images, however with the template I am working on now, this will not work. Any help will be greatly appreciated

Good Morning David, Thank you ever so much for your reply. I have created a rule based off of the function you posted and everything seems to be working great. You hit the nail right on the head. It is a wonderful thing being able to post to this forum knowing someone out there has encountered the same issues you have and their willingness to share their solutions. Thank You again, Rob Sheldon

I am using FusionPro 9.0.3 in Acrobat 10.1.8 on the Mac running OS 10.8.5. I am trying to use the math function to round up an entry in my database to the nearest $5 amount (i.e., $6.00 to $10.00) I need help writing a rule to do this. The second part of the equation is to take the same number (i.e., $6.00) multiply this by 1.5 and then round up to the nearest $5.00 amount (i.e., $6.00 x 1.5 = 9.00, but needs to equal $10.00)

Good Morning Dan/Thomas, Please allow me to start over. The issue I am having is: I need to create a dynamic border that will go around variable text box. The variable text box has some static information along with a OnJobStart callback rule: Make any changes to your designees on this form or include the changes on a separate sheet of paper. (Static text) «Designee Rule_2» (OnJobStart_Rule) If you have a change in the Point of Contact, please be sure to note this on this list. (Static Text) The Designee Rule I posted originally minus the callback string, I then posted the callback string. I am attaching a sample collected file (test data, PDF). I am thankful for all the help. I am using FP7.2pk in Acrobat 8 on a Mac.

I have the OnJobStart rule in a variable text box along with some static information. I am trying to create a dynamic border that will grow vertically as more addresses are added. Some records only have 1 address, whereas others have 7 or more addresses.

Thank You Thomas for your reply, you are correct, this was not the entire Callback, the beginning to the callBack is: externalDF = new ExternalDataFileEx('Prolist_CORP_Roster_File_20121101.txt', '\t'); if(externalDF.valid != true) { Print('Failed to link to the external data file in OnJobStart'); }