Exporting Database in XML
-
Hey Guys/Gals, New to the forum here im hoping im in the right place. I work for my father at CetraCom in Ohio. He has recently put me on a new project for a client of ours. We're setting up a license scanner/reader that has a software that automatically fills out the info into a database. I need to be able to upload that Database to the States website in an XML format. They have already written the XML Schema. I am not a coder by any means but i did some reading on XML and it seems pretty straight forward. My question is: How would i go about performing this action (uploading the info from the database to their website while following their XML Schema)? Whats the easiest way to go about it? Thanks for your time/help :D
-
Hey Guys/Gals, New to the forum here im hoping im in the right place. I work for my father at CetraCom in Ohio. He has recently put me on a new project for a client of ours. We're setting up a license scanner/reader that has a software that automatically fills out the info into a database. I need to be able to upload that Database to the States website in an XML format. They have already written the XML Schema. I am not a coder by any means but i did some reading on XML and it seems pretty straight forward. My question is: How would i go about performing this action (uploading the info from the database to their website while following their XML Schema)? Whats the easiest way to go about it? Thanks for your time/help :D
Look into serializing / de-serializing objects. The basic idea is that you create a class which matches the structure of the XML file, then your program instantiates the object, fills in the properties and calls a "Save" method which writes the value of the object out in XML format. Sounds much easier than it is, but once you get the hang of it, works well. Lots of articles here on how to serialize objects. Just a thought. :thumbsup:
-
Hey Guys/Gals, New to the forum here im hoping im in the right place. I work for my father at CetraCom in Ohio. He has recently put me on a new project for a client of ours. We're setting up a license scanner/reader that has a software that automatically fills out the info into a database. I need to be able to upload that Database to the States website in an XML format. They have already written the XML Schema. I am not a coder by any means but i did some reading on XML and it seems pretty straight forward. My question is: How would i go about performing this action (uploading the info from the database to their website while following their XML Schema)? Whats the easiest way to go about it? Thanks for your time/help :D
What database-platform are you using? There'll be different features available in SQL Server than in MS Access :) If you have a database-server, do you want to have the server perform the main part of the effort, or the client (your local computer)?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
What database-platform are you using? There'll be different features available in SQL Server than in MS Access :) If you have a database-server, do you want to have the server perform the main part of the effort, or the client (your local computer)?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
This project is for a local scrap yard so they will not have a database server it will be run on the computer itself. Once i get home ill link the XML schema the state has provided and other such details to help you help me :D sorry if i was a bit too vague. As i stated, i am by no means a coder :P . I have messed around with an SQL server a bit before for a program the county uses but its not one i had to set up myself so i am a bit unfamiliar with such things, but im always willing to learn. Thanks for the replies i will post more details this evening EST
-
This project is for a local scrap yard so they will not have a database server it will be run on the computer itself. Once i get home ill link the XML schema the state has provided and other such details to help you help me :D sorry if i was a bit too vague. As i stated, i am by no means a coder :P . I have messed around with an SQL server a bit before for a program the county uses but its not one i had to set up myself so i am a bit unfamiliar with such things, but im always willing to learn. Thanks for the replies i will post more details this evening EST
SQL Server should be able to convert a table to XML using a SELECT-query. Can you also provide the structure of the source-tables? You can use below query (with the correct table-name) to get it.
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tableName'Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)