Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...FAQ module help... anyone?FAQ module help... anyone?
Previous
 
Next
New Post
2/25/2010 1:56 PM
 

I am going to try and keep a long story short, but if you need more detail, please let me know.

I am on DNN 4.8.4 and FAQ module 3.1.  I want to upgrade to the newer FAQ module, but I need to do something first.  I basically messed it all up and had to uninstall the FAQ module completely.  I reinstalled it and all is great.  All that is left is I need to import the old FAQs from a backup.  But I do not want to restore everything (because the backup is from Sunday and I do not want to overwrite everything from the last 4 days).  So I'm thinking I need a script that imports the FAQs table completely, and then the FAQ data from the modules table where moduledefid = the old def id and set it to the new def id.  I know I need info from more tables though, and wasn't sure which ones.  Tabmodules, tabmodulesettings?, modulecontrols?, modulepermission?, modulesettings?.

Is anyone overly familiar with this and good with SQL and have nothing better to do?  My sql isn't so strong nor is my familiarity with the db.

 
New Post
2/25/2010 2:35 PM
 

if you setup new module like old module in settings of the Module, you can skip transferring data from Modules, TabModules, ModuleSettings, TabModuleSettings and ModulePermissions tables. while in settings, notice the moduleID (or MID) parameter in URL.

Next copy over all items from FAQsCategory and next from FAQs table, adjusting moduleID accordingly. For this purpose use SQL statements like 

INSERT INTO newdb.FAQs ([ModuleID], [CreatedByUser], [CreatedDate], [Question], [Answer], [CategoryId], [DateModified], [ViewCount])

     SELECT  ({newmoduleID}, CreatedByUser, CreatedDate, Question, Answer, CategoryId, DateModified, ViewCount) FROM olddb.FAQs WHERE ModuleID = {oldModuleID}

 


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...FAQ module help... anyone?FAQ module help... anyone?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out