• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

2 Pages12>
Marcus
#1 Posted : Monday, April 13, 2009 10:23:47 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

This is an updated version of the migration tool for moving from BVC 2004.7 to BV Commerce 5.4 and 5.5. This version was rewritten to work directly against databases, skipping the web services.

IMPORTANT: This version requires .net 3.5 to be installed.

USEAGE: Ideally, this tool would run directly on the SQL server where your live databases are located. Second best is on the same local network and the SQL server. Last best is remote.

INVENTORY OPTIONS: There is a new checkbox that you should use if you have disabled all inventory on your BVC 2004 store. The checkbox will make more your bvc5 store more efficient by choosing modifiers instead of choices during the import process. It will also guarantee non-inventory tracking products show up correctly on the new store.
File Attachment(s):
MigrationTool_BVC2004_to_BVC5_5501.zip (211kb) downloaded 380 time(s).

You cannot view/download attachments. Try to login or register.
Aaron
#2 Posted : Tuesday, June 30, 2009 4:05:49 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
Is the source code for this available? I don't see it in my account.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
roxannez
#3 Posted : Tuesday, November 17, 2009 3:47:27 PM(UTC)
roxannez

Rank: Member

Joined: 8/28/2009(UTC)
Posts: 29

What if I am on BVC 2004.0? Sounds like I can't use this tool. I generated an email today which sent my version information to support asking the same question.
Aaron
#4 Posted : Tuesday, January 05, 2010 11:44:10 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
We recently migrated site data from 2004 to 5.6 and it only imported the first Related Item (from BV 2004) as a cross sell (in BV 5). Has anyone else experienced this?
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Marcus
#5 Posted : Wednesday, January 06, 2010 8:02:23 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Aaron,

The import tool should match all related items. They will always come in as cross-sells because 2004 doesn't have an "up-sell" concept.

If you think the tool isn't functioning correctly some sample data for us to try and import would be helpful.

Thanks,
Marcus
Matt@9BallDesign
#6 Posted : Thursday, January 07, 2010 9:58:50 AM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

hey aaron,


you mention "imported the first Related Item (from BV 2004) as a cross sell (in BV 5)."



Before I hit the go button.... i am interpreting your statement two ways..lol



1. All related item assignments are imported, however the first one is a cross sell and the rest are up sells



2. Only one related assignment is imported and it is set as a cross sell



can you expand a tiny bit?



thanks
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
Aaron
#7 Posted : Thursday, January 07, 2010 11:02:51 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
Hah, I thought that was probably a bit confusing. My intended meaning was #2 (only one related assignment is imported and it is set as a cross sell).

Let me know how it goes for you. If you run into problems we did write a SQL script to do this import.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Matt@9BallDesign
#8 Posted : Thursday, January 07, 2010 11:15:03 AM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

Thanks aaron, I'm cool with the item being assigned as a cross sell.

script pulls all of the 'related items' and imports in (BV2004 -> BV5)?
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
Aaron
#9 Posted : Thursday, January 07, 2010 11:45:24 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
Yes, our script imports all 'Related Items' from BV 2004 to 'Cross Sells' in BV 5. Did the BV import tool work for you?
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Matt@9BallDesign
#10 Posted : Thursday, January 07, 2010 12:39:27 PM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

I'm going to give it a go later today. just doing all my backups and organizing at the moment. artwork uploads, brewing another pot of coffee, etc...
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
Matt@9BallDesign
#11 Posted : Friday, January 08, 2010 2:09:20 PM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

hey aaron, I'm willing to compensate you for that sql script.
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
Matt@9BallDesign
#12 Posted : Tuesday, January 12, 2010 11:23:48 AM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

just a heads up that Aaron shared the necessary script with me via email. worked perfectly.


