Data Tool

Posted By pcotgrove Mon 1 Apr 2013
Add to Favorites0
Author Message
pcotgrove
 Posted Mon 1 Apr 2013
Supreme Being

Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)

Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0, Visits: 57
Trying to upload a very simple file which contains one product which should be located in an existing category.

Firstly the data tool complains about the xslx file so I attempted the upload with a CSV version instead.

Then the tool complained saying that my import file is not compatiable with the version of the database. I am using the latest version of the software, V2.0001 with the tool.

Does anyone have any ideas about how I may resolve this issue?
pcotgrove
 Posted Wed 3 Apr 2013
Supreme Being

Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)

Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0, Visits: 57
Does anyone have any info on this issue? I really need to bulk upload my content

Thanks
Paul
 Posted Wed 3 Apr 2013
große Käse

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

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
We've been totally rebuilding the DT for 2.0; if you can PM me with your email address I can send you an alpha version.

As well as code changes to handle 2.0 changes, we've also overhauled the interface so it runs largely in a resizable window. We also save connections in a connections manager, so you don't have to rekey data if running in multiple times, and the interface has been simplified.


--
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
pcotgrove
 Posted Wed 3 Apr 2013
Supreme Being

Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)

Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0, Visits: 57
Had to email you Paul as the PM kept producing an error

Have you got it?
Paul
 Posted Wed 3 Apr 2013
große Käse

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

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
yes... i will test PM now and see what the problem is

--
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
pcotgrove
 Posted Fri 5 Apr 2013
Supreme Being

Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)

Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0, Visits: 57
Hi Paul

Did anyone get the chance to look at the alpha version of the data tool yet? Your suggestion re the 1.4 database is a non starter for me as I only have a v2 environment

I am well versed with SQL so if there is a list of tables that I need to make sure are populated could you let me know as I can either use BCP or 2008 DTS equiv to get the data in - just need to know what tables need to be populated for a complete product to be valid on the site

Thanks
Paul
 Posted Fri 5 Apr 2013
große Käse

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

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Getting data on manually would be a very complex task - product info for example is spread over multiple tables, because the language specific text parts are in the language elements table while the product stubs are in the products table - then there are versions, and product-category links, cat-cat links and so on.

The 1.4 db setup script would create a 1.4 db you can run data into that with the older data tool, then run the upgrade process scripts. Alternatively you could download an older CactuShop access db (from www.cactushop.com), run your data into that with the older data tool, and then use the new Kartris data tool to copy data from that to your SQL db (I've used the CactuShop import part of it so pretty sure that part is working).

We're working on the v2 db but it's going to take some time to get this all done and tested.


--
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
pcotgrove
 Posted Fri 26 Apr 2013
Supreme Being

Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)Supreme Being - (17,340 reputation)

Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0, Visits: 57
Hi

Has there been any updates to the data tool v2 beta that I have had a look at previosuly? As my product portfolio grows its taking more and more time to manage

Thanks

Paul
Paul
 Posted Mon 29 Apr 2013
große Käse

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

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
I'm compiling a version now... need to do a few basic tests, but if it runs ok should have a zip in next 2-3 hours.

--
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
Paul
 Posted Mon 29 Apr 2013
große Käse

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

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Can you give this one a try...

https://dl.dropboxusercontent.com/u/10672133/KartrisDataTool_2_0002.zip


--
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