Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

When import csv file in insert mode, if head column has character "/" import is stop with message error

Description

I. step redo:
1. in any window has field with "/" (example product with field "UPC/EAN")
export record to give template file.
2. fill some data, process import with insert mode.
3. below error message is showed
"org.adempiere.exceptions.AdempiereException: In order mark a column as a Key,the character 'K' must be used in capital letter."

II. reason:
Current GridTabCSVImporter assumes column contain "/" must is column key => must contain "/K".
because column name with "/" fire error.

. solution
check key with pattern (end "/K" is key)

Environment

None

Attachments

1

relates to

Activity

Show:

Hiep Lq July 16, 2014 at 5:24 PM

sorry, maybe my template is wrong. just check code. it do correct as you said

Carlos Ruiz July 16, 2014 at 5:10 PM

, I think the case is not valid, the header is composed by columnNames, not fieldNames. The UPC/EAN field is exported as UPC columnname, a columnname in databases usually cannot contain "/"

Cannot Reproduce

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Created November 12, 2013 at 9:49 AM
Updated July 16, 2014 at 5:24 PM
Resolved July 16, 2014 at 5:24 PM