Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tie Commerce Help

Status
Not open for further replies.

primadonna

IS-IT--Management
Nov 6, 2004
5
US
We are using Tie Commerce Suite of products. We are new at it and we are trying to write the Segments we read from an EDI transaction to a record in our data base. The intent, is to always have the raw EDI Data attached to the Record for work-Flow management. We have opened a field in the Application Db called EDIData, within our mapping process we need to know how to write each segment, delimited by a carraige return, so that when displayed over the web, it would display the EDI data similarly to how it appears in the Itegrator package:
ST*123*133
B3*123*123*213
N1*ABC***SH
LX*1
.
.
.
SE*123*123

Does anyone have any idea on how we can do this? prima-donna@comcast.net

 
Hi primadonna,
When you extract or manipulate specific data from a document, especially only ST to SE, you will NOT have "raw" data. You should consider including the ISA to IEA.

If you want the browser to display the EDI doc as Tie Integrator does, you will have to map the EDI to XML to have the hierarchy open when click. If you want the actual branches, you will have to use ActiveX. Not so easy, but I think it can be done.

Never-the-less, I will attempt to answer your question below with alternatives.

Option1:
How about putting a pointer, such as directory path of the file, in the database? Then have the application use the path to open the file.

Option2:
How about having your mapper write an html file and store that in the database? Something like this...
<html>
ST*123*133<br>
B3*123*123*213<br>
N1*ABC***SH<br>
LX*1<br>
.<br>
.<br>
.<br>
SE*123*123<br>
</html>
Notice that the <br> is the carriage return. Then have you app display the document.

Option3:
How about using EDI-INT (aka EDIINT)? I am not sure of the specifics but it might help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top