What do you need to insert a transaction?
You need to create a ZIP file containing a CSV file named import.csv and all the file to attach. The SV file must contain all data required for the registration of every single transaction an all the file associated to each transaction
How the file to download is made?
You can download the sample file from here. The sample file contains exemple attachments and a import.csv file filled with example data.
Below you can see the file structure with the transposition of rows in columns:
|A||id||Sì|| numeric - counter
|B||data_transazione||Sì||data - format dd/mm/yyyy||01/02/2020|
|C||controparte||Sì||alphanumeric - CUUA code||58426078521|
|D||anno_campagna||Sì||numeric - year||2020|
|E||qta||Sì||numeric - Kg||50480|
|F||ruolo||Sì||text - transferor/receiver||cedente|
|G||tipo_coltivazione||Sì||text - B/C||B|
|H||intrastat||Sì||code - Intrastat Code||7099290|
|J||allegato01||Sì||vector - (file name | data | code)||Fattura 01.png|19/06/2019|FATTURA|19-01|
|K||allegato02||No||vector - (file name | data | code)|
|L||allegato03||No||vector - (file name | data | code)|
|M||allegato04||No||vector - (file name | data | code)|
|N||allegato05||No||vector - (file name | data | code)|
Below, the summary of all the fields necessary to enter a transaction (the others fields eventually filled out will be ignored):
A: Counter to identify the lines, e.g.,1 2 3 4 5 .. or 10 20 30 40 50
B: Transaction data format dd/mm/yyyy, e.g., 25/04/2018
C: Counterpart CUAA, e.g., 12451526485 or FVVFRN70D12C888A
D: Campaign year, e.g., 2020, 2021
E: Product quantity in KG, e.g., 50800
F: Role in transaction: transferor/receiver
G: Product tipology B or C (Organic, in Conversion)
H: Intrastat. Product Intrastat Code
J: Allegato001 contains attachment name, data, tipe and document number. Datas are separated from pipe symbol |
K: Allegato002 contains attachment name, data, tipe and document number. Datas are separated from pipe symbol |
L: Allegato003 contains attachment name, data, tipe and document number. Datas are separated from pipe symbol |
M: Allegato004 contains attachment name, data, tipe and document number. Datas are separated from pipe symbol |
N: Allegato005 contains attachment name, data, tipe and document number. Datas are separated from pipe symbol |
IMPORTANT: working with MS Excel the fields ClientVATNumber, containing the VAT Number, and IntrastatProductID, containing the Intrastat product code, could lose the eventual initial zeros, therefore we suggest, after saving the file with the .csv extention, to verify it opening the saved file with con Block notes or another text editor.
How to upload a transaction using file?
To insert a transaction from file it is necessary to follow the steps below:
Click on menu item
This screen will open:
Click on "Seleziona File ZIP", select the ZIP file to upload and click on "Submit"
You will see the following page
The transaction was executed succesfully: there are green chechmarks near each line and transactions input is confirmed.
In case of anomalies during ZIP file download, a red X will appear. That signal show us where the error appened so th eoperator can correct it.
Exemple of screen with loading error:
In this case, as it is reported, the error is related to CSV File. To find easily the error an operator has to click on "Download report" and a page with a report will open.
Example of Report containing errors:
Report errors can be : A and D
A: error related to attachments e.g
- attachment name is not present in CSV File or it is wrong
- attachment value is written in a wrong way. Admitted values are: DDT, FATTURA; LETTERA_CMR
D: error related to data e.g
- Insert data doesn't respect the right format (dd/mm/yyyy) or it's dated afer the date on which the transactions are inserted
- a CUAA present in CSV file is wrong or not present in the platform