Rick J.

Thank you Thomas. Worked like a champ. I knew there was something simple to fix the issue. Thanks so much.

I've received a file that has the address, city, state and zip all in one field. It has a comma after the street address and the city. Is there a way to trim the field to remove the everything from the comma after the street address, so it only returns the street address. The filed varies in length of course so I can't use a static number to trim.

Thanks Dan! That's an awesome explanation. It helps people like me to understand better, so I can do better in the future.

Thank you Dan for the quick reply. I knew there had to be a way to get rid of the commas and decimal point, but had no idea how to go about that. Is there anyway you could just explain what (/[^\d\.]/g, '') that all means. I know it's to strip all those out, but I'm very curious as to what the symbols mean. I don't see anything that tells it to remove the commas and decimals. Thanks again. Worked perfect.

I'm working on trying to multiply a dollar amount times two. Sounds simple. The problem is the file I receive daily is a tab delimited text file where all fields have been formatted as text. My rule "2xAmt" works on amounts under $1,000.00, but I believe because of the comma any amount equal to or over $1,000.00 does not return the proper amount. I'm using the "2xAmt "rule in the "FinishingForward" rule where I'm bringing in data through javascript so the text flows properly. There is no way to get the file formatted different than it is now. I'm stuck with what I recieve for a data file to work with. Is there any way I can make this happen? Im attaching the files for review. Any help would be appreciated. Thanks in advance, Rick J. FP_AppealLtrTmplt.zip

I'm trying to move a text frame with the following FindTextFrame("Total").y -= 8400; It moves the frame, but the only problem is the moved frame is filled with a random color and the text does not show. I've attached a screenshot of what it looks like. Am I missing something in the movement of the box? How can I get this box to show the text instead of a solid color? Thanks, Rick J. Mac OS Mojave 10.6 FusionPro 10.1.11 Adobe Pro DC 2019 Adobe InDesign 2019

Maybe I should have explained it better. I would like to know if Imposer can impose one side of the sheet left to right / top to bottom and the other side of the sheet right to left / top to bottom. Does that make more sense?

I have a 2 sided name tag project and was wondering if there is any way imposer can mirror the data on one side of the sheet so that when it gets printed the names back each other up? I only have a one page FusionPro file at the moment. Thanks in advance. Rick J. OS X 10.10.5 FusionPro 10.1.11 Adobe Acrobat Pro DC 2018 InDesign 2017.1

I have a project that I need to return multiple records into one text frame. I have FusionPro 10 and have chose multi line records. I chose the field change that I need and all seems in order. My problem is the rule I made to bring in the proper fields (which change from record to record) is and if/else statement in javascript with HTML tags. There will only be one record per person and my rule works just fine but I only get one entry per frame. The data takes up to a max of about 2 inches of length, but I want to fill my 10 inch frame with as many records as will fit, then go to a new frame (page). It seems like a need a for loop of some kind and have tried some of that with no success based on my previous posts. Any idea of what may need to be done to get my rule to return multiple records into one text frame? FusionPro VDP Creator 10.0.26 Adobe Acrobat 2018 Mac OS X Yosemite Version 10.10.5

Thanks Dan for the info.

If I upgrade from FusionPro VDP Creator 9.3.36 to FusionPro VDP 10.0.26 for the Mac, would all my 9.3.36 files run in version 10.0.26? Also is there a date for the release of Version 11? Thanks, Rick J. FusionPro VDP Creator 9.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5

I'm working on a project that consists of a list of that has a ID number, date and amount. I also have 3 text frames that will hold the date and amount. Some ID numbers have more than one date and amount. I can be up to three different dates and amounts per ID number. I need each date with it's matching amount to show up individually in each text frame up to three different frames. Some ID numbers only have one, some two and some three. I only want the frames to appear when they have data, which it seems like I have that working. The problem I'm having is that when there is more than one date/amount per ID number only the first date/amount is going in all the boxes. How can I get each entry to show up in it's own frame? I have got this to work when it was all in one text frame, but I now have to return the entries each to it's own frame. I'm attaching my project to be looked at. Thanks in advance for the help. Thanks, Rick J. FusionPro VDP Creator 9.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5 FP_BenGift.zip

Any way to get this done in Version 9.3.36? I'm not seeing getting version 10 any time soon.

Sorry Dan. When I typed my version of Fusion Pro it is 9.3.36 not version 10.

