[jira] Created: (OFBIZ-108) DataFiles tool improvements to support CSV, tabs, empty columns, default values, sequences, etc.

[Nicolas Malin (Jira)]

DataFiles tool improvements to support CSV, tabs, empty columns, default values, sequences, etc.
------------------------------------------------------------------------------------------------

                 Key: OFBIZ-108
                 URL: http://issues.apache.org/jira/browse/OFBIZ-108
             Project: OFBiz (The Open for Business Project)
          Issue Type: Improvement
          Components: framework
    Affects Versions: SVN trunk
            Reporter: Si Chen
             Fix For: SVN trunk


A long time ago we had worked on extending the OFBiz DataFile tool with the following features:

1.  separator-style="tab" or "csv" will do tab or csv importing.  This will support Excel CSV files, including formats such as

"This is a comma delimited field, which means it can have commas in the text separated by quotes", "125.00",

Also supports tab delimited formats.

2.  Set constant values for fields or default values if they are null, by using tags such as default-value="<value>" will set the value when there is nothing there
and default-value="<value>" constant-value="true" will set a constant
3.  Skip null records: use a skip-if-null="true" for a field, and if the field is null or only has blank spaces, a record will not be added
4.  Default values for date fields, use attributes: default-value="2004-05-01" constant-value="true"
5.  auto-generated="true" will cause an auto-generated sequence from the current entity name, or if seq-name is specified, from that entity

This unfortunately never got pushed back to OFBiz, but I think it would be a good enhancement, so if someone else on the list has the time to work on it, I can post a file plus some documentation to help you merge it back into the OFBiz DataFiles component.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-108?page=comments#action_12423365 ]
           
Leon Torres commented on OFBIZ-108:
-----------------------------------

Also, I think there should be an option to ignore empty columns.  When generating CSV, it is common to get blank columns such as,

,,data,,,,data

There are 6 columns here and only two are empty.  As it stands, the user has to remove these blanks by hand, which can be tricky without a good editor.

> DataFiles tool improvements to support CSV, tabs, empty columns, default values, sequences, etc.
> ------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-108
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-108
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Si Chen
>             Fix For: SVN trunk
>
>
> A long time ago we had worked on extending the OFBiz DataFile tool with the following features:
> 1.  separator-style="tab" or "csv" will do tab or csv importing.  This will support Excel CSV files, including formats such as
> "This is a comma delimited field, which means it can have commas in the text separated by quotes", "125.00",
> Also supports tab delimited formats.
> 2.  Set constant values for fields or default values if they are null, by using tags such as default-value="<value>" will set the value when there is nothing there
> and default-value="<value>" constant-value="true" will set a constant
> 3.  Skip null records: use a skip-if-null="true" for a field, and if the field is null or only has blank spaces, a record will not be added
> 4.  Default values for date fields, use attributes: default-value="2004-05-01" constant-value="true"
> 5.  auto-generated="true" will cause an auto-generated sequence from the current entity name, or if seq-name is specified, from that entity
> This unfortunately never got pushed back to OFBiz, but I think it would be a good enhancement, so if someone else on the list has the time to work on it, I can post a file plus some documentation to help you merge it back into the OFBiz DataFiles component.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

     [ http://issues.apache.org/jira/browse/OFBIZ-108?page=all ]

Si Chen closed OFBIZ-108.
-------------------------

    Resolution: Won't Fix

Well, I guess nobody was really interested in this one...

> DataFiles tool improvements to support CSV, tabs, empty columns, default values, sequences, etc.
> ------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-108
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-108
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Si Chen
>             Fix For: SVN trunk
>
>
> A long time ago we had worked on extending the OFBiz DataFile tool with the following features:
> 1.  separator-style="tab" or "csv" will do tab or csv importing.  This will support Excel CSV files, including formats such as
> "This is a comma delimited field, which means it can have commas in the text separated by quotes", "125.00",
> Also supports tab delimited formats.
> 2.  Set constant values for fields or default values if they are null, by using tags such as default-value="<value>" will set the value when there is nothing there
> and default-value="<value>" constant-value="true" will set a constant
> 3.  Skip null records: use a skip-if-null="true" for a field, and if the field is null or only has blank spaces, a record will not be added
> 4.  Default values for date fields, use attributes: default-value="2004-05-01" constant-value="true"
> 5.  auto-generated="true" will cause an auto-generated sequence from the current entity name, or if seq-name is specified, from that entity
> This unfortunately never got pushed back to OFBiz, but I think it would be a good enhancement, so if someone else on the list has the time to work on it, I can post a file plus some documentation to help you merge it back into the OFBiz DataFiles component.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira