[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: CSV to XML

• To: <xml-dev@l...>
• Subject: Re: CSV to XML
• From: "Bryce K. Nielsen" <bryce@s...>
• Date: Thu, 11 Aug 2005 09:58:41 -0600
• References: <200508101611882.SM00656@m...>

Take a look at the tutorials in the help file, particularly the 
SingleMapFile one, as well as check out 
http://www.sysonyx.com/xml-to-edi-850 for a small sample on how to use the 
tool. It may not be what you're looking for, since it won't do any 
transformations, it's just a quick way to get your document from text into 
XML. You have a document, lines and fields inside the lines (as well as 
nestable lines).

Bryce K. Nielsen
SysOnyx, Inc. (www.sysonyx.com)
Read the genesis of xmlHack, the Simple XML Editor
http://www.sysonyx.com/xml-editor


----- Original Message ----- 
From: "Taco Fleur (@DataBroker)" <taco@s...>
To: <xml-dev@l...>
Sent: Wednesday, August 10, 2005 4:04 PM
Subject: RE:  CSV to XML


> Had a go at the software, no offense but its not very intuitive, I could 
> not
> figure out how to work it.
>
> Cheers.
>
> -----Original Message-----
> From: Bryce K. Nielsen [mailto:bryce@s...]
> Sent: Thursday, 11 August 2005 3:36 AM
> To: xml-dev@l...
> Subject: Re:  CSV to XML
>
>> If you have your data in one format and need it in another format, you
>> need your data transformed. If you don't want to write it yourself and
>> would prefer to use an existing utility, I would ask whoever came up
>> with your target format if they have anything. If they don't, no one
>> will.
>>
>> I really can't picture how starting with CSV would be any easier than
>> starting with XML, unless you're new to XML transformations (whether
>> by XSLT, SAX, or whatever) in general.
>>
>
> Often times the document you are starting with is not in your control, 
> it's
> given to you by external means, and even they may not have control (such 
> as
> an export from an old software package).
>
> As for translating the CSV into XML, there are a lot of 3rd party packages
> on the market that will do this (one of which I am the author of). Some go
> all the way to transforming the document into the end message you are
> looking for, some do a simple tranlsation of the document straight into 
> XML
> and then expect you to use a stylesheet to transform the resulting 
> message.
> This is used often in B2B/EDI projects. Altova offers one in their 
> MapForce
> product, many EDI companies do as well. Prices range from very expensive
> (read thousands of dollars) to relatively in-expensive(xmlLingusit, the 
> tool
> I created, is only $79.95). Shop around, check out xmlsoftware.com, etc.,
> you can probably find a descent middle-ware tool to do this job for you, 
> if
> you don't want to create the code yourself.
>
> Bryce K. Nielsen
> SysOnyx, Inc. (www.sysonyx.com)
> Makers of xmlLinguist, the Text-to-XML Translator
> http://www.sysonyx.com/products/xmllinguist
>
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an 
> initiative
> of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://www.oasis-open.org/mlmanage/index.php>
>
>
>
>
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://www.oasis-open.org/mlmanage/index.php>
>
> 

• Prev by Date: RE: Is HTML structured or unstructured information?
• Next by Date: [ANN] early version of the XML Query Test Suite
• Previous by thread: RE: CSV to XML
• Next by thread: Web 2.0 - Leading the Web to its full potential by side-steping theW3C bureaucracy
• Index(es):
  • Date
  • Thread