The database types below are supported. You can find some sample files here: Download samples file.
See ImportWizard for more details.
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.
Please note that due to the ODBC layer Import Wizard uses to access the data you must ensure that the date you import is correctly defined in the first 8 rows of the file you import.
ODBC interprets automatically the data type based on the first eight rows of your file.
If you have "1", "a", "3" in the same column in row 1, 2 and 3 respectively, then Import Wizard will see it as text, because of the a.
If you had "1", "2", "3", "4", "5", "6", "7", "8" and then had an "a" in row 9, then row 9 will not be imported correctly as ODBC will have determined that the column contains numbers, and a is not a number.
The a will then be imported as either a 0 or as en empty field, depending on what field in ShopFactory is is being imported into.
See the following two examples to highlight the problem:
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.
To import a MYOB database perform the following steps:
To import a QuickBooks database perform the following steps: