Xylem CHATTER Notification System configuration guide - Manual (Page 52)

MANUAL
GB CHATTER NOTIFICATION CONFIGURATION 1303
52
Import-file for object names
Create an import file for object names in a SCADA-system
If you need to add new objects to the table containing the SCADA object names, it is easiest to modify the supplied
spreadsheet and afterwards import those data to the table.
In order to be able to import these data into the database table, the spreadsheet must be saved as a tab-delimited text
file. After that, this file can be imported into the database.
When importing data to the table csnSCADAobects, remember to delete the existing content of the table
before importing new data. You can use this SQL-script to delete the existing content:
CNS\Server2008R2\ScadaObjects
cleanSCADAobjects.sql
Follow this procedure
Select the menu Files in Microsoft Excel
select Save as...
Save the file in a place of your choosing.
Select the file type Text (Tab delimited) (*.txt)
Click the button Save
Copy the saved file to this location on the server running MJK
C:\Users\Administrator\Documents\SQL
Server Management Studio\Projects
cnsSCADAobjects.csv
Find the saved text file and open it with Notepad.
Delete the top-line in the file, see the marking in the picture to
the right.
Save the file again.
48