aaron asked for nothing in compensation. I offered buddy....lol.... :)
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
Aaron
#13 Posted : Tuesday, January 12, 2010 12:15:20 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
For anyone else that is experiencing this problem, here is the script that I shared with Matt. This is provided as-is with absolutely no warranty, guarantee, etc. Be sure to backup your databases before running it. Before you run the script you will need to do a search/replace of the database names in the script. This script assumes that both your BV 2004 and BV 5 databases are on the same SQL Server. This isn't the most efficient query (it took about 5 minutes to run on a catalog of 3,000 SKU's), but that wasn't a priority when it was written (i.e. get it done ASAP since we will only run this once). Also note that this script deletes any Cross Sells from the BV 5 database that correspond to products in the 2004 database before importing the Related Items.
File Attachment(s):
Related Items import.sql.txt (2kb) downloaded 239 time(s).

You cannot view/download attachments. Try to login or register.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Rich
#14 Posted : Tuesday, August 17, 2010 3:20:50 PM(UTC)
Rich

Rank: Member

Joined: 3/1/2004(UTC)
Posts: 145

BVC2004.7 to bv5.7.1 user import problem? Has anyone else tried to import to 5.7.1 using the latest tool? I have recently and the user data will not import. Everything else seems to have been imported correctly except the users. Any help would be appreciated being the updated store is currently live.

Thanks
Rich
krulewicz
#15 Posted : Monday, June 25, 2012 7:44:50 AM(UTC)
krulewicz

Rank: Member

Joined: 7/5/2005(UTC)
Posts: 5

Hi,


I'm having a problem moving "Users" from a BVC2004 store to a new BV 5.8 store. Even when I re-ran the import tool selecting users only, the log shows the "Roles" as Skipping and then the "Starting Import Users" all are show as "not created"/



Has anyone else encountered this?



Thanks,



Jerry
jeverett
#16 Posted : Wednesday, May 11, 2016 1:56:05 PM(UTC)
jeverett

Rank: Member

Joined: 5/10/2016(UTC)
Posts: 3

I tried using the migration tool to Import Products but I get an "Invalid object name 'dbo.bvc_TaxClass'" error.
My connection strings are correct and I see that table in 5.6 database. I dont see it in the 2004 database. Could that be the problem?

Aaron
#17 Posted : Wednesday, May 11, 2016 2:47:14 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
Originally Posted by: jeverett Go to Quoted Post
I tried using the migration tool to Import Products but I get an "Invalid object name 'dbo.bvc_TaxClass'" error....I dont see it in the 2004 database. Could that be the problem?

Yes, that is likely the issue. I checked one of the old 2004 sites that we have lying around and it does have that table. That site was running 2004.7 (final release of 2004). Perhaps older versions of 2004 didn't have that table.

You could try running the SQL script below to create the table. That may help you get through the migration.

Code:
/****** Object:  Table [dbo].[bvc_TaxClass]    Script Date: 5/11/2016 3:46:41 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[bvc_TaxClass](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[DisplayName] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_bvc_TaxClass] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
jeverett
#18 Posted : Wednesday, May 11, 2016 2:53:18 PM(UTC)
jeverett

Rank: Member

Joined: 5/10/2016(UTC)
Posts: 3

Thanks Aaron. I tried that script and made it past that error but then it failed in the next table. I think I just have a much older version.
Aaron
#19 Posted : Wednesday, May 11, 2016 3:27:23 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,318
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 151 time(s) in 146 post(s)
Originally Posted by: jeverett Go to Quoted Post
Thanks Aaron. I tried that script and made it past that error but then it failed in the next table. I think I just have a much older version.


Sounds like it. You can check your version by going to Settings >> Version Information in the admin. Look at the version number of the BVSoftware.BVC.Core.dll file. If you have access to the various versions of 2004 you could always upgrade your site to 2004.7.Alternately we can continue to help you build out the missing or different tables.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
jeverett
#20 Posted : Wednesday, May 11, 2016 4:40:45 PM(UTC)
jeverett

Rank: Member

Joined: 5/10/2016(UTC)
Posts: 3

I think I have a much older version and its possible the developers that built our shopping cart didnt use the entire BVCommerce software.

These are the only BVCommerce DLLs we have:

BVSoftware.DataBlocks.dll 1.0.4119.17039
BVSoftware.Encryption.dll 2.0.4119.17039

Well those are the only ones that start with BVSoftware.
2 Pages12>
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.

©2020 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012