bkurzbuch

Thanks Dan I wasting to add it where the red text is in my previous post. My bad. As always thanks so much.

I need to add a "%" after the Disc field in a table. I tried a couple of options but I'm missing something as I always get a error on validation. Thanks for your help var myTable = new FPTable; myTable.AddColumns(5760, 21168, 4536, 4536); for (var i = 1; i <= 20; i++) { var item = Field("Item " + i); var desc = Field("Desc " + i); var disc = Field("Disc " + i); [color="Red"]Insert % after this field [/color] var price = Field("Price " + i); // There 2 different triggers to not include a row. // 1. data is blank for that row. if (!item && !desc && !disc && !price) continue; // 2. The "Disc" field is zero. if (Int(disc) == 0) continue; // 3. The "Disc" field is zero. if (Int(disc) == 5) continue; var row = myTable.AddRow(); var cell = row.Cells[0]; cell.SetBorders("Thin", "Black", "Bottom"); cell.Margins = new FPTableMargins; cell.Margins.Top = 25; cell.Margins.Bottom = 25; row.CopyCells(0, 1,2,3); cell.Margins = new FPTableMargins; cell.Margins.Top = 25; cell.Margins.Bottom = 25; cell.Margins.Left = 350; row.CopyCells(0, 1); row.Cells[0].HAlign = "Left"; row.Cells[1].HAlign = "Left"; row.Cells[2].HAlign = "Center"; row.Cells[3].HAlign = "Center"; row.Cells[0].Font = "News Gothic Bold"; row.Cells[0].PointSize = 6; row.Cells[1].Font = "News Gothic Regular"; row.Cells[1].PointSize = 7; row.Cells[2].Font = "News Gothic Bold"; row.Cells[2].PointSize = 7; row.Cells[3].Font = "News Gothic Regular"; row.Cells[3].PointSize = 7; row.SetContents(item, desc, disc, price); } return myTable.MakeTags();

Thanks Dan I figured it was. If it becomes a problem I'll revisit this post. Thanks

We just recently upgraded to FusionPro 11.1 from 10 and I'm getting a error message on ever job and just want to understand why. The message is "Unknown Tag no_tag ignored". Thanks for your help

Thank You SOOOO much for your time. NOW it makes since to me. thanks again and stay safe Obi-Wan

Thank You Dan. I see where I was inserting my code incorrectly. I wasn't adding the 4 fields in the correct spot. Thanks again for all your help. Invaluable!! If you don't mind. Can you explain the comments below I've added so i get a better understanding of this code. var myTable = new FPTable; myTable.AddColumns(5760, 21168, 4536, 4536); for (var i = 1; i <= 20; i++) [color="Red"]Var i=1 What does i mean or denote? the next <=20: i++)this tells it to loop trhough 20 lines, but what does i++ mean or denote.[/color] { var item = Field("Item " + i); var desc = Field("Desc " + i); var disc = Field("Disc " + i); var price = Field("Price " + i); // There 2 different triggers to not include a row. // 1. data is blank for that row. if (!item && !desc && !disc && !price) continue; // 2. The "Disc" field is zero. if (Int(disc) == 0) continue; var row = myTable.AddRow(); var cell = row.Cells[0]; cell.SetBorders("Thin", "Black", "Bottom"); cell.Margins = new FPTableMargins; cell.Margins.Top = 25; cell.Margins.Bottom = 25; row.CopyCells(0, 1,2,3); cell.Margins = new FPTableMargins; cell.Margins.Top = 25; cell.Margins.Bottom = 25; cell.Margins.Left = 350; row.CopyCells(0, 1); row.Cells[0].HAlign = "Left"; row.Cells[1].HAlign = "Left"; row.Cells[2].HAlign = "Center"; row.Cells[3].HAlign = "Center"; row.Cells[0].Font = "News Gothic Bold"; row.Cells[0].PointSize = 6; row.Cells[1].Font = "News Gothic Regular"; row.Cells[1].PointSize = 7; row.Cells[2].Font = "News Gothic Bold"; row.Cells[2].PointSize = 7; row.Cells[3].Font = "News Gothic Regular"; row.Cells[3].PointSize = 7; row.SetContents(item, desc, disc, price); } return myTable.MakeTags();

