hi all,

Could anyone help me out with biztalk server... I have a CSV file and I need to generate an XML from that CSV file. I have only the conceptual knowledge about biztalk but dont have any practical knowledge for that. Could any one tell me the steps to be followed so that the work could be done.

paras

Hi,

As far as i know , BizTalk is not the general tool for generating XML from a CSV file. You would have to search for some other tool or software that does that.

XML in BizTalk is used to represent Schemas, internal data representations and other data that would be needed during integration of one system/applicaiton with another.

If you want to use the csv file as input data to your BizTalk project than you have to write a schema that would represent that csv file. Then generate an instance of that schema (Which would be in xml format), where you can input the values you need.

To Generate a schema file in BizTalk just add new item and select "Schema" from the existing templates and you get a graphical designer where you can design the schema.

Hope this helps,


Regards
Vijay R

hi vijay,

Thanks for reply.. Actually I am not able to write the schema there. I mean I have to create a schema that has the same fields that my csv file is having in the biztalk editor and then map that to the other xml file in the mapper. Actually I am totally new to the concept of this Biztalk. I have one csv file in one folder in my machine and I want do get the xml as the output document in some other folder. Could u please give me the steps that I have to follow to do the same. I know the concepts of biztalk but do not have any exposure to the practical part of it. Do I need to create orchestation for this purpose?? I mean I am totally confused what to do and what steps are to be followed to do the work. Could u please help me out in this...

thank and regards
paras jetly
nucleus software
noida
india