problem faced while converting XML files to IDOCS

[Former Member]

Hi guys,

I need a bit of help from you people. Firstly I want to congratulate all of you and especially the moderators for making this a very thriving community.

My requirement is I need to convert XML files deposited by our project's Unix team on a server(which is just like a physical drive like C:/ drive) known as Mercator to inbound IDOCS to be posted in a custom table which would be later used to satisfy a business requirement. I have provided the full physical path of the XML files on the Mercator and the Port name as input parameters to the FM IDOC_XML_FROM_FILE. But I am getting a runtime dump which says that the file cannot be opened by OPEN DATSET command.

Can anyone please help me in this regard?

Thanks a lot !

Hasso.

[former_member191735]

To Open from Open dataset, the file has to be in application server which is in filesystem where the SAP is.

You have to move these files into application server from presentation server.

check out transactions: cg3y and cg3z. you can convert to/from application server.

[Former Member]

Hi Sampat I thought of this solution but this will prove cumbersome for many files. Neways thanks a lot

[former_member191735]

Good you found the solution.

[brad_bohn]

The file does not have to reside on the application server, as long as the folder/directory is mounted in your system landscape. Your Basis team can map the location so that it is accessible but you are going to reference the location using '/tmp/.../myfolder/...' and not using 'C:\...\...\...' and the location should also be consistent with the inbound file folder settings on the file port you have configured in WE21.

[Former Member]

Brad thnx alot man I think this is the best thing to do .

Edited by: Hasso14 on Apr 28, 2011 3:10 PM

[Former Member]

Brad sorry to say that our Basis team is not sure how to do this-can you please chalk out the steps? It would be very helpful for us. Thanks a lot !

[Former Member]

someone help please ! basis team is totally in the dark.

[Former Member]

Hello Hasso,

Request your BASIS team to do the steps that is mentioned in the below steps:-

1) Using Mount command, mount the folder :

Format : Format: mount -t smbfs -o username={user name},password= {folders network location} {mount point} Example : mount -t smbfs -o username=tridge,password=foobar //fjall/test /data/test 2) Set the mount : Format: {folders network location} {mount point} smbfs username={user name},password=

Example: //monkey/Movies /mnt/abbas smbfs username=taco,password=paco

You can find lot of articles over the net.

Thanks,

Greetson