W3C home > Mailing lists > Public > xmlschema-dev@w3.org > February 2009

Re: hi

From: Arshad Noor <arshad.noor@strongauth.com>
Date: Wed, 11 Feb 2009 09:21:10 -0800
Message-ID: <49930906.5010805@strongauth.com>
To: vaseem khan <vaseemkhanusa@gmail.com>
CC: xmlschema-dev@w3.org

Vaseem,

This mailing list is focused on addressing questions related
to XML Schema and technology around schema-development and
its semantics.  Your question is more appropriate for forums
that focus on programming tools/practices around XML (such
as http://forums.sun.com/forum.jspa?forumID=34).

That said, there are many ways to solve your problem:

1) Define an XML Schema Definition (XSD) file - either manually
    if the data is as simple as you show, or using a tool that
    understands XML Schema (Netbeans, Oxygen, etc.).  Then write
    a small software program to read your CSV file and create
    the XML based on your schema using JAXB;

2) Another approach is to use some database import tool to import
    your CSV into an RDBMS.  Then create your XSD that maps to the
    RDBMS schema (Oxygen is one tool that will do this for you
    automatically), and finally use Netbeans to generate Java classes
    conforming to your XSD.  Finally, write a small program to read
    your RDBMS data and write out XML files through JAXB.

There are other ways to approach this problem; these are two
that I would choose from.

Arshad Noor
StrongAuth, Inc.

vaseem khan wrote:
> hi
> i am trying to import bulk csv into database and than covert each record 
> to xml
> 
> *for examples *
> id    Title,Author,ISBN13,Pages
> 1 1984,George Orwell,978-0451524935,268
> 2 Animal Farm,George Orwell,978-0451526342,144
> 3 Brave New World,Aldous Huxley,978-0060929879,288
> 4 Fahrenheit 451,Ray Bradbury,978-0345342966,208
> 5 Jane Eyre,Charlotte Brontė,978-0142437209,532
> 6 Wuthering Heights,Emily Brontė,978-0141439556,416
> 7 Agnes Grey,Anne Brontė,978-1593083236,256
> 8 Walden,Henry David Thoreau,978-1420922615,156
> 9 Walden Two,B. F. Skinner,978-0872207783,301
> 10 "Eats, Shoots & Leaves",Lynne Truss,978-1592400874,209
> 
> 
> ok i have to ask u how can i make indivdual xml schema
>  i am tryng for out put like
> 
> id number  1.xml
>                  2.xml
>                  3.xml
> 
> and so any sugestions plz soon
> 
> 
> 
> thanks in advacne
> vaseem
> 
Received on Wednesday, 11 February 2009 17:21:55 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 11 January 2011 00:15:10 GMT