I have a project where I need to list all the donations from each donor onto one or more pages. The name and address can only appear on the first page and I have that working. The Total gift amount can only appear at the end of the list of donations (weather that is on a single sheet or at the end of multiple pages) that part is not working. Also, I’m bringing back the donations, but it is bringing back all the donations for each record on each record on its own page. I can fit up to (but no more than) 32 lines of data in my “Donations” text box. The maximum lines on one sheet would be 30 separate donations, one space and the Total Gift Amount. If we have 31 or 32 donations the Total Gift Amount would be the only line on the second page. My donations text boxes take care of the amount of data that appears on each page. What I’m trying to do with the rule “ListOfDonations” is make an external copy of my input file and as long as the DonorID field match between the external and the input file, it should bring back the data for that donor. Right now, the pdf never gets created because there is something wrong with my code on the count. It gets to the end of the list and the estimated page count goes to 9300 something. I just have to stop composing at this point. The output should be as follows: DonorID 1 - 1 page with one gift with total. DonorID 2 - 2 pages. First page full, second page half full with total. DonorID 3 - 1 page full with total. DonorID 4 - 1 page with 5 gifts and total. DonorID 5 - 2 pages. first page full (32 lines of data) and second page with the Total only. The pdf should be 7 pages total. I’m attaching a zip of my project. Any help is appreciated. Thanks, Rick J. FusionPro VDP Creator 9.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5 FP_YES_Test.zip

I have a project that I’m trying to figure out. What I would like to do is have a different graphic brought into the background based on my data file. If the DN number stays the same I need a specific graphic brought in for the first time that number shows up, and then a different graphic brought in for each time that same number occurs. The YN column will determine what graphic gets pulled in for the first occurrence. There is a different graphic for Y and N. The graphic that goes on each consecutive entry (as long as the DN is the same) is the same for both the first Y and N. In other words, the “G” graphic will go on any page after the first instance of a DN number regardless of whether it is a Y or N. The pages in the output should be as follows (DN-text YN-graphic) 1 Y 1 G 1 G 1 G 2 N 2 G 3 Y 3 G 3 G 4 Y 5 N 6 Y 7 N In OnJobStart I tried to create an external data file based on my input file and then tried to call OnJobStart from inside of onRecordStart and compare the DN fields to see if they are equal. It's not working. I just get an output exactly the same as my input file. In other words, no "G" background is coming in. I'm only getting the Y and N graphics. Here’s my info: FusionPro VDP Creator 0.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5 FP_MR_Test.zip

Thanks Ste the code is working good. I have a bump in the road. I have modified my Name Add rule (that ends up getting deleted) to be tagged text that needs to be formatted with html tags. The format looks correct in the rule editor window. When I run the file the formatting is lost. Do I need to add code in the On Record Start to tell it that it is tagged text?

Thanks Ste for the help. Everything worked flawless. I realized that I have a new problem because I forgot that I have to add a text frame with data relevant to each graphic. I spent a few hours trying to get this to work with no avail. I can't seem to get the text to come back with each graphic. I tried to treat it like the graphic, but it doesn't seem work with text. What am I missing? I'm uploading a new collection with a modified Fusion Pro template and a modified data file. Thanks in advance for any help, Rick J. FusionPro VDP Creator 0.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5 FP_TribTest_1.zip

I have collected the project and attached all the files. I tried to simplify my project and now it is producing to many pages with nothing on them. What I need is any field with and "H" to bring in the "H Graphic" and the fields with a "M" to bring in the "M Graphic". Thank you for taking a look. TribTest.zip

What happened when more than one record was in my file is that it would bring in the wrong graphic on the wrong page and leave some graphics out where they were needed. I do need multiple pages per record (from 1-4 pages per record). What job files do you need me to attach to proceed. Thanks, Rick

I would like to produce multiple pages from an individual record each with different graphics based on 4 separate fields in that each record. Not all records will have all 4 fields filled with information (i.e. some may have only one field, and others may have from 2 – 4 fields and not always in order). The fields that are blank should not produce a blank page in the output file. I will only have one input file to work with. I would like all the pages to be in one pdf that I could print from it. I tried the code in this thread http://forums.pti.com/showthread.php?t=4566&highlight=compose+multiple+pages+record it somewhat works when there is only one record (still output blank pages). The minute I added a second record everything went south. Any help would be great. Here’s my info: FusionPro VDP Creator 0.3.36 Adobe Acrobat XI Mac OS X Yosemite Version 10.10.5