[
https://issues.apache.org/jira/browse/OFBIZ-10108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Brohl reopened OFBIZ-10108:
-----------------------------------
> 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)
Locked
