BPA Import Utility

This application will allow you to import coma and tab delimited text files as well as CSV and Dbase III files into Business Plus Accounting.

After you install it you will need to open up My Computer and go to the directory that you installed it to (the default is C:\Import) and click on the Import.exe file to start the import application.

On the first screen you see you will be prompted for four different options.

File to import: This is the path and file name of the file you are going to import from. You can use the button next to this field to find the file you want.

Example: C:\Products.csv

File type: This is the type of file that you are importing from. You can choose from CSV, TAB, COMMA, and DBF. CSV is a comma-separated value text file with the column names in the first row of data. TAB is a tab separated text file. COMMA is a comma-separated value with no column names in the first row of data. DBF is a Dbase III or compatible data file.

Import to: This is the database in Business Plus Accounting that you want to import into. You can choose from Customer, Vendor, and Product data files.

Replace or Append: Check the Replace box to replace the current data file with the imported one. Check the Append box to append to the end of the current data file.

Once you have entered all the options click the Go button. After you click the go button it may take a little bit for the next window to come up.

This window is where you map the columns in your import file to the fields in Business Plus Accounting’s data files.

On the far left you will see a grid with two columns. The first column contains the text file column names from the file that you are importing.
The second column contains the Map To column name in Business Plus Accounting’s database file that corresponds to the text file column name in the import file.

On the far right you will see a column that contains the column names of the database you selected to import to. (Customer, Vendor, or Product)

In the middle you will see five buttons.

Map To: Click on this button to Map a selected database field name to the text file’s selected column. You should see the selected database field name appear in the Map To column of the Text File Columns.

Un-Map: Un-maps/clears the currently selected text file’s Map To column.

Un-Map All: Un-maps/clears all of the text file’s Map To column.

Cancel: Cancels this import.

Finish: Starts importing into Business Plus Accounting.