[jira] Created: (OFBIZ-2031) Import CSV file using specify text delimiter

[Nicolas Malin (Jira)]

Import CSV file using specify text delimiter
--------------------------------------------

                 Key: OFBIZ-2031
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2031
             Project: OFBiz
          Issue Type: Improvement
          Components: framework
    Affects Versions: SVN trunk
         Environment: N/A
            Reporter: Ray Barlow
            Priority: Minor
             Fix For: SVN trunk


Given a CSV like below:
  "123456", "1273681xa", 33
  "234567", "12dsq81xa", 21

and using text-delimiter i.e.
  <data-file name="MyRecord" separator-style="delimited" type-code="text" delimiter="," text-delimiter='"'>

it will now handle removing the quots (or any specified character) from around the data if they exist.


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ray Barlow updated OFBIZ-2031:
------------------------------

    Attachment: DataFile-CSV-text-delimiter.patch

> Import CSV file using specify text delimiter
> --------------------------------------------
>
>                 Key: OFBIZ-2031
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2031
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: N/A
>            Reporter: Ray Barlow
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: DataFile-CSV-text-delimiter.patch
>
>
> Given a CSV like below:
>   "123456", "1273681xa", 33
>   "234567", "12dsq81xa", 21
> and using text-delimiter i.e.
>   <data-file name="MyRecord" separator-style="delimited" type-code="text" delimiter="," text-delimiter='"'>
> it will now handle removing the quots (or any specified character) from around the data if they exist.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-2031.
----------------------------------

    Resolution: Fixed

Thanks Ray,

Your patch is in trunk rev. 709002.

For anyone interested : as it's not really a bug fix I did not merge in, but I guess it can also be used in release4.0,

> Import CSV file using specify text delimiter
> --------------------------------------------
>
>                 Key: OFBIZ-2031
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2031
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: N/A
>            Reporter: Ray Barlow
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: DataFile-CSV-text-delimiter.patch
>
>
> Given a CSV like below:
>   "123456", "1273681xa", 33
>   "234567", "12dsq81xa", 21
> and using text-delimiter i.e.
>   <data-file name="MyRecord" separator-style="delimited" type-code="text" delimiter="," text-delimiter='"'>
> it will now handle removing the quots (or any specified character) from around the data if they exist.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.