Database to edi

, ,
1

Hello all,
Im new to webMethods and here im with a problem which is draining me.Im successful in inserting the required data from edi(850) into database(SQL SERVER).Now i want to know whether i can gat an edi document from the database values i have inserted.Please let me know this.Thanks in advance…

Nivas

2

Nivas,

EDI document cannot be directly created from database,first you need to retrieve/extract the database values and then do mapping of individual values to appropriate EDI segments to prepare the final edi docume.

Regards,

3

RMG,
thanks for ur reply.but can u please be more specific.

4

RMG,
thanks for ur reply.but can u please be more specific.

5

RMG,
thanks for ur reply.but can u please be more specific.

Regards

6

Nivas,

You need to query the source data from database which gives the results as a recordlist set in webMethods.Then map these values to (EDI50)record structure (segment mapping)what ever fields you specification require and finally using WmEDI package there are some built-in services available like(convertToString,addICEnvelope,addGroupEnvelope) which helps to create the EDI document.

There are lot of discussions done in this forum,about creating the EDI document,basic services to use.Please use the search functionality.

BTW which version of webMethods/EDI you are using?

Regards,

7

Nivas,
Checkout the webMethods provided wmEDISample packags. they have shown how to convert XMl(DB values) into EDI and EDI859 and vice versa.
It will be really help.
If this does not work let me know I will give you mapping services.

8

vikram,
examples in wmEDISample package r lil confusing.can u help me in this.Im trying to convert the values from database to edi.i first extracted the values from the database and then used the service convertToString.Please tell me what to do next.

Thanks,

9

Nivas,

Is this inbound or outbound EDI to you? I’m assuming outbound application (database) to EDI but please confirm.
What version of wm are you using?
Exactly what have you done so far?
Do you have an Idata object that represents your application file?
Do you have an Idata object that represents your X12 EDI?
Have you mapped the one to the other?
When you used converToString what did you get.

What in wmEDISamples package didn’t you understand.
The more detail the better.

And finally, Don’t cross post.
Answer the questions and let’s see if we can help you.

10

Chris,
This is outbound EDI im doing.Wm version is 6.0.1.i have a table containing the some data related to tax segment of 850 edi .now i want to convert the data in the database to edi.After extracting the data from database …i used convertToString,which gave a string pertaining to the schema i created.now i want to know how to map these values in the database to the edi record structure.

11

Nivas,

Once you have extracted the data from database it will give the results (IDATA object).Nextstep will is loop thru results and map the tax values to TAX segment of 850 recordstructure(ST/TAX), like this map rest of the required segments and form an ST segment that contains (eg:BEG,N1,LIN,TAX segments etc…)
.
Finally invoke the convertToString and here map the ST segment which i have mentioned above, set the edi 850 schemaname,delimiters following with addICEnvelope(ISA/IEA),addGroupEnvelope(GS/GE) services to generate (Envelope segments) to prepare the valid EDI 850 document (ISA/GS/ST/SE/GE/IEA.

Regarding mapping of addICEnvelope,addGroupEnvelope mapping,refer the WmEDISamples package which will help you with necessary information.

HTH,

12

RMG,
Thank u very much for ur info.I’ll go thru the steps u mentioned and get back ,for further clarifications if any…

Thanks,

13

Hello Professionals,
I am trying to create an XML file by the data which is results from an adapter service. I have multiple records in my hand. Can any one help to generate an XML file for the multiple records.

Thanks

Nani

14

Nani,

I see you got your answer in another post. Please do not cross post.

Thanks.

And please register.