Nicolas Malin created OFBIZ-10108: ------------------------------------- Summary: Import file with data-file, add start-line to escape the header column line Key: OFBIZ-10108 URL: https://issues.apache.org/jira/browse/OFBIZ-10108 Project: OFBiz Issue Type: Improvement Components: framework Affects Versions: Trunk Reporter: Nicolas Malin Assignee: Nicolas Malin Priority: Minor
When you load a CSV file some time with a data-file definition, if it contains some header column you can use the format attribute of you column. Example {code} ref;date 100;2017-10-10 200;2017-12-11 {code} This definition failed {code} <data-file name="MyCsvTest" separator-style="delimited" type-code="text" delimiter=";"> <record name="Test"> <field name="ref" type="String" position="1"/> <field name="date" type="CustomTimestamp" format="yyyyy-MM-dd" position="2"/> </record> {code} You need to read the date as string and after convert it on your code to escape the first line. To solve it I propose to add a new attribute start-line like this : {code} <data-file name="MyCsvTest" separator-style="delimited" type-code="text" *start-line="1"* delimiter=";"> <record name="Test"> <field name="ref" type="String" position="1"/> <field name="date" type="CustomTimestamp" format="yyyyy-MM-dd" position="2"/> </record> {code} I already implemented this on customer site with success -- This message was sent by Atlassian JIRA (v6.4.14#64029)