[jira] Created: (OFBIZ-2518) Datafile additions, fixes and other stuff

[Nicolas Malin (Jira)]

Datafile additions, fixes and other stuff
-----------------------------------------

                 Key: OFBIZ-2518
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
             Project: OFBiz
          Issue Type: Improvement
          Components: framework
    Affects Versions: SVN trunk
            Reporter: BJ Freeman
             Fix For: SVN trunk


First is to figure out what all it supposed to do and document the Xsd.
Then if I have missed something will check to make sure it works.
finally add new functionaliity
Yes I know you can program like with zipsales.
but right now I want to be able to just create entity files that will load through webtools.
1) using a tab delimited file that has a header.
2) some of the fields have quoted around them that need to be removed.
3) Need to declare entity field not in the file and put in values. Like unit of messure.


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: datafiles.xsd

This is my first attempt at docmumenting an XSD.
though there is anotation fields for everythng, I could not find enough in the code to make sense of some so if someone wants to add them then I can start the next phase.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: OFBIZ-2518-Datafile_xsd.patch

this is a patch version so you can see the changes easier.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, OFBIZ-2518-Datafile_xsd.patch
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: Product_Data_327766_1.xls

this is a sample of the type of file I am working with.
if it helps

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: Productimport.xls

this is a sample output from a 9.04 webtools

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: goodident.xml

sample output of 9.04 and what i am trying to achieve

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment:     (was: Productimport.xls)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Priority: Minor  (was: Major)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: OFBIZ-2518-Datafile_xsd.patch

updated xsd with more added constraints as well as new attributes and one to support building data definition from a file that has headers, for when use java to import.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment:     (was: OFBIZ-2518-Datafile_xsd.patch)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment:     (was: datafiles.xsd)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: datafiles.xsd

and the file itself

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment:     (was: datafiles.xsd)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: datafiles.xsd

This version still works with the current java code.
have to make changes to any existing Datafile definition in the following ways:
1)type-code="text"  is now type-code="UTF-8"

unless I figure out the ones that are commented as
Not sure the function of this
will probably leave that part alone in the code and start making mods.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: OFBIZ-2518-Datafile_xsd.patch

updated to see change current changes.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment:     (was: OFBIZ-2518-Datafile_xsd.patch)

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713378#action_12713378 ]

BJ Freeman commented on OFBIZ-2518:
-----------------------------------

List of new changes to added to code:
commented the H+++ out of the xsd.
1) has-header=true will ignore the first record of the file.
2) enumerate
      A.  type-code
     B. delimiter
     C.  text-delimiter
      D. line-terminator
     E: type

3) use-header-as-fields=true will build a datafile from the column headers

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713428#action_12713428 ]

Peter Ford commented on OFBIZ-2518:
-----------------------------------

Hello BJ,

Don't you think you that you have used very bad English in XSD files. Which country?
IMO this should be improved first then it should be committed in the trunk.

Contents present in XSD files are reference for the developer so few points should be taken care.

- Start new sentence with capital letter.
- Full stop is missing everywhere.
- There are so many other points that I can mention but please look into the patch to find those.

Isn't it lazy work?
WDYT?

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713578#action_12713578 ]

BJ Freeman commented on OFBIZ-2518:
-----------------------------------

Normally I have someone do the proof reading, since my english is terrible.
and Yes I can go back days  after and see some of the errors.
However I can't at this time.
I guess iF my english is in the way it will not get submitted.
This is not irogants, just frustrattion on something I have faced most of my life.
I envy people that can write good grammar.
And Courses will not help, It is how my brain is wired.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BJ Freeman updated OFBIZ-2518:
------------------------------

    Attachment: OFBIZ-2518-Datafile_xsd.patch

found more description and made some changes to descripitions.
this is not ready to be put in the trunk or 9.04 yet
it is here for others to comment on so I can be complete before committing.

> Datafile additions, fixes and other stuff
> -----------------------------------------
>
>                 Key: OFBIZ-2518
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2518
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: datafiles.xsd, goodident.xml, OFBIZ-2518-Datafile_xsd.patch, Product_Data_327766_1.xls
>
>
> First is to figure out what all it supposed to do and document the Xsd.
> Then if I have missed something will check to make sure it works.
> finally add new functionaliity
> Yes I know you can program like with zipsales.
> but right now I want to be able to just create entity files that will load through webtools.
> 1) using a tab delimited file that has a header.
> 2) some of the fields have quoted around them that need to be removed.
> 3) Need to declare entity field not in the file and put in values. Like unit of messure.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.