Getting the lastest ERP data onto the mSeller App

  • Updated

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 from your ERP. To do this, we use an application called psql_access.exe. 

The easiest way to locate this is by navigating to the folder on your desktop called mSeller Shortcuts
mceclip0.png

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. 


mceclip1.png

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.


mceclip2.png
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.  

mceclip3.png

It should take about 5min to extract the data. 

You can confirm if it was successful by checking if the date modified updated to your current time. 

mceclip4.png

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 > Import Data From Back Office

mceclip5.png

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 > Export Handheld Updates

mceclip6.png

After doing this, the latest data has been transferred to the mSeller server. Your field user needs to download the updates from the mobile app in order to see the changes.

Please keep in mind that this process happens automatically every hour and does not need to be done manually every time a change is made. This is for urgently required changes.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.