XML to MDB View previous topic :: View next topic  


NFOHump.com Forum Index - Applications
Page 1 of 1
nouseforaname
Über-VIP Member



Posts: 21306
Location: Toronto, Canada
PostPosted: Fri, 27th May 2011 00:23    Post subject: XML to MDB
Figured I give it a shot and ask here.

Anyone know of a program (free or trial version) that can convert an XML file (without a schema definition) to an access database or even just a set of .csv files or whatever?

We've tried XML Spy, Map Force, and Ultra Edit but none of them can deal with the file being 780mb... not sure if it is relevant but basically these is a set of data tables extracted from an EMR.

Any ideas? Smile

asus z170-A || core i5-6600K || geforce gtx 970 4gb || 16gb ddr4 ram || win10 || 1080p led samsung 27"
Back to top
shole




Posts: 3363
PostPosted: Fri, 27th May 2011 02:39    Post subject:
erm, xml is way WAY different from a relational database
there's no software to convert it since it's not comparable in any way
i would just do an xquery of the xml file that formatted everything as relational insert lines and ran that

or .csv as you mentioned

edit:
google gives this;
http://www.xml-converter.com/
Back to top
PumpAction
[Schmadmin]



Posts: 26759
PostPosted: Fri, 27th May 2011 03:13    Post subject:
Totally depends on the layout of your xml.

=> NFOrce GIF plugin <= - Ryzen 3800X, 16GB DDR4-3200, Sapphire 5700XT Pulse
Back to top
nouseforaname
Über-VIP Member



Posts: 21306
Location: Toronto, Canada
PostPosted: Sat, 28th May 2011 05:15    Post subject:
basically if this were the near future it would look like this:
https://www.ontariomd.ca/imageserver/OMDContent/cms/documents/EMR_Specification_v40_Appendix_G_Final_Jan172011.pdf

but we're getting data (relational database) in xml that doesn't match that. these companies don't always stick to specifications even though govt pays them to..
http://www.practicesolutions.ca/clinical%20software

asus z170-A || core i5-6600K || geforce gtx 970 4gb || 16gb ddr4 ram || win10 || 1080p led samsung 27"
Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Applications
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group