Import Export Function
Import Export Function can be found across the system.
| Export | You can click the Export button which will return the existing data listing into the required template for import |
| Import Using ID |
Using this option allows one to export with the internal ID. This means one can change the code of the item Once you click Import ID. You will receive a warning. The import using ID refers to including the system ID which should not be changed at any given time. |
| Select & Upload File | Click the Select File Button to open your file explorer: search and select the import file you saved in the above step. |
| Verify | Click the Verify button to check for any errors on the import file |
| Import | Allows you to be able to import debtors/ Customers to the system |

| 1. |
Once you have the worksheet populated with the respective new information details, save the file as a normal Excel file. |
| 2. |
You should get a successful result returned. If not, correct the file, resave the file and retry the Verify |
| 3. |
If there are any errors when you click verify then you can click on report to see what is causing issues |
| 4. |
Once Verify is successful, click the Import Button |
| 5. |
Then click the report button below import to check if all the information were loaded accordingly |
| 6. |
When all results are successful and you are happy with the report |
| 7. |
Your New data will be loaded into the system and you can search for it in the normal manner. |
Verify Errors
When Verifying the data and an error comes up, check the Report of the Verify
Open up the report and handle any issues in the Excel file
Line No corresponds with the Excel row line
When in Excel use Crtl + G to enter the Line number with A9952
Find the corresponding line in Excel to fix or find where the issue is
After all the errors have been sorted, save and close your Excel file
Close the Import Export window to re-upload
Verify the data again
Once the Verify is successful, move to importing the data






No Comments