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

["Si Chen (JIRA)" <ji...@apache.org>]

     [ 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