Our aim is to create a template to repeatedly convert data from a csv file into a stocklist matrix.
The process as following steps:
1. We create a csv file according to example "Sample [url removed, login to view]"
2. We want to run a file/program to pick up the data and convert into a file according to the layout as example "Sample [url removed, login to view]"
a. The colour and size information needs to be displayed in a matrix format.
b. We have to load 1 picture per item. If no picture then blank.
3. We want to calculate the totals per row in the matrix as well as the total qty at the end of the list as per example "Sample [url removed, login to view]"
4. We need to be able to save as pdf and print.
5. In the title: “AVAILABLE STOCK AS PER [url removed, login to view]” the date needs to be today’s date (systems date)
The document does not need to be a excel spreadsheet – we are open ofr other formats such as pdf or html as long as there is a print document function which allows up to print and distribute the document.
The following files are attached for further reference:
- Project description including Data Mapping.
- Sample CSV data file
- Sample Template
- Sample pictures