473,372 Members | 1,338 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,372 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 967

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...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.