Step 1: Define your needs: what you want from offline software on online panel
To receive data from offline software to online server you need to configure your server first. The whole process starts with a thorough investigation of your needs. The offline software contains a lot of data like account masters, item masters, vouchers, ledgers, tax details etc. etc. Whichever data you need depends upon your purpose.
For example if you are going to make an e-Commerce website or mobile app, you will need item masters only. In another case if you want to develop a stock management reporting portal, you need items, vouchers & inventory details. If you going to develop an accounts reporting website, you will need Account masters, Vouchers & ledger tables.
Today in this blog we are going to share with you a sample of getting your data from offline to online server as an example only.
After learning this blog, you will be able to
Ø Receive Offline software data on your own php my admin server.
Ø Configure server settings.
Ø Edit our php sample code
Ø Define database structure as per your requirements.
Ø Define columns to import from offline to online portal
Again I would like to repeat that this is a sample project for your understanding purpose only. Your actual requirements may differ from this project. To fulfill those requirements, you may need a bit more hard work.
Settings at online Server
1) Login to your own web hosting cpanel account
2) Create a new folder under public_html (Like in this example onlineapi)
3) Download Sample php Code files from http://bit.ly/2NbxY68
4) Extract these files using winrar.
5) Put php files in your online server in onlineapi folder
6) Sample_database.sql script is also given along with the php files
7) Import that script in php my admin to create a sample database.
8) Edit db_2.php file
9) Provide database information and credentials properly
In the same way you can edit any file to configure data import as per your requirement.
Configure this code according to your needs defining your own database variables.
Setting In Offline ERP Software
Click Help >> Developers Corner
Configure your server here
Click on Server Configuration to configure your server setting in offline software.
This step means you are redirecting the data flow path to your web hosting server.
Click Activate company to generate company id
To check your data synchronization click on “Synchronize Data”
Make sure
Ø You have “Developers Corner Synch.exe” file in your software application folder. Its available in latest software setups.
Ø You have configured the domain name, cpanel details and specified the script folder name (e.g. onlineapi) properly.
Ø You have configured your online server properly as defined above.
Ø There is no antivirus program running in the background.
Ø Read / write permissions as allowed on your server.
Comments