Unknown Entity

[mclisa81]

I'm getting an error that I believe is related to the "&" ampersands in my external data.

Incomplete entity definition TROUGH
Unknown Entity &TROUGH; in record 169

From reading other posts, I'm pretty sure I need to insert the TaggedTextFromRaw function in my rule somewhere, so far everywhere I've tried has failed.

returnStr = '';

if(FusionPro.Composition.isPreview == true || FusionPro.inValidation == true)
{
    Rule("OnJobStart");
}


numRecsExtDF = externalDF.recordCount;

for (recordWalker=1; recordWalker <= numRecsExtDF; recordWalker++)
{
    if (externalDF.GetFieldValue(recordWalker, 'Client No') == Field("Client No"))
    {
        
        returnStr += '<t>' + externalDF.GetFieldValue(recordWalker, 'Service Code') + '<t>' + externalDF.GetFieldValue(recordWalker, 'Service Name') + '<t>' + externalDF.GetFieldValue(recordWalker, 'Current Price') + '<t>' + externalDF.GetFieldValue(recordWalker, 'Price Effective 07/28/2014');
        returnStr += '<br>';
        
    }
}


return returnStr;

Thanks in advance for any help
Lisa


FusionPro VDP software version 9.0.3
Windows 7
Acrobat Version Acrobat 9.x

[dreimer]

You could just replace the "&" with "&" in your data and check the "Treat returned strings as tagged text" check box in your rule.

[mclisa81]

Thanks for the quick response Don.

I was trying to avoid going back to the data, unless I really needed to. I may have to do that if I can't get it to work with the rule. Thanks!

[dreimer]

Should be able to use a simple text editor and do a find and replace.

[mclisa81]

That's probably the way I'll go since I'm on a tight schedule with this. I figured there may be a quicker way to do it in the rule so it would take care of any characters, not just ampersands. Just in case one of the thousands of errors that this 1 records threw, was for another problem character. Thanks again.

[dreimer]

Sorry can't help with the rule. I normally do this kind of work in the data since I am not a JavaScript guru!!

[Dan Korn]

The place to use TaggedTextFromRaw is around all the calls to get data from the external data file. Try this:

if (FusionPro.inValidation)
    Rule("OnJobStart"); // load external data file

var returnStr = "";
var numRecsExtDF = externalDF.recordCount;

for (var recordWalker = 1; recordWalker <= numRecsExtDF; recordWalker++)
{
    if (externalDF.GetFieldValue(recordWalker, 'Client No') == Field("Client No"))
    {
        returnStr += '<t>' + TaggedTextFromRaw(externalDF.GetFieldValue(recordWalker, 'Service Code'));
        returnStr += '<t>' + TaggedTextFromRaw(externalDF.GetFieldValue(recordWalker, 'Service Name'));
        returnStr += '<t>' + TaggedTextFromRaw(externalDF.GetFieldValue(recordWalker, 'Current Price'));
        returnStr += '<t>' + TaggedTextFromRaw(externalDF.GetFieldValue(recordWalker, 'Price Effective 07/28/2014'));
        returnStr += '<br>';
    }
}

return returnStr;

[mclisa81]

Thanks Dan! I'll give that a try.

[mclisa81]

Worked perfectly!

(ps - Thanks for cleaning up my code also!)