Generate content from a custom database table?
Last Post 06/17/2015 9:30 AM by Max Sermisoni. 3 Replies.
Author Messages Not Resolved
Max Sermisoni
Nuke Newbie
Nuke Newbie
Posts:1


--
06/16/2015 4:32 PM  
Hello, I'm using DNN 7.4, local test server, fresh install. I would like to port my company's current website, which is based on a simple MS Access database, into DNN.

Mapping the old db to the new one is extremely difficult, so I'm thinking of a different approach:

- Create a new table inside DNN SQL db with the old content (with columns like "page ID","H1 Title","H2 Title","Content","Custom url" and things like that)

- Create a page template with modules that get content from that new table in the db (ex: a Title module that looks for the "H1 Title" value)

Do you think it is possible?

Thanks for helping,
Max

(I've tried to post on DNN official forums but somehow I can't....)
Andy Stephenson DNN Creative
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:169


--
06/16/2015 5:55 PM  
Hi Max,

In programming I usually say that nothing is impossible. You could do that but you would have to understand a bit about how to create custom modules on DNN. I recommend these videos: Module Development on DNN

Sincerely,
Andy
Joseph Craig
DNN MVP
Posts:11667


--
06/16/2015 9:32 PM  
Max,

Often, the best solution is to start almost afresh.

You will certainly want to convert your old site's look and feel into a DNN Theme ("skin" in the old terminology).

For content that essentially is static on the old site, you'll probably want to just cut and paste it into HTML modules.

For dynamic content, the nature of the content will determine how best to do it. That will require some analysis on your part. If you can find modules that handle the special stuff, that's probably the best way to go.

Most websites fall into the above categories. Most sites do not require custom module development.

If you would like for me to look over the site and pontificate even more, please let us know the site's URL.

Joe Craig, Patapsco Research Group
Complete DNN Support
Max Sermisoni
Nuke Newbie
Nuke Newbie
Posts:1


--
06/17/2015 9:30 AM  
Thank you Andy and Joseph!

@Andy: I'll definitely start from there, thank you for sharing the link.

@Jospeh: I'm ok with the skinning part. The website is made of approx 800 dynamic .asp pages. It's www.m*o*dalshop.com (sorry for the * but I don't want this to show up on search engines). The main page layout is basically a left column, with 4 or 5 modules (product photo, related pages, downloads and such), and a right column with the page content.
That's all I need to transfer..

Thanks again for helping!
Max


---