FILE to JDBC Adapter

[Former Member]

Hello, everyone,

I am going through the scenario "FILE to JDBC Adapter using SAP XI3.0" provided by Anirban Ghatak.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

One step I don't understand. In step 4, it says '...the action field is hard coded with "insert" value under CONSTANT function'. Is there anybody can tell how I can do this step? Thanks in advance!

Meiying

[Former Member · Accepted solution]

Hi Meiying,

Very simple..:)

Create a constant and give its value as insert, and map it to the 'action' field in the target

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member · Accepted solution]

Thank you very much, Prashanth!

I am really new to XI.

Now I created a constant, it appears in the Layout Mapping area. Then I droped down the "action" node into the area too and map them. Does it sounds OK? Thank you!

Meiying

[Former Member]

Hi Meiyang,

That is nothing, Since we define action as an attribute, XI automatically assigns it an Optional tag..

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

I see. Thank you very much for your answer. /Meiying

[Former Member]

Hope ur problem got solved!

cheers,

Prashanth

[Former Member]

Hi, Prashanth,

Thanks very much for your instruction. I did not do those mappings you mentioned, especially the most important one map "TABLE". That is why I got error. Now I successfuly activated it. One more question, I see in your screen shot,field "action"'s Occurences is "optional" and has an arrow on the top of the node. How can I get that? Thank you! meiying

[former_member192079]

Hi Meying

i to got stuck with the <u>table</u> element,

can u send me the screen shots sent to u , by prashant of message mapping.

below is link of the page from where i got into the disscussion between u & prashant.

dated:- Aug 2, 2006 11:24 PM

Your valuable suggestion will be of great help to me..

Thanks & Regards

Ashutosh

[Former Member]

Hi Meiying,

Sent it to you... Check ur mapping, and let me know!

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

Hi Meiying,

Please gimme ur email ID.. I shall send u a screenshot of the mapping

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

My email is myang@olemiss.edu. Thank you for your help!

Meiying

[Former Member]

Hi Meiying,

Have fun! All the best

cheers,

Prashanth

[Former Member]

Hi,

I am back again. I still have problem on this one. I created an Message Mapping and mapped them as stated in the step4. (I also created a node " constant" and mapped it to "action"). When I try to activate it, it give me an error says "Mapping not sufficiently defined". I see node "TABLE" in the tagart is red, not green. Is there any suggestion? Thanks!

Meiying

[Former Member]

Hi Meiying,

Statements with this action cause table values to be inserted. Therefore, the statement corresponds to an SQL INSERT statement.

Look at this for more info

http://help.sap.com/saphelp_erp2005/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

cheers,

Prashanth

P.S Please Mark Helpful Answers

[Former Member]

Hi, Prashanth,

Thank you very much for your answer! I will look at the link carefully!

Best regards!

Meiying

[Former Member]

Hi Meiying,

Double click on the constant node, and in the value field, give INSERT. Then map it to the action field as u said

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

I did as you said. Would you please tell me what that mapping mean? Thank you very much!

Meiying