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:

 

Colonna Intestazione Obbligatorio Valore Esempio
A id  numeric - counter
 1
B data_transazione  data - format dd/mm/yyyy  01/02/2020
C controparte  alphanumeric - CUUA code  58426078521
D anno_campagna  numeric - year  2020
E qta  numeric - Kg  50480
F ruolo text - transferor/receiver  cedente
G tipo_coltivazione  text - B/C  B
H intrastat code - Intrastat Code  7099290
I note No text  
J allegato01 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

I: Note

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  importamenu item

This screen will open:

importahelp

Click on "Seleziona File ZIP", select the ZIP file to upload and click on "Submit"

You will see the following page

CaricamentoFileZIP

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:

CaricamentoZIPErrato

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

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 

 

 

Go To Top