|
By Paul - Thu 3 Sep 2015
|
We've updated the Data Tool and posted a new zip on the downloads page:
http://www.kartris.com/t-Downloads.aspx?
- Fixed issues where it did not update items, though inserting new items worked
- Improved logging so much easier to see what went into db tables for categories, products, versions
- Fixed command line issue with arguments being turned lowercase, which made logins using SQL accounts with uppercase letters in password fail
- Added new 'sourceimagesfolder' argument; if source file spreadsheet includes full paths, don't need this, but if all your source images are in same folder, this makes it simpler - just need filename in spreadsheet, and pass the sourceimagesfolder in via argument.
We will be improving the documentation on the userguide in the next few days explaining some aspects of the data tool in more detail that are not necessarily obvious or documented yet.
|
|
By Vipin - Sat 5 Sep 2015
|
Hi Paul,
Thanks for the updated tool. I've one question - while migrating with earlier version of tool to import data from CactuShop DB to kartris, we had a problem with the 'old' customer trying to checkout on the new system.
It looked liked there was a problem with importing their addresses and the Label field in the table was NULL.
Do you know if this has been resolved in this version of the tool.
Also, on another query - if I need to import only customer and order related data from CactuShop into Kartris, do you know if it's possible ?
Many thanks
Vipin
|
|
By Paul - Sat 5 Sep 2015
|
Yes, these issues should be fixed. The new version zip was missing SQL updates, but that file has been uploaded in a new data tool zip now.
Things like null values can be fixed with the SQL script which is run when the DT completes running:
http://userguide.kartris.com/Default.aspx?headID=405
We have added SQL to it to fix a couple of issues including the addresses not being tagged with a type - shipping or billing or both (so they didn't show up in back end).
Also it is possible with this tool to just import customer and order data from CactuShop, without touching the products in the store. If you work through the CactuShop upgrade, after choosing the source and destination databases, you get a choice of whether you want to just update product related data, customer/order related data, or both. It's probably safer if you have a store up and running to update customer data and then product data separately even if you want to do both.
As with all use of the DT, we'd definitely suggest backing up the site before you use it and fully testing afterwards.
|
|