Database types
The following database types are supported:
!

Access Databases

You can set up your Access database in a similar fashion to the one included in the software in the folder ShopFactory/Sample Databases. There is no need to use the same field names — the Import Wizard will prompt you for the appropriate field names later.

Excel Databases

You can set up your Excel database in a similar fashion to the one included in the software in the folder ShopFactory/Sample Databases. There is no need to use the same field names — the Import Wizard will prompt you for the appropriate field names later. You should ensure that you note which table you have used within the spreadsheet.

Please read the note below about particulars how the rows need to be ordered.

Note about Excel and CSV import

Please note that due to the ODBC layer Import Wizard uses to access the data it's important to make sure the first 8 rows of data in a column are the same type as ODBC tries to interpret what type the data is, say for example you have, "1", "a", "3" in row 1, 2 and 3 respectively then Import Wizard will see it as text correctly, whereas if you had "1", "2", "3", "4", "5", "6", "7", "8" and then had "a" in row 9 that row won't be imported properly and will come through as 0 or empty depending what field in ShopFactory it's being imported into.

See the following two examples to highlight the problem:

Item  How Import Wizard sees it    Item  How Import Wizard sees it 
1 1   1 1
2   2 2
3 3   3 3
A A   4 4
4 4   5 5
5 5   6 6
6 6   7 7
7 7   8 8
8 8   A 0

The first column is correctly setup and the second one is wrong.

Text

The Import Wizard can import data from any text file using a comma, tab, or any other delimiter.

A delimiter is simply a symbol used to separate adjoining fields within the same row. The choice of the delimiter can be set with the set up of the text file selection.

An example of a comma delimited (.csv) text file, and a tab delimited (.txt) text file are included in the folder called ShopFactory/Sample Databases.

Please read the note below about particulars how the rows need to be ordered.

MYOB

To import a MYOB database perform the following steps:

  1. In MYOB open the database which is to be imported into ShopFactory.
  2. Select "File Menu", then "Export Data", then "Items".
  3. At the "Export File" dialog box specify "Export Items Format" with "Comma-separated", and change the "First Record is:" radio button to "Header Record", then click "Continue".
  4. At the "Export Data" dialog box click the "Match All" button then click the "Export" button.
  5. At the "Save As" dialog box save the file name in the "ShopFactory" installation directory (e.g.: c:/Program Files/ShopFactory).

QuickBooks

To import a QuickBooks database perform the following steps:

  1. In QuickBooks open the database which is to be imported into ShopFactory.
  2. Select the "Reports" menu, then "List Reports", then "Item", then "Item Listing".
  3. At the "Item Listing" page, click the "Head/Footer" button which will display the "Format Header/Footer" dialog box.
  4. De-select ALL the check boxes, and click "OK" which will return to the "Item Listing" page, click the "Print" button to display the "Print Reports" dialog.
  5. In the first section, click the "File" radio button to select it, select "Tab delimited file" from the drop-down list, then click the "Print" button.
  6. Specify file name to save the database as (it will be saved as a '.txt' text format file, this is correct), make sure the destination is in "ShopFactory" installation directory (eg: c:/Program Files/ShopFactory)

SQL Server

The "Edit DSN" section is an advanced function and will only be visible if you tick the "advanced" button on the first page. Select a DSN Type from the DSN drop down list (either User DSN, System DSN or File DSN), specify the respective DSN on the edit field next to the drop down list. The DSN (Data Source Name) files are specified with the ODBC Administrator program located in the "Control Panel" popup. Import Wizard supports either User-DSN , System-DSN or File-DSNs. For more information on importing MS SQL Server 7 Databases contact your 'Database Administrator'.

Paradox

You need to specify the full path name of a paradox database, e.g. "c:\database\paradox\parardox-db1.db". There is no need to use the same field names - the Import Wizard will prompt you for the appropriate field names later. You should ensure that there is a file on the same folder as the specified db file.

dBase

To import a DBase database into ShopFactory Borland's BDE (Borland Database Engine) needs to be installed. Without BDE the Import Wizard may fail. A copy of BDE can be downloaded from http://www.borland.com.