|
By pcotgrove - Mon 1 Apr 2013
|
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?
|
|
By pcotgrove - Wed 3 Apr 2013
|
Does anyone have any info on this issue? I really need to bulk upload my content
Thanks
|
|
By Paul - Wed 3 Apr 2013
|
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.
|
|
By pcotgrove - Wed 3 Apr 2013
|
Had to email you Paul as the PM kept producing an error
Have you got it?
|
|
By Paul - Wed 3 Apr 2013
|
|
yes... i will test PM now and see what the problem is
|
|
By pcotgrove - Fri 5 Apr 2013
|
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
|
|
By Paul - Fri 5 Apr 2013
|
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.
|
|
By pcotgrove - Fri 26 Apr 2013
|
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
|
|
By Paul - Mon 29 Apr 2013
|
|
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.
|
|
By Paul - Mon 29 Apr 2013
|
Can you give this one a try...
https://dl.dropboxusercontent.com/u/10672133/KartrisDataTool_2_0002.zip
|
|
By pcotgrove - Mon 29 Apr 2013
|
Hi
Have downloaded but need to sort out a new database to test with unless you can tell me if I can use this tool to add - I am asking if my testing with a new product or two will completely the zero the product list that already exists in the DB or whether it will just append the new products?
Also is there a way to export the product data at all? Maybe in a similar format so that I can maintain a master product file?
|
|
By Paul - Tue 30 Apr 2013
|
Firstly, whatever you do, back up your db first, so if anything goes wrong, you can restore it. This is good advice even if you're just having a big manual session of adding or editing products, and is certainly advisable when using alpha software like this for direct modification.
It is possible to use a spreadsheet to add new products to an existing site, and update existing items too. There are options for this (see screenshot).
There is a saved export in the back end (database admin) that can export products; not 100% sure about options products though.
|