OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   RE: [xml-dev] Csv2dsml

[ Lists Home | Date Index | Thread Index ]


I new it had to be out there...Thanks Menzo for the link...really good


-----Original Message-----
From: Menzo Windhouwer [mailto:M.A.Windhouwer@cwi.nl] 
Sent: Friday, October 29, 2004 3:21 AM
To: Brad Tumy
Cc: xml-dev@lists.xml.org
Subject: Re: [xml-dev] Csv2dsml


a google "I'm feeling lucky" query on "csv sax xml java" will directly 
take you to:


which describes how to construct a SAX parser which reads in a CSV file,

in this
case the SAX event stream is tied to a XSLT processor which may be what
you want to create the DSML file, but of course you can connect to any
handler ...

Menzo Windhouwer

Brad Tumy wrote:

>I was asked to write a "script" that would take a csv file as input and

>create a dsml file as output.  We are receiving employee data as csv 
>and importing to an identity management system using DSML.  I finished 
>this last night...pretty small java code...I ended up using 
>StringTokenizer to capture the columns from each row and then 
>constructed the output as a String for each element...and then using 
>File.write.  So I ended up with a write "line" for each XML element.  
>Not too efficient and not scaleable...
>I looked at some resources on the web...saw a csv2xml...but it looked 
>like it was taking the column headers from the csv to use as element 
>names...in this particular situation I had specific element names that 
>were different then the column headers.  I also looked at java's SAX 
>and DOM libraries but couldn't quite get a handle on how to leverage 
>these if I wasn't starting with an XML file.
>As anyone else been down this road?  What kind of solutions did you end

>up with...also, if anyone knows how to utilize DOM or SAX to create a 
>XML file from another source I would love to learn how to do this.
>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>

Menzo Windhouwer, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, NL 1098 SJ Amsterdam, The Netherlands
url: http://www.cwi.nl/~windhouw/,  e-mail: windhouw@cwi.nl


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS