This article is a step-by-step instruction on how you can get the latest data from your ERP (SAGE) system onto the mSeller app.
We first need to extract the latest data out of the ERP. We use an application called psql_access.exe that does this.
The easiest is to access the folder on your desktop called mSeller Shortcuts
Inside the folder, there should be quite a few shortcuts that have been set up. Please navigate to the shortcut called Data Extract and double-click on it.
The shortcut will take you to the Integration folder. This folder contains all the latest extracted data files from your ERP as well as the psql application and the config files linked to it.
You can also navigate directly to the integration folder to run the psql application.
Once you are in the folder you can simply double-click on the psql_access.exe application.
It should take about 5min to extract the data.
You can check if it was successful by using the date modified as an indication. The date should update to your time.
Next, we'll need to import the data into the SOP software. You can do so by opening up the SOP software on your PC. After opening it, you need to navigate to Tools, Headoffice, and then Import Data From Back Office
SOP will then import the latest data that is located in the integration folder. Once this has been completed we need to export the data to the mSeller server for the mSeller app to gain access to it.
You can do this by going to Tools, Handhelds, and then Export Handheld Updates
After doing this, the latest data has been moved to the mSeller server, your field user needs to simply download the updates from the mobile app.
Please keep in mind that this process happens automatically every hour and does need to be done manually every time a change is made. This is for urgently required changes.