Question Re: Uploading a Flat file in Product Lifecycle Management Q&A

Uploading a Flat file

Former Member — Thu, 23 Jun 2011 10:17:14 GMT

Hello!

How to upload a flat file in MII ?

Is flat file is always a jar fille ?

Is there any connector available for the same ?

Thanks.

Re: Uploading a Flat file

Former Member — Thu, 23 Jun 2011 13:55:59 GMT

Hi Vaibhav..

What is the purpose of the file?

If you want to upload any drivers, you can upload .zip or .jar file under System Management -> JDBC Drivers.

You can upload flat file here as well.

You can use action blocks in transactions to deal with files.

Some information here as well : http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30472799-604b-2b10-d4bf-d7498b027674?quicklink=index&overridelayout=true

Hope this is useful..

Best Regards,

Kedar

Edited by: Kedar Shewalkar on Jun 23, 2011 3:57 PM

Re: Uploading a Flat file

Former Member — Thu, 23 Jun 2011 15:33:07 GMT

If you are dealing with a text flat file with data (CSV file for example) then you can use 2 action blocks. First - "FTP_Input". There you specify your FTP information where file is stored. Than you need to connect this block with "Text_Loader". Here you specify path to file in your system after it was uploaded from FTP. After that you can do whatever you want with the file. Use flat file parser for example or something else.

Hope this helps,

Peter

Re: Uploading a Flat file

Former Member — Thu, 23 Jun 2011 16:14:22 GMT

One of the way that I prefer for uploading flat file is FTP.

I wrote a blog on it some time back.

Here is the link. You may find it useful

/people/musarrat.husain2/blog/2008/01/10/xmii-and-file-transfer-handling-for-beginners

Thanks,

Musarrat