Major Description
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.