Help :XML file data formatting ??

From: serge calderara (sergecalderara_at_discussions.microsoft.com)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 05:55:09 -0800

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

Relevant Pages

  • Re: Complex Import Problem - PDF to XML to CSV to Access?
    ... CSV file of numeric values into one with the corresponding text values. ... What's in the XML file? ... and translate the numerical data back into the text I need. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • XML parser
    ... For one of my applications I write and read some data to / from a CSV file ... Now I want to replace the CSV file by a XML file. ... because it wouldn't be too hard to code my own routine to ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: XML to CSV
    ... Harry wrote: ... and convert it to a CSV file using an XSLT file. ... Everything works fine but I cannot figure out how to include the list of field names as the first row in the CSV file. ... if your XML file looked like this: ...
    (microsoft.public.sqlserver.xml)
  • Re: Parse a CSV file in C#?
    ... Can I programmatically save the file as an Excel Workbook and then parse ... file using the Excel Namespace Methods available? ... Or can I programmatically save the CSV file as an XML file and then parse ...
    (microsoft.public.dotnet.framework.aspnet)
  • Encoding string to fit CSV standard
    ... quotes, new lines, etc.). ... How can l encode them to make them proper ... fields of a CSV file? ...
    (comp.lang.basic.visual.misc)