Print this tome
Print

10. The Data Tool

The Data Tool is a companion product to Kartris. It's a Windows application that is designed to carry out various tasks relating to Kartris, although it is primarily used for importing data.

The Data Tool is presently a free download from our web site.

10.1. Overview

The Data Tool requires .NET 4.0 or above installed on your machine in order to run. It can be downloaded for free from our web site 'downloads' page. It does not need installation, just unzip the files to your desktop and then open KartrisDataTool.exe to get started. You should see the following:

10.2. Getting started

You will generally find it's easier to use the Data Tool if you set up the connections you need before starting. Clicking 'Saved connections' in the left hand menu brings up a dialog which lets you create as many connections to different databases as you need.

10.3. Importing data

The Data Tool can import from CactuShop v6 or v7 (CactuShop is an older classic ASP shopping cart also produced by Cactusoft), from a CSV or Excel spreadsheet, or from another Kartris database.

The basic principle of data imports is to have a source and destination, and copy information from one to the other. In this way, imports and upgrades do not damage or change the original database.

The import dialogs will typically walk you through step-by-step, and give information if there are problems.

10.3.1. Formatting spreadsheet/CSV data for import

The Data Tool requires CSV or spreadsheet data to be suitably formatted for import. A sample spreadsheet with some correctly formatted data is included in the data tool zip, or you can download it below.

Example Excel Spreadsheet for importing with the Kartris data tool 1519051679_8531.xls 48KB
 
powered by tome.host