Back Office > Administration > SQL Tools > Import & Export > Import Opening Account Balance

Description

This menu item is used to import Customer/Member's Account Balances (from a .CSV file) and use them to set the Customer/Member's Account Opening Balance.

To Be Considered

1. Note : It is aimed at advanced users only and also ensure that backups have been made before invoking this feature.
2. Only existing Customer/Members will have their Opening Balances imported. Note : This feature is not designed to fix any previously imported records that are incorrect.
3. Problems importing data, click here.
4. The custom import will not import account balances, you have to use this option.

Pre-Requisites

1. Ensure a backup has been made.
2. Import Customer/Members using the Custom Import menu item. Note : DO NOT import the Account_Balance field (This can be achieved by NOT matching it to a field in the .csv file).

Import Opening Account Balance

Header

• Transaction Date Time - Select from the drop down calendar the Transaction Date to be assigned to the generated (import) Account Charge/Payment transactions.
• Terminal ID - Select to open the Search Terminals screen to select the Terminal to be assigned to the transactions.
• Location Name - Displays the Location associated with the Terminal selected.
• Sales Person (Clerk) - Select to open the Search Clerks screen and select the Clerk/Staff Member to be  assigned to the transactions.
• Media Type - Select to open the Search Media screen and select the Media Type to be assigned to the transactions.
• Comment - Enter a comment (if required) to be assigned to the transactions.
• File - Select to open the Import File screen to select the CSV file to be imported.
• Import - Select to invoke the importing of the data.
• Close - Select to exit.

Grid

• Field - Displays all the fields of the selected table.
• Required - Displays those database fields that are mandatory. That is, data must exist for the import to succeed.
• Unique - Displays those database fields that are unique. That is, the data imported must contain a unique value. Duplicate values will cause the import to fail.
• Data Type - Displays the data type of the database fields. Data to be imported must be compatible with the data types displayed.
• Matching Field - Select from the drop down list of CSV file fields the field that is to be used to populated the selected database field.

Operation

1. First import the Customer/Members using the Custom Import menu item. Note : DO NOT import the Account_Balance field (This can be achieved by NOT matching it to a field in the .csv file).
2. Import the Customer/Members Account Balance using this feature and the same import file (assuming it holds the Customer/Member's current Account Balance) used in the above step.
3. Once the import has complete successfully, the imported Customer/Members should now show an Opening Balance in the SwiftPOS Back Office.

Related Topics

1. Data Export
2. Import/Export Overview
3. Installation
4. SQL Tools