Help meee. How to import structure like this:
I was trying to import that and this happen:
Hi,
fiddle out an import setup is always a little tricky. I don’t know your data model, especially the other ids conception. But in your import field selected I only see *Other IDs" but you try to import many more columns without correctly mapping to a Tryton field. Your actual mapping looks like this:
| Import table column | …maps to Tryton field |
| | (Import Fields Selected) |
|— | — | — | —|
| Others IDs/Record Name | Other IDs |
| Others IDs/Code | Active |
| Others IDs/ID type | Create Target |
| Others IDs/ID type (string) | Person |
The import fields selected definition must be equal to the fields in the csv table.
Usually I start Import definition with the following guidelines:
- Create a small set of records to import
- Simplify until it works → delete all columns with a problem
- Add the problematic columns step by step.
If I need to import more complicated things, I always write a proteus script.
again, the columns of the sheet to import are different from the fields in Fields Selected. It looks like you export with cost price, Type but did not remove these columns. Also the cost price can’t be imported always. Sometime you need to run the Product action Update Cost Price.
Please have a look at Client Usage — Tryton desktop client where is clearly stated, that Fields to Import are the “Exact sequence of all columns in the CSV file.”
IMHO it would be a great enhancement to Tryton, to have a “None” Fields to Import, which just skips columns from import.
1 Like