[ 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
