filemaker 8 user Posted December 3, 2008 Share Posted December 3, 2008 (edited) 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, 2008 by Guest Link to comment Share on other sites More sharing options...
Raybaudi Posted December 3, 2008 Share Posted December 3, 2008 Hi I found this Link to comment Share on other sites More sharing options...
filemaker 8 user Posted December 4, 2008 Author Share Posted December 4, 2008 (edited) 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, 2008 by Guest Link to comment Share on other sites More sharing options...
filemaker 8 user Posted December 4, 2008 Author Share Posted December 4, 2008 Attached is the file Im trying to create from an import of the 810.txt. 810.fp7.zip Link to comment Share on other sites More sharing options...
Raybaudi Posted December 4, 2008 Share Posted December 4, 2008 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 ? Link to comment Share on other sites More sharing options...
filemaker 8 user Posted December 4, 2008 Author Share Posted December 4, 2008 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 Link to comment Share on other sites More sharing options...
filemaker 8 user Posted December 11, 2008 Author Share Posted December 11, 2008 Anyone with any help on this would be great:) Link to comment Share on other sites More sharing options...
Raybaudi Posted December 11, 2008 Share Posted December 11, 2008 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 ? Link to comment Share on other sites More sharing options...
filemaker 8 user Posted December 11, 2008 Author Share Posted December 11, 2008 Sorry the returns cannot be cleared, this is what makes this so difficult for me. Link to comment Share on other sites More sharing options...
Raybaudi Posted December 13, 2008 Share Posted December 13, 2008 Ok. Place the 2 files in the same location and give it a try. 810.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5751 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now