- From: Arshad Noor <arshad.noor@strongauth.com>
- Date: Wed, 11 Feb 2009 09:21:10 -0800
- 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 UTC