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.
- Use SQLite Browser to create a new database and name it as
datalist.db
. - Enter
list
as table name, then add a field or column and name it asfile
and selectTEXT
as its type.
- Save the changes and copy the file into SCADA project folder.
- 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"
- 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.