CSV export/import not working on tables with ad_ref_list
Description
Environment
None
Attachments
1
- 06 Oct 2014, 01:25 PM
Activity
Show:
Hiep Lq May 29, 2017 at 3:37 AM
now i know why. almost table use column "EntityType" when reference to "AD_EntityType".
just AD_Package_Exp_Detail use AD_EntityType_ID
refer:IDEMPIERE-3378
Hiep Lq May 28, 2017 at 11:35 AM
sorry @Claudemir Todo Bom, this logic is already exists from begin.
hi @Carlos Ruiz has any reason for "Entity Type" to use ID?
Hiep Lq May 28, 2017 at 11:28 AM
hi @Claudemir Todo Bom can you give me a test case for "Entity Type"
i don't see any reason to use id for this table.
Claudemir Todo Bom October 26, 2014 at 1:27 PM
Looks like this bug only happens when using a language different from English.
The patch attached before solve the issue exporting and importing the actual database value instead of the referenced textual value.
To keep the behaviour intended, it is needed to force the export to work in English, or adapt the importer to work on the current language.
Fixed
Assignee
Carlos Ruiz
Carlos RuizReporter
Claudemir Todo Bom
Claudemir Todo BomLabels
Components
Affects versions
Priority
Created October 6, 2014 at 1:25 PM
Updated September 30, 2017 at 2:49 PM
Resolved February 2, 2015 at 11:38 PM
When exporting using the CSV format, the generated file uses the "Column[Name]" format for columns that are related to the AD_Ref_List table, and for the field content it uses the contents of the column Name on AD_Ref_List (translated to the selected language if possible).
The problem is that the importer does not recognize this format, always telling that the relation is not found.
I was successful on exporting and importing with the small patch attached, what it does is treat the column related to the AD_Ref_List as a simple column, without any relation and placing on the exported file the exact data of the column on the record. When the (unmodified) importer gets this, it will treat the same way, and if the related data doesn't exist on AD_Ref_List, the record insertion will fail.