Posted By Ronnie on 02 May 2020 02:16 PM
I created a membership system in the old XMOD several years ago and now that the old XMOD does not work on later versions of DNN I have purchased XMODPRO and have the latest version 4.8 installed. I have exported the data from the old XMOD, cleaned up, renamed tables and made sure all the XML items are correct. I have read the document at http://www.dnndev.com/community/discuss/import-xml-file-into-xmodpro and the table is formated properly.
I have searched and searched and have not found the answer to my problem. I need to import the XML file into the XMODPRO table for the membership. I am using SQLEXPRESS 2012 vesion 11.0.2100.
P.S, I have asked the question on the XMODPRO forums but not much activity on that forum.
What are the steps I need to go through to import into my table in XMODPRO.
If you can get your Xml into Excel there's a dirty trick to do this I got from my colleague and it comes down to this:
You "create" multiple insert statements in Excel and execute them in mssql server