I have an 810 edi format file that I need to import into filemker pro 8. I have no idea how to do this. I have looked this up everywhere I can think of, but to no avail. Can anyone help.

A sample is attached of the 810 file. The filemaker database im importing it into will be built from scratch for this once I know a bit more about the import. Any help would be grand!

INVOICE.810.TXT

Edited December 3, 200817 yr by Guest

Hi

I found this

Thanks, I did not make my question detailed enough.

I know what the field definitions are for the 810 but Im looking for a way to import this info FMP. Right now its just one line with "~" breaking each line. How can I import each of the the lines into the database in some meaningful way so that each person in the 810 will have a record. Next post is the example of the 810 in FMP.

Edited December 4, 200817 yr by Guest

Attached is the file Im trying to create from an import of the 810.txt.

810.fp7.zip

I have to know:

1) the INVOICE.810.txt file has some spurious returns at the end ?

2) there are always the first 2 lines ( ISA and GS ) ?

3) The line SE isn't needed ?

4) there are always the last two lines ( GE and IEA ) ?

5) can the ST number be safety considered a unique serial number ?

1. yes the returns are there, this is how the file is given to us from our supplier.

2. yes the first two lines are always the ISA and GS segments.

3. Yes the SE line is not needed.

4. Yes the ( GE and IEA ) are always the last two lines

5. the ST number is a unique serial number.

Thanks

Anyone with any help on this would be great:)

Hi

I didn't have the time to work on your problem...

but I promise to work on it.

BTW: Those spurious returns can be cleared by your supplier ?

Sorry the returns cannot be cleared, this is what makes this so difficult for me.

Ok.

Place the 2 files in the same location and give it a try.

810.zip