New data tool with a lot of improvements and bug fixes

Posted By Paul Thu 3 Sep 2015
Add to Favorites0
Author Message
Paul
 Posted Thu 3 Sep 2015
große Käse

große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
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.


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Vipin
 Posted Sat 5 Sep 2015
Supreme Being

Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)Supreme Being - (1,094 reputation)

Group: Forum Members
Last Active: Sun 11 Oct 2015
Posts: 2, Visits: 11
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
Paul
 Posted Sat 5 Sep 2015
große Käse

große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)große Käse - (449,818 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
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.


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top