EDI 2

[Databaseguy]

Anyone out there have any sample code for converting an EDI document (810-Invoice, 850-PO, 856-ASN, 860-Change Order or 977-Order Ack)into an Access table ??

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[DougP]

No,
Is it ASCII text file??
I can create something. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Databaseguy]

Hey Doug.

I've been away for a while. Got laid off, and hired about a week later as MIS Mgr.

Anyway, to answer your question, no. It's not ASCII. It's, well... have a look see:

ISA*00*0000000000*00*0000000000*08*6111470100 *12*6195987909 *011015*1841*U*00401*000001765*0*P*>
GS*PO*6111470100*6195987909*20011015*1841*450*X*004010
ST*850*100835356
BEG*00*SA*0076-3655095-0553**20011015
REF*IA*1026371*OUR COMPANY NAME
REF*DP*076
FOB*DF*OR*VISTA CA
CSH*Y
ITD*01*2*1**30
DTM*037*20011017
DTM*038*20011022
TD5*B*2*VIKN*M
N1*BY*OUR CUSTOMER 0553*92*0553
N3*ADDRESS
N4*FONTANA*CA*92336*US
PO1*1*495*EA*2.7*WE*CB*076061726*VA*00000*UP*490760617264
CTP*RS*RES*4********1
PID*F*73***WHITE
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
PO1*2*495*EA*2.7*WE*CB*076061727*VA*00000*UP*490760617271
CTP*RS*RES*4********1
PID*F*73***CHALK
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
PO1*3*810*EA*2.7*WE*CB*076061728*VA*00000*UP*490760617288
CTP*RS*RES*4********1
PID*F*73***RED
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
PO1*4*810*EA*2.7*WE*CB*076061729*VA*00000*UP*490760617295
CTP*RS*RES*4********1
PID*F*73***POPPY
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
PO1*5*693*EA*2.7*WE*CB*076061730*VA*00000*UP*490760617301
CTP*RS*RES*4********1
PID*F*73***BLUE
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
PO1*6*693*EA*2.7*WE*CB*076061731*VA*00000*UP*490760617318
CTP*RS*RES*4********1
PID*F*73***COBALT
PID*F*08***BOY TOP
PO4*9
SAC*N**VI*HA
CTT*6*3996
SE*51*100835356
GE*1*450
IEA*1*000001765

I could study it & figure it out, I was hoping someone out there does this routinely & had a tool that they use.
Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[cmmrfrds]

There are a lot of issues with coding and decoding EDI transactions, since each transactions has different segment types filled in. Looking at raw EDI data from the vendor will not show all the possible ways the vendor could be filling out the particular EDI transaction. You would need to look at their specifications for the EDI transaction type. Also, if you have more than one EDI vendor the raw EDI may contain more or less segment types depending on how the vendor chose to implement the particular EDI transaction. I have used Access to create 850, 852, and 867 transactions , but it was specific to one vendor. The Access programs formats the data to be exported to a format expected by ProEdi, an EDI product that maps EDI transactions with all the partner and interchange data needed to send the EDI. I have also used Sterling Commerce's EDI mapping product and it is a better solution than trying to process EDI data in Access. If you are interested, I can send you an Access mdb where I process an incoming EDI 850 or another mdb that processes an outgoing EDI 850.

Jerry

 

[Databaseguy]

Ahhhh....An Expert Just what I was looking for.

Sure. Please E-mail the zipped mdb's. At least I can get an idea on how one person has attacked this problem.

I've been studying X-12 all day. Also been in touch with GE @ gegxs.com and trying to get up to speed. There's a lot to be learned, I'm afraid.

Really appreciate your effort. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[cmmrfrds]

Tyrone, I emailed you some files, mdb's etc. for processing the 850. In my experience the most difficult edi transaction is the 856 since there can be a lot of different implementations and a lot of loops, and sub loops when you create the transaction. Again, I would recommend purchasing a mapping product, such as, ProEdi or Sterling Commerce. There are others but I am not familiar with them.

Jerry

 

[MichaelRed]

cmmrfrds, I would also appreciate an opportunity to look at your implementation. I have some code to GENERATE the 850/855 docs, but have not gotten to to the reverse (YET).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Databaseguy]

cmmrfrds, Thx again for your help. Awesome Stuff.

Hey Michael, wanna trade ???? Seriously, I know you're a VB Pro, and would like to see you're outgoing stuff. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[GBGH]

Jerry (cmmrfrds),
I would also like to see your code if possible. I need to generate a Health Care Claim/837 EDI document from my Access application and am very newbie at EDI.
Thanks,
Gretchen
gretchen@maine.rr.com

 

[cmmrfrds]

Gretchen, I will send you code for the 850 (PO) coming in. I could send the code for the 850 going out if you feel that would add anything. Just let me know.

 

[thewa]

Jerry (cmmrfrds),
Sounds like something I'm struggling with myself...outputing a "simple" 856. I'd greatly appreciate taking a look at what you have accomplished.
Thanks,
Warren
wjsherling@attbi.com

 

[MIS778]

Jerry (cmmrfrds),
Your Access database with incoming and outgoing EDI format would be of great help to me. Is it possible for you to email me what you have done? I have needs of sending an EDI file (I believe a 211, Bill Of Lading) from our ERP software out to a vendor. Access is our tool for extracting the data out of our ERP software. I have the template for the EDI file, and I can extract all the different data in a database format, but to translate or output into the needed EDI format is where I need help.

I would love to be able to look at what you have done. Thanks for any help you can give.

Tony
tony@gdtinc.com

 

[Ecniv]

Sorry to butt in but doesn't EDI follow a file format?

I did one for a company a while back (incoming and outgoing file formats where records in the file format could be a various amounts of data and data types). Would EDI be similar? I almost had a job which would have involved EDI and I would be grateful for an insight into what I missed.

Vince