Is it just me or does ever complex variable jobs information common in bits and pieces as you work on it. Ugh. Ok - Off the soap box. Uncle, Help!! I've tried unsuccessfully to incorporate the loop. Kinda flying blind when i don't understand the code. My updated code is below. This output the first row perfectly matching the customer originals. Now to get the rest to fill. Now the wrinkle. The data runs out to 20 rows. There 2 different triggers to not include a row. 1. data is blank for that row. 2. The "Disc" field is zero. Now if you cycle through the data you will see that some of the "Disc" lines say "Number 0". This is bad data and we want to show it like this so the customer can see there data needs to be cleaned up. There is also other spelling error and such, all of which they need to see. And of course the due data is moved to Monday. Thanks for all the help. Code away. new FPTable; var myTable = new FPTable; myTable.AddColumns(5760, 21168, 4536, 4536); myTable.AddRows(17); myTable.Rows[0].Cells[0].SetBorders("Thin", "Black", "Bottom"); myTable.Rows[0].Cells[0].Margins = new FPTableMargins; myTable.Rows[0].Cells[0].Margins.Top = 25; myTable.Rows[0].Cells[0].Margins.Bottom = 25; myTable.Rows[0].CopyCells(0, 1,2,3); myTable.Rows[0].Cells[0].Margins = new FPTableMargins; myTable.Rows[0].Cells[0].Margins.Top = 25; myTable.Rows[0].Cells[0].Margins.Bottom = 25; myTable.Rows[0].Cells[0].Margins.Left = 350; myTable.Rows[0].CopyCells(0, 1); myTable.Rows[0].Cells[0].HAlign = "Left"; myTable.Rows[0].Cells[1].HAlign = "Left"; myTable.Rows[0].Cells[2].HAlign = "Center"; myTable.Rows[0].Cells[3].HAlign = "Center"; myTable.Rows[0].Cells[0].Font="News Gothic Bold"; myTable.Rows[0].Cells[0].PointSize=6; myTable.Rows[0].Cells[1].Font="News Gothic Regular"; myTable.Rows[0].Cells[1].PointSize=7; myTable.Rows[0].Cells[2].Font="News Gothic Bold"; myTable.Rows[0].Cells[2].PointSize=7; myTable.Rows[0].Cells[3].Font="News Gothic Regular"; myTable.Rows[0].Cells[3].PointSize=7; myTable.Rows[0].SetContents(Field("Item 1"), Field("Desc 1"), Field("Disc 1"), Field("Price 1")); return myTable.MakeTags();

Thank You all for the quick Reply. I'm Familiar with "for loop" concept just not how to code it. Thanks Dan. i know its hard not to code it. i have a couple of question already, but I'm going to work with this today and see what other questions arise. It may come to helping with the code as I can learn just by see what it should be. Also thanks for the JavaScript Table API – The Basics post. This was a huge help in getting me started. thanks again

Coding my first table from scratch and need some advice. Mac - 10.14.6, FP 10.1.11 and latest Acrobat DC. I've attached a zip file of the job to help. There is a pdf labeled customer original to show what the output should be. The table is 4 columns and no more than 17 rows. The data file is imported, not XDF and the data for the table is set up in cell by cell and row by row. You'll see in my template that I have the first row formatted, except for adjusting margins and alignment to match the sample. Since I am finding myself repeating a lot of code, thought i would ask for help. This will be a monthly job so I'm trying to cover all the bases right out of the box. Is there a way to copy all that formatting to the rest of the rows? It will be the same as row zero. My coding skills are minimal at best. My other question is if there is no data can i just use the skip row function or is there a better way. For once I have a few days on this and am using it as a good learning tool, so if you can just point me in the right direction instead of coding for me that would be great. As always thanks for the help.Table_Advise.zip

Thanks Dan Thats what i thought, but never hurts to ask. Stay safe

Am I missing something really easy? Is there a way to export a FusionPro template from Indesign as spreads instead of single pages. I've tried everything I can think of but no spreads. Thanks for the help

Thanks Dan. I found it in the users guide. Very handy

Thanks Dan. That is my next stop. To see if I can find a font thats close to this. A inline graphic has always given me trouble with getting the base align just right. What do you mean by Repeatable Component? Thanks

What would be the best way to tackle this variable. I've attached a screen shoot of a Indesign file I'm doing the variable for. There are 4 lines of variable with a percentage point. If that line is zero it does not print and the rest of the text moves up. No problem, done this before. Whats throwing me off is the little icon in front of each variable line. The cross is a font in white with a small circle drawn behind it. Would a inline graphic work best? Thanks for any help or advise.

In the text editor. Set the second line indent to the same amount as your tab. That should fix your problem.

Thank You I've added my code to the excessing rule but am getting a syntax error on line 4 and I don't understand why. Thanks for your help. FusionPro.Composition.SetBodyPageUsage("front", IsPreview()); if (Field("Imprint Line 2")) == "" { SetBodyPageUsage("back_1",true); SetBodyPageUsage("back_2",false); } else { SetBodyPageUsage("back_1",false); SetBodyPageUsage("back_2",true); }

