Import data from WMS

This article is to assist the shop administrators to migrate data from WMS to WMS2/Bufferzone.

You need to use Microsoft Access 2003 in this instruction.

You need the Shop Administrator Role to import data into WMS2 or Bufferzone.

Instructions for Importing Sites and Contacts

There are 3 steps to export data from WMS and import data into WMS2 or Bufferzone

Open the pools.mdb file in the C:\LCS folder. If the WMS application is installed in another location, please use that folder instead of C:\LCS.
Open the table PCustIn of pools.mdb database
1. Select File\Export to export the table to PCustIn.csv.
2. Enter PCustIn.csv in the File Name
3. Select Text Files (*.txt; *.csv; *.tab; *.asc) in the Save as Type
4. Click Export All button
5. Add | (pipe character) in the Other box
6. Check Include Field Names on First Row
7. Select none in Text Qualifier
Open the WMS2 (https://www.wms2.info) or Bufferzone (https://www.bufferzone.info).
1. Login with your account
2. Go to the Sites page
3. Click on the “Import Sites” button.
4. Select Water Management System (csv pipe delimited)
5. Click Select Data File and Import
6. Select the PCustIn.csv that you exported in Step 3.
7. Wait for the data to import. How long does it take? it depends on the size of your data (~ 10 minutes for 10000 sites). When the importing process finishes, an email will be sent to you.

There are 3 steps to export data from WMS and import data into WMS2 or Bufferzone

Open the poolsh.mdb file in the C:\LCS\hist folder. If the WMS application is installed in another location, please use that folder instead of C:\LCS\hist.
Open the table TestHist of the poolsh.mdb database
1. Select File\Export to export the table to TestHist.csv.
2. Enter TestHist.csv in the File Name
3. Select Text Files (*.txt; *.csv; *.tab; *.asc) in the Save as Type
4. Click Export All button
5. Add | (pipe character) in the Other box
6. Check Include Field Names on First Row
7. Select none in Text Qualifier
Open WMS2 (https://www.wms2.info) or Bufferzone (https://www.bufferzone.info).
1. Login with your account
2. Go to the Sites page
3. Click on the Import Sites button.
4. Select the TestHist.csv that you exported in Step 3.
5. Wait for the data to import. How long does it take? it depends on the size of your data (~ 10 minutes for 10000 sites). When the importing process finishes, an email will be sent to you.