471,337 Members | 1,407 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Help :XML file data formatting ??

Dear all,

I have a CSV file which contains different type of data which are not
classified at all. What I mean by classified is for instance that the second
field might not always correspond to "customer Name" but maybe the second
field on the third record in the file might correspond to telephone number.

In order to edit those data in aproper way I need first to tag each records
with proper information type. Type will later correspond to a single dataset
column name.

For that I need to read this CSV file and build the proper XML file node
format based on the type of information encounter.
I can have more than 100 csv files to read with the same formating.

I was thinking of creating an XML template and use that template to generate
correctly my XML files issue from the initial CSV file.

I have nver done that before and have no experience on that, could you help
me on how to proceed ? Is ita good aproach to do so ?

I think I could also read my file , field my field and then create the xml
file line by lien accordingly with proper nxmlnode name but sounds a bit heavy

The final idea is that for data edition, I will afterwards load XML file and
bind it to a dataset object.
Thanks for your help and you expericence
Jul 21 '05 #1
0 916

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Michael Probst | last post: by
reply views Thread by serge calderara | last post: by
3 posts views Thread by Nick Gilbert | last post: by
2 posts views Thread by serge calderara | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.