EDI Data format

I have the Data Model Resource Book I, II, III, as I saw they were used by ofbiz developers.
I have not read them cover to cover, so I was wondering if anyone knows if there is a model that makes sense for me to look at (point at a book).
I did a quick design and need to link the EDI records to the supplier record in ofbiz (going to use party_ID).
I want to make it flexible, so I will have if using ftp, or a service etc (The two companies I am initially working with use FTP). I need a record for stuff like URL, username, and password.
I need to define what is used for delimiter etc (file layout specifics).
I need for each type to have a way to define the fields that are needed on the header , the detail, and the footer (where in ofbiz do I get it, what the vendor is asking it be named etc).
Not sure the Data Model Resource Books have this. I read the part about ecomerce in book 2. It was very interesting, but did not get much into EDI.

[Pierre Smits]

Hi Joel,

It might be an option to use the contact mechanism features to capture the
ftp address of the party involved. And use the Identification element of
the party to capture the ftp userid.

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Wed, Aug 27, 2014 at 5:19 PM, [hidden email] <
[hidden email]> wrote:

> I have the Data Model Resource Book I, II, III, as I saw they were used by
> ofbiz developers.
> I have not read them cover to cover, so I was wondering if anyone knows if
> there is a model that makes sense for me to look at (point at a book).
> I did a quick design and need to link the EDI records to the supplier
> record
> in ofbiz (going to use party_ID).
> I want to make it flexible, so I will have if using ftp, or a service etc
> (The two companies I am initially working with use FTP). I need a record
> for
> stuff like URL, username, and password.
> I need to define what is used for delimiter etc (file layout specifics).
> I need for each type to have a way to define the fields that are needed on
> the header , the detail, and the footer (where in ofbiz do I get it, what
> the vendor is asking it be named etc).
> Not sure the Data Model Resource Books have this. I read the part about
> ecomerce in book 2. It was very interesting, but did not get much into EDI.
>
>
>
> -----
> Joel Fradkin
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/EDI-Data-format-tp4654326.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

I created EDI record entity to allow me to do configurable exporting of data.

I have a header record (part of that is the FTP URL, Password, and userid.
I may take a look at moving those elements per your suggestion.

I am using a Role under the party group to say if there is a EDI configuration.
I added to my supplier screen a drop down where the EDI format can be selected.
If one is selected the role is added.

I have a section and field table. Its a bit hard coded to using entities in view order, but the field selection is configurable. I have done two vendors with it and is working good. The header has place to say if usng quotes, what the delimiter is EOL etc. My one supplier just wanted a header and line items, the other was 9 sections. I added the two suppliers to my seed data, so they will be available for any clients. I may add a front end at some point to configure EDI data, as username, password, etc will be specific to the user.
It gets all the other stuff from ofbiz data, like requested date (I had to do a loop and get the first one for one of the vendors as they wnated just one requested date in the header). So there are a few specialized fields.