Jump to content

dfalkowitz

Registered Users - Approved
 View Profile  See their activity

  • Posts

    35

  • Joined

 Content Type 

Posts posted by dfalkowitz

    File Name Variable used for Data Source

    in FusionPro® VDP Creator

    Posted

    Hello,

     

    We use the same Fusion Pro Template for many jobs and the name of the Template is:

     

    12345 Letter Layout.pdf

     

    Job Number = 12345

    Data Source = 12345.dbf or 12345.txt

    Output File Name = 12345 Letter Live.pdf

     

    I would like to automatically update the data source file and the output file, based on the job number. Hopefully :]

     

    So when the next job comes in, we open 12345 Letter Layout.pdf and rename to 12399 Letter Layout. Once the PDF is renamed, the data name and output name should update to:

     

    Job Number = 12399

    Data Source = 12399.dbf or 12399.txt

    Output File Name = 12399 Letter Live.pdf

     

    ------------------------------------

     

    If this is not possible, I would like to have 1 Master Fusion Pro Template:

     

    Master FP Template = Letter Layout.pdf

     

    Within this template, there is a job number Global Variable. The Data Source and Output File Name should be linked to this variable.

     

    job_variable = 12345

    Data Source = 12345.dbf or 12345.txt

    Output File Name = 12345 Letter Live.pdf

     

    So when the next job comes in, we open Letter Layout.pdf and update the Global Variable to new job number (e.g. 12399). Once variable is updated, the data source name and output name should update to:

     

    Job Number = 12399

    Data Source = 12399.dbf or 12399.txt

    Output File Name = 12399 Letter Live.pdf

     

    Thank you!

    File Name Variable used for Data Source

    in FusionPro® VDP Creator

    Posted

    Hello,

     

    We do many recurring jobs, where the only differences are the PDF File names and the database file names. The Job number is used for both, for example:

     

    Job Number = 12345

    File Name = 12345 Letter Layout.pdf

    dbase Data Name = 12345.dbf

    OR Text File Name = 12345.txt (tab delimitted)

     

    dbase is our default data file type but for this purpose, a tab text file might be better

     

    Is there any way to create a variable/rule to pull in the first 5 chars/digits of the the File Name?

     

    So Left(FILENAME,5) = 12345

     

    Can this variable be used for the data source name? ExternalDataFile Name?

     

    Thank you!

    Numbered List

    in FusionPro® VDP Creator

    Posted

    Yes, you are correct - trying to accomplish something a little more complicated than manually typing the Numbered List. I guess I should have provided a little more details.

     

    What you provided was very helpful and is appreciated.

     

    Thank you so much!!!

    Numbered List

    in FusionPro® VDP Creator

    Posted

    Hello!

     

    I was hoping someone would be able to help me create a numbered list within a Fusion Pro Javascript Rule?

     

    Sample HTML:

    <ol>

    <li>test1</li>

    <li>test2</li>

    </ol>

     

    Fusion Pro Output:

    1. test1

    2. test2

     

    Is there a way to produce the FP Output within a Rule?

     

    Thank you!

    Compose Sample Records

    in FusionPro® VDP Creator

    Posted

    Hello,

     

    I was trying to compose/output to a PDF when a specific data field equals a value. For proofing purposes, we mark which records get a proof. For Example:

     

    Live Data file = 2,000 records

    Samples Records = 10 records

     

    The Sample/Proof records have a value of "X" in the <<SAMPLE>> data field.

     

    Is there a was to only output these 10 records (SAMPLE = "X"), instead the entire file, without creating 2 data files?

     

    Thank you!

    isSpot issues

    in FusionPro® VDP Creator

    Posted

    Hello,

     

    I am trying create a Spot Color but my OnRescordStart Rule is not working:

     

    var myColor = new FusionProColor("PANTONE_TEST", 100, 50, 0, 0, true);

    FindTextFrame("TEST").fillColorName = "PANTONE_TEST";

     

    I have "true" after Black value of "0", but after composition, the composed PDF still shows up as a CMYK color not a Spot Color (when using Pitstop eyedropper tool).

     

    Am I missing something?

     

    Thank you!

    dif file

    in FusionPro® VDP Creator

    Posted

    Thanks for getting back to me so quickly. We do not have Producer API or the MarcomCentral. I kind of figured that I couldn't since the dif file is generated after composition. I have a lot a text boxes that I have to edit one by one. So I was just looking for a faster way to do this and thought editing the dif file would be faster. Thanks again!

     

    PS - do you personally offer any advanced training for VDP Creator, since you seem to be the best out there? Or do you recommend a javascript course I could take because some of the scripts I've seen you post are crazy?

    Dynamically Add Row

    in Tables & Charts

    Posted

    Is there a way to dynamically add rows to a table on the fly based off data fields?

    For example:

    Data file looks like this

    FIELD1 FIELD2 FIELD3

    A B C

    A B

    A

    A B

     

    I need the table to look like this

    REC#1

    A

    B

    C

     

    REC#2

    A

    B

     

    REC#3

    A

     

    REC#4

    A

    B

    Prevent line break

    in Issues, Questions, Etc.

    Posted

    When using this rule below combined with the font Frutiger 45 Light my text shows "MyProductName" - no spaces. When I switch to a different font like Arial or Tahoma then it's correct "My Product Name" - with spaces. Do you know why this works with most fonts but not all?

     

    function NoBreak(s)

    {

    return NormalizeEntities(s).replace(/ /g, " ");

    }

    return NoBreak("My Product Name");

    Variable Table Rows based on External Data

    in Tables & Charts

    Posted

    Where would I add the call to AddRows (rule below):

     

    if(FusionPro.inValidation)

    Rule("OnJobStart");

     

    var DaysOfWeek = ["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"];

     

     

    text = new FPTable; //This variable is defined in the Globals dialog.

    text.AddColumns(8000, 8000, 8000, 8000, 8000, 8000, 8000);

    text.AddRows(3);

     

    for(a=0;a<7;a++) //Loops through the cells in a row

    {

    //Row 1

    text.Rows[0].Cells[a].Content = DaysOfWeek[a];

    cellTraits(0,a); //Calls the function defined below to set the cell borders and margins

     

    //Row 2

    x = data.FindRecord("Location", Trim(Field("Destination")))

    text.Rows[1].Cells[a].Content = "<z newsize=14>" + (a+17) + "<z newsize=9><br>" + Trim(data.GetFieldValue(x, a+1));

    cellTraits(1,a);

     

    //Row 3

    var value = Trim(data.GetFieldValue(x, a+8));

    if(value != "")

    {

    text.Rows[2].Cells[a].Content = "<z newsize=14>" + (a+24) + "<z newsize=9><br>" + value;

    cellTraits(2,a);

    }

    }

     

    text = text.MakeTags();

    text = "Dates and Times During your Trip<br><z newsize=2> <z newsize=10><br>" + text;

     

     

    function cellTraits(b,a)

    {

    text.Rows.Cells[a].SetBorders("Thin", "Black", "Top", "Bottom", "Left", "Right");

    text.Rows.Cells[a].Margins = new FPTableMargins;

    text.Rows.Cells[a].Margins.Top = 60;

    text.Rows.Cells[a].Margins.Bottom = 40;

    text.Rows.Cells[a].Margins.Left = 600;

    text.Rows.Cells[a].Margins.Right = 600;

    }

    Variable Table Rows based on External Data

    in Tables & Charts

    Posted

    Do you have any templates or examples that show how to have variable table rows?

    For Example: I need to build a table that can have anywhere from 1-50 rows based off of a External file. I only want to show the amount of rows for each record. Record 1 will have 3 rows but Record 2 might have 5 rows. Anything you have will be appreciated. Thanks!

×
×
  • Create New...