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

MANUAL
GB CHATTER NOTIFICATION CONFIGURATION 1303
56
Import file for stormflow data
Create an import file for stormflow data in a SCADA-system
If you need to add new objects to the table containing the stormflow data, 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\StormflowData
cleanStormflowData.sql
Follow this procedure
Select the menu Files 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
cnsStormflowData.txt
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.
Do a Search and Replace in the open document.
search for , (comma)
replace all with . (period)
Save the file again.
55