CSV export/import not working on tables with ad_ref_list

Description

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.

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 , this logic is already exists from begin.
hi has any reason for "Entity Type" to use ID?

Hiep Lq May 28, 2017 at 11:28 AM

hi 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

Reporter

Labels

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