Jump to content

msteinberger

Registered Users - Approved
  • Posts

    9
  • Joined

Converted

  • FusionPro Products
    No

msteinberger's Achievements

Rookie

Rookie (2/14)

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

Recent Badges

10

Reputation

  1. Thank you! I ended up with this as my final rule. It displays the date in English or Spanish based on a language column in the data as well as a predetermined date that is also in the data: function SpanishDate(myDate) { var months = ['enero','febrero','marzo','abril','mayo','junio','julio','agosto','septiembre','octubre','noviembre','diciembre']; var letterdate = Field("letter date") var month = months[myDate.getMonth()]; return myDate.getDate() + " de " + month + " " + myDate.getFullYear(); } return (Field("language") == "S") ? SpanishDate(DateFromString(Field("letter date"))) : FormatDate(DateFromString(Field("letter date")), 'lm d, yyyy');
  2. Is there a way to use this same formula but also pull in a date field from the data instead of using Today's Date?
  3. Thank you for getting back to me. It makes sense it would work this way.
  4. We have a document that has a declared data file linked. Within the same document, we have page calling an external CSV for the flyout. When we compose the document, we would like the pages to be created in the order of the external document and not the linked data document. Is this possible? Between the two data sets, we have a unique identifier to match the rows.
  5. Do you want a sample with the data and template attached, or just a screen shot of what is not working? I cannot send the template or data, but could possibly get a screen shot that would not include any sensitive data.
  6. I have a rule called 'A Travis Help' that is working when we validate and preview the PDF in Fusion. However, upon composing, our rule errors. The error say: A Travis Help, line 7: Error: In ExternalDataFileEx.SortBy(), no field named letter[@track] When we look in the external file we have a column called letter[@track]. Has anyone experienced this before? Here is the rule: var result = ""; var letter_track = Field('letter[@track]'); // create a variable on the letter[@track]'s value. This is pulled from the primary data source member = new ExternalDataFileEx('ExternalDataMainFlyOnly.xlsx', 'Excel', 'SP2307'); var row = member.SortBy('letter[@track]').FindRecords(letter_track); // This is finding the row that matches on the letter[@track] field's value. Should only pull back one row. TM too lazy to change var name to row. #MariNotSorry //barcade Vars - these were taken from the barcode script Meg helped TM produce RoutingNum=""; var Var3 = ""; // There is no Var 1 orVar2 because it was not need for our purpose var Var4 = ""; var v_tracking = "5"; var v_font = "IDAutomation4State"; var fontTag = false; result += '<p><tracking newsize="' + v_tracking + '">' + MakeIntelligentMailBarcode(member.GetFieldValue(row[0], 'IMb Payload'), RoutingNum, Var3, fontTag, v_font, Var4) + "</tracking></p>"; result += '<p><f name="Arial"/><z newsize="9"/>'+member.GetFieldValue(row[0], 'Opt. Endorsement Line')+'</p>'; result += '<p>'+member.GetFieldValue(row[0], 'Manifest Keyline')+'</p>'; result += '<p><t><t><t><t><t>'+member.GetFieldValue(row[0], 'seq')+', '+member.GetFieldValue(row[0], 'Sortcode')+'</p>'; result += '<p>'; result += member.GetFieldValue(row[0], 'Letter/Member/FirstName')+' '+member.GetFieldValue(row[0], 'Letter/Member/LastName')+'<br>'; result += member.GetFieldValue(row[0], 'Letter/Member/Address1')+'<br>'; if (member.GetFieldValue(row[0], 'Letter/Member/Address2') != '') { result += member.GetFieldValue(row[0], 'Letter/Member/Address2')+'<br>'; } result += member.GetFieldValue(row[0], 'CSZ'); result += '</p>'; return result; **Unfortunately this rule is part of a template that contains protected PHI information so I cannot share my data or template.
  7. I am having a similar issue where my 3 of 9 barcode is scanning differently than the input data. Input data reads: C714094A-2EDB-4136-A514-D4FC86909D02 Scanned barcode reads: C714094A/M2EDB/M4136/MA514/MD4FC86909D02 How do I replace the /M with the hyphen that is in the data?
  8. Hi Alex, My POD department has asked that we give them batches of 5,000 records so I have infinite stack turned off and stack set to 2500 in my Imposer definition file.
  9. I have triggers set up that turn a page on or off depending on the data, but when I try to impose the job, the pages that are set to unused will not impose. I have the pages set to unused in the page manager and am using "set body page usage" in the OnRecordStart rule to turn them on or off depending on the data. Under normal composition, the jobs compose exactly as they should. When I try to compose and use an imposition definition, the unused pages will not impose even when the data is saying they should be used. I'm using FusionPro VDP Designer 9.3.9 Thanks,
×
×
  • Create New...