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
