Bufferzone
Bufferzone
Breadcrumbs

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

  1. 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.

    unnamed.png


  2. 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

      unnamed (1).png

    5. Add | (pipe character) in the Other box

    6. Check Include Field Names on First Row

    7. Select none in Text Qualifier

      unnamed (2).png


  3. 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.

      unnamed (3).png


Instructions for Importing Water Test History

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

  1. 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.

    unnamed (4).png


  2. 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

      Capture.PNG


    5. Add | (pipe character) in the Other box

    6. Check Include Field Names on First Row

    7. Select none in Text Qualifier

      unnamed (2).png


  3. 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.

      image-20200730-083557.png