XML to CSV conversion is not happening using file adapter!

[Former Member]

I am new to XI and with some extensive reading and hep of experts here I finished file adapter configuration for conversion of XML to CSV. here are the steps I followed.

1) Create new software componet version and product

2) I had XML1 with deep structure and since File content conversion does not work with deep struture, I created XML2 using mapforce that generated XSLT which I used in the configuration. I downloaded "xsl" file into "imported archives" in IR.

3) I created XSD schemas for XML1 and XML2. I downloaded these under "external definitions" in IR.

4) I created "otubound interface (used XSD1 as my data type" and "inbound interface (used XSD2 as data type). I found help on SDN that mentioned I don't have to create data type and message types because I am using xsds and data types are ddefined in those.

5) I then created interface mapping with source interface (XSD1) and target interface (XSD2) that would convert my XML1(deep) to XML2(simple) and then use this to create CSV file.

Integration directory:

I then created configuration scenario, sender communication channel, recever communication channel (with file content conversion), receiver determination, sender and reciever agreements and all that stuff. In receiver communication channel I provided "source directory" "file" and also "archive directory" where the file should move to after processing. I set poll interval as 5 but it takes half hour to process file every time! I am not sure what is worng here! The source XML dile XML1 is moving feom source to archive directory but it is not getting converted to XML2 and then to CSV! Is there a place to see XML2 as this is the XML that receiver should use as source to create CSV file. CSV file is also not getting created.

Could someone please give any feedback? I am stuck here and would appreciate your help.

Thanks.

--Mithun

[Former Member]

Thanks everyone for the feedback. I found out the problem was with authorization where I am writing the file to and everything is working fine now.

Mithun

[Former Member]

Hi Mithun,

Check whether the file is picked from the respective folder. Check this in Communication Channel monitoring.

RWB> Component monitoring> Click Adapter Engine> Click Communication Channel monitoring>Select the Communication Channel and check the status.

Now, Goto to Moni using the Transaction code Sxmb_moni or SXI_Monitor. Select the Namespace and interface and check for the processed messages. Now, check the Payload.

Click Inbound Message>Payloads>Main document --- Inbound message

In the same way, Select Technical Routing and check the payload of the receiver.

Thanks,

[Former Member]

HI,

1. File adapter will poll for every 5 minutes and if file is not available it does nothing...else it will process the file...

Check in source directory whether thefile is there or not to process for the file adapter....

2. For youe scenario check any error generated in SXMB_MONI if yes then specify the error...

3. Take the input payload and try to test the same in operation mapping test tab for knowing the mapping program working or not..

4. if mapping program is fine then check at the receiver adapter (RWB->AdapterEngine->CC Monitoring ->channel name of receiver)whether any conversion error occured for the FCC..

HTH

Rajesh.P

[Former Member]

Thanks for the fedback. I checked sxmb_moni and not able to find anything there! I might be doing something wrong. There are several items in the list when i run this transaction. Which one should I select? Also, where do I find the payload? thanks for all your help again.

Mithun

[Former Member]

Keep Filter in the sxmb_moni to find out the selective interfaces..

Once you find your message in the moni then expand the same there you can find the inbound payload in that..

right click and downlaod the same ..

HTH

Rajesh .P

[zameerf]

Hi Mithun,

->I checked sxmb_moni and not able to find anything there! I might be doing something wrong. There are several items in the list when i run this transaction. Which one should I select? Also, where do I find the payload?

Please select the 'Monitor for processed XML messages' option under sxmb_moni, then press F8.

You will find all the messages processed, find the relevant message and then under 'Inbound Message->Payloads', check for your payload. Hope this helps.

Thanks,

Zameer

[Former Member]

ANyone has any idea please?

Thanks.

Mithun

[baskar_gopalakrishnan2]

XML TO CSV.

Create File sender for input XML data(XML1). Use normal file adapter for picking up the file.

map XML1 source side to XML2 target side.

Create file receiver adapter with FCC message protocol and configure adapter to convert xml structure to csv.

Check in SXMB_MONI .... What is the error? problem could be mapping ...conversion from file to fcc on the inbound side.(FCC side).

Refer document for the target side file adapter (receiver).

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Hope this helps.