I am trying to import a complete chart of accounts using the importer, but for some reason I always get errors and cannot complete the process.
So I’m trying to insert new records, I’ve tried of course downloading the template and modifying it accordingly.
I tried importing 1 account at a time to see if it works. Nope
I’ve tried CSV and XLS files, same outcome.
I’ve tried updating existing records from an exported dataset… nope.
I’ve even tried exporting and reimporting the same data with no success.
I get errors like
COLUMN 6 (Parent Account) The following values do not exist for Account: Actifs non-courants, Actif, Banque, Dépenses, Actif à court terme, Passif, Encaisse, Immobilisations
Which seems to point out that the importer can’t find the parent account, but in my import list, I am creating the parent before importing the child. And I’m checking for typos and other obvious errors.
I am using account numbers, so I checked the database and tried to rewrite the
parent_account using the syntax
Acc# - AccName - CieAbbr and it’s not working.
So I’m pretty sure I am missing something but I can’t find anything in the docs that I’m doing wrong or in the forums related to my issue and I’m pretty much out of ideas as to what to look for next to make this work!
Thanks for your suggestions/explanations