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/com...ml-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.

Thanks!

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:

https://chandoo.org/wp/sq...ents-from-csv-files/

You "create" multiple insert statements in Excel and execute them in mssql server

Thanks! 

The XML is 100% readable by Excel so I will take a look at the link you provided.

In order to use the Excel I will need to do a massive edit on the XML file so it may take more time that learning how to import the actual XML file, but I will investigate!

With the exmple it should not be that much work IMO.