Showing results for 
Search instead for 
Do you mean 
Reply
New Member
Posts: 5
Registered: ‎06-15-2017

Core and csv Data files

Hi

 

I am currently trialing Freeflow Core and have a project lined up that includes incorporating a field of data from a supplied csv file onto the front cover of my job. 

 

Is there a way that Core can process my csv file adding the required data to my job as it goes through my workflow? I would be submitting numerous pdfs at a time as a job group but cannot see how Core would know what code to print on the associated pdf?

 

As I am trialing It doesn't give me access to the Manifest options to test, but is this the area in which I would be able to configure this?

 

Any help much appreciated.

 

Thanks

LJ

Account Deactivated
Posts: 2,298
Registered: ‎01-03-2012

Re: Core and csv Data files

The trial license should give you all FFC modules. The manifest configuration is done in the hot folder setup. 

 

As as to your specific question: when you use manifest submission each row in the CSV must point to a job file. All other mapped fields in the Csv are submitted as variables that are associated with the job. As such you can add data from the manifest in the watermark component using the following syntax: $FF<manifest field name>$

New Member
Posts: 5
Registered: ‎06-15-2017

Re: Core and csv Data files

Thanks for getting back to me,

 

Unfortunately the MAX setup in the Hot Folder window is greyed out so I am unable to attempt any form of test.

Is there a way I can enable this feature??

 

 LJ

Account Deactivated
Posts: 2,298
Registered: ‎01-03-2012

Re: Core and csv Data files

Can you post a picture of the about screen?

New Member
Posts: 5
Registered: ‎06-15-2017

Re: Core and csv Data files

Here you go....About.PNG

Account Deactivated
Posts: 2,298
Registered: ‎01-03-2012

Re: Core and csv Data files

ok - that looks good. thanks

 

Can you also post the licensing screen?

New Member
Posts: 5
Registered: ‎06-15-2017

Re: Core and csv Data files

License.PNG

New Member
Posts: 5
Registered: ‎06-15-2017

Re: Core and csv Data files

Any luck with enabling the MAX setup in the Hot Folder section on my trial version?

 

 

Member
Posts: 18
Registered: ‎11-15-2016

Re: Core and csv Data files

 

I had a similar issue at the start when going towards CSV MAX Status submission,

 

CSV

 

Row A1 = title File Name

Row A2  = 12345.pdf

This file name will reference a file name of 12345 in your ‘Default source location’ and find the file name 12345

Row B1 = Qty

Bow B2 = 5

 

Save it out as CSV ( comma ) via Microsoft Excel

 

  • MAX file is located such as C:\Hotfolders\CSVExport

 

Select send job to a single work flow.

  • Build your workflow ( just use a simple save pre-set to desktop to make sure your getting a PDF back out.

 

MAX SETUP

 

  • Set priority to Normal
  • Make sure file name is in A (Standard fields)
  • Quantity is B (Standard fields)
  • Default source location ( just keep this local for the time being) before adding network and drives into it to make sure it works.

 

 

Manifest processing

 

Column delimiter:  Set as a ,

Text qualifier: None

Untick – process the first row as data

Tick the 2 underneath.

 

 

- Drop the CSV file into the hot folder and a new MAX STATUS should appear. 

 

If its says .Satus its successfully pulled the file into FFC it should be where you asked it to save the file

If it says .Status. Error open it and it should tell you why

 

Member
Posts: 18
Registered: ‎11-15-2016

Re: Core and csv Data files

sometimes my MAX STATUS Blanks out, just reboot the server or PC you're using seems to fix my issue.