Jump to content

Hawk

Registered Users - Approved
 View Profile  See their activity

  • Posts

    25

  • Joined

 Content Type 

Posts posted by Hawk

    External data file no data source defined or data could not be loaded

    in FusionPro® VDP Creator

    Posted

    It seems that the OnJobStart rule will not run with a field in it. I cant get the filename variable to print.

     

    This is what I got;

     

    OnJobStart, line 2: Error: In Field(), no data source defined or data could not be loaded

    Job started 15:36:20 - 1458243380.

    Creator: FusionPro VDP Creator 8.2.5

    Computer Name: HAWK-PC

    Current working folder: C:\Program Files\Common Files\Adobe\Adobe Version Cue CS4\Client\4.0.1

    Template File: C:\Users\Hawk\Desktop\130515 Ideal Solutions\IRS Form 1095cCopy.pdf

    Input File: C:\Users\Hawk\Desktop\130515 Ideal Solutions\Printer PackardPart1&2.csv

    Rule Dependents, line 8: ReferenceError: XDF is not defined

    Rule Dependents Check Box, line 8: ReferenceError: XDF is not defined

    Composing record #1, input record 1

    Sheet #1, record #1

    Value for variable Rule Dependents not found in instance data

    Value for variable Rule Dependents Check Box not found in instance data

    Word <Dependents> does not fit in frame after line 1.

    The amount of text inserted into a flow exceeds the depth

    of all frames in the flow <(null)>. Text is truncated.

    Text does not fit in the last frame on page 1 at (7.37, 4.31).

    Job ended 15:36:23 - 1458243383.

    External data file no data source defined or data could not be loaded

    in FusionPro® VDP Creator

    Posted

    I'm getting this error on composition when I have a field name in my OnJobStart rule. "no data source defined or data could not be loaded"

     

    I does preview correctly. When I remove the field name it previews and composes correctly.

     

    This works

    var filename = 'CompanyName' + '.txt';

    XDF = new ExternalDataFileEx("C:\\Shared\\130515_IdealSolutions\\" + filename, "\t");

    return XDF.valid;

     

    This Does Not

    var filename = Field("ER.Name").replace(/ /g, '') + '.txt';

    XDF = new ExternalDataFileEx("C:\\Shared\\130515_IdealSolutions\\" + filename, "\t");

    return XDF.valid;

    First row from external data file not showing

    in Issues, Questions, Etc.

    Posted

    I'm trying to create a table form an external data file. There could be 1 or more matches in the external file from my main data file. I can't get the first matching row to display in my pdf. if there is only one row I get nothing.

     

    Here is my rule;

     

    if(FusionPro.Composition.isPreview == true || FusionPro.inValidation == true)

    {

    Rule("OnJobStart");

    }

     

    var numRecsExtDF = XDF.recordCount;

     

    var myTable = '<table columns=16><column width=17400><column width=8500><column width=7200><column width=4400><column width=2875><column width=2875>'

    myTable += '<column width=2875><column width=2875><column width=2875><column width=2875><column width=2875><column width=2875><column width=2875>'

    myTable += '<column width=2875><column width=2875><column width=2875>';

     

    for (recordWalker = 1; recordWalker <= numRecsExtDF; recordWalker++)

    {

    if (XDF.GetFieldValue(recordWalker, 3) == Field("EE.SSN"))

    {

    var ssNo = Right(XDF.GetFieldValue(recordWalker, 8),4)

    myTable += '<row minheight=3650><cell margins="top:030;bottom:030"><p br=false quad=C>'

    + XDF.GetFieldValue(recordWalker, 4) + ' ' + XDF.GetFieldValue(recordWalker, 6)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ "***-**-" + ssNo

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 9)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 10)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 11)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 12)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 13)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 14)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 15)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 16)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 17)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 18)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 19)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 20)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 21)

    myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ XDF.GetFieldValue(recordWalker, 22)

     

    }

    }

    myTable += '</table>';

     

    return myTable;

     

    Variable Image from URL

    in FusionPro® VDP Producer

    Posted

    Hi. I'm trying to insert a variable image from a url. The url is in an external data file. This previews and produces a correct pdf file if I compose localy. When using VDP Producer I get no images.

     

    This is the message that I get.

     

    Check for file existence and that it is of the proper format.

    Graphic is not found or is not processed properly: Error downloading URL: http://blackbooklivemarketing.net/Ev...280_032_3U.jpg.

     

    Can I even do this? If so, How?

     

    Thanks,

    Larry

    Maximun records in External Data file

    in FusionPro® VDP Creator

    Posted

    Is there a maximum number of records allowed in an external data file?

     

    I have an external data file with over 200,000 records, and I can't get all of the records to populate. If I pull out samples in a smaller file it works fine. Other wise it is inconsistant. It seams that after it gets to a certian record it fails. There is no error message, it just doesn't work.

     

    Thanks,

    Larry

    Table from external data file

    in FusionPro® VDP Creator

    Posted

    I have an external data. The first one is the id that matches a record in the main data file. The second is categories, each category can be listed more than once for each Id. The third is category codes. I am trying to create a table that lists the unique categories with the codes for that category listed beneath for each id. Any help would be appriciated.

     

     

    Thanks,

    Larry

    Variable text color in table

    in Getting Started

    Posted · Edited by Hawk

    I am creating a table from an external data file. I need the text color of a row to be red if there is a Y in the last column of the external file. Can't seem to get it.

     

    Here is what i have so far.

     

    numRecsExtDF = XDFTop.recordCount;

var numRecsExtDF = XDFTop.recordCount;

var  myTable = '<table columns="6" Space="Above:180;Below:180" Alignment="Center" Margins="Top:60;Bottom:60;Left:60;Right:60"' 
myTable +='BoxRules="Top:thin,BLACK;Bottom:thin,BLACK;Left:thin,BLACK;Right:thin,BLACK" HeaderRules="Rule:thin,BLACK;" '
myTable +='ColumnRules="Freq:1;Default:thin,BLACK;Alternate:thin,BLACK" RowRules="Freq:1;Default:thin,BLACK;Alternate:thin,BLACK">'
myTable +='<column width=8000><column width=8000><column width=12000><column width=8000><column width=8000><column width=8000>'
myTable += '<row><cell margins="top:030;bottom:030"><p br=false quad=C>Provider Type<br />(renering service)'
        myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>Last Known<br />ICD-9 Code'
        myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>ICD-9<br />Description'
        myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>Date Last<br />Confirmed'
        myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>DHCC<br />Grouping'
        myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>Need to be<br />Confirmed in<br />2012 (Y/N)'
for (i=0; i <= numRecsExtDF; i++)
{      

   if (XDFTop.GetFieldValue(i, 0)==Field("hicn"))
   {   

       myTable += '<row>'
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 1))
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 2))
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 3))
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 4))
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 5))
       myTable += '<cell margins="top:030;bottom:030"><p br=false quad=C>'+ NormalizeEntities(XDFTop.GetFieldValue(i, 6))

   }
}  
 myTable += '</table>';
 return  myTable;

     

    I can't even change the color with a color tag.

     

    I'm using VDP Creator 8. And Acrobat 9.

     

    Thanks,

    Larry

    Error 4555

    in FusionPro® VDP Producer

    Posted

    We are running FusionPro Direct Version 7.2P1k on Windows server 2008 R2 the server has Accrobat X. I am using Accrobat 9.4.6 with FusionPro Version 7.2P1k on Windows XP Pro. The ports 12093 and 12083 are open for UDP, the rest are TCP.

     

    Thanks,

    Larry

×
×
  • Create New...