logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
xware  
#1 Posted : Monday, March 4, 2019 7:20:52 AM(UTC)
xware

Rank: Newbie

Groups: Registered
Joined: 2/25/2019(UTC)
Posts: 4
United States
Location: Tennessee

So ive been working thru setting up the store again and I imported the store backup from my old site. all the products and categories did import . however they are no longer linked. all the products are listed without categories
leedavi  
#2 Posted : Monday, March 4, 2019 9:21:34 AM(UTC)
leedavi

Rank: Administration

Groups: Registered, Administrators
Joined: 11/6/2016(UTC)
Posts: 323
United Kingdom
Location: France

Was thanked: 28 time(s) in 28 post(s)
This should work. There is an internal ref created for products and categories. The import makes use of this to import products to categories. But you MUST create 1 export with Products, Properties and categories. The use that 1 file.
xware  
#3 Posted : Monday, March 4, 2019 10:36:25 AM(UTC)
xware

Rank: Newbie

Groups: Registered
Joined: 2/25/2019(UTC)
Posts: 4
United States
Location: Tennessee

ok so I deleted all products and categories out of the database

went to old copy of site and did an export choosing only products categories and properties.

did the export

went to new site and did an import choosing the same 3 options.. this time the categories are linked but the products are missing all other information . name , summary.etc

I checked languages and they are the same
leedavi  
#4 Posted : Monday, March 4, 2019 4:58:31 PM(UTC)
leedavi

Rank: Administration

Groups: Registered, Administrators
Joined: 11/6/2016(UTC)
Posts: 323
United Kingdom
Location: France

Was thanked: 28 time(s) in 28 post(s)
Did you delete the products form the Database or use the OpenStore Admin Panel to delete?

It should not make a difference, but the cascade delete for all index and language records needs to be run. Maybe clearing from the DB directly stopped the trigger from being activated to delete all data.

I've done this import multiple times, without any issues.

What versions of OpenStore and DNN are you running from? and To?
xware  
#5 Posted : Tuesday, March 5, 2019 12:26:04 AM(UTC)
xware

Rank: Newbie

Groups: Registered
Joined: 2/25/2019(UTC)
Posts: 4
United States
Location: Tennessee

I cleared all applicable records from the database.

I've been trying for days and finally just gave up. I just used SSMS to export the NB tables from the old database making sure to include indexes, schema and data using the generate scripts option in ssms

then I deleted all NB tables from the new database


then I ran the generated scrips against the new database

and after they ran I made sure that the default themes under OpenStore Settings were set to Default.

now granted this method wouldn't work if i had info in the new database i was trying to preserve. but for me all i needed was the "Old" data
leedavi  
#6 Posted : Tuesday, March 5, 2019 3:21:25 AM(UTC)
leedavi

Rank: Administration

Groups: Registered, Administrators
Joined: 11/6/2016(UTC)
Posts: 323
United Kingdom
Location: France

Was thanked: 28 time(s) in 28 post(s)
Hi,

I don't think this idea of Database to Database will work. (Never Tried it) You'll need to use the export and import option in the AdminPanel of OpenStore. This will preserve all data, unless your moving from NBSv2, but NBSv3 to OSv4 should be OK.

What version of OpenStore do you have?
xware  
#7 Posted : Tuesday, March 5, 2019 3:51:02 AM(UTC)
xware

Rank: Newbie

Groups: Registered
Joined: 2/25/2019(UTC)
Posts: 4
United States
Location: Tennessee

I am using version 4.0.6

however the database dump worked perfectly the first time. I am fixing to move the development site back to production so I will be attempting it a second time here shortly
leedavi  
#8 Posted : Tuesday, March 5, 2019 3:55:31 AM(UTC)
leedavi

Rank: Administration

Groups: Registered, Administrators
Joined: 11/6/2016(UTC)
Posts: 323
United Kingdom
Location: France

Was thanked: 28 time(s) in 28 post(s)
OK, good. Should should also do a portal validation from the admin panel. Among other things, this verifies the database XML is in good format.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2019, Yet Another Forum.NET
This page was generated in 0.069 seconds.