Jump to content

External composition errors


Recommended Posts

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.

Link to comment
Share on other sites

  • 3 weeks later...
Do you want a sample with the data and template attached, or just a screen shot of what is not working?

I need a sample with a template and data, to debug. A picture is usually worth a thousand words, but I need to be able to reproduce the issue, not just see a picture of it.

I cannot send the template or data, but could possibly get a screen shot that would not include any sensitive data.

Please create some "dummy" data, with a template containing just the parts needed to reproduce the issue, as a minimal example, and post that.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...