473,325 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 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
Regards
Serge
Jul 21 '05 #1
0 966

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jonathan Buckland | last post by:
Can someone give me an example how to append data without having to load the complete XML file. Is this possible? Jonathan
0
by: Michael Probst | last post by:
Hi all, I am new to .NET and the way XML data is handled in .NET I wrote a small application with .NET forms in C++ The application reads data from an XML file to fill-in the fields of the...
0
by: serge calderara | last post by:
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...
3
by: Nick Gilbert | last post by:
Hi, I have to send an array of prices for a list of products over XML. Currently my XML data looks like this: <ArrayOfProd> <Prod Code="productcode001"> <Prices> <P F="2005-01-01"...
2
by: serge calderara | last post by:
Dear all, I have an ASP.NET 1.1 application which show data collected from an sql database inside a datagrid bind to a dataset which contains all data retrive. I need to display ki^nd of...
3
by: darrel | last post by:
We've had a month long headache with one of our functions in the CMS we've built. Whenever a page is updated in our CMS, we do a recursive call to the DB to get all the pages (and child pages,...
17
by: pbd22 | last post by:
hi. i keep getting this error. as i understand it, my xml isn't formatted correctly. the online errata suggests the standard formatting to solve this problem: element (tab) (tab) element
0
by: kapsshaw | last post by:
Hi I have an xml file e.g Data.xml which contains raw data e.g. <Name>Mark</Name> <Address>New York</Address> and another xml file containing the formatting factors or attributes of Data.xml e.g...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.