Home. 
.

transparent

transparent

transparent

Altova Mailing List Archives


Re: hi

From: Arshad Noor <arshad.noor@----------.--->
To: vaseem khan <vaseemkhanusa@-----.--->
Date: 2/11/2009 1:21:00 AM
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 recor=
d 
> 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=EB,978-0142437209,532
> 6 Wuthering Heights,Emily Bront=EB,978-0141439556,416
> 7 Agnes Grey,Anne Bront=EB,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
> 


From erwin.kloeck@b... Fri Feb 13 17:11:25 2009
Received: from farnsworth.w3.org ([128.30.52.43] helo=wi


transparent
Print
Mail
Like It
Disclaimer
.

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.

.
.

transparent

transparent