I am trying to replace quickbooks, and I'd like to either use the same .qbo export file from my bank(s), or use CSV. But with CSV, dates like '1/20/2015' fail to validate. So how do I change the data format(s), or make it so I can automate import of bank account data?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilidad
- Inventario
- PoS
- Project
- MRP
Se marcó esta pregunta
2
Respuestas
13134
Vistas
[Click on pictures to enlarge]
The correct date format that Odoo accepts is YYYY-MM-DD. The way I know this is because I exported an existing bank statement in "Import-compatible export" in CSV and looked at how it was made. You export in the list view after clicking the checkbox of the records you want to export. Here I exported 1 bank statement that contains 4 lines. The export window looks like below and I exported the bank statement date and the date of each line:
If I open the CSV in Excel, I see this:
Be careful with spreadsheet editors, they tend to display dates differently than how they are stored. This format looks weird, so I decided to open the csv file in a text editor:
You see that the date format is YYYY-MM-DD.
Now, I can reuse this template to re-import a new bank statement in Odoo. It helps to have the correct column headers. Note that I only did this test with a few fields; more fields can be added. I changed the data as follows:
Back in the list view of bank statements of Odoo, I clicked on the Import button and selected my file. All the fields are recognized automatically.
When I validate, a green message indicates everything is correct, and I then click on Import.
My new bank statement appears then:
Note: you don't necessarily have to use a text editor to make a change in the CSV or reformat a date. I did it here to warn about the fact that certain spreadsheet editors display something different than the encoded data. It is still possible to use a spreadsheet editor like LibreOffice, Excel, or Google spreadsheet. You'll have to play with the "Format Cells" feature.
I can't comment yet because I don't have enough points, but what I would really like are pointers to the import python code in https://github.com/odoo/odoo, and an estimate on what it would cost to have configurable data format import filters in the SaaS version, and then I can decide if I should just pay for the development or write my own importer.
I'm trying to get away from external programs (particularly spreadsheets) that require lots of (error-prone) gui clicking to massage the data before import, and automate the whole thing so I can click one button and pull in *all* of my latest bank statements with some simple programmatic automation with something like Selenium.
And apparently I can't delete my own 'answer' which should probably be a comment either...
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Registrarse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
Bank Statement in Odoo
Resuelto
|
|
3
jun 25
|
3415 | |
|
1
abr 25
|
1226 | ||
|
0
nov 23
|
1400 | ||
|
2
jul 23
|
3394 | ||
|
3
mar 23
|
3995 |
what I would really like are pointers to the import python code in https://github.com/odoo/odoo, and an estimate on what it would cost to have configurable data format import filters in the SaaS version, and then I can decide if I should just pay for the development or write my own importer. I'm trying to get away from external programs (particularly spreadsheets) that require lots of (error-prone) gui clicking to massage the data before import, and automate the whole thing so I can click one button and pull in *all* of my latest bank statements with some simple programmatic automation with something like Selenium.