Jump to content

LyndaEngelage

Registered Users - Approved
  • Posts

    51
  • Joined

Everything posted by LyndaEngelage

  1. Thanks for the reply. One thing though, it doesn't stop at the "End" number in the data. What I'm actually needing is for each Location to start a new pdf. For example. When Adams County Health Department ends with 23 pages, a pdf is created and a new pdf is started with Boone filling the 45 pages with the range of 95701-95706 to 101095-101100, and down the list of rows of data. I revised my files, do you know why the "Adams" location doesn't end with 95700 (or specifically 95695 - 95700)? The next Record "Boone" doesn't start with 95701 either. 167888-1_WIC_Log_Bk_FP.zip
  2. I'm coming back to this project a year later. I have a question. When I compose the "log book" pages, it doesn't fill out the last page with the remaining range that is in the On Record Start Rule. It stops at page 22. There should have been one more page with the remaining ranges. Does it have to do with the var lines_per_sheet? Any Ideas? I have attached my collected project. Mac OS Monterery InDesign 2022 AcrobatPro 2022.003.20258 FusionPro Designer 12.1.3 On Record Start Rule: var start_number = 93001; var largest_number = 95700; var range_between = 5; var lines_per_sheet = 20; var iterate = (FusionPro.Composition.outputRecordNumber -1) * (lines_per_sheet * (range_between +1)); var sequence = ""; for (i = 0; i < lines_per_sheet; i++) { sequence += "<t>" + (start_number + iterate) + "<t>-<t>" + (start_number +iterate +range_between) + "<br>"; start_number += (range_between +1); } FindTextFrame("numbers").content = sequence; FusionPro.Composition.repeatRecordCount = ((largest_number -start_number +1) / (lines_per_sheet * (range_between +1))) +1; 167888-1_WIC_Log_Bk1_Adams_FP.zip
  3. With a little help from a co-worker we figured it out by converting an existing rule and making edits to it as follows // Rule converted from XML Template "QR Barcode Rule: Numbering": // Choose the following values: // Begin XML Template selections // //var FieldOrRuleToEncode = "Numbering"; // "Data field or rule to encode" (Required): FieldOrRuleList var data = "222222222" + FormatNumber("00000", number1++); var EncodingMode = "Byte"; // "Encoding mode" (Required): PickList ["Byte" (All characters), "AlphaNumeric" (Alphanumeric only), "Numeric" (Numeric only)] var ErrorCorrectionMode = "M"; // "Error correction" (Required): PickList ["L" (Low), "M" (Medium), "Q" (Quality), "H" (High)] var PreferredFormat = "0"; // "Format (symbol size)" (Required): PickList ["0" (0 (automatic)), "1" (1 (21x21)), "2" (2 (25x25)), "3" (3 (29x29)), "4" (4 (33x33)), "10" (10 (57x57)), "40" (40 (177x177))] var PointSize = StringToNumber("6 pt"); // "Font size (defaults to 10)": PointSize var NoFontTag = false; // "Suppress <f> (font) tag": CheckBox var Font = "IDAutomation2D"; // "Font": FontList var ProcessTilde = false; // "Process tilde (~) escapes": CheckBox // End XML Template selections // var DataToEncode = data; return MakeQRBarcode(DataToEncode, ProcessTilde, EncodingMode, ErrorCorrectionMode, PreferredFormat, PointSize, NoFontTag, Font);
  4. I created a QR Code that has an account number (static) and a numbering system for 5 positions on the same page. The following works but I need it sized a little bigger. Is this possible? Changing the point size in text editor doesn't do the trick. var data = "222222222" + FormatNumber("00000", number1++); return MakeQRBarcodeGraphic(data);
  5. Thanks Dan, I need the Color Change rule to apply to all except the one record AND the text frame containing the phone, email, and address. Where specifically would I insert the "if" statement so it only affects the one record and text frame? // BEGIN: Rule converted from XML Template "Color From Data": { // Overrides a color based on a data field value. // Please specify the appropriate values. // Begin XML Template selections // var FieldName = "BC Type Color"; // "Choose the field containing the color specification (RGB or CMYK):" (Required): FieldList var ColorName = "Custom"; // "Choose a color to override:" (Required): ColorList // End XML Template selections // var colorData = Trim(Field(FieldName)).replace(/^#/, ''); // strip leading pound/hash sign var parts = colorData.match(/[\d\.]+/gi); // decimal numbers, with non-numeric delimiters if (colorData.match(/^([0-9a-f]{6}|[0-9a-f]{8})$/i)) // 6 or 8 hex digits parts = colorData.match(/[0-9a-f]{2}/gi).map(function(val) { return parseInt(val, 16) / 255 * 100; }); if (parts.length < 4) parts.unshift("RGB"); //return parts; // TODO: Validate 3 parts for RGB, 4 parts for CMYK, and ranges. if (parts.length < 4) parts.concat([0,0,0,0]); parts.unshift(ColorName); CreateFusionProColor.apply(null, parts); FusionProColor.prototype.changeFrameBordersAndFills = true; } // END: Rule converted from XML Template "Color From Data"
  6. I have several business cards that use the Event Rule, On Record start "Color From Data" which works great. But now I have a customer that wants his name and title as is using the "Color From Data" Rule and then his phone, email and address as black. Is there a way to override the "Color From Data Rule for this particular card without messing up all the rest of the cards. I use FusionPro Designer 12.1.3 on a Mac M1 using Monterery OS.
  7. Thanks for the reply, Dan. I didn't even try composing, just assume it wasn't working.
  8. I ended up using a rule to insert a graphic image of the character return '<graphic file="Arrow two-tone right glyph.eps">' but would still like to know why what you see in the text editor window doesn't match the preview or composition.
  9. Anyone know how to get this character to work? The left is how it's previewing, the right is in the text editor window. The Font is wingdings. Using FusionPro 12 on a Mac. (see screenshot)
  10. I'm needing a rule to convert currency values to a 11 digit padded number. Examples are: $265.39 to 00000026539 $43.90 to 00000004390 $765.00 to 00000076500 I thought the padded number rule would work but apparently with the $ sign and (.) in the data, it's not. Any ideas?
  11. 1. The new imposer needs MAJOR improvements. When opening a previous template, it should keep the setup but you have to do it all over again. 2. A shortcut for "Save As" like "command-shift-s" (for Mac) was taken out, why? 3. I have to open a newly saved/created template two to three times before it shows the layout that I had set up. (shows default otherwise). 4. Most of all the GUI is cumbersome and too big. You have to scroll and click a lot to select the settings you need. I'm all for improvements but this did not help productivity. By the way, I put off upgrading FusionPro because of the Imposer GUI, but because of my system being outdated with Adobe products was forced to totally upgrade my system.
  12. Just a Note… To try to simplify things, I tried to make two separate rules to overflow (getting rid of the tabs), but apparently you can't Overflow to two text frames onto the "Overflow" template Page.
  13. I ran into a snag. I need to edit the rule to include tabs, but when I do and send to compose the server gets to 95% done and just hangs. I let it set all night but it didn't complete. It looks fine in the preview. Is there an easier or more efficient way to put tab stops in the rule. I have the tab stops defined in the text editor, under the tabs. I have also attached my revised setup with a screenshot of the preview. Here's my rule with the tab tags added: var start_number = 6001; var largest_number = 87000; var range = 4; var sequence = ""; while (start_number +range <= largest_number) { sequence += start_number + "<t>-<t>" + (start_number +range) + '<br>' + "<t>"; start_number += (range +1); } return sequence; 158789-1_WIC_Log_Book_FP.zip
  14. Thank you very much. It works great now. I was missing the checked box on the Overflow template. I appreciate your help!!
  15. Thomas, Thank you for your reply. That worked great! but I had to change the range to 4 to make it work the range I needed. For some reason when I compose the job all the pages turn out the same and not continuous. I have the Text frame on the body page marked as overflow and the 2nd page set up as an Overflow template. I have attached my collected file. Can you take a look and see what I'm not doing correctly? 158789-1_Log_Book_FP.zip
  16. I need a rule for Sequential numbering in ranges of 6 increments that repeats until a specified range ending (1001-146000). I will use a Overflow template until the pages are filled with the repeating range. How do I repeat the rule on the same page until it's filled within the text box? for example: 1001-1006 1007-1012 1013-1018 etc. filling the rest of the page down, then overflow to the next page and continue where it left off. My current Sequential Incremental Rule looks like this: var start_number = 1001; var increment = 6; var crn = CurrentRecordNumber() -1; var set_start = start_number +crn +(crn * increment); var set_end = set_start + increment; return set_start + "-" + set_end
  17. I'm trying to create ticket covers that will print what ticket numbers are in each book. Each book has 7 tickets. Ex. book 1.(815255 TO 815261) book 2. (815262 TO 815268) book 3. (815269 TO 815275) and so on. I know how to use the numbering rule, but I need to skip the numbers in between. I found this on another post but don't know how to apply a specific start number and in increments of 7. return FormatNumber("000000", (CurrentRecordNumber() - 1) * 100 + 1) + "-" + FormatNumber("000000", CurrentRecordNumber() * 100);
  18. Thank you Dan, The first suggestion worked great. I forgot to mention that if the whole address line was blank I wanted the line suppressed. Also "having no address" was a customer request for business cards. Thanks again for your expertise.
  19. Using Acrobat Pro DC with FusionPro version 10.1.11 I need to join the State and zip with a different "join" of just a space. The following code works except it joins STATE and ZIP CODE with ", " Is there a way to differentiate the joins. var items = [ Field("STREET"), Field("CITY"), Field("STATE"), Field("ZIP CODE") ]; items = items.filter(String); // remove empty items return [ items.slice(0, 4).join(", "), items.slice(4).join(" ") ].filter(String).join("<br>\n");
  20. I found the rule I needed. In the Callback rules called Color from Data. Too easy!!!
  21. I need a rule that will change the text color for each record based on the CMYK value in a data file. The field is named "BC Text color". The values in the data field are formatted as 00-00-00-00 (C-M-Y-K). How do I direct FusionPro to pick up these values to color my text per record.
  22. Using FusionPro Designer 10.1.11 I'm trying to create a table where the rows have alternate shading with 13 percent black shading starting on row two and following the same every other row. I would like the shading or rows in the table to be suppressed if the data doesn't exist and need some assistance on the coding. I know you can "Loop" code but with alternating row shades was not sure how to do this. This is part an example of my table (the finished table will have a possibility of 40 rows with two columns. new FPTable; var table = new FPTable; table.AddColumns(20000,32000); table.AddRows(40); table.Rows[0].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[0].Cells[0].HAlign = "Left"; table.Rows[0].Cells[0].VAlign = "Middle"; table.Rows[0].Cells[0].Content=Field("cardholder1"); table.Rows[0].Cells[0].Font="Futura Std"; table.Rows[0].Cells[0].PointSize="10"; table.Rows[0].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[0].Cells[1].HAlign = "Left"; table.Rows[0].Cells[1].VAlign = "Middle"; table.Rows[0].Cells[1].Content=Field("credit_limit1"); table.Rows[0].Cells[1].Font="Futura Std"; table.Rows[0].Cells[1].PointSize="10"; table.Rows[1].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[1].Cells[0].HAlign = "Left"; table.Rows[1].Cells[0].VAlign = "Middle"; table.Rows[1].Cells[0].ShadeColor = "Black"; table.Rows[1].Cells[0].ShadePct = "13"; table.Rows[1].Cells[0].Content=Field("cardholder2"); table.Rows[1].Cells[0].Font="Futura Std"; table.Rows[1].Cells[0].PointSize="10"; table.Rows[1].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[1].Cells[1].HAlign = "Left"; table.Rows[1].Cells[1].VAlign = "Middle"; table.Rows[1].Cells[1].ShadeColor = "Black"; table.Rows[1].Cells[1].ShadePct = "13"; table.Rows[1].Cells[1].Content=Field("credit_limit2"); table.Rows[1].Cells[1].Font="Futura Std"; table.Rows[1].Cells[1].PointSize="10"; table.Rows[2].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[2].Cells[0].HAlign = "Left"; table.Rows[2].Cells[0].VAlign = "Middle"; table.Rows[2].Cells[0].Content=Field("cardholder3"); table.Rows[2].Cells[0].Font="Futura Std"; table.Rows[2].Cells[0].PointSize="10"; table.Rows[2].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[2].Cells[1].HAlign = "Left"; table.Rows[2].Cells[1].VAlign = "Middle"; table.Rows[2].Cells[1].Content=Field("credit_limit3"); table.Rows[2].Cells[1].Font="Futura Std"; table.Rows[2].Cells[1].PointSize="10"; table.Rows[3].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[3].Cells[0].HAlign = "Left"; table.Rows[3].Cells[0].VAlign = "Middle"; table.Rows[3].Cells[0].ShadeColor = "Black"; table.Rows[3].Cells[0].ShadePct = "13"; table.Rows[3].Cells[0].Content=Field("cardholder4"); table.Rows[3].Cells[0].Font="Futura Std"; table.Rows[3].Cells[0].PointSize="10"; table.Rows[3].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[3].Cells[1].HAlign = "Left"; table.Rows[3].Cells[1].VAlign = "Middle"; table.Rows[3].Cells[1].ShadeColor = "Black"; table.Rows[3].Cells[1].ShadePct = "13"; table.Rows[3].Cells[1].Content=Field("credit_limit4"); table.Rows[3].Cells[1].Font="Futura Std"; table.Rows[3].Cells[1].PointSize="10"; table.Rows[4].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[4].Cells[0].HAlign = "Left"; table.Rows[4].Cells[0].VAlign = "Middle"; table.Rows[4].Cells[0].Content=Field("cardholder5"); table.Rows[4].Cells[0].Font="Futura Std"; table.Rows[4].Cells[0].PointSize="10"; table.Rows[4].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[4].Cells[1].HAlign = "Left"; table.Rows[4].Cells[1].VAlign = "Middle"; table.Rows[4].Cells[1].Content=Field("credit_limit5"); table.Rows[4].Cells[1].Font="Futura Std"; table.Rows[4].Cells[1].PointSize="10"; table.Rows[5].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[5].Cells[0].VAlign = "Middle"; table.Rows[5].Cells[0].ShadeColor = "Black"; table.Rows[5].Cells[0].ShadePct = "13"; table.Rows[5].Cells[0].Content=Field("cardholder6"); table.Rows[5].Cells[0].Font="Futura Std"; table.Rows[5].Cells[0].PointSize="10"; table.Rows[5].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[5].Cells[1].HAlign = "Left"; table.Rows[5].Cells[1].VAlign = "Middle"; table.Rows[5].Cells[1].ShadeColor = "Black"; table.Rows[5].Cells[1].ShadePct = "13"; table.Rows[5].Cells[1].Content=Field("credit_limit6"); table.Rows[5].Cells[1].Font="Futura Std"; table.Rows[5].Cells[1].PointSize="10"; table.Rows[6].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[6].Cells[0].HAlign = "Left"; table.Rows[6].Cells[0].VAlign = "Middle"; table.Rows[6].Cells[0].Content=Field("cardholder7"); table.Rows[6].Cells[0].Font="Futura Std"; table.Rows[6].Cells[0].PointSize="10"; table.Rows[6].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[6].Cells[1].HAlign = "Left"; table.Rows[6].Cells[1].VAlign = "Middle"; table.Rows[6].Cells[1].ShadeColor = "Black"; table.Rows[6].Cells[1].Font="Futura Std"; table.Rows[6].Cells[1].PointSize="10"; table.Rows[7].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[7].Cells[0].VAlign = "Middle"; table.Rows[7].Cells[0].ShadeColor = "Black"; table.Rows[7].Cells[0].ShadePct = "13"; table.Rows[7].Cells[0].Content=Field("cardholder8"); table.Rows[7].Cells[0].Font="Futura Std"; table.Rows[7].Cells[0].PointSize="10"; table.Rows[7].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[7].Cells[1].HAlign = "Left"; table.Rows[7].Cells[1].VAlign = "Middle"; table.Rows[7].Cells[1].ShadeColor = "Black"; table.Rows[7].Cells[1].ShadePct = "13"; table.Rows[7].Cells[1].Content=Field("credit_limit8"); table.Rows[7].Cells[1].Font="Futura Std"; table.Rows[7].Cells[1].PointSize="10"; return table.MakeTags(); I'm not sure how to write the rule to purge rows in a table where there is no data and with alternate shading in the cells.
×
×
  • Create New...