[ https://issues.apache.org/jira/browse/OFBIZ-10108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nicolas Malin updated OFBIZ-10108: ---------------------------------- Attachment: OFBIZ-10108.patch > 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 > Attachments: OFBIZ-10108.patch > > > 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)