Products

Solutions

Resources

Partners

Community

About

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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreInstalling WWStore over a default store?Installing WWStore over a default store?
Previous
 
Next
New Post
4/27/2007 12:14 AM
 

Hi All,

I've just inherited a customer whose site was implemented using the default store module before anyone realised that it didn't actually work. And he, unsuprisingly, isn't very happy. So I am looking at migrating him to the WWStore module, and was wondering if the upgrade would be as simple as installing the WWStore module over the default module. Does anyone know what would happen to a populated product / category database if this was done - I'm hoping the answer is going to be 'no problem the new module reads the data the same'?

If it won't do this, does anyone by chance have a set of SQL commands to move the data from a default store database to a WWStore one? There are a couple of hundred products in there and I don't fancy having to re-enter them all by hand....

Thanks for any advice.

Graham

 
New Post
4/27/2007 10:37 AM
 

I took a look, and it's not difficult to migrate the categories and products. Store settings i think you can do manually.

as an FYI, the original store and Alans WWStore use different tables, albiet with near-same structure; The WWStore has added functionality.

You can migrate them with some simple SQL Server TSQL commands in Query analyzer; if you don't have access to that, I don't have a simple solution; the TSQL below would be ideal if you have a lot of categories and products int he database, and don't want to reenter by hand.

in order for this to work, you cannot have entered any categories or products into the WWStore; just install the WWStore and then perform the commands below.

--migrate categories: manditory
SET  IDENTITY_INSERT ON WWStore_Categories
INSERT INTO WWStore_Categories(CategoryID, PortalID, CategoryName, CategoryDescription, Message, Archived, CreatedByUser, CreatedDate)
  SELECT CategoryID, PortalID, CategoryName, CategoryDescription, Message, Archived, CreatedByUser, CreatedDate FROM Store_Categories
SET  IDENTITY_INSERT OFF WWStore_Categories

--migrate products

SET  IDENTITY_INSERT ON WWStore_Products
INSERT INTO WWStore_Products(ProductID,PortalID,CategoryID,Manufacturer,ModelNumber,ModelName,ProductImage,UnitCost,Summary,Description,Featured,Archived,CreatedByUser,CreatedDate)
  SELECT ProductID,PortalID,CategoryID,Manufacturer,ModelNumber,ModelName,ProductImage,UnitCost,Summary,Description,Featured,Archived,CreatedByUser,CreatedDate   FROM Store_Products
SET  IDENTITY_INSERT OFF WWStore_Products

Hope that helps

 
New Post
5/6/2007 11:10 PM
 

Lowell,

Just an update to say thanks, that worked a treat!

As a heads-up to anyone else performing this migration, there is just a minor typo in the above SQL query - the ON / OFF switch on the SET IDENTITY_INSERT commands goes after the table name, not before...

Thanks Again,         Graham

 
New Post
5/7/2007 10:29 AM
 

glad this helped you and sorry about the typo; my strengths are currently more in database than .net

; if the DNN store version 2 ever comes out, some slight changes to the query would let you migrate WW store categories and products into the DNN version;

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreInstalling WWStore over a default store?Installing WWStore over a default store?


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