Create File List Management with SQLite for SCADA

Datamap can be used to map to many columns in a table of a database, and of course can also map to only one column in a table for listing purpose. Here’s a step by step guide in creating a file management list. You will need to download SQLite Browser for creating the database and at least one table with a column for storing the file list.

  1. Use SQLite Browser to create a new database and name it as datalist.db.
  2. Enter list as table name, then add a field or column and name it as file and select TEXT as its type.
  3. Save the changes and copy the file into SCADA project folder.
  4. Create an entry in Datamap call datalist and paste the following connection string: Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="driver={SQLite3 ODBC Driver};database=<PROJECT>\datalist.db"
  5. Create a standard HTML file call “datamap-file.html” and add the following content:
    
    <!DOCTYPE HTML>
    <html>
    <head>
         <title>Datamap </title>
         <meta charset="utf-8">
         <link rel="stylesheet" type="text/css" href="system/styles/igrX.css" />
    </head>
    <body>
    <table data-igx='{"database":"datalist", "table":"list"}'>
        <tr>
            <th id = "file">FILE</th>
        </tr>
        <tr>
            <td ><input type="file"></td>
        </tr>
    </table>
    <script type="text/javascript" src="system/scripts/igrX2.js"></script>
    </body>
    </html>
    
    

When you start the Ecava IGX SCADA, you shall see an empty list and you may click Add button on top right and start uploading and archiving files.