You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Si Chen (JIRA)" <ji...@apache.org> on 2006/07/25 01:43:13 UTC
[jira] Created: (OFBIZ-108) DataFiles tool improvements to support
CSV, tabs, empty columns, default values, sequences, etc.
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
[jira] Closed: (OFBIZ-108) DataFiles tool improvements to support
CSV, tabs, empty columns, default values, sequences, etc.
Posted by "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
[jira] Commented: (OFBIZ-108) DataFiles tool improvements to
support CSV, tabs, empty columns, default values, sequences, etc.
Posted by "Leon Torres (JIRA)" <ji...@apache.org>.
[ 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