I'm having trouble with the syntax for a page usage rule and where to apply it. I have a 3 page document with 2 different backs. If field-2 is not blank use page back_2, if field-2 is blank use page back_1. Since you can have only 1 On Record start rule i believe. I already have a rule to suppress the first page on press output in Marcom. Listed below. Do i just add my page usage rule to it? Thanks For the help. FusionPro.Composition.SetBodyPageUsage("front", IsPreview());

Has anyone worked with integrating SalesForce Lighting with Marcom? We have a customer who uses it and would like us to implement it. PTi was great in getting me a answer on using SalesForce with Marcom and the manual, but I've received little in the way of a response from Salesforce. Just looking any thoughts, tips or problems people have run across with using SalesForce. Thank You.

OMG - That falls under DA. Thank You

I have a field called "Access Code" that will always be 5 numbers followed by 3 letters. 12345abc. The customer would like to pull just the last three letters in one spot on there flyer. The trim field code I have is below, but I'm getting a error "no value returned". I can't for the life of me figure out whats wrong with my code. Any help is greatly appreciated. Right(Field("access code"),3);

Works great Dan. One quick question. The old rules returned a tab in front of "Dr." and another tab in front of "Tel". I've tried coding them back in but I can't seem to get the syntax correct. Any advise? Thanks Again.

Dan Thank You too much. Ya, I know its not the "Ask Dan Forum". With a problem this complex I figured you where the only one who could help. Thank You Obi-Wan. My next stop was support. Thanks again for taking the time to look at this and the explanation. Seems the more I learn about javascript the more i realize how much I don't know. You are the man.

Mac Sierra 10.12.6, Acrobat 11.0.23, FusionPro 9.3.36. 32 Gigs memory Dan I'm having trouble with a large XDF and error line 10: out of memory. The jobs loads a list of providers and them compares the mailing list to the XDF and returns the 3 closets office using Long & Lat. This file has worked fine in the past with the provider list being around 13,000 records. The new provider list from the customer is 194,092 and won't process. Customer has assured me that this list is correct. Since this is using Long. and Lat I'm not sure how and if the provider file can be split. File attached. Any help is greatly appreciated. Thank You DD Prevent Services2 No Current Dentist Ltr_ccg.zip

Hi Dan Thanks for the response. After further testing, yup it is working as expected both when I compose and in Marcom. Just for my own knowledge. How come it doesn't show correctly when you use the preview template palette in acrobat? I ask because I had a similar job that I used a switch rule for the pages and it showed my preview correctly. The code is below so you know what i mean. It was a smaller job with only 12 pages and it would show me a preview of the correct page and no preview if not. As always thank you very much for your time. Great appreciatied. switch (Field("Letter Type")) { case "ARNOT18 YP1 ACH-CC SNGL T": FusionPro.Composition.SetBodyPageUsage("1",true); FusionPro.Composition.SetBodyPageUsage("2",true); break; case "ARNOT18 YP1 ACH-CC INST T": FusionPro.Composition.SetBodyPageUsage("3",true); FusionPro.Composition.SetBodyPageUsage("4",true); break; case "ARNOT18 PHY-RES ACH-CC SNGL": FusionPro.Composition.SetBodyPageUsage("5",true); FusionPro.Composition.SetBodyPageUsage("6",true); break; case "ARNOT18 PHY-RES ACH-CC INST": FusionPro.Composition.SetBodyPageUsage("7",true); FusionPro.Composition.SetBodyPageUsage("8",true); break; case "ARNOT18 PHY ACH-CC INST T": FusionPro.Composition.SetBodyPageUsage("9",true); FusionPro.Composition.SetBodyPageUsage("10",true); break; case "ARNOT18 PHY ACH-CC SNGL T": FusionPro.Composition.SetBodyPageUsage("11",true); FusionPro.Composition.SetBodyPageUsage("12",true); break; default: ReportError("Can't set pages for Letter Type: " + Field("Letter Type")); }

I have several jobs I need to assemble like this job, so if anyone has a better way to do this please don't hesitate to speak up. FusionPro 9.3.36, Mac OS Sierra 10.12.6. I have a 80 page document of cards that are state specific. The code looks like "AZ-ART-TR-E", "CA-ART-TR-S" so on and so forth for all 40 versions. With the first 2 characters being the state and last one being English or Spanish.I have named each page with there code like this "CA-ART-TR-S Front" and "CA-ART-TR-S Back" and all are set to unused. My code is below and set for on record start, but when I preview template it is showing all pages as I scroll through instead of just the page called for by "Version". I can't see what I'm missing to get this to work. Thanks in advance for your help. FusionPro.Composition.SetBodyPageUsage(Field("Version") + " Front", true); FusionPro.Composition.SetBodyPageUsage(Field("Version") + " Back", true);