importing data (CSV) on Move fail : a value is required for field
with 5.2 (and tip), I couldn't import a Move (with MoveLines) anymore.
It was working with 5.0, and I couldn't find a way to make it work with newer version.
I am importing a CSV file with the following data (my database is configured for french, so I kept fieldnames as they are in the file):
$ cat test.csv
Journal,Période,Date effective,Description,Lignes/Compte,Lignes/Débit,Lignes/Crédit
Produit,2019-08,2019-08-31,Test de mouvement,7071,0,100
,,,,5112,100,0
The wanted move is:
- Journal: Produit
- Period: 2019-08
- Date: 2019-08-31
- Description: Test de mouvement
- Lines
- Account: 7071 (an account without required party)
Debit: 0.0
Credit: 100.0
- Account: 5112 (an account without required party too)
Debit: 100.0
Credit: 0.0
On the Move view (Financier > Entrées > Mouvements comptables), I open the menu, and clic on "Import Data..."
I select my file and ask for "Auto-Detect". The "fields select" panel is completed correctly.
CSV parameters are the default values:
- Delimiter: ,
- Quote char: "
- Encoding: utf_8
- Use locale format: True
- Lines to skip: 1
When I validate (pressing OK button), I have the following error message: "Une valeur est requise pour le champ « Débit » sur « Ligne de mouvement comptable »".
I wonder if the 0 value is interpreted as no value here.