Jump to content

Unknown Entity


Recommended Posts

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

Edited by mclisa81
Removed my tagged text from rule
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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;

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...