Dave Hassall
Nuke Pro Posts:86
|
02/13/2010 6:20 AM |
|
I have a 6,000 page PHP website that I am about to rebuild in DNN. The majority of the pages are auto generated, a bit like a mail merge; to generate personalised geographically unique pages e.g. Hairdresser London, Hairdresser Manchester. Does anyone know if this can be achieved with DNN by “publishing” information straight to the database? Alternatively does anyone know of a good book / info site that give details of how the back end database operates? |
|
|
|
|
Dave Hassall
Nuke Pro Posts:86
|
|
Joseph Craig DNN MVP Posts:11667
|
02/13/2010 10:42 AM |
|
If that's not enough ... please give more details on how you want these pages to look. |
|
Joe Craig, Patapsco Research Group Complete DNN Support |
|
|
Dave Hassall
Nuke Pro Posts:86
|
02/13/2010 12:55 PM |
|
The videos mentioned above were a brilliant pointer. Still got investigations to do but..
When a page is created it produces entries in the Tabs and TabPermission tables. When you add a module to that page then there is an entry into the TabModules table. There is also an entry into the Modules Table. You can then track to the table that controls the specific module type - in my case HTMLTEXT. There is a field in there that holds all the data (RAW HTML) which in theory can be cut and pasted to form a template for the auto-generation of text on your page.
I'm guessing at this point if you use a Page Template to generate the page you just need to work out the number of modules on the page to know which ones to poke. That is you create a page and add a text/HTML module then in rough terms it'll go TadId=1 ModuleID=1 next page 2 and 2, 3 and 3
But if the page contains 3 modules then you would get
TabID=1 ModuleID=1,2,3
TabID=2 ModuleID=4,5,6
Assuming The 2nd module was your module of choice then you would create you Excel file or your Access / VB program to cut/paste or SQL update ModuleID 2, 2+(1x3), 2+(2x3) etc etc. that is 2,5,8
Brilliant |
|
|
|
|
Joseph Craig DNN MVP Posts:11667
|
02/13/2010 7:27 PM |
|
Seems like you are on the right track ... good luck!
|
|
Joe Craig, Patapsco Research Group Complete DNN Support |
|
|
Dave Hassall
Nuke Pro Posts:86
|
02/23/2010 5:39 AM |
|
Joe and Lee
I've just spent some time looking at the videos on Shadow Pages
BRILLIANT :-). I've been caught out in the past with "include on every page" but this concept is amazing.
When you trully realise the POWER of the database driven website this becomes amazing |
|
|
|
|
Dave Hassall
Nuke Pro Posts:86
|
02/24/2010 10:40 AM |
|
Hi
I have successfully added pages and modules to a site purely through SQL.
So far it has proved a relatively straight forward process.
I have achieved this through SQL Server Management Studio Express and just recently by connecting Access 2007 to my hosted SQL database
The next test is to query an Access Database and append records to the SQL database to create pages.
Then Modules......
Watch This Space |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Dave Hassall
Nuke Pro Posts:86
|
03/18/2010 5:46 AM |
|
CAUTION - I am also adding pages to the site manually (Page Functions Add) but I am finding after adding the pages I need to restart the application for them to appear on the menu. I will investigate further |
|
|
|
|
Joseph Craig DNN MVP Posts:11667
|
03/18/2010 12:15 PM |
|
Are you using the DotNetNuke menu or another one? |
|
Joe Craig, Patapsco Research Group Complete DNN Support |
|
|
Dave Hassall
Nuke Pro Posts:86
|
03/19/2010 6:53 AM |
|
Hi Joe
DNN Out of the box version 4.9
Login as Host with Firefox to create and IE8 to monitor, CTRL - F5 on both platforms but need to Host - Restart App
I can give you access to the site / login if you would like to play |
|
|
|
|
Dave Hassall
Nuke Pro Posts:86
|
05/17/2010 4:03 PM |
|
Progress is being made.
I have the challenge to build pages based on post code area e.g. BH, OX and EX etc
In an Access 2007 application I have created a single entry in a table by selecting the TABS table and making a table. By building a query that has a list of post codes in one table and the single entry in another you get a list of all the pages that needs a post code entry. The bits that needs customising e.g. Hairdresser_in_OX is achieved by using the Acess build command
This neatly generates the pages.
By sampling a completion event in DynamicForms I can link a drop down selection to the autogenerated pages.
This will save hours....
More to come as I progress further and add Catalook product pages to these pages |
|
|
|
|