Our aim is to convert an existing pdf file into a programmed pdf file that can be used to repeatedly update data from a csv file.
The process as following steps:
1. Once the file is opened it should prompt the user to select the csv file with the data.
2. User selects the file and the programmed pdf file reads the data (stock quantities) into the style/colour matrix cells.
3. We want to print or save to a static pdf file (no more editing allowed)
Mapping the CSV file to the pdf file:
We create a csv file according to example “stocklist gg&l 12-1”
a. The Description in the csv file matches the item description (vertical) in the pdf.
b. The Code in the csv matches the colour # (horizontal) in the pdf.
c. The structure of the csv file is always the same but the numbers to upload are changing
We want to keep the layout and structure of the pdf document – we only want to add functionality to read data into the matrix.
The following files are attached for further reference:
-Sample CSV data file – stocklist gg&l 12-1
-Sample Static Template – Stylesheet GGL2012-1
-Sample Result – Pages of Stylesheet GGL2012-1
Hi! I specialize in creating custom-made scripts for PDF files, and can do this quickly and professionally. There are some possible issues, though. See my PM...