Home

AutoLog_GSM_PLC_Driv.. - FF

Contents

1. FTP Interface Database History data Alarm handling Saving history data Creating alarms User Interface Trends Graphics over 200 drivers programmable time controls Ask more GSM SMS CallControl Web support DB2SMS SMS Interface SMS parsing Database I Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls All Applications can run in the same PC 1 New Database window opens Write Name smsindusoft and Owner Iws Note This database is needed only for DB2SMS driver Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 25 CONFIGURATIONS E Hew Database Properties variables Privileges Mame smsindusort OID Chwner Encoding Template Tablespace lt defaulk tablespace gt Schema restriction Collation Character type Connection Limit Comment Psql guide smsindusoft database can be created using the following command CREATE DATABASE smsindusoft WITH ENCODING UTF8 OWNER iws Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual CONFIGURATIONS Right click on the smsindusoft database and select Properties peAdmin Ill Seles File Edit View Tools Help Object browser Hj Servers 1 B F PostgreSQL Database Server 8 2 loca
2. smsindusoft j Domains U 5 FTS Configurations 0 lll FTS Dictionaries 0 FTS Parsers 0 FTS Templates 0 gt Functions 0 a Sequences 5 a Tables 12 calls in E calls out errormessage E phonebook receiving E Columns 3 4 4 Constraints 1 Indexes 0 T Rules 0 i gt Triggers D phonebook sending received events received history received report send all send one send watchdog ES variable crosslinks fi Open pgAdminlll and open smsindusoft database Right click the phone book receiving and select View data gt View all rows Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 5 CONFIGURATIONS E Edit Data PostgreSQL 8 4 localhost 5437 smsindusoft 2 w gem v name phone enabled text PK text numeric 1 Ip 13 T3584 l 2 p 15 3584 1 3 imk 5 3584 1 4 mk 10 3554 1 2 rik 11 T3584 1 amp mk 1z 3584 1 y 3584 1 Ip 20 T3584 1 g Ip 21 T3584 1 10 mk 13 3584 1 11 Ip 17 3564 1 1 Ip 7 T3584 1 13 Ip 14 T3584 1 i4 Ip 15 3584 1 15 wo T3585 1 16 rk 6 3554 1 17 mk 7 3584 1 18 mk 8 3584 1 19 mk a 3554 1 2 Ip 18 T3584 1 21 avs 1 3584 1 22 mk 4 3584 1 23 Ip 8 T3584 1 4 Ip 4 T3584 1 25 Ip i0 3554 1 25 vpt 3584 1 ef vp z T3584 1 2 vp 3 T3584 1 29 p 5 3584 1 30 p 4 3584 1 31 vp 1 T3584 1 32
3. Provides F Parvittaa a Google Lp eer isi You might need to restart the server after this change You can check the status of the Filezilla server in Control Panel gt Administrative Tools gt Services Click restart Status Started Started Started Started Started Started Startup Type Automatic Automatic Automatic Automatic Manual Automatic Disabled Automatic Manual Manual Log On s Local System Local System Local System Local System Network 5 Network 5 Local System Local System Local System Local System Started Started 7 2 7 Setting up the GSM PLC to send FTP files over GPRS Open GSMProgrammer View gt FTP info F Ftp Info Editor File Transfer Compile SUS VHEY S Humber Ut Files 4 Ftp Server Ftp Path Ftp Password securetest Check your public IP address www whatismyipaddress com rPLEID 123 123 123 FFAO0001 G8M TO INDUSOFT Automatic Manual Automatic Manual Automatic Pikara nic Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual Local System Local System Local System Local System Local System Lael Cockers CONFIGURATIONS Write your public IP address to the Ftp server fields Click save View Gprs info File Transfer Compile LE x a w Use Gprs Info Auth Phone number DNS 1 rar 38 18 v o o o o o o o o ISPYAPH user name ISP SPN password
4. Databases 2 smsindusoft E postgres 32910 iws Tables Refresh E B Group New Object pg default dk Login peletejDrop SQL_ASCII im Default schema public po CREATE script Allow connections Yes Reports d E Connected Yes Maintenance System database No Backup EE Comment Restore Properties Database smsindusoft DROP DATABASE smsindusoft CREATE DATABASE smsindusoft WITH OWNER iws ENCODING SQL ASCII lt lili Select Variables sheet and write Variable name search path and Variable Value smsindusoft Click Add Change D Database smsindusoft Properties Variables privileges Variable Value Variable Mame search path smsindusark Variable Value Psql guide Setting search_path variable ALTER DATABASE smsindusoft SET search_path smsindusoft Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 27 CONFIGURATIONS 4 Right click smsindusoft database and select Restore pgAdmin Ill File Edit View Tools Help O 2 0 HET p n Object browser X Properties Statistics Dependencies Dependents Hd Servers 1 E F PostgreSQL Database Server 8 2 loca E B Databases 2 3 postgres 0 s Tablespace Refresh i Group Role New Object F Tablespace pa default S Login Role Salete a Encoding SQL_ASCII M iws F Default schema public posta CREATE script E A
5. driver Use the same password for iws user as was configured when installing postgreSQL database Connection Test Eg N Connection successful OK Test connection Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 39 CONFIGURATIONS PosteresOL Unicode ODBC Driver ipsglODBC Setup Data Source I Description Database smshistary SSL Made disable SEE localhost Fort 5432 User Mame is cera 77 Options TET ez Datasource Global Manage DSH een _ ee Meee Make the above configuration for smshistory database if you are using DB2SMS driver Use the same password for iws user as was configured when installing postgreSQL database Connection Test E P Connection successful OK Test connection Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 40 CONFIGURATIONS 5 2 2 Adding ODBC DNS Data Source Name for FTP parser driver This is needed for GPRS FTP only Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication gt gt Alam sending via SMS gt gt Measurement History data icicles by ese Pee eee sending via FTP or SMS I GPRS FTP needs I Report sending via SMS nir mE MP EN SMS controls parameters or eae ion A lt lt Remotely programmable a jue ee ae ee PP lt lt Free call controllable incoming phone number identification Features FTP Parser Full program
6. Features eo FTP Interface Database Full programmable PLC z features I O Modbus M S Edera History data programmable time controls TP server Ask more nm GSM SMS CallControl ask measurement reports Set parameters Call controls Filezilla FTP server GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls Overview of using WebStudio GSM GPRS Driver 1 GPRS FTP needs SMS Interface Database Alarms Reports History Group messages etc CUL All Applications can run in the same PC Download free Filezilla FTP server from https filezilla project org FileZilla Server 0 9 49 exe Install it to your PC using default settings m FileZilla Server beta 0 9 49 Setup Choose Components Choose which features of FileZilla Server beta 0 9 49 you want to install z Check the components you want to install and uncheck the components you don t want to install Click Next to continue Select the type of install Or select the optional components you wish to install Space required 5 5MB Standard FileZilla Server Service Administration interface Description Position vatur mouse over a component to Source Code see its description Start Menu Shortcuts Desktop Icon Nullsoft Install System v2 46 Unicode Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 1
7. Modem extra settings APN server nane ihternet GSM TO IMDUSOFT FTP DEMO GPR T Enr Check your mobile operators SIM card supplier s Internet APN name You can google this using words like your operator name internet access point name Check also if you need to use some DNS IP addresses and what is the authentication method The above setting work in Finland DNA mobile operator s network Compile gt Compile Transfer gt Transfer Project Click Green RUN button oet GSM PLC s DIP 4 OFF insert SIM card PIN code request is turned off and reboot the GSM PLC activates GSM GPRS modem For GSM 20 put the GSM modem cable back to GSM PLC s serial port 1 Check that the FTP Parser program is stopped system tray and stop it If not right click on this icon on the If your GSMProgrammer FTP settings Firewall settings SIM card and GSM modem settings and FTP server settings are working you should receive files to your FTP server s home directory 1 file 60 seconds Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 6 CONFIGURATIONS Note If FTP parser is running it will read the FTP files from the home directory and move the old files to Old files directory so in this case you might not see FTP files in this directory Check the system tray if the FTP parser is running Close it to verify that the FTP files are coming to the server s home directory 7 2 8
8. purposes DB ReceiveEvent Message DB SendAll Flag C Group message flag is set to 1 DBC SendAll Insert If StrLeft StrLower DB ReceiveEv If the event message starts with the word ent Message 5 alarm NOT alarm or ALARM then it will be send using DBC SendAll InsertDBC SendAll group SMS sending Insert DBC ReceiveEvent Mselect NOT DBC ReceiveEvent Mselect Selects array for modification Event Receiver State Moves to phase 2 Event Receiver State0 MTrig O This math will not be executed again 10 3 4 3 Phase 2 Event Receiver State1 MTrig DB ReceiveEvent Flag O0 Flagis turned to zero array is read DBC ReceiveEvent MUpdate NOT DBC ReceiveEvent MUpdate The flag field is updated to zero Event Receiver State Next phase Event Receiver State1 MTrig LEER This math will not be executed again 10 3 4 4 Phase 3 Event Receiver State2 Mtrig DB ReceiveEvent Phone Phone number is cleared DBC ReceiveEvent Next NOT DBC ReceiveEvent Next Next event is read Event Receiver State lO Backto phase 1 Event Receiver State2 MTrig EN This math will not be executed again Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 98 99 10 3 4 5 Finish Event Receiver Finish_MTrig Event Receiver Active 0 S Receiving has Finished Event Receiver Finish MTrig O This math will not be executed again 10 3 5 Report and history maths 1 phase only 10 3 5 1 History receiving math 1 Ph
9. Colors C Use default name C Automatically create Data source settings Highlight ag Odd lines L aj Name trend ffaaffaa w Refresh Test Even lines F Col S Data Link Properties x D isable E 5ian Security LLL Vita keyboarg se Defaut Provider Connection Advanced All a Specify the following to connect to ODBC data 1 Specify the source of data Use data source name C Use connection string Connection string Bi 2 Enter information to log on to the server LL OO Warning Far efer to the FE JW verify pr C Blank password _ Allow saving password 3 Enter the initial catalog to use Double click grid object gt Select Data source settings gt Select on the right side of the connection string gt Select Connection tab gt Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 111 Appendix FTP Data Reading Sample goo SOc time stamp Introduction J This application demonstrates showing received FTP ass ess measurement data in Webstudio frm MySQL or oi ic PostgreSQL database es This application by default uses DSN name IWS_FTP and database trend ffaaffaa The trend and the table show only variable ail_temp values NELE If you explore this application you can see that showing FTP
10. Make the configuration Do not copy the IP addresses Use your own WAN IP and local host IP addresses 7 2 4 Order Static public IP address Note You will might need static public IP address for your SCADA server PC otherwise your application will not work long time Dymanic IP address might change when you reboot Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 70 CONFIGURATIONS your computer Please consult your Internet network operator and order public static IP address for your network connection For testing you can have dynamic IP address To check your IP address you can open http www whatismyip com 7 2 5 Setting up Filezilla FTP server software Group Settings Groups General Enable access Far users inside group Shared Folders Speed Limits IP Filter Connection settings Bypass userlimit of server Maximum connection count oo Connection limit per IP Force SSL For user login Description Copy You can enter same comments about the group Edit gt Groups Add user group admin OK Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 7 General Shared folders Speed Limits TP Filter Directories H CSFTP 4 CONFIGURATIONS Aliases Ea Les Ea JAMM Write Delete Append Directories Create Delete List Subdirs Autocreate You can use u in Faldermames as a placeholder for the username IF specified an alias for a directo
11. 2 Change FTP wm100 FTP mTrig 1 3 Clock 00 01 00 FTP WD timer FTP WD timer 1 init_timer 12 4 Change FTP wm100 FTP WD timer 5 Change FTP WD limer N1 status IKFTP WD timer 5 1 0 6 Change FTP wm100 N1 WatchDog FTP wm100 Clock 00 00 05 select ftp not select ftp Change FTP wm100 FTP mTrig 1 Clock 00 01 00 FTP WD timer FIP WD _timer 1 init timer 12 Change FTP_wm100 FTP WD timer 0 Change FTP WD timer N1 status i FTP WD timer25 1 0 Change FTP_wm100 N1 WatchDogFTP wm100 FTP mrTrig Starts the Math task which scales the raw analog values to engineering units See the next page WD WatchDog which is used to check that the FTP communication is working Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 83 TESTING FTP DEMO 7 4 3 Math task which scales the raw analog values to engineering units Sa MATHUOUOS8 Language Built in Description FTP mirig Execution FTP mirigz1 Tag Name Expression 1 WN1_verk_painet FTP WM20 400 2 M1 verk painez FTP WM21 400 3 M1 verk LT1 FTP WM22 20 50 4 M1 verk LT2 FTP WM23 20 50 5 Ni verk paineera M1 verk paine1 M1 verk painez 5 FTP mirig 0 Paine pressure in Finnish LT L mporTila temperature in Finnish oee complete Indusoft web studio FTP demo application to learn more Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 84 TESTING FTP DEMO 7 5 Configuring GsmProgrammer and Pump demo monitoring template application This
12. GSM Phone s receive SMS alarms i O f acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls All Applications can run in the same PC You can download ODBC connector for PostgreSQL from this site http www postaresal org ftp odbc versions msi ODBC connectors are also delivered in driver CD Tested version psqlodbc 08 04 0200 zip For Window 7 x64 you should use psqlodbc 09 03 0300 x64 1 especially if you are using ftp parser Unzip this file and run setup i psglODBC Setup Welcome to the psqlODBC Setup Wizard The Setup Wizard will install psal GDBC an your computer Click Next bo continue ar Cancel to exit the Setup wizard Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 14 INSTALLATIONS Click Next i psglODBC Setup End User License Agreement Please read the Following license agreement carefully GNU LESSER GENERAL PUBLIC LICENSE Version 2 1 February 1999 Copyright 071991 1999 Free Software Foundation Inc 59 Temple Place Suite 330 Boston MA 02111 1307 USA Everyone is permitted to copy and distribute verbatim copies of this license document but changing it is not allowed This is the first released version of the Lesser GPL It algo counts az the successor af the GNU Library Public License version 2 hence the version number 2 1 Preamble I accept the terms in Ehe License Agreement
13. 0 0 0 0 0 0 30 You can check that the data is coming to database from pgAdminlll program Sana Fie Edit Plugins View Tools Help FO 3n l9 m browser Servers 1 PostgreSQL 8 4 localhost 5432 a Databases 3 g g Ftpdata GA FTS Parsers 0 P 3 FTS Templates 0 La amp Functions 0 m E Sequences 0 B Tables 1 nmana TA al ee AS Right click and select gt View data gt view all Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 119 Appendix Now open Indusoft web studio IWS FTPParserDemo app Check that you have set correct DSN name IWS FTP in the screen objects RUN the project BI FIP Data Reading Sample m gt Tanz v 13 56 01 00 00 01 30 20 14 56 gt You should receive data to the tables This is just a simple demo You can also configure ODBC task which reads values from the database to Indusoft tags Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 120 APPENDIX 12 Appendix 12 1 DB2SMS driver interface description DB2SMS is SMS driver which handles the outgoing and incoming SMS messages It is responsible for low level communication with GSM modem filtering the incoming SMS messages and parsing the messages DB2SMS uses an PosGreSQL database interface with other programs like Indusoft Web Studio IWS SCADA software DB2SMS driver can receive and send SMS messages through GSM mod
14. 00 The first and the only data field has date 1 1 2007 OE 21 and time 09 00 09 00 The variable AOO value is 65535 FF FF Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 141 Appendix 12 4FTP_parser Config ini example FEE FTP parser configuration file Updated 23 1 2008 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI General configuration THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI DataDir defines the directory that holds received files DataDir C FTP HHARHHHHRHHHRHHHHHHRHHHRHHHHHHHHHHH Database connection THBHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI You can use MySQL or PostgreSQL with FTP parser comment the line you don t need Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL ANSI SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto for 64 bit windows 7 ConnectionString DRIVER PostgreSQL Unicode x64 SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto Next line defines connection string for MySQL ConnectionString DRIVER MySQL ODBC 3 51 Driver SERVER localhost DATABASE ftp_ data JSER iws PASSWORD secure_password Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 142 Appendix GSM PLC application example FTP pressure sending EFrogram FIP program Version 1 1 Date S 2p Owe Dd Author Antti Moijanen v 1 1 Jouni Paavonen v1 0 base code PEk kk T1 Q AlO0 pressure
15. 1 30 2012 12 41 PM 1 30 2012 1 36 PM 1 30 2012 12 46 PM 1 30 2012 1 41 PM 1 30 2012 12 51 PM 1 30 2012 1 46 PM Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 116 Appendix 11 4 1 Setting the PLC clock with Alarm Log You can check and set the PLC clock to correct time ig Alarm Log File Alarm ze dde 13 31 57 30 01 2012 OO00 TIME 13 31 58 30 l z lz TS3584b5740030032z TIHME 30 01 12 1 13 31 TIME returns the date and time you can copy the time format for next command he Alarm Log File Alarm SHa tas TIME 30 01 12 1 13 34 13 31 57 30 01 2012 OO00 TIME 13 31 58 30 01 2012 T13584574 0 030032 TIME 30 01 12 1 13 31 Paste the time format and add one space between TIME and and change the time fe Alarm Log 13 31 57 30 01 2012 O0O00 TIME 13 31 58 3 0 0l1 z lz T3584574 0030032 TIHME 30 01 12 1 13 31 13 34 43 30 01 2012 O0O00 TIME 30 01 12 1 13 34 13 34 44 30 01 2012 T3584574 0030032 TIHE 30 01 12 1 13 34 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 7 Appendix P config ini Notepad File Edit Format View Help PrETESPTPTTTETSES TTTTTS4Gg EES G4HgHEERESSG FTP parser configuration file Updated 23 1 2008 AE Eee A Bg agg RE E ede General configuration 7A EER Eee DataDir defines the directory that holds received files DataDir C ftproot Fi Database
16. 1 Adding ODBC DNS Data Source Name for DB2SMS driver This is needed for GSM SMS only Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication gt gt Alam sending via SMS gt gt Measurement History data sending via FTP or GPRS i Peg EEEN oe 1 i GPRS FTP needs i gt gt Report sending via SMS i E i SMS controls parameters static Internet IP address lt lt Remotely programmable Internet Service L oS PC TRE M Free call controllable incoming phone number identification t Features FTP file parsing Full programmable PLC Ethrenet Provider FTP Interface Database features I O Modbus M S wane History data programmable time controls FTP server Ask more GSM SMS CallControl DB2SMS SMS Interface SMS parsing Database Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms O acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls All Applications can run in the same PC PostgreSOL Unicode ODBC Driver psqlODBC Setup Data Source smsindusoft escription Database smsindusoft SSL Mode disable SEET localhost Fort 5432 User Name iws aad re _ T est atasource Global Manage OSH Save Cancel Make the above configuration for smsindusoft database if you are using DB2SMS
17. 30 seconds WM35 0 WM35 1 WM36 0 WM36 5 M100 M100 WM20 AIO0 WM21 AI1 WM22 AT2 WM23 AI3 executed always moves RAW Analog input values to WM20 23 KE ee ne ICE FTP LOGGING amp Transfer KKAKKKKKKKKK Optional clause If some of the output status changes log amp send uncomment the next line to activate it DOO 1 DO0 0 D01 1 DO1 0 D02 1 DO3 1 D0O3 0 M62 1 log amp send on event P1 WM30 1 increment logging timer and transfer timer once second P1 P1 WM100 1 increment communication watchdog once second P1 WM100 65535 WM100 1000 resets communication watchdog to 1000 when reached 65535 SR LOGGING kKkK kK WM30 25 M60 timer baser logging M60 M60 1 SWM20 SWM21 S5WM22 5WM23 S5WM100 SRO98 245 P TRANSFER WM30 30 M61 WM30 0 Timer based Transmit M61 M61 1 RO38 8 RO37 1 RO37 amp RO38 are special FTP sending registers look GSM PLC User Manual Backup SMS sending if enabled Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 6 CONFIGURATIONS Send if error in FTP transfer Exclude file empty error 130 sends SMS to phone number 20 defined in phone book 7 RO37 gt 26 amp L ROSTH 1L30 WM20 9WM21 9WM22 9WM23 S9WMIOO SRO9S9S 20 Note when testing this application use direct cable connection and DIP 4 position ON before testing the real GPRS transfer Look incoming files in alarm log view and the GsmProgrammer program root directory Se
18. After you have created a new variable and selected it you may create a history database for it Just check Enable history database for this variable checkbox Variable index defines the index of the selected variable while receiving history or report messages FF Automation Variable configuration See Add new PLC Add new variable Enable history database for this variable Delete selected variable Variable index NEN PLE enabled Delete Rename Duplicate selected selected selected 7 When you are done with creating variables just close the program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 92 TESTING FTP DEMO 9 5 Deleting messages MyTest demo project deletes old flag 20 messages from the interface database tables 24 hours period You can delete the old messages from the table by toggling the following tag values Toggling means that 1 turns to O or O turns to 1 Toggling doesn t mean that 1 turns to 2 DBC ReceiveEvent Delete DBC ReceiveReport Delete DBC ReceiveHistory Delete DBC _ SendAll Delete DBC SendSingle Delete Program is designed so that it will automatically select the deleted data using one minute period Look ODBC task 9 6 Sending error messages IWS changes the value of the interface database s Send Watchdog table every 8 seconds If DB2SMS detects that this value is not changing in defined time it sends the defined SMS message to the defin
19. Cache Server Uses HTTPS O BranchCache Peer Discovery Uses WSD O E ceserver CodeMeter Runtime Server O CodeMeter Runtime Server O CodeMeterFWExl Connect to a Metwark Projector O O Core Networking I emos 3 B La Allow another program Click Change settings and Allow another program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 64 CONFIGURATIONS Add a Program Select the program you want to add or dick Browse to find one that is not listed and then dick OK Programs Application Stack Builder LM CCleaner b Create a System Repair Disc cybertink Power 2Go FS CyberLink PowerDVD 12 Gi Desktop Burning Gadget EElExcel 2013 FileZilla Server Interface LC Google Chrome HP Client Security Wee Documentation Path C Program Files x86 Filezilla Server FileZilla What are the risks of unblocking a program You can choose which network location types to add this program to Select Filezilla server interface click add LITE arit ETITIEET 2TIaririt LJ L_ FileZilla Server Interface Set public network 7 2 2 Open TCP port 21 for FTP File Action View Help e Fl IH Windows Firewall with Advance I Rul Wi Inbound Rules Name Profile Outbound Rules By Connection Security Rules Bonjour Service Public b Monitoring V Bonjour Service Public Y Filter by Profile gt V Bonjour Service Public Y FiterbvS y V B
20. Ip 1 T3584 1 33 Ip 3554 1 34 p 5 3584 1 35 Ip 11 T3584 1 36 Ip 12 T3584 1 37 mki 3584 1 38 p 5 3564 1 3g mk 1 T3584 1 40 mk a 3504 I Add the GSM PLC s SIM cards phone number to the list with land area code no spaces Insert value 1 to enable column Name column is used to link the data between variable crosslinks table which we will configure next Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 52 CONFIGURATIONS 2 4 smsindusaft Domains 0 4 amp 5 FTS Configurations 0 FTS Dictionaries 0 ise FTS Parsers 0 FTS Templates 0 Functions 0 E ap Sequences 5 S A Tables 12 calls in calls aut EJ errormessage phonebook receiving E E Columns 3 Constraints 1 Indexes D T Rules 0 i Triggers 0 phonebook sending received events received history received report 0 6 6 E E E E E H Right click the variable_crosslinks table and select View data gt View all rows Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 293 CONFIGURATIONS Edit Data PostereSOL 8 4 localhost 5432 smsindusoft yariable_crosslinks File Edit View Tools Help W 7 No limit v name plc scaling divisi scaling base scaling max scaling min id Lext PK text integer integer integer integer numeric 31 isalarm Ip 1 1 0 4096 0 J 32 Wwm99 Ip 1 1 D 4096 D 10 33 wm50 Ip 1 i 0 4096 0 11 3400 wn Ip 1 l D 4096 D 12 35 w
21. Manual 0 Auto 1 state to binary memory number 2 M2 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 105 Appendix M50 M50 WM5O0 AIO0 WM51 AI1 WM52 AI2 WM53 AI3 analog inputs raw values are copied to WM50 53 0 2 A GSM modem is resetted at clock 2359 FOR AUTOLOG GSM 4 GSM 8 GSM 16 CLK 2359 M90 M90 1 RO30 1 resets gsm modem system program sets it back to 0 automatically just in case the modem gets jammed RO30 resets embedded GSM modem which is used in GSM 4 8 and 16 0 2 B GSM modem is resetted at clock 2359 FOR AUTOLOG GSM 20 with external GSM modem GSM 20 has external GSM modem which needs to be resetted using external relay which is controlled by digital output M90 1 DOO 1 resets GSM 20 GSM modem Conennect DOO to external relay to cut off the power from the GSM modem DO0S10 DO0 20 1 0 DIGITAL ALARMS DIO High water level limit switch NC Normally Closed 0 alarm 1 normal state DIO MO MO High water level alarm bit value 1 alarm DIO 0 0 normal state DIO 1 IDIOS3S M0 1 ALARM state 3 seconds delay for water waving note NC input DIOS120 M0 0 NORMALIZATION state 120 seconds delay for hysteresis so that the alarm state doesn t repeat too often empty Empty lines are reserved for program updates through sms empty 1 2 HEAT RELAY ALARM PUMP 1 FAULT AND NORMALIZATION DIL Pump 1 heat relay alarm NC M1 Pu
22. New folder e E l Pictures m Name Date modified Type Size B Videos config 28 5013 11 55 Configuration sett 1 KE u C FTPParser 24 1 2008 16 26 Application 40 KB Computer ECC 3 _ state log 19 6 2013 2 19 Text Document 51 KB az Windows C E E a FTP_parser driver is in the FTP_parser subdirectory Open it Open config ini and check the configuration Check that the DataDir C F TP or same as your FTP server s home directory Check that database is ftpdata Uid iws Pwd ffauto or your own password which you have defined when creating iws user to the postGreSQL database You can check also the state log which should be empty Youi can open the C FTP directory to see the ftp files These files will be parsed to the PostGreSQL database with the ftp parser driver Now you can start the ftp parser by double clicking the FTPParser application file If you test setup is working the table should be filled with data coming from the GSM PLC Click table refresh button If you cannot see data after about 2 minutes one thing you can check is the PosGreSQL s server status which is useful for solving database related problems Tools gt Server Status Server Status PostereSOL 8 4 localhost 5432 Logfile PID Database Relation User Timestamp Level Log entry 2015 03 04 08 29 01 EET FATAL the database system is starting up 2015 03 04 08 29 01 EET LOG database system was inte
23. Receiver State 1 0 AND Event Receiver StateO MTrig 0 0 11 Modify report table Received Report mindex DB ReceiveReport Index Modify the report table Modifies the report array s flag back to zero after reading AND Event Receiver State1 MrTrig 0 Change DBC ReceiveHistory Event Receiver NOT DBC_ReceiveEvent StatusO 0 OR NOT Event Receiver Active Transaction Finish Mtrig DBC_ReceiveEvent Status1 0 OR DB ReceiveEvent Time 0 Change DBC ReceiveHistory Event Receiver DBC ReceiveEvent Status0 0 AND Event Receiver Active MTransaction otate2 Mtrig DBC_ReceiveEvent Status1 0 AND Event Receiver State 2 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 96 TESTING FTP DEMO First row activates the initialization ODBC task is triggered from math function Second row activates the saving process of the read event to the history database This phase is activated only is there are no errors in ODBC read Event Receiver Status0 0 and program is in the first phase Event Receiver State O0 and third phase is not active Event Receiver State2 MrTrig 0 and initialization is not active Event Receiver Begin MrTrig 0 and the read event array was not empty NOT DB ReceiveEvent Phone 3 and 4 rows are similar to 2 row The last row activates the Finishing process if something went wrong NOT DBC ReceiveEvent Status0 0 OR NOT DBC ReceiveEvent Status1 0 or there are no more new
24. Select accept Click Next i psglODBC Setup Custom Setup Select the way vou Wank Features to be installed Click the icons in Ehe tree below bo change the way Features will be installed psqiopBc The PostgreSQL ODBC Driver r Documentation This Feature requires OKB on your hard drive It has 1 of 2 subFeatures selected The subFeatures require 4832KB on your hard drive Location C Program FilesipsgiODEC Click Next Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 15 INSTALLATIONS i psglODBC Setup Ready to install psqlODBC Click Install to begin the installation Click Back to review or change any of your installation settings Click Cancel bo exit Ehe wizard Click install i psglODBC Setup Completed the psqlODBcC Setup Wizard Click the Finish button bo exit the Setup wizard Finish Click Finish Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual INSTALLATIONS 4 5 Installing FTP server software If you are using only the GSM SMS communication you don t need to install FTP Server AutoLog GSM RTU s GSM SMS GPRS FTP Call Communication Alarm sending via SMS gt gt Measurement History data sending via FTP or SMS NS Report sending via SMS lt lt SMS controls parameters e pone aa lt lt Remotely programmable cei io ears E eee Free call controllable Er P incoming phone number identification
25. connection Fi ES You can use MySQL or PostgreSQL with FTP parser comment the line you don t need PostGresQL is suggested more tested amp documented amp used Next line defines connection string for PostgresoL connectionstrings DRIVER POostgreSQL UNICODE SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto Next line defines connection string for MySQL Connectionstring DRIVER MySOL ODBC 3 51 Driver SERVER localhost DATABASE ftp data USER21ws PASSWORD secure pass Open ftpparser program s config ini You can change the DataDir line DataDir C ProgramFiles GsmProgrammerWProjects GSM Demo Kit Logic Program Databir defines the directory that holds received files DataDir c Program Files sasmProgrammer sPrajects aGsM Demo kit Logic Program ConnectionString DRIVER PostgreSQL UNICODE SERVER localhost DAT ABASE ftpdata Uid iws Pwd yourpostgresqlpas sword Save the file and double click FT PParser exe 40kB FTPParser exe Application 1 24 2008 4 26 PM FTPParser starts in the system tray You can exit the program by double right clicking the icon SKB state log tet Text Document 1 30 2012 2 47 PM You can check the status of the FTPParser from the state log txt file ect Explorer Du Sx MATHOO1 Language Built in As Project APPL APP Alarms Description Trend j Recipes 4 Reports Execution ODBC Bei Math la 1 Initialization Script Ta
26. d mager Functions 0 E xm rj Views 0 Be public 8 Replication 0 L postgres z smshistor y smsindusoft aie Tablespaces 2 4 bee Group Roles 0 H A Login Roles 2 SOL pane Table trend ffa0o001 DROP TABLE trend ffa 0001 CREATE TABLE trend ffa00001 time stamp timestamp without time zone NOT NULL time stamp ms integer wm20 integer wm21 integer wm22 integer wm23 integer wm99 integer wmlOO integer ro98 integer CONSTRAINT trend ffa00001 pkey PRIMARY KEY time atamp WITH OIDS FALSE ALTER TABLE trend ffa 0001 OWNER TO iws Browse to the ftp database and right click trend ffa00001 table EE Edit Data PostgreSQL 84 localhost 5432 ftpdata trend ffa00001 File Edit View Tools Help H 2 2 G 9 T wvw time stamp time stamp wm20 wm21 wm22 wm23 wm99 wmi00 integer integer integer integer integer EN E View data gt View all rows The table is still empty Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 78 TESTING FTP DEMO Open the windows explorer and locate your GSM to Indusoft FTP demo Indusoft project directory You can copy the GSM to Indusoft FTP demo project directory under the following folder CAMWS 71 Projects QU t Computer Windows Cz IWS 71 Projects GSM to Indusoft FTP DEMO FTP parser Organize Include in library Share with Burn
27. data doesnt need any tags nor ODBC sheets as it OE uses only table and graph objects built in data viewing possibilities The database confiquration is done in objects ject Properties ed m 9 Ls Hiel E Data Sources Data Source FTP data v TTE source TYPE Database vj C Use project default m ue Connection string Provider MSDASQL 1 Data Source l Cancel DW l ET Came dus m Max Buffer 1024 Data Link Properties x Load Progress Provider Connection Advanced All DNI CSS sd Specify the following to connect to ODBC data sort 1 Specify the source of data Keep Open Use data source name Data Source Settings lwS5 FTP v ol OO UETUMTTERCUTE YS Use connection string Warning For compatibility re Onnec TIE Verify project was co Build 2 Enter information to log on to the server User name C Blank password _ Allow saving password 3 Enter the initial catalog to use v 3 ES INSTAT In Log ret Double click trend object gt Select Data source settings gt Select on the right side of the connection string Select Connection tab gt 11 3 2 DB2SMS driver IWS application e DB Config DSN Startup value o Please notice that following variables should values be nothing DB Config Username DB Config Password Database Spy n Tag Expressian value Qu
28. databases that uses ODBC interface should work without problems 7 Normally you don t need to give any other parameters to DB2SMS but in the next table includes all the parameters that can be configured Mandatoryn Optonal ConnectionString x Mandatory Database connection definition Modem Port x Mandatory Used serial port for GSM modem Modem Speed Mandatory Serial port speed normally 9600 Modem Handshaking Mandatory Handshaking level 0 No handshaking 1 XOn XOff 2 Request to send 3 Request to send and XOn XOff DIN XXxXx Optional SIM card s PIN code license move Optional Activates licence move state loglevel x Optional default 1 Selects the level for message log 1 Received and send messages are written to log default 2 The serial communication is written to log 3 Both 1 and 2 Config ini Parameter explanations Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 45 CONFIGURATIONS Note If your PIN code request is enabled suggestion PIN code request should be disabled in your SIM card you should not change the PIN code while the program is running DB2SMS tries to initialize SIM card with the defined PIN code and if the code is wrong the SIM card probably gets locked 5 4 2 Starting the DB2SMS program Program can be started by double clicking the DB2SMS exe file If your program is unlicensed the program informs how much evaluation time you have left and when clicki
29. ge TOMATION InduSott Realize Your Potential AK User Manual v 2 04g AutoLog GSM PLC GPRS amp SMS drivers for ndusoft Web Studio Updated 15th April 2015 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual E c i I T Seeeooes Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call 9 tS AS a Communication gt gt Alam sending via SMS gt gt Measurement History data sending via FIP or SMS 22Report sending via SMS SMS3S controls parameters Remotely programmable Free call controllable incoming phone number identification x GPRS l NC 2 GPRS FTP needs oU i static Internet IP address Internet Service to server PC Features Full programmable PLC features I O Modbus M S programmable time controls Ask more GSM SMS5 CallControl SMS5 Interface Database GSM Modem Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms 7 acknowledge alarms GSM ISMS a rud cari Call Controls ask reports All Applications can run in the Set p eters same PC Call controls Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 2 1 Drivers description 1 1 DB2SMS driver DB2SMS is the name of the Web Studio SCADA s GSM SMS driver DB2SMS driver can rec
30. its flag to zero Then it continues to read next event which flag 21 When all the events are read all the event flags are zero Note that events are not deleted from the interface database after reading Deleting events is a separated process Reading Events reports and history is about similar process 10 3 1 Phases e Beginning x Receiver Begin MrTrig Inthe beginning all the flag 1 arrays are selected from the database Some tags are initialized e 1 phase x Receiver StateO MrTrig The event is read and SendEvent function stores event to the event database Alarm events are sent to GSM phones e 2 phase x Receiver State1 MTrig The events flag is turned to zero e 3 phase x Receiver State2 MTrig The next array is selected from the database and the process goes back top phase 1 e Finish x Receiver Finish MTrig The Finish process just ends the event receiving process Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 94 TESTING FTP DEMO a 1 Send SMS messages to everyone Send Al __ Send SMS messages to everyone 2 Sendsinge SMS Messages Send One Send single SMS Messages Modifying phonebook group messages 6 Modify the event table Received_Events mindex DB ReceiveEvent Index Modify the event table Modifies the event s flag to zero after reading T Receive a history messages Received History Flag 1 Receive a history messages There are 17 ODBC tasks in the MyTest program Indu
31. message Problem with date and time ID 0 A0 060705150000 Problem Receiving event message Problem without date and time ID 1 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 128 Appendix A1 Problem Received events are stored in Received Events table Look more from database structure chapter 12 1 12 History Received_History History message can be used to send one variables history e g some sensor s measurement value history History message uses Variable Crosslinks table Message consists of Message type identifier H variable number nn as integer DateTime DDMMHHYYMMSS Sample Interval HHMM and actual data D1 D2 The data part starts from the most recent value D1 the oldest value comes last 12 1 12 1 Format Hnn DDMMYYHHMMSS HHMM D1 D2 D3 D4 12 1 12 2 Examples Receiving history message from variable number 1 Sample interval 1 hour with DateTime H1 060705150000 0100 20 19 19 18 18 19 17 15 14 13 12 12 Receiving history message from variable number 2 Sample interval 3 hour 30 min without DateTime H2 0230 20 19 19 18 18 19 17 15 14 13 12 12 Received history messages are stored in Received History table The data is divided in separate rows in the table The variable number is changed to variable name using Variable Crosslinks table Look more from database structure chapter 12 1 13 Report Received Report Report message can be used to send the latest values of many vari
32. or feature Windows Firewall can help prevent hackers or malicious software from gaining access to your computer through Windows Firewall through the Internet or a network Change notification settings How does a firewall help protect my computer igi Turn Windows Firewall on or What are network locations off E i i CAN Restore defaults No Home or work private networks Connected 2 a Adwanced settings Networks at home or work where you know and trust the people and devices on the network Troubleshoot my network Windows Firewall state On Incoming connections Block all connections to programs that are not on the list of allowed programs Active home or work private networks lin Network 2 Notification state Notify me when Windows Firewall blocks a new program 7 Public networks Not Connected v Firewall settings in Windows 7 Profesional Log in to windows with administrator user rights Open control panel gt Firewall Click Allow a program or feature Allow programs to communicate through Windows Firewall To add change or remove allowed programs and ports click Change settings What are the risks of allowing a program to communicate P Change settings Allowed programs and features Name Home Work Private Public Bonjour Service m Bonjour Service O BranchCache Content Retrieval Uses HTTP LJ LJ BranchCache Hosted Cache Client Uses HTTPS LJ LI Cl BranchCache Hosted
33. parses the FTP file to PosGreSQL s ftpdata database e Indusoft Web Studio reads the dat from database using ODBC task and shows the data in variety of interfaces FTP DEMO application files and other related DEMO application files are included to driver package If you don t have these files please contact FF Automation 7 1 Setting up GSM PLC to send FTP files via direct cable connection Look GSM PLC service manual for basic instructions Look also GSM demo application for sending FTP files Open the GsmProgrammer Open the GSM to Indusoft FTP Demo SMS project oet GSM PLC s DIP 4 position ON position and reboot the GSM PLC disables FTP transfer in GSM 4 8 and 16 not in GSM 20 for GSM 20 take the cable of from the GSM modem Check that the FTP Parser program is stopped system tray and stop it If not right click on this icon on the Connect programming cable to GSM PLC s serial port 1 Check the following settings Transfer gt Config set Configuration Com Fort Baud Rate Ico 3600 Lines Numbers IButtans Times 256 n a la Modem Type Direct connection wn Phone Number PLC FIH 12345678 joao OF Cancel Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 57 CONFIGURATIONS F GSM PLC Programm p File View Compile Transfer Options Help eh ae Xm Uwe FLC Type Lun Phone Number PLC FIM Code PLC Password ceu 6 512 12345678 oono Change nnnc nnn
34. to 1 when PRG Counter and Old PRG Counter has different values for too long time 1 proram ok O problem in program message send PRG Counter Integer SCADA should change this using e g increasing counter Old PRG Counter Integer 10 sec intervals the value from PRG Counter is copied to this A2SMS Counter Integer If PRG Counter and Old PRG Counter has same values the value will be increased by one 10 seconds intervals If they differ this value is reset to zero Counter Max Integer Max value for A2S8MS Counter before sending the message and flag reset to zero Phone String Phone number to where the warning message is send Message String oend warning message free format Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 1 35 Appendix 12 2DB2SMS Config ini example THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem settings THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem Port 1 Z Modem PIN 0000 Modem Speed 9600 0 No handshaking 1 XOnXOff 2 RequestToSend 3 Request oSendXOnXOff Modem_Handshaking 2 Modem_Handshaking 1 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Database configuration See http www connectionstring com if you don t want use PostgreSQL or MySQL THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Next line defines connection string for MySQL ConnectionString DRIVER MySQL ODBC 3 51 Driver SERVER localhost DATABASE smsindusoft USER root PASSWOR
35. 2SMS SMS Interface L Alarms Reports GSM Phone s receive SMS alarms acknowledge alarms send controls All Applications can run in the Set parameters m pe Call controls A GSM SMS Call Controls See Appendix for DB2SMS driver interface description 5 4 1 Configuring DB2SMS ini file 1 Open config ini with text editor The file looks like this THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem settings THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem Port 1 Indusott Web Studio GSM SMS and GPRS FTP drivers User Manual A3 CONFIGURATIONS Modem_PIN 0000 Modem_Speed 9600 0 No handshaking 1 XOnXOff 2 Request oSend 3 Request oSendXOnXOff Modem_Handshaking 2 Modem_Handshaking 1 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Database configuration See http www connectionstring com if you don t want use PostgreSQL or MySQL THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHE Next line defines connection string for MySQL ConnectionString DRIVER MySQL ODBC 3 51 Driver SERVER localhost DATABASE smsindusoft USER root PASSWORD securepassword Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL UNICODE SERVER localhost DATABASE smsindusoft Vid iws Pwd ffauto THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Wierd options These may be useful in some cases THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Next line defines h
36. 2SMS to destination PC After that you should add the following line to the original already licensed PC s configuration file Config ini license move Look the previous Config ini parameter explanations table This activates the license transfer state Write the Product key field the destination PC s Product key and click Move Program warns about the license transfer if you answer Yes the original license is removed and you get new Purchase key to be inserted to destination PC s Purchase key field Note Be careful when you insert the product key If the product key is faulty the program doesn t generate right purchase key and you will lose the license If this happens please contact with FF Automation Include the product key and the generated purchase key in your message 12 1 10 Receiving SMS messages Program can receive three types of messages report history data and event messages The program goes through the Phones Receiving table in the database Only the messages which are coming from the active phone numbers enabled lt gt 0 are accepted 12 1 11 Event message Received Events Event message can be used to send e g alarm warning status change or any other freely defined message from the GSM PLC Message consists of Message type identifier A Event type nn as integer DateTime DDMMYYHHMMSS and Actual message 12 1 11 1 Format Ann DDMMYYHHMMSS Message 12 1 11 2 Examples Receiving event
37. 4 58 55 ob T3 ip 14 wl 0 17200 2013 09 19 14 53 55 37 0 35 ip 14 wm 0 17201 2013 09 19 14 58 55 38 35 Ip 14 vwmb53 79 17202 2013 09 19 14 58 55 39 4 35 ip 14 Aml l 0 1 203 201 3409 19 14 53 55 40 D 35 ip 14 wml2 0 17204 2013 09 19 14 58 55 41 0 35 inf 14 wml3 17205 2013 09 19 14 58 55 In this table you can see the data from gsm plcs It is filled automatically when you receive data from GSM PLCs Flag number value 0 indicates that the data is read to the Indusoft Value 1 indicates that it is not yet read to Indusoft Time stamp is read from the SMS message s internal timestamp field When you get data to this table you can move to Indusoft web studio and try to read data from this table to the Indusoft variables See the IWS demo template application for more info Open the IWS s ODBC task which is used to read data from this table See also the Math tasks Report Receiver codes and scheduler codes After the variables are read to Indusoft tags then it can be stored to PostGreSQL s smshistory database so that all the GSM RTUS have own table for storing history Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 56 CONFIGURATIONS 7 Testing the GSM to Indusoft FTP DEMO This chapter descripes step by step how you can set up test system for the FTP DEMO application which has the following fuctionality e GSM PLC sends FTP files over GPRS connection to your PC s FTP Server e FTP Parser driver
38. 5 piia wand 17171 2013 09 19 14 00 26 8 35 Ip 13 wml T 17172 2013 09 19 14 00 26 u 355 ig 13 uml 17173 2013 09 13 14 00 26 10 0 35 Ip 13 wmz4 17174 2013 09 19 14 00 26 11 35 Ip 13 ami i7175 2013 09 19 14 00 26 iz 55 Iip 13 anil 0 17170 2013 09 19 4 00 26 13 Q0 35 13 VSZ D 17177 2013 09 19 14 00 26 14 0 35 Ip 13 vwm33 17178 2013 09 19 14 00 26 15 0 4358 ip 13 verd 17173 2013 09 19 14 00 26 16 0 35 p13 werd n 17180 2013 09 19 14 00 26 17 o 55 pf 15 isalarm l 17181 2013 09 19 14 50 35 18 35 Ip 15 vena 258 17182 2013 09 19 14 50 35 13 59 ip 15 wert 0 17183 2013 09 19 14 50 35 20 0 5 pis vami T 17184 2013 09 19 14 50 35 21 0 35 Ip 15 wei 17185 2013 09 19 14 50 35 22 4 35 ip 15 wb 412 1 1865 2013 09 19 14 50 35 23 o 35 Ip 15 well 0 17187 2013 09 19 14 50 35 24 0 35 pf 15 wmlz 17188 2013 09 19 14 50 35 25 35 Ip 15 wml3 T 17185 2013 09 19 14 50 35 2b 355 lef 15 wnmz4 0 17190 2013 09 19 14 50 55 27 lo 35 pf 15 wm22 T 17191 2013 09 19 14 50 35 28 35 Ip 15 wmi 17192 2013 09 19 14 50 35 2 39 Io 15 aT 0 17193 2013 09 19 14 50 55 30 0 55 piis wei SS D 17194 2013 09 19 14 50 35 34 0 35 piis werd 0 17195 2013 09 19 14 50 35 32 39 inf 15 wm z 17196 2013 09 19 14 50 35 33 55 lpg 14 izalar l 17197 2013 09 19 14 53 55 94 D 35 ip 14 vemos 259 17198 2013 09 19 14 58 55 35 35 Ip 14 veme 17199 2013 09 19 1
39. 503111346 bin 11 3 2015 13 49 BIM File 1 KB _ FFA0000101503111347 bin 11 3 2015 13 50 BIN File 1 KB jE Computer FFA0000101503111348 bin 11 3 2015 13 51 BIM File 1 KB i Windows C _ FFAQ000101503111349 bin 11 3 2015 13 52 BIM File 1 KB cx HP RECOVERY D FFAQ000101503111350 bin 12 3 2015 8 50 BIM File 18 KB Ga HP TOOLS E _ FFADOQ00101503120848 bin 2 3 2015 8 51 BIM File 1 KB DVD RW Drive F IWS71 2 FFAQ000101503120849 bin 12 3 2015 8 52 BIM File 1 KB G2 guest 192 168 1 10 G _ FFAQ000101503120850 bin 12 3 2015 8 53 BIM File 1 KB G talous 3192 168 1 10 K FFAQ000101503120851 bin 12 3 2015 8 54 BIM File 1 KB Cz programs 192 168 1 10 P _ FFAQ000101503120852 bin 12 3 2015 8 55 BIM File 1 KB G eudora 192 168 1 10 Rz _ FFADOO0101503120853 bin 12 3 2015 8 56 BIM File 1 KB G9 home 192 168 110 5 _ FFADOQ0101503120854 bin 12 3 2015 8 57 BIM File 1 KB Ke SHARE 192 168 1 150 T FFA0000101503120856 bin 12 3 2015 8 58 BIM File 1 KB G2 dat part 192 168 1 10 U FFA0000101503120857 bin 12 3 2015 8 59 BIM File 1 KB tg no backup 192 168 1 10 V FFAQ000101503120858 bin 12 3 2015 9 00 BIM File 1 KB S wp 4192 166 1 10 W _ FFA0000101503120859 bin 12 3 2015 9 01 BIN File 1 KB FFA0000101503120900 bin 12 3 2015 9 02 BIM File 1 KB ty Network __ FFA0000101503120901 bin 12 3 2015 9 03 BIM File 1 KB FFA0000101503120902 bin 12 3 2015 9 04 BIM File 1 KB GSM to Indu
40. 6 bin bytes 12 03 2015 Received file FFA0000101503120857 bin bytes 12 03 2015 Received file FFA0000101503120858 bin bytes 12 03 2015 Received file FFA0000101503120853 bin 4 bytes 12 03 2015 Received file FFA00001015031205300 bin bytes 12 03 2015 Received file FFA0000101503120301 bin bytes 12 03 2015 Received file FFA0000101503120302 bin bytes i G SM TO INDUSOFT FTP DEMO LOG Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 59 CONFIGURATIONS Check that you will receive incoming files in the GsmProgrammer project s directory O E Gh 99 QU A k Computer Windows C amp GSMProgrammer Projects GSM to Indusoft FTP DEMO Organize Include in library Share with Burn New folder Sr Favorites Name j Date modified Type Size EE Desktop FFA0000101503111332 bin 11 3 2015 13 40 BIM File 1 KB d Downloads __ FFAQ000101503111338 bin 11 3 2015 13 40 BIM File 1 KB E Recent Places __ FFAQ000101503111339 bin 11 3 2015 13 42 BIM File 1 KB Ai SkyDrive FFAQ000101503111340 bin 11 3 2015 13 43 BIM File 1 KB __ FFAQ000101503111341 bin 11 3 2015 13 44 BIN File 1 KB ig Libraries FFA0000101503111342 bin 11 32015 13 45 BIM File 1 KB E Documents __ FFAQ000101503111343 bin 11 3 2015 13 46 BIM File 1 KB al Music FFAQ000101503111344 bin 11 3 2015 13 47 BIM File 1 KB E Pictures _ FFA0000101503111345 bin 11 3 2015 13 48 BIN File 1 KB i Videos FFAQ000101
41. 7 INSTALLATIONS m FileZilla Server beta 0 9 49 Setup e s Ax Startup settings Select startup behaviour for FileZilla Server Please choose how Filezilla Server should be started Install as service started with Windows default Please choose the port the admin interface of FileZilla Server should listen on 1 565535 14147 Start Server after setup completes Nullsoft Install System v2 46 Unicode H FileZilla Server beta 0 9 49 Setup Laie 3j Startup settings Select startup behaviour for FileZilla Server Please choose how the server interface should be started Start if user logs on apply to all users default Start Interface after setup completes Nullsoft Install System v2 46 Unicode Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 18 INSTALLATIONS Installation is ready Connect to Server Server Address Administration password Always connect to this server After that the FTP server starts automatically Click OK File Server Edit 5 m 5 48 ele 3 FileZilla Server version 0 9 49 beta Copyright 2001 2015 by Tim Kosse tim kosset filezilla project org https filezilla praject ong Connecting to server 1 14 147 Connected waiting for authentication Logged on The configuration of the FTP server is continued later Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual INSTALL
42. ATIONS 4 6 Installing GSM Programmer This is needed for both GPRS FTP communication and GSM SMS communication Overview of using WebStudio GSM GPRS Driver Autem GSM RTU s GSM SMS GPRS FTP Call Controls Communication Alarm sending via SMS Measurement History data GPRS sending via FTP or SMS N GPRS FTP needs I n Q Report sending via SMS static Internet IP address 1 Lu SMS controls parameters l p Internet Service to server PC Remotely programmable Free call controllable incoming phone number identification Indusoft Web Studio FTP Interface SCADA software Database History data Features Full programmable PLC Alarm handling Saving history data Creating alarms User Interface Trends Graphics features I O Modbus M S programmable time controls Ask more over 200 drivers Web support Etc SMS Interface Database Alarms Reports History Group messages etc All Applications can run in the same PC umm 4 6 1 Download latest version of GsmProgrammer a DES GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls Latest version can be downloaded from the FF Automation Web page s Distributor Area http www ff automation com download Distributor signin sht
43. ATIONS Now you can create the table The structure of the table depends on your PLC variable configuration Replace wm20 integer wm21 integer by your variable configuration and trend pl c D by your PLC ID For testing the FTP DEMO application you should not change the default values o0 for example CREATE TABLE trend ffa00001 SS Table name should be time_stamp timestamp without time zone NOT NULL time_stamp_ms integer trend PLC ID wm20 integer wm21 integer Look bellow wm 22 integer wm23 integer wm99 integer wm100 integer ro98 integer CONSTRAINT trend ffa00001 pkey PRIMARY KEY time stamp WITH OIDS FALSE ALTER TABLE trend ffa00001 OWNER TO iws Note In FTP Parser interface table you cannot use row names like WM21 name you can use only standard names like WM21 Look FileParser description appendix for more information Note2 The above table is used in GSM PLC Demo project PLC ID can be set using GSMProgrammer View FTP info id Ftp Info Editor EE g ge Number OF Files Ftp Server 123 123 123 123 FFAO00001 Ftp Path PLC ID should have 8 HEX characters met HEX characters are 0123456789ABCDEF Ftp Password securetest DEPIOLIMIT FTP After changing the PLC ID you need to compile the project and transfer it to GSM PLC and start the PLC Look GSM PLC User Manual how to do that Every GSM PLC you have should have unique PLC ID you can u
44. Check that you have installed MS Net Framework 2 0 This can be checked form control panel Add remove programs list http www microsoft com downloads details aspx familyid20856eacb 4362 4b0d 8edd aab15c5e04f5 amp displaylang en Windows 7 doesn t need this ask measurement reports Set parameters Call controls Mame Size Type Date Modified config ini KB Configuration Settings 19 09 2015 12 58 h DB2SMS exe 70KB Application 14 03 2012 10 16 2 Copy DB2SMS program DB2SMS exe and configuration file config ini to your PC e g CADB2SMS directory or as suggested under Indusoft Web Studio Projects directory e g c IWS_Projects IWS_Project_name DB2SMS 3 DB2SMS cannot be used without PosGreSQL database or other components described in this manual Look Installing PostGreSQL database chapter 4 Installation is ready Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 7 INSTALLATIONS 4 2 Installing FTP parser driver If you are using only the GSM SMS communication you don t need to install FTP parser driver Overview of using WebStudio GSM GPRS Driver ue AutoLog GSM RTU s GSM SMS GPRS FTP Call LN Controls Communication gt gt Alarm sending via SMS gt gt Measurement History data GPRS Foes ee ee D CE P N GPRS FTP needs E static Internet IP address Intranet SMS controls parameters i lt lt Remotely programmable Internet
45. ConnectionString should include Server Database User and Password parameters look example file e PostgreSQL PostgreSQL includes needed ODBC connection drivers You don t need to install these separately ConnectionString should include Server Database User and Password parameters look example file e Access Access 2000 database is not supported If you need to use this you should use Access2SMS program not DB2SMS program Note that DB2SMS program has more features than Access2SMS e Other databases Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 124 Appendix Other databases are not tested with DB2SMS In principle all the databases that uses ODBC interface should work without problems 14 Normally you don t need to give any other parameters to DB2SMS but in the next table includes all the parameters that can be configured Mandatoryn Optonal ConnectionString x Mandatory Database connection definition Modem Port x Mandatory Used serial port for GSM modem Modem Speed Mandatory Serial port speed normally 9600 Modem Handshaking Mandatory Handshaking level 0 No handshaking 1 XOn XOff 2 Request to send 3 Request to send and XOn XOff pin xxxx Optional SIM card s PIN code license move Optional Activates licence move state loglevel x Optional default 1 Selects the level for message log 1 Received and send messages are written to log default 2 The serial commu
46. D securepassword Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL UNICODE SERVER localhost DATABASE smsindusoft Vid iws Pwd ffauto FEE Wierd options Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 136 Appendix These may be useful in some cases THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Next line defines how many times modem initialization may fail before error message is given We ve noticed that a modem gives modem link is too weak alarm without any reason in some cases Therefore we recommend not to comment next line WT InitializationErrorMax 2 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 137 Appendix 12 3FTP File Parser Description 12 3 1 FTP History File Parser Version history v 1 0 e 5 1 2007 ArMe e Software copies history data from received FTP files into a database 12 3 2 Installation 12 3 3 Installing program file Installation of FTP History File Parser is quite a simple process 5 Install Microsoft NET Framework 2 0 not needed for Windows 7 6 Install PostgreSQL see previous chapter 7 Copy FTPPaerser exe program executable and config ini into local computer 8 Do necessary modifications to config ini file 9 Installation is ready Marne Size Type Date Modified config ini 1 KE Configuration Settings 23 01 2006 18 18 FTPParser exe 40 KB Application 2401 2006 16 26 The application can be started simply by
47. ER localhost DATABASE smsindusoft Vid iws Pwd ffauto FETE Wierd options Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 12 3 Appendix These may be useful in some cases THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Next line defines how many times modem initialization may fail before error message is given We ve noticed that a modem gives modem link is too weak alarm without any reason in some cases Therefore we recommend not to comment next line WT InitializationErrorMax 2 Same config ini is also in the appendix 9 Used serial port for modem is defined in the first line 10 SIM card s PIN number is defined in the second line You can leave this undefined if the P N code request is configured as off in your SIM card 11 Modem speed is defined in the third line Normally this is 9600 so normally you do not need to change it 12 Modem Handshaking parameter is important and it should be defined correctly If you are unsure which value to use you can try one by one which work correctly Look the table next table for more information 13 The connection string defines the database connection MySQL connection string is commented Change the user name and password to correct ones e DB2SMS uses ODBC driver to create connection with database e MySQL Uses MyODBC database connection driver This can be downloaded for example http dev mysql com downloads connector odbc 3 51 html
48. HHHHHHHHHHHHHHHHHI Database connection THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI You can use MySQL or PostgreSQL with FTP parser comment the line you don t need Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL ANSI SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto 2 The database name username and password was created earlier Check that these are correct Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 49 CONFIGURATIONS 5 5 1 Starting the FTP Parser driver program Do not start the FTP Parser driver yet Or if you start it remember to stop it before going to next step Program can be started by double clicking the FTPParser exe file If your program is unlicensed the program informs how much evaluation time you have left and when clicking the Continue Evaluate software button the application is started If the configuration of the program is correct you should see small mobile phone picture in the right down corner system tray 5 5 2 Closing the FTP parser program Program can be closed by double clicking the mouse s right button on the mobile phone picture in the right down corner system tray After that you will get confirmation message and answering Yes closes the program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 50 TESTING FTP DEMO 6 Configuring PostgreSQL smsindusoft database s tables for DB2SMS and IWS application
49. If you experience problems with FTP file receiving try the following Disable firewall temporarily and test if it works After you got it working turn on the firewall again and make some firewall exception rules and configure Filezille settings according to the following instruction https wiki filezilla project org Network Configuration Firewalls e g this helped when the NAT port forwarding is used Open also ports e g 27500 27510 or define the range freely 22000 Open the Filezilla gt Edit gt Settings gt Passive mode settings El General settings Welcome message P bindings IP Filter Passive mode settings Security settings Miscellaneous Admin Interface setting Logging Speed Limits Filetranster compressior SSL TLS settings Passive mode settings Use custom port range 2700 IPv4 specific External Server IP Address for passive mode transfers Default 5 Use the following IP 80 223 211 78 You can also enter hostnames C Retrieve external IP address from http ip filezilla project org ip phr 27505 1 865535 Use custom PASV settings if you are operating the server from behind a MAT router or a firewall In that case the IP address of the server is not accessible from outside of the router so you should fill in the correct address here Use the port range to limit the number of ports that will need to be forwarded through the router Informat
50. Intranet gt gt Report sending via SMS aca dien gt Rep g gt static Internet IP address Piiri lt lt SMS controls parameters lt lt Remotely programmable lt lt Free call controllable incoming phone number I Provider ats oar a identification Indusoft Web Studio Features its disc LA FTP Interface lt em gt SCADA software Full programmable PLC e Database Ethrenet History data Alarm handling Internet Service features I O Modbus M S WLAN E E programmable time controls FTP server a sad data Ask more pt Creating alarms User Interface Trends Graphics over 200 drivers DB2SMS SMS Interface Alarms Reports N S fial History Group 9 port messages etc ii GSM Phone s tC receive SMS alarms GSM SMS All Applications can run in the same PC acknowledge alarms Call Controls send controls ask measurement reports Set parameters Call controls FASTRACK SUPREME GA Connect the GSM modem cable to PC s serial port check that the serial port is free so that any other program is not using it Suggestion connect GSM modem to PC s serial port 1 serial port 2 can be used for programming GSM PLOs Connect other end to GSM modems serial port Check that the SIM card s PIN code request is turned OFF Move the SIM card to your mobile phone and set the PIN code request to OFF Look for something like Setting gt Security gt PIN
51. Ip 1 wm99 gets the value from the id 9 and plc phone number from phonebook receiving If you are configuring many GSM PLC s you can use PostGreSQL s command prompt to insert values to these tables Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 54 CONFIGURATIONS Testing the configurations 2 4 smsindusaft j Domains 0 i FTS Configurations 0 Ul FTS Dictionaries 0 s FTS Parsers 0 FTS Templates 0 e Functions 0 E ap Sequences 5 S A Tables 12 EJ calls in I calls aut EJ errormessage FJ phonebook receiving EJ phonebook sending FJ received events FJ received history J received report EA send all E H E E E E The data from GSM RTU will be parsed automatically to received report table Open the table by right clicking and selecting view data view all rows Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual CONFIGURATIONS E Edit Data FosteresOL H4 localhost 3437 smsindusoft received repart Fie Edt View Tools Help 22 8G 8 T v 3v Flag phone name variable value mindex Lime stamp nurnveric tent tent text text PK integer timestamp without time zone 1 fb ha p 13 isalarm 0 17165 2013 09 19 14 00 26 T3 ip 13 HIE oad 17166 2013 09 19 14 00 26 3 0 38 Ipg 13 vrbi 17167 2013 09 19 14 00 26 4 0 35 Ip 13 wei 17168 2013 09 19 14 00 26 5 9 Iip 13 AD T 1 169 201 09 19 4 00 26 6 0 35 pf 13 wari 58 17170 2013 09 19 14 00 26 T oO 3
52. P PastgreS HL Unicode MySGL_ODBC_SA MewSGL ODBC 3 51 Driver MySQL_ODBC_S4_old MySQL ODBC 3 51 Driver MySQL ODBC saudi MySQL ODBC 5 1 Driver smszhistary PastgreS HL Unicode smsindusaft PostgreSQL Unicode trend MuSBL ODBC 3 51 Driver a Pasteres0l Unicode ODBC Driver ipsglODBC Setup x Data Source e Description Database ftpdata SSL Mode disable SBrver localhost Fort 5432 User Mame ives Password 7 Options ae ez Datasource Global Manage DSN uen ted rer ce 11 3 1 Configuring IWS FTP_parser_DEMO application You have just created DSN name IWS FTP which is used as a link between Indusoft web studio and the ftpdata database Configuring IWS project is done simple by changing every database references in the project to use just created DSN name These places are 11 3 1 1 IWS FTPParser Demo application Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 110 Appendix FTP Data Reading Sample DRE time stamp Introduction 22 Bii Database Configuration This application demonstrates showing received FTP measurement data in Webstudio from MySQL or PostgreSQL database Settings m L Use project default This application by default uses DSN name WS FTP and m database trend ffaaffaa The trend and the table show only Connection string Provider MSDASQL 1 Data Source l azul Object Properties Username Hit S XE Data source Retry Interval Secs
53. PRS FTP drivers User Manual 46 CONFIGURATIONS DB2SMS program can be used 50 hours evaluation time without licensing Program informs how much time is left when it is started BIST DB25 15 Evaluation version Evaluate software 50 00 left Purchase now E 5 4 5 2 Purchase and registration Program can be licensed by selecting the Purchase now checkbox and clicking Continue Program generates product key which is unique key for PC This key should then be send to FF Automation e g by e mail and FF Automation then sends back the right Purchase key to activate the license Program informs if the activation were successful FF Automation DB25MS ioj xj DB2SMS Evaluation version Product key 247 87 85 244 238 242 Puchasekey S ce Purchase 0 4 5 3 Moving the license The license can be moved to other PC The original license is removed You should first install DB2SMS to destination PC After that you should add the following line to the original already licensed PC s configuration file Config ini license move Look the previous Config ini parameter explanations table This activates the license transfer state Write the Product key field the destination PC s Product key and click Move Program warns about the license transfer if you answer Yes the original license is removed and you get new Purchase key to be inserted to destination PC s Purchase key field Note Be careful when you i
54. Pro Now you have installed GsmProgrammer Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 2 INSTALLATIONS 4 7 Installing Indusoft Web Studio SCADA software This is needed for both GPRS FTP communication and GSM SMS communication Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication gt gt Alarm sending via SMS gt gt Measurement History data EE AMEN eee sending via FTP or SMS GPRS FTP needs m l I Report sending via SMS static Internet IP address SMS controls parameters I Internet Service l to server PC l Provider Intranet lt lt Remotely programmable lt lt Free call controllable incoming phone number identification FTP Parser FTP Interface Features Full programmable PLC Database Ethrenet History data features I O Modbus M S WLAN programmable time controls FTP server Ask more Indusoft Web Studio SCADA software Alarm handling Saving history data Creating alarms User Interface Trends Graphics over 200 drivers Web support Etc GSM SMS CallControl DELE GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls SMS Interface Database Alarms Reports History Group messages etc CH All Applications can run in the same PC evum Download latest version
55. RS 254 M70 1 amp WM0 9999 SET FAILED P1 START COUNT MAXIMUM is 9999 254 empty 7 0 REPORT SMS QUERY SREPORT M72 M72 21 StartCount 24h 2WM11 Tot WM22h Level AIOm HLimAlarm MO HeatRelay M1 Man Aut M2 GsmSign 0 30 RO98 254 empty 8 0 CONTROLLING OUTPUT WITH SMS message CONTROL M69 M69 1 DO1S5 Digital Output 1 is controlled on for 5 seconds 254 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 108 Appendix 11 2 Other needed configurations E Phone Book Editor Transfer lel g ge 435812345678 SCADA system s GSM number You should define the SCADA systems GSM phone number Check that DIP switches and Jumpers are in correct position When you test the system with GSM modem disable SIM card s PIN code query otherwise it will get automatically jammed and asks for PUK code PIN code query can be disabled by moving the SIM card to normal GSM phone and then go to Settings gt Security etc to disable the PIN code request Check other Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 109 Appendix 11 3Adding ODBC DSN ODBC Data Source Administrator User DSN system DSN File DSN Drivers Tracing Connection Pooling About System Data Sources Add ball MySQL ODBC 3 51 Driver L5 Micrasaft Access Driver mdb Remove FFA MySQL ODBC 3 51 Driver 35 MIndusofit Micrasaft Access Driver mdb z Configure IwS5 FT
56. S message 3 Trigger the interface database ODBC write procedure Changing the value of DBC SendAll Insert does this DBC SendAll Insert NOT DBC SendAll Insert Group SMS is sent to all active GSM numbers in the Phonebook Sending table 9 2 2 Sending message to defined number 1 Write DB SendsSingle Flag 1 2 Write to tag DB SendSingle Phone the wanted phone number 3 Write to tag DB SendSingle Message the wanted message 4 Trigger the interface database ODBC write procedure This is done by changing the value of DBC SendSingle Insert DBC SendSingle Insert NOT DBC SendSingle Insert 9 3 Reading the error status DB2SMS program You must trigger the DBC ErrorMessage Select tag to read the status of the DB2SMS program The Error status message can be read from the DB ErrorMessage tag This is done automatically in every Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 89 TESTING FTP DEMO 9 4 Receiving SMS messages 9 4 1 Event messages When IWS detects that new Event messages have arrived to the interface database Received Events Flag 1 it just generates IWS s SendEvent function SendEvent function stores the event to the event database and it can be seen using the Event object If the event message starts with word ALARM it will be send using group SMS sending to all phone numbers that are configured in Phonebook sending table 9 4 2 History messages When IWS detects that new H
57. Service T to server PC NUT Free call controllable Provider incoming phone number identification A i rv Indusoft Web Studio Features 1 FTP Interface SCADA software Full programmable PLC Ed d Database features I O Modbus M S pe History data Alarm handling programmable time controls Saving history data Ask more Creating alarms User Interface Trends GSM SMS CaliControl nsu over 200 drivers Web support DB2SMS SMS Interface Ee SMS parsing Database Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls CUN ask measurement reports Set parameters Call controls All Applications can run in the Installation of FTP History File Parser is quite a simple process 1 Install Microsoft NET Framework 2 0 not needed for Windows 7 2 Copy FTP parser program FTPParser exe and configuration file config ini to your PC e g CAFTP parsen directory or as suggested under Indusoft Web Studio Projects directory e g cAWS ProjectsVWS Project nameV TP Parsen 3 FTP Parser cannot be used without PosGreSQL database or FTP server or other components described in this manual Look Installing PostGreSQL database chapter 4 Installation is ready Marne Size Type Date Modified config ini 1 KE Configuration Settings 23 01 2006 18 18 FTPParser exe 40 KB Applicatio
58. ables Report message consists of Message type identified D first variable number nn as integer DateTime DDMMHHYYMMSS and actual data Variable values Program uses Variable Crosslink table to change the variable number to variable name Every variable in the messages data part increases variable s number by one so that first variable s V1 number is nn V2 is nn 1 12 1 13 1 Format Dnn DDMMYYHHMMSS V1 V2 V3 V3 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 129 Appendix 12 1 13 2 Examples Receiving Report message from variable values numbers 0 1 and 2 with DateTime D0 060705150000 20 19 21 Receiving Report message from variable values numbers 1 2 and 3 without DateTime D1 20 19 21 12 1 14 Sending message s Message sending can be done in two ways To one phone number Send to one or to Group of phone numbers Send to group 12 1 15 Send to Group messages Program sends all messages in the SendAll table which has flag 1 value to phone numbers defined in Phones Sending table which are active enabled 71 12 1 16 Send to One messages Program sends all messages in the Send One table which has flag 1 Before sending the message user should write value to Phone field and after that change the flag to 1 which sends the message 12 1 17 Error messages Server program needs to send e g increasing counter value to PRG Counter field If the program detects that this value has not changed and the t
59. ality Continuous SMSIndusoft GOOD DB Config Password BOD DB Contig Password GOOD DB Config Username WE GOOD DB Config Username ws Goon HisPool_CrSt SM SHistory GOOD HisPool Password GOOD HisPool_Username IE Goon d e Lists of Crosslinktable page Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 112 Appendix Lists of Phonebook page Lists and graphs of Receiving History page Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 113 Appendix 11 4Testing the FTP File Parser driver ftpdata database and IWS FTP Parser Demo Load IWS GSM demo application to GSM PLC This application collects FTP file and sends it to FTP server or GSMProgrammer s project directory For 1 step testing you don t need to have FTP server in your PC and you don t need to have SIM card in your GSM PLC You can use direct cable connection Serial COM port on personal computer gt RS232 connector os if the GSM PLC cable is connected between PC and GSM PLC and DIP switch 4 is set to ON position and you have open connection between GSM Programmer and GSM PLC ld GSM PLC oi a leg egge PLC Type gt Own Phone Number rele FIN Code PLC Password esm1e 512 345843740030032 pee Change jonon mm Change DEMOUNIT SI 5M5 COM 9600 Direct connection Activated PLC Running It can take about 1 minute for GsmProgrammer to connect with GSM PLC Whe its con
60. are using FTP data you should next read FileParser GPRS FTP driver for Indusoft UM v11 pdf After that you can learn more about AutoLog GSM PLC application programming with GSMProgrammer AutoLog GSM PLC Service Manual pdf Then you could learn more about Indusoft Web Studio SCADA by reading Getting Started Guide v70 pdf Technical Reference pdf AND the most important Try creating your own application using DEMO applications as template or from the scratch FF Automation can help you to get started by arranging technical training and project consultancy Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 145
61. ase History Receiver StateO MTrig DB HistoryPool Variable DB ReceiveHistory Name This sets the correct table name in the DB ReceiveHistory Time DBC ReceiveHistory Mselect NOT DBC ReceiveHistory Mselect The history array is selected for modification Flag will be set to zero History Receiver State Next phase History Receiver StateO MTrig O This math will not be executed again 10 3 5 2 Report receiving 1 Phase Report Receiver StateO MTrig Report Pointer DB ReceiveReport Name Pointer gets correct class variable s DB ReceiveReport Variable name Sender s Name Variable Report_Pointer DB ReceiveReport Value Value is set to pointed variable modification Flag will be set to zero Report ReceiverStateO MTrig O This math will not be executed again 10 4 Removing old flag 0 messages IWS scheduler task Remove old messages from the interface database is configured to remove automatically all the old messages flag 70 in 23 59 59 1 day intervals Note that new messages not read messages has flag 71 so these won t be removed Calendar 23 59 59 DBC ReceiveEvent Delete NOT DBC ReceiveEvent Delete NOT Calendar 23 59 59 DBC ReceiveReport Delete DBC ReceiveReport Delete NOT Calendar 23 59 59 DBC ReceiveHistory Delete DBC ReceiveHistory Delete Calendar 23 59 59 DBC SendAll Delete NOT DBC SendAll Delete Calendar 23 59 59 DBC SendSingle Delete NOT DBC SendSingl
62. at incorrect Message format incorrect Error in saving message 12 1 20 Database stucture Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 12 Appendix ErrorMessage Programs writes Errorcode String e Look Error codes chapter Phonebook Sending User defines m Name String e Program doesn t use this field It can be used in SCADA program Phone String Phone number m Enabled Integer e 0 Phone number not in use e 1 Phone number in use Phonebook Receiving User defines n Name String e Program reads the field to Received tables Field can be used also in SCADA program 7 Phone String Phone number Needs land code e g 358401234 a Enabled e 0 Phone number not in use 1 Phone number in use Received_Events Program writes m Mindex Integer increasing e Unique identifier for every received message z Flag Integer e Value 1 indicates that the message is new The user program e g SCADA can reset this value to zero to indicate that it has read the message Old messages can be deleted e g after reading once per day or week to protect that the table size doesn t increase too much Date String e Message receiving date yyyy mm dd Time String e Message receiving time hh mm ss n Phone String e Phone number from where the message was received Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 132 Appendix Name String Sender s name copied from P
63. be the same for every alarm so after the boot up maximum 1 alarm sms is send DB2SMS format Dn Var n Var n 1 Var n 2 Var n 3 DB2SMS is driver between SCADA and GSM PLCs Look more from DB2SMS documentation ALARM is send when any of the alarm bit changes its value to alarm state or to normal state DB2SMS format Dn opt timestamp DDMMYYHHMMSS Var n Var nt 1 Var nt 2 Var nt 3 Var nt 4 Var nt 5 MO 0 M0 1 M1 0 M1 1 M10 0 M10 1 amp WM60 lt 10 WM60 1 M110 M110 1 amp WM60 10 D9 1 WM99 WM50 WM51 WM52 WM53 SWM11 SWM12 SWM13 5WM24 SWM22 0 D9 1 one in here informs for SCADA system that this is alarm message so it is not shown in daily report view empty 9 2 Pl REPORT MESSAGE Send once every day at 07 00 Same information is send as in Alarm message DB2SMS format Dn opt timestamp DDMMYYHHMMSS Var n Var nt 1 Var nt 2 Var nt 3 Var nt 4 Var nt 5 M80 1 amp WM60 lt 10 WM60 1 D9 0 WM99 WM50 3WM51 WM52 WM53 SWM11 WM12 3WM13 WM24 3WM22 0 P1 tiedot empty P D9 0 zero in here means that this is report message and it is shown in SCADA in report view 6 0 SET PUMP 1 TOTAL START COUNT amp TOTAL OPERATING TIME WITH SMS WM12 P1 TOTAL START COUNTER low byte 0 9999 WM13 P1 TOTAL START COUNTER high byte 10000x SP1 M70 M7021 amp WMO 10000 WM12 WMO WM13 0 WM22 WM1 SET P1 TOTAL START COUNT WM12 Pl TOTAL OPERATING TIME WM22 HOU
64. c Change GS5M TO INDUSOFT FTP DEMO SMS COMI 9600 Direct connection Activated Check that the connection status is Activated It may take max about 1 minute to connect File Transfer Compile euo rre Number OF Files Ftp Server FPLC ID j ja f faze fies fies fies monaci FFAocoo1 Ftp Path P Password dT securetest View gt FTP Compile gt Compile Transfer project to GSM PLC E GSM PLC Programr 1 F ile View Compile Transfer Options y a RE SG mw FLL a Own Phone Number femnes s C5Hl6 51z dfe 0 T12345678 l PLC PIM Code ooo0 noo0gd Change PLE Password nouo joooo Change GSM_TO_INDUSOFT_FTP_DEMO SMS BREEBE COMI 9600 Direct connection Activated IPLC Stopped When you transfer the project the PLC status becomes PLC Stopped After transfer you need to click green RUN button Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 58 CONFIGURATIONS Fr 6SM PLC Programe AM File View Compile Transfer Options Help lal e E ww d PLE Type Own Phone Number PLC PIN Code PLC Password 12345678 EE Change nano nno Change GSM TO IMDUSOFT FTP DEMO SMS COMI 9600 Direct connection Activated IPLC Running Now the status is PLC Running gt ee a Check that you will receive incoming files 1 new file 60 second in alarm log view Alarm HS eas 12 03 2015 Received file FFA000010150312085
65. code You can test that it is off by opening your mobile phone It should not ask PIN code when it starts Check than antenna is tightened Power the modem using suitable 12VDC or 24 VDC power Look at the modem s red indication LED which should start blinking after initialization steadily about 2 sec intervals If the RED led is not blinking after about 30 seconds then try to reboot or check the manuals for possible cause Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 42 CONFIGURATIONS 5 4 Configuring the DB2SMS driver and GSM modem initialization test This is needed for GSM SMS only For FTP you don t need GPRS modem it is using Internet connection Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Communication gt gt Alam sending via SMS Measurement History data aet sending via FTP or SMS ON GPRS FTP needs I s z i l static Internet IP address Lu History Group messages etc SMS controls parameters Remotely programmable Internet Service Aem a _____ lt lt Free call controllable Provider incoming phone number identification 7 a Indusoft Web Studio Pais FTP Parser FTP Interface SCADA software Full programmable PLC FTP le parsing Pennie features I O Modbus M S AN SUy OR programmable time controls FTP server Ask more aa B o GSM SMS CallControl 7 N DB
66. demo application is used to demonstrating how the DB2SMS driver and Indusoft Web Studio is used and configured to monitor incoming SMS measurement data alarms etc Look GSM PLC service manual for basic instructions Transfer the Pump Demo application to the GSM PLC See the source code in Appendix Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 85 TESTING FTP DEMO 8 PART 3 Using DB2SMS with Indusoft Web Studio This part of the manual describes how to use DB2SMS with Indusoft Web Studio IWS SCADA DB2SMS program is GSM SMS driver which allows Web Studio to communicate with AutoLog GSM RTUS bi directionally This manual should be used with IWS Demo project which is made with IWS v 6 1 The purpose of this document with DEMO project is to show all essential features of using AutoLog GSM RTUs with Web Studio so system designers can get as fast getting started process as possible PostgreSQL s smsindusoft database is used just as an interface and not for permanent storing of measurement data Measurement data is read to Indusoft Web Studio and stored to another database e g PostGreSQL s smshistory database using IWS s ODBC task Also other database types can be used but it needs some modifications in ODBC task sheets FF Automation would appreciate to get any feedback of this manual and DEMO project Any questions and feedback can be sent to antti moijanen ff automation com or info ff automation com 8 1 Re
67. doesn t increase too much m Date String e Message receiving date yyyy mm dd z Time String e Message receiving time hh mm ss n Phone String e Phone number from where the message was received n Name String e Senders name copied from Phonebook Receiving table Variable String e Variables name Read from the message m Value String e Variable s value Send AII User defines program changes Mindex Integer increasing e Unique identifier for every send message z Flag Integer e Send message flag This is reset to zero after sending the message Message String E Send message 160 characters Send One User defines program changes Mindex Integer increasing e Unique identifier for every send message Flag Integer e Send message flag This is reset to zero after sending the message n Phone String e Phone number Message String Send message Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 134 Appendix 160 characters Variable Crosslinks User defines Index Integer Variables index number Name String Variable s name Note that e g Web Studio SCADA doesn support special characters or spaces in this field Send Watchdog User defines partly program changes Name String Identifier name field for e g SCADA application use Not used by DB2SMS Enabled Integer Watchdog enabled when 1 user defines Flag Integer Changes
68. double clicking program icon It ll run background until you close it by double clicking the program icon with the right button of your mouse in System tray Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 138 Appendix THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBHI FTP parser configuration file Updated 23 1 2008 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI General configuration THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI DataDir defines the directory that holds received files DataDir C FTP FEAR Database connection FEE You can use MySQL or PostgreSQL with FTP parser comment the line you don t need Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL ANSI SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto ConnectionString DRIVER PostgreSQL UNICODE SERVER localhost DATABASE ftpdata Vid iws Pwd ffauto for 64 bit windows 7 ConnectionString DRIVER PostgreSQL Unicode x64 SERVER localhost DATABASE ftpdata Uid iws Pwd ffauto Next line defines connection string for MySQL ConnectionString DRIVER MySQL ODBC 3 51 Driver SERVER localhost DATABASE ftp_ data JSER iws PASSWORD secure_password Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 139 APPENDIX 12 3 4 File format A PLC sends a binary file which always has two sections PLC description section and data section 12 3 5 PLC description block PLC descrip
69. e 64 bit Windows 7 you need to use the following program to configure 32 bit ODBC c windows syswow64 odbcad32 exe ODBC Data Source Administrator User DSN system DSN File DSH Drivers Tracing Connection Pooling About System Data Sources Add ball MySQL ODBC 3 51 Driver L5 Micrasaft Access Driver mdb Remove FFA MySQL ODBC 3 51 Driver GSM ndusot Microsott Access Driver mdb Configure MySQL ODBC 54 MySQL ODBC 3 51 Driver MySQL_ODBC_S4_old MySQL ODBC 3 51 Driver MySQL_ODBC_saudd MySQL ODBC 5 1 Driver stishistory PastgreS UL Unicode smsindusatt PostgreSQL Unicode trend MySQL ODBC 3 51 Driver TV 5H MySQL ODBC 5 1 Driver An ODBC System data source stores information about how to connect ta the indicated data provider A System data source Is visible to all users on this machine including MT services UF Cancel Apply Help Open System DNS tab click Add Create Hew Data Source Select a driver for which pou want to set up a data source gt Microsoft Paradas Treiber db Micragaft Text Driver tst csv Microsoft Text Treiber txt csv Microsoft Visual FoxPro Driver Microsoft Visual FoxPro Treiber MySQL ODBC 5 1 Driver PastgreS UL ANSI PostgreSQL Unicode SOL Server ull Te aW 487033 6 l l e e l cence Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 38 CONFIGURATIONS Select PostgreSQL Unicode driver click Finish 5 2
70. e Delete Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 99 100 10 5Watchdog timer DB2SMS sends SMS message to the defined phone number if it is doesn t get heartbeat signal from IWS This can happen if IWS program is jammed IWS updates the interface database s watchdog using Reset watchdog Counter scheduler task 00 00 08 DB Watchdog Flag DB Watchdog Enabled 00 00 08 DB Watchdog PRG Counter Second 00 00 08 DB Watchdog Old PRG Counter DB Watchdog PRG Counter 1 00 00 08 DB Watchdog A2SMS Counter 0 00 00 08 DBC_Watchdog Update NOT DBC_Watchdog Update Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 100 101 11 Tags and class tags Tag DB SendAIl DB SendSingle DB ReceiveEvent DB ReceiveHistory DB ReceiveReport DB HistoryPool DB ErrorMessage DBC SendAll DBC SendSingle DBC ReceiveEvent DBC ReceiveHistory DBC HistoryPool DBC ReceiveReport DBC ErrorMessage DBC Send Phones DB Send Phones DBC Receive Phones DB Receive Phones Event Receiver History Receiver Report Receiver DBC Crosslink DB Crosslink Iface StringO Iface String1 Iface String2 Iface String3 Iface String4 Iface String5 Iface String6 Iface String8 Iface String7 Iface History DataGrid Update Iface History Grid Update Iface PB Sending Grid Update Iface Phonebook receiving Update send Phones Name Al1Alarm Report_Pointer PLC 10 DBC_Watchdog DB Watchdog WD_ResetTrig DB Config DSN DB Co
71. e appendix for little bit more advanced version of this program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 62 TESTING FTP DEMO 7 2 Testing the FTP file transfer over GPRS to FTP server 7 2 1 Setting up FileZilla FTP Server Static public IP and Firewall This is needed for GPRS FTP only Overview of using WebStudio GSM GPRS Driver v 690099 AutoLog GSM RTU s GSM SMS GPRS FTP Call c n ontrols Communication Alarm sending via SMS gt gt Measurement History data BGM Intranet sending via FTP or SMS GPRS f GPRS FTP needs Report sending via SMS SMS controls desierit N Static Intemet IP address lt lt Remotely programmable Internet Service to server PC ee lt lt Free call controllable Provider incoming phone number m p d identification s Indusoft Web Studio CUNTUR h FTP Parser FTP Interface SCADA software Full programmable PLC Eth FTP le parsing Database features I O Modbus M S oi History data Alarm handling ln WLAN FTP sengr Saving history data programmable time controls gt Ask more S Creating alarms User Interface Trends GSM SMS CallControl Graphics over 200 drivers Web support DB2SMS SMS Interface LE SMS parsing Database Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Contro
72. eb Studio Storing history data Report message values to class type tags History message values to class type tags Storing event messages User Interface New incoming report history and event messages Status of the DB2SMS outgoing SMS phone number configurations resetting watchdog timer variable crosslink configurations PostgreSQL interface database DB2SMS Low level communication with GSM modem Incoming Message filtering Message parsing Report history and event messages Look DB2SMS Manual for more info GSM Modem Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 88 TESTING FTP DEMO 9 Using MyTest User Interface 9 1 Phone numbers The interface database has two phone number lists Phonebook Sending table includes numbers where the Group SMS messages are send Phonebook Receiving table includes numbers which are allowed to send incoming messages DB2SMS copies the value from Phonebook Receiving Name field to Received Name field Report History or Events Only those phone numbers are active in phonebook tables which Enabled field is lt gt 0 9 2 Sending SMS messages from IWS sending SMS message from the user interface is quite simple User just writes the values to flag and message tags and triggers the saving tag 9 2 1 Sending group message 1 Write DB SendAll Flag 1 2 Write to tag DB SendAll Message the wanted SM
73. eceived Received Received Received Received Received Received Received Received Received file file file file file file file file file file FFAAFFAA01201301337 BIN FFAA FFAA01201301342 BIN FFAAFFAA01201301347 BIN FFAAFFAAO01201301352 BIN FFAA FFAA01201301357 BIN FFAAFFAAO01201301402 BIN FFAAFFAA01201301407 BIN FFAA FFAAO01201301412 BIN FFAAFFAAO01201301417 BIN FFAAFFAAO01201301422 BIN TIME 30 01 12 1 13 34 TIME 30 01 12 1 13 36 Size 1 KB 1 KB OKB 43 KB 1 KB 14 KB 12 KB 0 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB 1 KB Tvpe File Folder File Folder File Folder File Folder File Folder FTP File GPR File IBN File Text Document PHF File PRG File SMS File TTB File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File BIN File Date Modified 1 27 2012 2 48 PM 1 27 2012 2 48 PM 1 27 2012 2 48 PM 1 27 2012 2 48 PM 1 27 2012 2 48 PM 1 4 2012 2 37 PM 1 4 2012 2 32 PM 1 4 2012 2 32 PM 1 4 2012 2 32 PM 1 4 2012 2 32 PM 1 4 2012 2 32 PM 1 30 2012 10 19 AM 1 4 2012 2 32 PM 1 30 2012 11 41 AM 1 30 2012 11 46 AM 1 30 2012 11 51 AM 1 30 2012 11 56 AM 1 30 2012 12 01 PM 1 30 2012 12 06 PM 1 30 2012 12 11 PM 1 30 2012 12 16 PM 1 30 2012 12 21 PM 1 30 2012 12 26 PM 1 30 2012 12 31 PM 1 30 2012 12 36 PM
74. ed phone number From user interface you can change the error message and the phone number You may also disable the error message sending Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 93 TESTING FTP DEMO 10 How the IWS links to DB2SMS This chapter describes how the communication interface between IWS and the interface database is created IWS uses ODBC task to communicate with the interface database To make the communication automatic IWS uses scheduler and math tasks Normally scheduler starts the certain communication process using e g time triggering Math tasks are used to make more complicated scripts Be sure that you fully understand the functionality of these scripts before you make any changes 10 1 Sending SMS message This project demonstrates only the simple SMS sending process and it works only manually from the user interface See chapter 5 2 for more information 10 2 Reading ErrorMessage ErrorMessage table is read automatically once per second using Scheduler task 1 Clock 1 00 00 01 DBC ErrorMessage Select NOT DBC ErrorMessage Select This will start the ODBC task called Read DB2SMS s state from database The ErrorMessage is stored to tag DB ErrorMessage 10 3 Reading incoming messages from the interface database Reading incoming SMS messages from the interface database is divided to three phases This process reads all events which flag 71 After first event is read it writes
75. eive and send SMS messages through GSM modem with FF Automation s AutoLog GSM RTU devices It can be used also for SMS alarms forwarding from Indusoft Web Studio Driver uses PostGreSQL database as an interface Driver is made by FF Automation so it is not included in the standard Indusoft software package 1 2 FTP Parser driver FTP Parser is the name of the Web Studio SCADA s GPRS FTP file parser It can be used to parse the incoming FTP files send by AutoLog GSM RTU using GPRS communication Driver uses PostGreSQL database as an interface Driver is made by FF Automation so it is not included in the standard Indusoft software package 1 3 Tested versions DB2SMS v 1 3 4456 18311 Tested with Windows XP Tested with Windows 7 32 bit Tested with Windows 7 64 bit postgresql 8 4 16 1 windows exe FTP Parser v 1 0 0 0 Tested with Windows XP Tested with Windows 7 32 bit postgresql 8 4 16 1 windows exe Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual e PREPARATIONS 2 Contents 3 Preparations 3 1 Manual Description This manual serves as installation and configuration manual for setting up the interface between AutoLog GSM RTUs and Indusoft Web Studio SCADA software 1 2 3 4 5 6 Needed components Step by step installation manual for installing all the needed software components Configuring the software and hardware components Part of this manual shows how to use and test
76. elect Next MSelect MUpdate Status1 Delete Phone Enabled Name AIO Al Al2 Al3 WMO WM1 WM2 WM3 Temperature Flag Date Time Phone Message Name Index Flag Date Time Phone Variable Value Type Integer otring otring otring Integer otring Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Integer Boolean Boolean Boolean Boolean Integer Boolean otring Boolean otring Integer Integer Integer Integer Integer Integer Integer Integer Real Integer otring otring otring otring otring Integer Integer otring otring otring otring otring 102 Description Crosslink class variable Index Name History data class variable history data saving milliseconds Error message class variable Select trigger History data ODBC control class variable Select trigger Insert trigger Next trigger Message sender class variable both Group and single Insert trigger Select trigger Delete trigger Phonebook data ODBC control class variable Delete trigger Insert trigger Select trigger Transaction Complete Reveiving message ODBC control class variable otatus Select trigger Next trigger Select trigger DB modification Update trigger DB modification Status DB modification Delete trigger Phonebook class variable Phone number Active flag Name PLC class variable example Analog input O Analog input 1 Analog input 2 A
77. em with FF Automation s AutoLog GSM RTU devices DB2SMS supports three kinds of incoming GSM RTU gt IWS SMS message types 1 Report message can be used to send the latest values of GSM RTU s variables Inputs One message can have many variables One value variable 2 History message can be used to send many time stamped values of one variable 3 Event messages can be used to send other kinds of text messages e g alarms or events DB2SMS supports three kinds of outgoing IWS gt GSM RTU SMS message types 1 Send Group SMS message Same message is send to all defined GSM numbers 2 Send one SMS message Message is send to one defined GSM number 3 send System Error SMS message If the DB2SMS detects that IWS application is not running watchdog pulse from IWS is not changing it can send System Error SMS message DB2SMS is supplied with DEMO projects DB2SMS sub folder 12 1 1 DB2SMS version history v 1 0 e 5 1 2007 ArMe e Initialization of GSM modem e Sending SMS messages to one to group fault events messages e Receiving SMS messages report history and event message types e Program status in database e Compatible with different databases 12 1 2 Needed components etc Indusoft Web Studio SCADA Or some other SCADA with ODBC support DB2SMS program Win2000 XP OS Microsoft Net Framework 2 0 can be downloaded from Microsoft homepage GSM modem Database which support ODBC interface MySQL Postg
78. er Order from FF Automation FTP parser driver Order from FF Automation Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual PREPARATIONS e PostGreSQL database Download from Internet or ask FF Automation http www posigresgl org This manual is written using PostgreSQL version postgresql 8 4 16 1 windows exe For Window 7 x64 you should use postgresql 9 3 6 1 windows x64 especially if you are using ftp parser e ODBC connectors You can download ODBC connector for PostgreSQL from this site http www postgresql org ftp odbc versions msi Tested version psqlodbc 08 04 0200 zip For Window 7 x64 you should use psqlodbc_ 09 03 0300 x64 1 especially if you are using ftp parser e Filezilla FTP server FileZilla Server 0 9 49 exe used in this manual Download free Filezilla FTP server from https filezilla project org e Indusoft Web Studio SCADA software Download latest version of Indusoft Web Studio from Indusoft s web page www indusoft com You need to register to the page or ask FF Automation Licenses can be ordered from FF Automation FF Automation can also give training e GsmProgrammer software for programming AutoLog GSM PLOs The latest version while writing this manual is v 1 6 512 2 Order from FF Automation Contact FF Automation and order GSM PLC Driver for Indusoft Web Studio and you will get DVDs which contain all the needed software components and manuals 3 2 4 Needed Manuals This manua
79. events DB ReceiveEvent Timez Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 97 TESTING FTP DEMO 10 3 4 Math tasks There are five Math tasks per message type This represents the Events Math tasks but Report and history maths are quite similar and only phase 1 differs 10 3 4 1 Initialization Event Receiver Begin MTrig Event_Receiver Active Event receiving flag is turned active DB ReceiveEvent Phone HERR Clearing phone number DBC ReceiveEventStatus 0 Clearing ODBC error status DBC ReceiveEventStatus 0 Clearing ODBC error status Event ReceiverState MTrig 0 n jDeactiveatesphase 1 o o Event ReceiverStatel MIrig O 1 jDeactivatesphase2 Event ReceiverState MTrig O n jDeactivatesphase3 o o Event_ReceiverState 0 Activates the first state DBC ReceiveEvent Select NOT DBC ReceiveEvent Select Stars ODBC task Selects all events which flag 1 Event Receiver Bedin MTria 0 This math will not be executed adain 10 3 4 2 Phase 1 Event Receiver StateO MrTrig oendEvent DB ReceiveEvent Mes Stores the event to the history database sage DB ReceiveEvent Date DB ReceiveEvent Time DB ReceiveEvent Phone DB ReceiveEvent Name DB SendAll Message DB ReceiveEvent Phone Copies the event message for group SMS DB ReceiveEvent Name
80. formation and latest versions of PostgreSQL can be found and downloaded free from the Internet http www postgresql org This manual is written using PostgreSQL version postgresql 8 4 16 1 windows exe Some of the pictures are taken from the older version 8 4 10 1 but the procedures are the same For Window 7 x64 you should use postgresqgl 9 3 6 1 windows x64 especially if you are using ftp parser PostgreSQL database is needed both for DB2SMS driver and FTP file parser driver 4 3 1 Starting installation Copy the file to your PC s local hard disk e g c temp BF postgresql 8 4 10 1 windows exe 47 079 KB Application Double click the file Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 9 INSTALLATIONS Open File Security Warning Do you want to run this file zn Name poshgresgl 6 4 10 1 windows exe Publisher EnterpriseDB Corporation Type Application From Cs 4ntki2012 FTPParser Cancel Always ask before opening this file While files from the Internet can be useful this File type can potentially harm your computer Orly run software from publishers wou trust What s the risk 1 Click Run Setup PostgreSQL Welcome to the PostgreS L Setup Wizard PostgreSQL Packaged by Enterprise The Enterprise Postaresu L Company lt Back 2 Click Next gt Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual INSTALLATIONS Installation Director
81. g Mame Expression d Scheduler 1 WinExec C Program FilesiFtpParsenFtpparser exe D Hl Database ERP 2 init 1 FTP parser can be started automatically from Indusoft using the following math task WinExec C Program Files FtpParser Ftpparser exe O Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 118 Appendix Edit Data Easterentt 8 4 localhost 5432 ftpdata trend_ffaaffaa rrr eer T No limit v time stamp time stamp wm21 ail cn cn2 dio di2 ao90 do0 dol do2 do3 ro98 PK timestamp with integer integer integer integer integer integer integer integer integer integer integer integer integer IZS ZUIZ UI 3U I 34 0U U 3997 ZU 5046 7459 1 U U 3U 126 2012 01 30 14 35 00 0 4001 19 5046 7469 1 0 0 0 0 0 0 30 127 2012 01 30 14 36 00 0 4000 20 5046 7469 1 0 0 0 0 0 0 30 128 2012 01 30 14 37 00 0 4000 18 5046 7469 1 0 0 0 30 129 2012 01 30 14 38 00 0 4001 20 5046 7469 1 0 0 3 130 2012 01 3014 39 00 0 4000 19 5046 7469 1 0 0 0 0 0 0 30 131 2012 01 30 14 40 00 0 4001 19 5046 7469 1 0 0 3 132 2012 01 30 14 41 00 0 4000 19 5046 7469 1 0 0 0 0 0 30 133 2012 01 30 14 42 00 0 4001 19 5046 7469 1 0 0 0 0 0 0 30 134 2012 01 30 14 43 00 0 4001 21 5046 7469 1 0 0 0 0 0 0 30 135 2012 01 30 14 44 00 0 4001 19 5046 7469 1 0 0 0 0 0 0 30 136 2012 01 30 14 45 00 O 4000 20 5046 7469 1 0 0 0 0 0 0 30 137 2012 01 30 14 46 00 0 4000 19 5046 7469 1
82. honebook Receiving table Event String Actual message free format ID Integer Event ID Received Report Program writes Mindex Integer increasing Unique identifier for every received message Flag Integer Value 1 indicates that the message is new The user program e g SCADA can reset this value to zero to indicate that it has read the message Old messages can be deleted e g after reading once per day or week to protect that the table size doesn t increase too much Date String Message receiving date yyyy mm dd Time String Message receiving time hh mm ss Phone String Phone number from where the message was received Name String sender s name copied from Phonebook Receiving table Variable String Variable s name DB2SMS copies this name from Report Crosslinks able s name field using the variable number Value String Variable s value otring type Supports both text and number formats This allows variable s value to be send also in text format Received History Mindex Integer increasing Unique identifier for every received message Flag Integer Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 133 Appendix e Value 1 indicates that the message is new The user program e g SCADA can reset this value to zero to indicate that it has read the message Old messages can be deleted e g after reading once per day or week to protect that the table size
83. ime in A2SMS_ Counter has increased to Counter Max it sends defined message to phone number and put flag to zero When the value in the PRG Counter field changes it changed flag to 1 12 1 18 Log files There are three log files which can be used to debug the possible fault situations etc The logging level is configured in Config ini file Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 130 Appendix sms traffic txt SMS traffic serial traffic txt Serial traffic state log txt Program states Error codes 12 1 19 Error Codes In addition to state log DB2SMS stores its states also to database Errormessage table Error code Description 0 Noerrors gt O Modem Errors write to log and database MO1x Could not open serial port MO2x Message couldn t be send to serial port MO3x Modem is not answering M04x PIN code error wrong PIN SIM locked MO5x Could not go to Text mode MO6y MO7x GSM modem signal strenght information sending disabling failed MO8x Unknown problem when initialization modem M1x Error in receiving message M2x Error in sending message M3x Error in calculating new messages Critical Errors write to log and database if possible info to screen and stops the program COO Critical program error Unknown error report to FF Automation C02 PIN code insertion error C03 Database not found Errors in message handling write to log only DateTime format incorrect Report message form
84. ing the following command CREATE ROLE iws LOGIN PASSWORD your_own_pw NOINHERIT VALID UNTIL infinity Note the semi colon at the end of the line Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 24 CONFIGURATIONS 5 Creating a database Right click on the Databases text and select New database peAdmin Ill File Edit View Tools Help 2 a 8 WER 2 Object browser X Properties Statistics Dependencies Dependents Servers 1 PostgreSQL Database Server 8 2 loca Database Comment 3 postgres Refresh o ner Database oa Reports d B postgres Retrieving Databases details Done 0 00 secs 5 1 1 Creating database for DB2SMS driver for GSM SMS driver This is needed for GSM SMS communication only if you are using GPRS FTP communication you can skip this step Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication gt gt Alam sending via SMS gt gt Measurement History data s pup GPRS I sending via FTP or SMS GPRS FTP needs ort n i l l Hin Mesa 9 ios static Internet IP address dam to server PC Remotely programmable UP Shoe in en d e Free call controllable incoming phone number identification Features Pane Full programmable PLC Eironat FTP ille parsing features I O Modbus M S WLAN FTP server
85. ion for users with dynamic IPs If your external IP changes it might take up to 5 minutes after the next failed transfer until FileZilla Server recognizes the changed IP In most cases the IP is updated within 30s after a failed transfer Don t use external IP for local connections After you have received files to your FTP directory you can move to next step Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 7 TESTING FTP DEMO 7 3 Testing the FTP_parser with GSM PLC Test table was created earlier in this manual TABLE trend ffa00001 Start gt All Programs PostGreSQL pgAdminlll E pgAdmin im File Edit Plugins View Tools Help AAEE Lim A Object browser X Properties Statistics Dependents Hj Servers 1 El PostgreSQL 8 4 localhost 5432 Property Value Ei Databases 4 EIName trend ffa00001 EO ftpdata lor 15803 j Catalogs 2 F Owner iws E Schemas 2 Tablespace pg default El historyschema HH Fact 2 22 Domains 0 E Primary key time_stamp L4 FTS Configurations 0 ESlRows estimated bd lll FTS Dictionaries 0 OLI Sl F IFill factor pox xu i Lem FTS Parsers 0 Eon M ne N FTS Templates 0 F Rows counted D 2359 zu gt Functions 0 Inherits tables No a Sequences 0 E Inherited tables count EN Has OIDs No EMR Tables 1 i ES trend ffatoo01 System ra s pr S 35 E Comment EE
86. istory messages have arrived to the interface database Received History Flag 1 it writes the value to the history database IWS selects the history table name using values from sender s Name Received History Name and Variable Received History Variable fields Table name is format trend Name variable e g trend PLC AIO ODBC task is not creating tables to the history database so user has to create those manually See 5 4 4 9 4 3 Report messages When IWS detects that new Report messages have arrived to the interface database Received_report Flag 1 it stores the value Received_report Value to class variable named Received report Name Received report Variable E g if sender s name is PLC and variable s name is WMO then value is stored to class variable PLC WMO Note that PLC is defined in IWS to be a class variable that has many members one of which is WMO Report message can have many variables but messages are parsed to the interface database so that one row in the Received report table has only one variable 9 4 4 Creating variables and history tables with Variable Configuration tool Variable cross linking table receivers phonebook and history table may be created by using Variable Configuration tool which is included with the project IWSDemo directory DB2SMS DBConfiguration exe Please note that the changes happen in real time If you do a mistake you cannot cancel 1 Start the program You sho
87. l AutoLog GSM PLC User Manual ask FF Automation Indusoft Web Studio Manuals download from www indusoft com Indusoft Web Studio training videos check from www indusoft com Contact FF Automation to get the permission to the FTP server to download the latest versions of the manuals and Demo applications 3 2 5 Needed demo application and accessory files e Smsindusoft_2013 backup file for DB2SMS driver configuration e GSM to Induosft FTP DEMO zipped project file for Indusoft Web Studio FTP parser demo project 3 3 Application types and driver usage 3 3 1 Indusoft Web Studio IWS SMS Alarms forwarding to GSM phones Requirements e GSM modem and accessories e DB2SMS driver e PostGreSQL database e ODBC e Indusoft Web Studio SCADA software Needed files This is the simplest application type You need to install PostGreSQL but you can skip the History database creation 3 3 2 IWS bi directional SMS communication with AutoLog GSM RTUs Requirements e GSM modem and accessories e DB2SMS driver Indusoftt Web Studio GSM SMS and GPRS FTP drivers User Manual J PREPARATIONS AutoLog GSM RTU s PostGreSQL database ODBC Indusoft Web Studio SCADA software AutoLog GsmProgrammer If you need to read different kinds of data from GSM RTUS and also to send control commands You can read measurements data but if you need to read lots of measurement data it might be more cost effective to use GPRS FTP driver Anyway you ca
88. l 4 20mA I for 0 10bar sensor P All pressure2 4 20mA I for O0 10bar sensor Al2 temperaturel 50 150 Al3 temperature2 50 150 EERE KERES FTP LOG amp SEND PARAMETERS t2 4227 242 message in format SFTP 5 60 where 5 defines log interval in minutes and 60 defiens the tx interval in minutes S SFTP MO WM35 WMO WM36 WM1 MO Log interval WM35 seconds Tx interval WM36 seconds 254 Check for incorrect values M100 M100 WM35 30 seconds WM35 0 WM35 1 WM36 0 WM36 5 M1004 M100 WM22 AI2 WM23 AI3 executed always moves RAW Analog input values to WM20 23 SR ee FTP LOGGING amp Transter KKKKKKKKKKK If output status changes log amp send DOO 1 DO0O 0 DO1 1 DO1 0 DO2 1 DO3 1 D03 0 M62 1 log amp send on event Calculating 10 sek average P1 WM59 WM58 WM58 2WM57 WM57 WM56 WMb56 WM55 WM55 WM54 WM54 WM53 WM53 WM52 WM52 2WM51 WM51 2WM5O0 WM5O0 AIO P1 WM10 WM59 WM10 WM58 WM10 WM57 WM10 WM56 WM10 WM55 WM10 WM54 WM10 WM53 WM10 WM52 WM10 WM51 WM10 WM50 WM10 10 WM20 WM1 0 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 143 Appendix Pl WM69 WM68 WM68 WM67 WM67 WM66 WM66 WM65 WM65 WM64 WM64 WM63 WM63 WM62 WM62 WM61 WM61 WM60 WM60 AII P1 WM11 WM69 WM11 WM68 WM11 WM67 WM11 WM66 WM11 WM65 WM11 WM64 WM11 WM63 WM11 WM62 WM11 WM61 WM11 WM60 WM11 10 WM21 WM11 P1 WM30 1 increment logging timer and transfer timer once second P1 P1 WM1OO 1 increment communication watchd
89. l ITPv6 Address IPu4 Address a Subnet Mask 255 255 255 0 Default Gateway 192 168 1 1 Tunnel adapter isatap iEB5D84B 1729 4H20 B17 7 DGD662BR8F984D e fef 97a ee91 65a52 8 2hz13 ee ee o o eo Bee eee oy Media State i x s GA G Se 34 A Media disconnected Gonnection specific DNS Suffix Tunnel adapter Local Area Connection 12 Media State EMT OT Media disconnected Connection specific DNS Suffix Tunnel adapter Local Area Connection 9 Connection specific DNS Suffix IPvu6i Address n o Link local IPv6 Address Default Gateway ws 206i 2 H29dS6 babdi2c53255d6 af 2 2chi FeGA 22053 35d6 af 2h 2chixie C Users Antti Check your PC s IPv4 address Start gt All Programs gt Accessories gt Cmd Promt Awm O o SY CO e Q 192 168 1 1 Vigor2 130 Serie High Speed Gigabit Router Quick Start Wizard Online Status Edit Port Forwarding Entry Enable Name FTP Protocol TCP UDP v WAN IP WANIPS ME Start Port 21 NAT Open Port gt Bandwidth Management End Port optional 21 Local Host 192 168 1 69 gt Wireless LAN Local Port optional 21 gt USB Application L gt IPv6 gt Applications gt VPN and Remote Access gt User OK Cancel Delete Entry Open router configuration normally using IE http 192 168 1 1 search for NAT setup The above picture is just an example
90. l OPERATING TIME SECONDS today WM15 Pl OPERATING TIME MINUTES today WM16 Pl OPERATING TIME HOURS today WM20 Pl OPERATING TIME SECONDS TOTAL WM23 Pl OPERATING TIME IN SECONDS sssss today DI3 amp P1 WM1441 WM20 1 WM23 1 Seconds today TOTAL and Seconds sssss today WMl14 559 WM15 1 WM14 0 minutes today WM15 gt 59 WM16 1 WM15 0 hours today empty P1 TOTAL OPERATING TIME WM20 P1 OPERATING TIME SECONDS TOTAL WM21 P1 OPERATING TIME MINUTES TOTAL WM22 P1 OPERATING TIME HOURS TOTAL HHHHH 0 65535 hours WM20 gt 59 WM21 1 WM20 0 minutes TOTAL WM21 gt 59 WM22 1 WM21 0 hours TOTAL empty 4 0 P1 RESETTING 24H COUNTERS M80 CLOCK TRIGGERED VARIABLE WM11 Pl START COUNT LAST 24H HISTORY CLOCK 7 00 klo 7 00 WM60 maximum SMS count per day safety limit CLK 0700 M80 this is true when PLC s RTC time is 7 00 for one program cycle only M80 1 WM11 WM10 WM10 0 WM60 0 P1 start count move and reset commands are executed from left to right order empty Pl Operating time 24h reset WM14 Pl OPERATING TIME SECONDS today WM15 Pl OPERATING TIME MINUTES today WM16 Pl OPERATING TIME HOURS today WM17 Pl OPERATING TIME SECONDS last 24h history WM18 Pl OPERATING TIME MINUTES last 24h history WM19 Pl OPERATING TIME HOURS last 24h history WM23 Pl OPERATING TIME IN SECONDS sssss today WM24 Pl OPERATING TIME IN SECONDS sssss las
91. le DEMOUNIT LOG Test E DEMOUNIT PHF GuildFTPd 4 DEMOUNIT PRG amp C3 HHD Software E DEMOUNIT SMS O historyboy f DEMOLINIT TTB amp C HST2EXCEL Hst merge C3 HTML Help Workshop O ICQLite O ICQToolbar 53 IGC C3 Indusoft web Studio v6 0 3 InduSoft Web Studio v6 1 InduSoft web Studio v7 0 Intel O IntellivIEW Designer Internet Explorer IPCheck Server Monitor 5 a E Er H larm Log File Alarm GB Sd f FFAAFFAA01201301229 BIN f FFAAFFAA01201301234 BIN f FFAAFFAA01201301239 BIN Ej FFAAFFAA01201301244 BIN E FFAAFFAA01201301249 BIN E FFAAFFAA01201301254 BIN E FFAAFFAA01201301259 BIN E FFAAFFAA01201301304 BIN f FFAAFFAA01201301309 BIN f FFAAFFAA01201301314 BIN f FFAAFFAA01201301319 BIN f FFAAFFAA01201301324 BIN f FFAAFFAA01201301329 BIN f FFAAFFAA01201301332 BIN f FFAAFFAA01201301334 BIN es FFAAFFAA01201301337 BIN f FFAAFFAA01201301339 BIN es FFAAFFAA01201301342 BIN 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 30 01 2012 0000 TIME T35845740030032 TIME 30 01 12 1 13 31 0000 TIME 30 01 12 1 13 34 35845740030032 Received file 0000 TIME FFAA FFAA01201301332 BIN 35845740030032 0000 TIME 0000 TIME t35845740030032 R
92. llow connections Yes Reports b FI Connected Yes Maintenance E System database No Backup E Comment Properties Property Value smsindusoft 32910 iws lt SQL pane Database smsindusoft DROP DATABASE smsindusoft CREATE DATABASE smsindusoft WITH OWNER iws ENCODING SQL ASCII lt Retrieving Database details Done 0 03 secs is Restore Database smsindusoft Filename Cr anttiz012 FTPParser post Only data _ nle schema Single object F Mo owner Disable Trigger Clean before restore Verbose messages Options Messages 5 From the opening window browse and select smsindusoft 2013 backup file This file includes all the tables and default values needed for DB2SMS so you don t need to re write those smsindusoft 2013 backup file is sent with the DB2SMS driver package When you are ready click OK Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 28 CONFIGURATIONS 6 Database restore window after successful restore Restore Database smsindusoft E mfx pg restore setting owner and privileges Far SEQUENCE send_all pg restore setting owner and privileges Far SEQUENCE OWNED pg restore setting owner and privileges Far TABLE send one pg restore setting owner and privileges Far SEQUENCE send or pg restore setting owner and privileges Far SEQUENCE OWNED pg restore setting owner and privileges Far TABLE send watchc pg
93. ls All Applications can run in the Set parameters same PC Call controls i erem CUN If you are having problems with setting up FileZilla Server to run behind Windows Firewall specifically it fails on List and the client receives a Failed to receive directory listing error you must add the FileZilla Server application to Windows Firewall s Exceptions list To do this follow these steps 1 Open Windows or other active Firewall under Control Panel 2 f using Windows Vista click Change Settings 3 Select the Exceptions tab 4 Click Add program 5 Do NOT select FileZilla Server Interface from the list instead click on Browse 6 Locate the directory you installed FileZilla Server to normally C Program Files FileZilla Server 7 Double click or select FileZilla server exe and press open Once again NOT FileZilla Server Interface exe 8 Select FileZilla server exe from the list and click Ok 9 Verify that FileZilla server exe is added to the exceptions list and that it has a check mark in the box next to it 10 Press Ok to close the window 11 see more https wiki filezilla project org Network Configuration Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 63 CONFIGURATIONS gg r k Control Panel All Control Panel Items Windows Firewall ipee Control Panel Home Help protect your computer with Windows Firewall Allow a program
94. m5z Ip 1 i 0 4096 D 13 35 wm53 Ip 1 1 D 4096 D 14 37 wmil Ip 1 i 0 4096 0 15 38 0 wml Ip 1 1 D 4096 D 16 39 wml3 Ip 1 i 0 4096 D 17 40 wm Ip 1 1 D 4096 D 18 41 wm Ip 1 i 0 4096 0 ig 42 wrm31 Ip 1 1 T 4096 0 20 43 wm3z Ip 1 i D 4096 D 21 44 WITS Ip 1 1 0 4096 D ec 45 wmd4 Ip 1 i 0 4096 0 23 46 wm Ip 1 l 0 4096 E ed 47 wmi IpL10 i D 4096 D 7 48 wins Ip 10 l 0 4096 D o 49 isalarm Ip 10 1 0 4096 0 J 50 wing Ip 10 1 0 4096 D 10 51 m5 IpL10 i 0 4096 D 11 52 wm5l Ip i0 i 0 4096 0 12 53 Wm52 Ip 10 l D 4096 D 13 S4 wm IpL10 i D 4096 D 14 55 wmll Ip 10 l D 4096 D 15 5b wmlz pf 10 i 0 4096 0 16 57 wmi3 Ip 10 l 0 4096 D 17 58 wmz4 IpL10 i 0 4096 D 18 59 wmzz Ip 10 l D 4096 D 19 60 wml Ip 10 i 0 4096 0 20 bl wm32 Ip 10 l 0 4096 D 21 B2 wm33 IpL10 i D 4096 D 22 63 wm4d Ip 10 l D 4096 D 23 Bd mdz Ip 10 i 0 4096 D 24 Here s two example GSM RT Us Ip 1 and Ip 10 Id the incoming SMS messages variable number DY 0 AlI0 7 WM91 this is part of the programming line in GSMProgrammer The first parameter D9 indicates the first ID number so that the O parameter is id 9 and Al0O id10 etc Id 9 parameter can be used freely e g to identify the message source e g if it was generated by digital input or analog input or clock etc It is just an example so it is not mandatory The name is the variable name in the Indusoft web studio which will be combined with plc so that e g
95. mable PLC Ethrenet FTP le p g features I O Modbus M S FTP Interface Database l History data programmable time controls WLAN FTP server Ask more GSM SMS CallControl DB2SMS SMS Interf GSM Modem k nterface Alarms Reports P Serial History Group port messages etc GSM Phone s receive SMS alarms CUN acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls All Applications can run in the same PC PostgreSOL Unicode ODBC Driver psqlODBC Setup Data Source I SESS Description Database ftpdata SSL Mode disable SEVE localhost Fort 5432 User Name iws P me Options a BS atasource Global Manage OSH uen ner Meer Make the following configuration for ftpdata database if you are using FTP parser driver Use the same password for iws user as was configured when installing postgreSQL database Connection Jest Eg N Connection successful OK Test connection Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 4 CONFIGURATIONS 5 3 Connecting the GSM modem to the PC s serial port This is needed for GSM SMS only For FTP you don t need GPRS modem it is using Internet connection Overview of using WebStudio GSM GPRS Driver 2333331 AutoLog GSM RTU s GSM SMS GPRS FTP Call c ontrols Communication gt gt Alarm sending via SMS Measurement data GPRS IEEE
96. ml Please ask password from FF Automation Oy E g to antti moijanen ff automation com cc info ff automation com Latest version of GsmProgrammer while writing this manual is v 1 6 512 2 About GSM PLC Programmers 2 35M PLC Pregrammerhb1 2 FF 4AUTOMATION Oy Version 1 5 512 2 Copyright 2002 FF Automation Oy All Rights Reserved 4 6 2 Installing the software Ld Search Key Folders EK GsmProgrammer v Go X Name Size Type Date Modified ff GsmPlcProgrammer exe 1 154 KB Application 1 19 2010 8 51 PM Projects File Folder 3 28 2011 3 07 PM Create directory for GsmProgrammer E g C GsmProgrammer Copy GsmProgrammer exe into this directory Create new Projects folder under this directory Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 20 INSTALLATIONS 4 6 3 Creating shortcut in Windows Start menu Right click on Programmer exe and select copy In Windows XP Go to the folder C Documents and Settings All Users Start Menu Programs and right click and select paste shortcut Programs Qe eJ 2 P Search 7 Folders EHK Address C Documents and Settings All Users Start MenulPrograms x Mame Size Type d GsmPlcProgrammer 1KB Shortcut My Documents m Arar wv lt ll 4 6 4 Creating shortcut in Windows desktop Right click on Programmer exe and select copy Go to desktop and right click and select paste shortcut Shortcut Ea GsmPlc
97. mp 1 heat relay alarm bit value 1 alarm DI1 0 0 normal state DI1 1 DI1S3 M1 1 ALARM state 1 second delay just in case note NC tulo DIISI120 MI 0 NORMALIZATION delay 120 seconds for hysteresis empty 2 0 ANALOG ALARMS AIL water pressure 4 20mA gt 0 10 bar WM51 AI1 M10 high pressure alarm bit M47 condition variable WM51 lt 800 M47 if under 2 bars over 30 minutes scaling for analog inputs 0 10 bar raw value is 0 4000 so 2 bar 800 MA7M30 M10 1 if Memort47 is TRUE over 30 minutes then M10 1 MA7M30 M10 0 if Memort47 is NOT TRUE over 30 minutes then M10 0 empty empty empty 3 0 PUMP 1 P1 START COUNT AND OPERATING TIME 3 1 Pl 24H START COUNTER during 24 hour time and P1 TOTAL START COUNTER DI3 Pump 1 Operating state 1 Running 0 Stopped M3 Pump 1 Operating state 1 Running 0 Stopped WM10 Pl START COUNTER today Pl TOTAL START COUNTER WM12 Pl TOTAL START COUNTER low byte 0 9999 WM13 Pl TOTAL START COUNTER high byte 10000x Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 106 Appendix Pl TOTAL START COUNTER 10000 x WM13 WM12 Counted in SCADA Note WM Word Memories has 16 bits so the maximum is 65535 DI3S1 M3 M3 1 WM10 1 WM12 1 WM12 gt 9999 WM13 1 WM12 0 empty 3 2 P1 24H OPERATING TIME and P1 TOTAL OPERATING TIME DI3 Pump 1 Operating state 1 Running 0 Stopped WM14 P
98. n Done 0 22 secs Note If you want to change the language of pgAdmin s to English you can select File gt Options gt General gt User Language gt English 2 Double click the serveron the left side After this logon window opens Write the superuser password to logon Psql guide This is just an optional alternative guide if you don t like pgAdmin Ill PgAdmin Ill is suggested for doing configurations Psql password is asked when you start the program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 23 CONFIGURATIONS Create new role for databases Select Login Roles gt New login role 1t peAdmin Ill File Edit View Tools Help FO 2 Object browser Properties Statistics Dependencies Dependents Servers 1 3 f PostgreSQL Database Server 8 2 loca es B Databases 1 A postgres H 5 Tablespaces 2 Group Roles 0 ERAS Login Role H postari Login Role Comment Refresh New Login Role Object list report SQL pane lt Retrieving Login Roles details Done 0 00 secs Write to the New Login role window Role Name iws Password your_own_password Remember the password and click OK amp New Login Role Properties Role privileges Role membership Variables SQL Role name OID Can login Account expires Ba ESSEN Connection Limit Comment Use replication Psql guide With psql you can create new user us
99. n 24 01 2008 16 26 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 8 INSTALLATIONS 4 3 Installing PostGreSQL database This is needed for both GPRS FTP communication and GSM SMS communication Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication Alarm sending via SMS Measurement History data wr UNUS a Od Ss a sending via FTP or SMS eases GPRS FTP needs Report sending via SMS static Internet IP address lt lt SMS controls parameters i Internet Service to server PC i Provider lt lt Remotely programmable lt lt Free call controllable incoming phone number identification Indusoft Web Studio FTP Parser FTP Interface SCADA software FTP file parsing Database Full programmable PLC z Ethrenet History data Alarm handling features I O Modbus M S WLAN z programmable time controls FTP server Saving history data Ask more Creating alarms User Interface Trends GSM SMS CallControl Graphics over 200 drivers Web support DB2SMS SMS Interface m SMS parsing Database Alarms Reports Serial History Group port messages etc I GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls ask measurement reports Set parameters Call controls All Applications can run in the same Additional in
100. n psal tool Start gt All Programs gt Postgre SQL gt SQL shell psal Server Clocalhost Database Lpostgres ftpdata Port 5432 Username postgres Password for user postgres Click Enter to select Server localhost Change database to ftpdata Click Enter to select Port 5432 Click enter to select Username postgres Write the password for user postgres it was defined during the installation process BE Server localhost l Database postgres ftpdata Port 5432 Username postgres Password for user postgres peql 8 4 18 MARHING Console code page 85 differs from Windows code page 1252 gt 8 hit characters might not work correctly See psgql reference page Notes For Windows users for details Type help for help fFtepdata H CREATE SCHEMA historyschema AUTHORIZATION iws Write the following line to psa CREATE SCHEMA historyschema AUTHORIZATION iws BEE Server localhost Database postgres ftpdata Port 5432 Username postgres Password for user postgres peql 8 4 18 WARNING Console code page 850 differs from Windows code page 12525 8 hit characters might not work correctly See psql reference page Notes for Windows users for details Type help for help ftpdata H CREATE SCHEMA historyschema AUTHORIZATION iwz CREATE SCHEMA ft pdata Click Enter C4 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 35 CONFIGUR
101. n use both DB2SMS driver and FTP file parser driver at the same time 3 3 3 IWS GPRS FTP data reading from AutoLog GSM RTUs Requirements e AutoLog GSM RTU s e FTP parser driver e Static Internet IP address If dynamic IP address changes the GSM PLC tries to send to FTP files to wrong IP address e Public IP address or defined FTP port normally port 21 forward for router NAT setup PostGreSQL database ODBC Indusoft Web Studio SCADA software AutoLog GsmProgrammer If you need only to read measurement data from GSM RTUS you can use FTP parser and you don t need GSM modem because FTP files are send from GSM PLC s to your PC using GPRS Internet oee also FTP Demo Indusoft Web Studio Demo application and FTP Demo GsmProgrammer application 3 3 4 IWS GPRS FTP data reading and SMS communication with AutoLog GSM RTUs GSM modem and accessories AutoLog GSM RTU s DB2SMS driver FTP parser driver Static Internet IP address If dynamic IP address changes the GSM PLC tries to send to FTP files to wrong IP address Public IP address or defined FTP port normally port 21 forward for router NAT setup PostGreSQL database ODBC Indusoft Web Studio SCADA software AutoLog GsmProgrammer FTP parser allows only one directional communication between SCADA PC GSM RTUS so you cannot for example send control commands from SCADA PC to GSM RTUs Common usage is to use both DB2SMS driver with GSM modem for sending controls a
102. nalog input 3 Word Memory 0 Word Memory 1 Word Memory 2 Word Memory 3 Scaled temperature Receiving event messages class variable New message flag date time Phone number message sender s name read from phonebook by DB2SMS Database index of the received message Receiving history messages class variable New message flag date time Phone number Variable name value Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 102 Rec_Report Receiver send All oend Single ODBC_Watchdog Watchdog Name Index Flag Date Time Phone Variable Value Name Index Active Begin_MTrig StateO MTrig otate1 MrTrig otate2 MrTrig Finish MTrig otate Flag Message Flag Phone Message Select Update Name Enabled Flag PRG Counter Old PRG Counter A2SMS Counter Counter Max Phone Message 103 otring Integer Integer otring otring otring otring otring otring otring Integer Boolean Boolean Boolean Boolean Boolean Boolean Integer Integer otring Integer otring otring Boolean Boolean otring Integer Integer Integer Integer Integer Integer otring otring sender s name read from phonebook by DB2SMS Database index of the received message Receiving report messages class variable New message flag date time Phone number Variable name value sender s name read from phonebook by DB2SMS Database index of the received message Message receiver math control clas
103. nd receiving alarms and FTP parser for collecting measurements data Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 6 INSTALLATIONS 4 Installing the software components 4 1 Installing DB2SMS driver If you are using only the GSRS FTP communication you don t need to install DB2SMS driver Overview of using WebStudio GSM GPRS Driver 06090090 A AutoLog GSM RTU s GSM SMS GPRS FTP Call Uu Controls Communication Alarm sending via SMS Measurement History data sanding via FTP or SMS GPRS GPRS FTPneeds Report sending via SMS GR needs static Internet IP address I SMS controls parameters E l u cutus Remotely programmable Internet Service i lt lt Free call controllable Provider S incoming phone number identification 2 Indusoft Web Studio Features FTP Parser FTP Interface SCADA software Full programmable PLC TEST FTP file parsing Database l features I O Modbus M S History data Alarm handling ER Intranet WLAN FTP server Saving history data Creating alarms programmable time controls Ask more User Interface Trends GSM SMS CallControl 7 N Graphics over 200 drivers Web support DB2SMS SMS Interface Ne SMS parsing Database Alarms Reports History Group messages etc p d GSM Phone s receive SMS alarms i 7 acknowledge alarms GSM SMS All Applications can run in the s same PC e 1
104. nected you can see that the communication LEDs are blinking fast and the Status line text halted changes to Activated Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 114 Appendix E Ftp Info Editor Transfer REG Pet d Humber OF Files Ftp Server PLE ID n EE 195 13 115 FFAAFFAA Ftp Path met Ftp Password securetest DEPMOLIMIT FTP Open Ftp Info Editor View Ftp info Change PLC ID to FFAAFFAA or the same as your trend table name suffix earlier when you created the table for ftpdata database trend ffaffaa If you can check the PLC ID also with Alarm Log view View gt Alarm Log FTP Returns FTP configurations UU00 FIP 7 35812345678 FTP 1 222 118 20 68 FFAAFFAA securetest Alarm log also informs when it has received the FTP file from the GSM PLC These files are stored to the project directory e g C Program Files GsmProgrammer Projects GSM_Demo Kit Logic Program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 115 Appendix GSM Demo Kit Logic Program File Edit view Favorites Tools Help o Back 7 Q 2 Search lig Folders tial Address C Program Files GsmProgrammer Projects G5M_Demo_Kit_Logic_Program Folders x Name E 3 GsmProgrammer alarm C3 Projects Display C3 Fortum eka 3 GsM Demo Kit Logc p FTP D alarm Timetable 3 Display DEMOUNIT FTP eka E DEMOUNIT GPR 3 FTP E DEMOUNIT IBN 23 Timetab
105. nfig Password DB Config Status DB Config Username HisPool DSN HisPool Password HisPool Username Type send All oend Single Rec Event Rec History Rec Report HisPool otring ODBC MsgSender ODBC MsgSender ODBC Receivers ODBC Receivers ODBC_HisPool ODBC_Receivers ODBC ErrorMessage ODBC Phonebook Phonebook ODBC Phonebook Phonebook Receiver Receiver Receiver ODBC Phonebook Crosslink otring otring otring otring otring otring otring otring otring Boolean Boolean Boolean Boolean otring Boolean otring PLC ODBC Watchdog Watchdog Boolean otring otring otring otring otring otring otring Description oend All tables active arrays values oend One tables active arrays values Received Events table s active arrays values Received History table s active arrays values Received Report table s active arrays values History database s active arrays values ErrorMessage table s active arrays values Send All able control ODBC task Send One table control ODBC task Received Events table control ODBC task Received History table control ODBC task History database control ODBC task Received Report table control ODBC task ErrorMessage table control ODBC task Phonebook_Sending table control ODBC task Phonebook Sending table s active arrays values Phonebook Receiving table control ODBC task Phonebook Receiving table s active ar
106. ng the Continue Evaluate software button the application is started If the configuration of the program is correct you should see small mobile phone picture in the right down corner system tray 5 4 3 Troubleshooting Modem initialization problems If you have problems with initializing modem you will get some error message with some error code You can check that these are ok You have inserted SIM card PIN code request is disabled you have right PIN code in config ini You have right type of cable and it is in right COM port Baud rate is set correctly 9600 Try different options 1 3 for Modem Handshaking 1 parameter Check the DB2SMS Log files and error code description look appendix for full description of DB2SMS driver If the above were ok you can test that the modem is in TEXT mode and the ECHO is OFF Open HyperTerminal and start session with parameters COM 9600 8 1 N OFF Command Modem should Reply AT OK AT CPIN OK or CPIN SIM PIN or CPIN READY If you get ERROR or CPIN SIM PUK there s a Problem with the SIM AT CMGF 1 text mode ATEO OK sets echo off 5 4 4 Closing the program Program can be closed by double clicking the mouse s right button on the mobile phone picture in the right down corner system tray After that you will get confirmation message and answering Yes closes the program 5 4 5 Program license 0 4 5 1 Evaluation period Indusoft Web Studio GSM SMS and G
107. nication is written to log 3 Both 1 and 2 Config ini Parameter explanations Note If your PIN code request is enabled in your SIM card you should not change the PIN code while the program is running DB2SMS tries to initialize SIM card with the defined PIN code and if the code is wrong the SIM card probably gets locked 12 1 6 Troubleshooting Modem initialization problems If you have problems with initializing modem you can check that these are ok e You have inserted SIM card e PIN code request is disabled you have right PIN code in config ini e You have right type of cable and it is in right COM port Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 1255 Appendix e Baudrate is set correctly 9600 e Try different options 1 3 for Modem_Handshaking 1 parameter If the above were ok you can test that the modem is in TEXT mode and the ECHO is OFF Open HyperTerminal and start session with parameters COM 9600 8 1 N OFF Command Modem should Reply AT OK AT CPIN OK or CPIN SIM PIN or CPIN READY If you get ERROR or CPIN SIM PUK there s a Problem with the SIM AT CMGF 1 text mode ATEO OK sets echo off 12 1 7 Starting the DB2SMS program Program can be started by double clicking the DB2SMS exe file If your program is unlicensed the program informs how much evaluation time you have left and when clicking the Continue Evaluate software button the application is started If the configurati
108. nsert the product key If the product key is faulty the program doesn t generate right purchase key and you will lose the license If this happens please contact with FF Automation Include the product key and the generated purchase key in your message Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 47 CONFIGURATIONS 5 5 Configuring the FTP_parser driver This is need for GPRS FTP only ems Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s Communication gt gt Alarm sending via SMS gt gt Measurement History data sending via FTP or SMS gt gt Report sending via SMS SMS controls parameters Remotely programmable Free call controllable incoming phone number identification Features Full programmable PLC features I O Modbus M S programmable time controls Ask more m GSM Phone s receive SMS alarms acknowledge alarms send controls ask measurement reports Set parameters Call controls Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 48 CONFIGURATIONS 1 Open config ini with text editor The file looks like this THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBHI FTP parser configuration file Updated 23 1 2008 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBHI THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI General configuration THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI DataDir defines the directory that holds received files DataDir C FTP THHHHHHHHHHHHHHH
109. of Indusoft Web Studio from Indusoft s web page ask measurement reports Set parameters Call controls www indusoft com You need to register to the page Or you can ask installation DVDs from FF Automation Install the software according to IWS technical reference manual Log in to Windows OS with administrator user rights when you install the software You can buy licenses to this software from FF Automation www ff automation com Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 22 CONFIGURATIONS 5 Configuring the components 5 1 Configuring PostgreSQL database This is needed for both GPRS FTP communication and GSM SMS communication 1 You can configure the database by using a graphical pgAdmin or a console psql interface a Start pgAdmin Ill program which can be used to configure database Start gt Programs PostgreSQL gt pgAdmin III b Start gt Programs gt PostgreSQL gt psql to postgres 1 pg dmin Ill Object browser Properties Statistics Dependencies Dependents Ss Servers 1 E PostgreSQL 8 4 lacalhast 5432 Databases 1 Tra Tablespaces 7 Property Value F Description PostgresQ 8 4 F Hostname localhost Group Roles 0 E amp lPert od b Login Rales 1 E Encryption not encrypted F Service postgresagl 8 Maintenance database postgres F lusername postgres stare password Mo SQL pane Establishing connectio
110. og once second P1 WM100 65535 WM100 1000 resets communication watchdog to 1000 when reached 65535 IKREK LOGGING KkK K WM30 55 M60 timer baser logging M60 M60 1 WM20 2 WM21 2 WM22 2 WM23 2 WM100 2 RO98 245 P TRANSFER WM30 gt 59 M61 WM30 0 Timer based Transmit M61 M6l 1 amp I B0357 21 RO38 8 BOSJ Ll RO37 amp RO38 are special FTP sending registers look manual Backup SMS sending if enabled Send if error in FTP transfer Exclude file empty error 130 RO37 26 amp RO372130 WM20 WM21 WM22 WM23 WM100 9 RO98 20 sends SMS to phone number 20 defined in phone book Note when testing this application use direct cable connection and DIP 4 position ON before testing the real GPRS transfer Look incoming files in alarm log view and the GsmProgrammer program root directory Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 144 Appendix 12 5 Configuring DB2SMS Open config ini file that is located in the installation folder of DB2SMS By default the file includes ConnectionString parameter that is suitable to be used with PostgreSQL Server user name and password should be located in the connection string example ConnectionString DRIVER PostgreSQL UNICODE SERVER localhost DA TABASE smsindusott Vid iws Pwd passwd 12 6 What to do next If you are using SMS data you should next read DB2SMS UM v102 eng pdf DB2SMS Using with WebStudio UM v101 eng pdf If you
111. on of the program is correct you should see small mobile phone picture in the right down corner system tray Md 12 1 8 Closing the program Program can be closed by double clicking the mouse s right button on the mobile phone picture in the right down corner system tray After that you will get confirmation message and answering Yes closes the program Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 126 Appendix 12 1 9 Program license 12 1 9 1 Evaluation period DB2SMS program can be used 50 hours evaluation time without licensing Program inform how much time is left when it is started FF Automation DB2SMS DEZSM5 Evaluation version Evaluate software 50 00 left C Purchase now 12 1 9 2 Purchase and registration Program can be licensed by selecting the Purchase now checkbox and clicking Continue Program generates product key which is unique key for PC This key should then be send to FF Automation e g by e mail and FF Automation then sends back the right Purchase key to activate the license Program informs if the activation were successful FF Automation DB2SMS DB25M5 Evaluation version Product key 247 87 85 244 238 242 mew i cet J roe Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 127 Appendix 12 1 9 3 Moving the license The license can be moved to other PC The original license is removed You should first install DB
112. onebook receiving EJ phonebook sending H E received events EJ received history received report send all ES 53 E E send ane send watchdog variable crosslinks ii Trigger Functions 0 Views 0 Su Replication 0 H E if the calls in and calls out tables are not created you can open psal shell and open database smsindusoft and create the following tables CREATE TABLE calls in flag numeric name text phone text WITHOUT OIDS ALTER TABLE calls in OWNER TO iws CREATE TABLE calls out flag numeric name text phone text WITHOUT OIDS ALTER TABLE calls out OWNER TO iws 5 1 2 Creating database for DB2SMS driver for GSM SMS driver Note smshistory database is only needed for DB2SMS driver The history database is used by Indusoft Web Studio for storing handled history data if you are using DB2SMS only for SMS alarm forwarding then you don t need this database Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 30 CONFIGURATIONS Creating the history database is done in the similar way as you did with smsindusoft database You can use the phases 1 to 3 of the former instructions simple by replacing smsindusoft with smshistory search_path smshistory steps 4 gt for restoring the database are not needed unless you have demo database which you want to restore The tables for history database has to be created manually The easiest way to do this is doing it by using p
113. onjour Service Public a ceserver All Y Filter by Group gt V CodeMeter Runtime Server Private View gt V CodeMeter Runtime Server Private a i IQ Refresh CodeMeter Runtime Server Public Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 65 CONFIGURATIONS Open also TCP port 21 in Firewall which is used for FTP i Ges ey Gear er aa A i ew Inbound R le Wizarc Rule Type Select the type of firewall rule to create Steps Rule Type What type of rule would you like to create 4 Protocol and Ports Action Program Profile Rule that controls connections for a program Name Port Rule that controls connections fora TCP or UDP port Protocol and Ports Specify the protocols and ports to which this rule applies Steps Rule Type Does this rule apply to TCP or UDP 4 Protocol and Ports TCP Action UDP Profile Name Does this rule apply to all local ports or specific local ports 21 Example 60 443 5000 5010 Leam more about protocol and ports Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 66 CONFIGURATIONS Action Specify the action to be taken when a connection matches the conditions specified in the rule Steps Rule Type What action should be taken when a connection matches the specified conditions Protocol and Ports i amp Allow the connection This includes connections that are protected with Psec as well as those are n
114. ot u Profile Allow the connection if it is secure Name This includes only connections that have been authenticated by using IPsec Connections will be secured using the settings in IPsec properties and rules in the Connection Security Rule node 5 Block the connection Leam more about actions Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 67 CONFIGURATIONS Specify the profiles for which this rule applies Steps Rule Type When does this rule apply Protocol and Ports Domain Applies when a computer is connected to its corporate domain Private Applies when a computer is connected to a private network location Public Applies when a computer is connected to a public network location Leam more about profiles Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 68 CONFIGURATIONS Name Specify the name and description of this rule Steps Rule Type Protocol and Ports Action Profile Name FTP21 Mame Description optional Click Finish Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 69 CONFIGURATIONS 7 2 3 Forwarding TCP port 21 in router NAT setup If your PC is in Intranet subnet and doesn t have public IP address you might need to forward your public IP address s port 21 to your PC s Intranet IP address If your PC has public IP address you don t need to do this Ey Command Prompt Gonnection specific DNS Suffix Link loca
115. our PostgreSQL installation Postg reSQL Packaged by Enterprise The Enterprise PosigresSQL Company lt Back Cancel Uncheck the Stack builder and Click Finish Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 13 INSTALLATIONS 4 4 Installing ODBC connectors for PostreSQL database This is needed both for DB2SMS and FTP file parser drivers Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRS FTP Call Controls Communication gt gt Alarm sending via SMS gt gt Measurement History data sending via FTP or SMS i GPRSIFTP needs an gt gt Report sending via SMS static Internet IP address lt lt SMS controls parameters bsna vs Remotely programmable Internet Service ARREARS TU AN As Lig a ee TRU gl lt lt Free call controllable Provider incoming phone number identification z Indusoft Web Studio FTP Parser FTP Interface SCADA software Features fs g Full programmable PLC FTF parsing Database Ethrenet History data features I O Modbus M S WLAN Alarm handling programmable time controls FTP server Saving history data Ask more Creating alarms User Interface Trends Graphics over 200 drivers GSM SMS CallControl DB2SMS SMS parsing Web support Etc SMS Interface Database Alarms Reports History Group messages etc Serial port
116. ow many times modem initialization may fail before error message is given We ve noticed that a modem gives modem link is too weak alarm without any reason in some cases Therefore we recommend not to comment next line WT_InitializationErrorMax 2 Same config ini is also in the appendix Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 44 CONFIGURATIONS 2 Serial port for modem is defined in the first line 3 SIM card s PIN number is defined in the second line You can leave this undefined if the P N code request is configured as off in your SIM card Note It is highly suggested that you turn off the PIN code request from your SIM card Otherwise the SIM card will go to PUK mode if you have wrong PIN code 4 Modem speed is defined in the third line Normally this is 9600 so normally you do not need to change it 5 Modem_Handshaking parameter is important and it should be defined correctly If you are unsure which value to use you can try one by one which work correctly Look the table next table for more information 6 The connection string defines the database connection MySQL connection string is commented Change the user name and password to correct ones e DB2SMS uses ODBC driver to create connection with database ConnectionString should include Server Database User and Password parameters look example file e Other databases Other databases are not tested with DB2SMS In principle all the
117. pace pg default E historyschema E amp IACL j ve en Domains 0 E amp lPrimary key time stamp ge FTS Configurations 0 Rows estimated w i FTS Dictionaries 0 Sra factor T z aris 0 Rows counted 0 il ida 0 Inherits tables No ax e FUNK MORES 9 Inherited tables count i bed Sequences 0 MEN EzIHas OIDs Ma 5 A Tables 1 sx 3 E3 Sa System table No s Trigger Functions 0 smeiiameiiicits reg Views 0 H public ig Replication 0 postgres g smshistory i g smsindusoft T6 Tablespaces 2 ssl X Group Roles 0 4 Login Roles 2 SQL pane Table trend ffa 0001 DROP TABLE trend ffa00001 CREATE TABLE trend ffa 00001 time stamp timestamp without time zone NOT NULL time stamp ms integer wm integer wil integer whe integer wm 3 integer wm99 integer wmln integer ro integer CONSTRAINT trend ffa00001 pkey PRIMARY KEY time stamp WITH OIDS FALSE ALTER TABLE trend ffa00001 OWNER TO iws Open pgAdmin and you can view just created schema and table If you cannot see the schema or tables click refresh button Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 37 CONFIGURATIONS 5 2 Configuring ODBC database Data Source Names DNS This is need for both GSM SMS and GPRS FTP Create ODBC connections for PostgreSQL databases Start gt ControlPanel gt Administrative Tools gt Data sources ODBC If you hav
118. quired software components e Indusoft Webstudio 6 1 SP2 or later e DB2SMS 2 1 or later supplied with DEMO project and manual o Net Framework 2 0 Not needed for Windows or if it is already installed http www microsoft com downloads details aspx familyid20856eacb 4362 4bOd 8edd aab15c5e04f5 amp displaylang en o GSM modem you can order this from FF Automation e PostgreSQL database o PostgreSQL http www postgresql org ftp binary v8 2 3 win32 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 86 TESTING FTP DEMO 8 2 MyTest short description of DEMO IWS project 8 2 1 User Interface MyTest DEMO project s user interface includes versatile features for settings configuration values in the interface database There is a ready made trend object that can be used to show the measurement values from the measurement history database User interface demonstrates also how to send SMS 8 2 2 Temperature Alarm MyTest application is sending alarm message to all GSM numbers in the Phonebook Sending table if the PLC 1 Temperature value goes above 40 C PLC is configured to send Report message every hour PLC x Temperature is scaled from the PLC x AI1 variable 0 4096 to 50 150 using scheduler task Alarm is created using Alarm task Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 87 TESTING FTP DEMO 8 3 Diagram of program functonality PostgreSQL history database Indusoft W
119. rays values Event receiver class variables history receiver class variables Report receiver class variables Report Crosslinks table control ODBC task Report Crosslinks table s active arrays values Interface variable Interface variable Interface variable Interface variable Interface variable Interface variable Interface variable Interface variable Interface variable History data update after selecting variable name History variable grid update after selecting plc Outgoing phonebook update after editing it in interface PLC data read after selecting PLC from a grid Selected outgoing phone number s name Alarm indication tag for Al1 Report pointer tag which gets the class variable s name Report variables for PLCs Watchdog timer s table control ODBC task Watchdog timer table s active arrays values Resetting tag for watchdog timer Interface database DSN Interface database password Interface database status Interface database username History database DSN History database password History database username Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 101 Class Crosslink HisPool ODBC ErrorMessage ODBC HisPool ODBC MsgSender ODBC Phonebook ODBC Receivers Phonebook Rec Event Rec History Tag member ID Name Value TimeStamp TimeStamp ms Variable Select Select Insert Next Insert Select Delete Delete Insert Select Complete StatusO S
120. reSQL Note Indusoft web studio demo uses PostgreSQL Database connection Please contact FF Automation for more information 12 1 3 Installing DB2SMS Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 12 Appendix See separate installation chapter 12 1 4 Configuring DB2SMS Program 12 1 5 General configuration description When configuring the program you should check the following parameters PIN code The serial port which is used by GSM modem The location of the database DNS name user name and password Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 1202 APPENDIX 8 Open config ini with text editor The file looks like this THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem settings THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHBI Modem Port 1 Modem_PIN 0000 Modem_Speed 9600 0 No handshaking 1 XOnXOff 2 RequestToSend 3 Request oSendXOnXOff Modem_Handshaking 2 Modem_Handshaking 1 THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHI Database configuration See http www connectionstring com if you don t want use PostgreSQL or MySQL THHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHE Next line defines connection string for MySQL ConnectionString DRIVER MySQL ODBC 3 51 Driver SERVER localhost DATABASE smsindusoft USER root PASSWORD securepassword Next line defines connection string for PostgreSQL ConnectionString DRIVER PostgreSQL UNICODE SERV
121. restore setting owner and privileges Far TABLE variable cro pa restore setting owner and privileges For DEFAULT mindex pa restore setting owner and privileges Far DEFAULT mindex pa restore setting owner and privileges Far DEFAULT mindex pa restore setting owner and privileges Far DEFAULT mindex pa restore setting owner and privileges Far DEFAULT mindex WARNING errors ignored an restore 1 Process returned exit code 1 Messages 7 Configuring PostgreSQL is finished Psql guide Restoring the database cannot be done in psql command line tool but it can be easily made in command prompt press Ctrl C in psql Note that you need to be in the same directory as the PostgreSQL management tools Restore command pg restore exe i h localhost p 5432 U postgres d smsindusoft v C DB2SMS 1 1 Databases smsindusoft 2013 backup The program asks for the password you used while installing PostgreSQL After writing the password press enter You can ignore errors happened in restoring process Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 29 CONFIGURATIONS After restore Check that you have 12 tables created smsindusoft H Catalogs 7 8 Schemas 2 public smsindusoft j Domains 0 5 FTS Configurations 0 ll FTS Dictionaries 0 FTS Parsers 0 FT5 Templates 0 es Functions 0 E ap Sequences 5 i Tables 12 E9 calls in E9 calls eut ES errormessage l ph
122. rrupted last known up at 2015 03 03 08 36 23 EET 2015 03 04 08 29 01 EET LOG database system was not properly shut down automatic recovery in progress 2015 03 04 08 29 01 EET LOG record with zero length at 3382550 2015 03 04 08 29 01 EET LOW redo is nok required 2015 03 04 08 29 03 EET FATAL the database system is starting up 2015 03 04 08 29 03 EET LOG database system is ready ka accept connections 2015 03 04 08 29 03 EET LOG autevacuum launcher started Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 9 TESTING FTP DEMO Check the LogFile window for tracking problems Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 80 TESTING FTP DEMO 7 4 Reading FTP data to Indusoft Web Studio Open Indusoft Web Sudio gt ODBC Task sheet fd ODBCOO amp DBC x Descriptions Data Source Mame User Password FIP read MWS FIP wes ffauto T able Condition Status Transaction Completed trend ffaaffbb time stamp 2012 05 z Select Trigger M ext Trigger Insert Trigger Delete Trigger select ftp Update Trigger Tag Mame Column 1 FIP timestamp time stamp 2 FIP_wm d wmt 3 FTP wm21 wm 4 FIP_wmi wm22 5 FTP wm23 wmz3 Bb FTP wml1 0 wm100 T FTP ROS8 roge Make the above configurations Make new Boolean type tag for select ftp Use the following condition to sort the data in the table when select trigger is used so that the latest value will be read to the tag names from the Table s colums The time
123. ry it will also appear at that location Aliases must contain the full local path Separate multiple aliases with the pipe character IF using aliases please avoid cyclic directory structures it wall only confuse FTP clients Click edit gt Groups gt Shared folders Create directory C F TP using windows explorer Add home directory C F TP and full permissions click set as home dir Click OK to save settings Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual x CONFIGURATIONS Account settings Users General Enable account FFA00001 Sonis me NC Speed Limits IP Fiter Group membership E Bypass userlimit of server Maximum connection count DENN Connection limit per IP E Force SSL for user login Description You can enter some comments about the user Cancel Select edit gt Users Add user account Please enter the name of the user account that should be added FFADODOT User should be member of the following group add user name If you are using AutoLog GSM PLCs you should add one user for every GSM PLC user name should be same as PLC ID which is defined from the AutoLog GsmProgrammer software e g FFA00001 PLC ID can be set using GSMProgrammer View FTP info Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 73 CONFIGURATIONS E Ftp Info Editor EE ge Humber OF Files Ftp Server n 123 123 123 123 FFAO00001 F
124. s Set parameters Call controls 1 New Database window opens Write Name ftpdata and Owner iws Note This database is needed only for FTP Parser T New Database Properties Name OID Owner Encoding LITF amp Schema restriction Collation Character type Connection Limit 1 Comment Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 33 CONFIGURATIONS 2 Right click on the ftpdata database and select Properties 3 Select Variables sheet and write Variable name search path and Variable Value historyschema Click Add Change Click OK E Database ftpdata Pro rties Variables Privileges SQL pE Ealo SS Variable Value search path historyschema Variable Name search path Variable Value historyschema Note ftpdata database is only needed for FTP file parser driver 5 1 4 Creating tables for ftpdata database interface Restoring the ftpdata database tables are not needed unless you have some already made template database which you want to reuse The ftpdata database table columns depend on what variables you want to read from the the GSM PLC application Next example is showing how to create table to the FTP Demo application The tables of ftpdata database are normally created manually The easiest way to do this is doing it by using psql tool Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 34 CONFIGURATIONS Ope
125. s variable Receiver is active Beginning of receiving math trigger 1 phase math trigger 2 phase math trigger 3 phase math trigger Finishing math trigger Receiving state oend All table ODBC control class variable send message flag Message oend One table send message flag Phone number Message Watchdog timer ODBC control class variable Select trigger Update trigger Watchdog timer class variable Watchdog name activation message send O send 1 not send yet This should be changed Old value Error status counter Error status timeout Phone number Message Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 103 104 Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 104 TESTING FTP DEMO Part 4 AutoLog GSM RTU Demo application You should now read the following manual AutoLog GSM PLC Service Manual to learn how to make application programs for AutoLog GSM RTUs After that you should be able to understand how the GSM pump station monitoring demo program works and how you can modify it to make your own special application 11 1 Example Source code GSM PUMP MONITORING DEMO PROGRAM VERSION 1 01 DATE 2nd March 2015 AUTHOR AM FF Automation Oy Water pump station monitoring only program doesn t control pumps ask other demo if you need pump controlling For DEVICE AutoLog GSM 8 AutoLog GSM 16 or AutoLog GSM 20 Pump start count and operating times surface level and digi
126. se numbers 0 9 and letters A F Copy paste the CREATE TABLE command from this manual to psql Click Enter Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 36 CONFIGURATIONS You can copy paste this command also from the txt file form the Manual accessories files sub directory WE SQL Shell psal ftpdata H CREATE SCHEMA historyschema AUTHORIZATION ius CREATE SCHEMA ftpdata H ftpdata H CREATE TABLE trend_ff ahi Fftpdata H Ft pdatac time stamp timestamp without time zone HOT NULL Ft pdatac time_stamp_ms integer Fe pdatach une integer Ftpdatach umzi integer Ft pdatach umz2 integer ftpdatactt umes integer ftpdatacti ume integer ftpdatacH vumiHBH integer ftpdatactH ro integer fFtpdatat CONSTRAINT trend ffaBWHHHi pkeu PRIMARY KEV Ctime_stamp gt Ftpdatath gt ftpdata it WITH lt Ftpdatat OIDS FRLSE ftpdatacH gt NOTICE CREATE TABLE PRIMARY KEY will create implicit index trend ffaBiHBHi p key for table trend fFfaBHHWHHi TABLE fFtpdata ALTER TABLE trend_ffahBO i OWNER TO iws P pgAdmin UH File Edit Plugins View Tools Help f eS Ry EP ES E P RE X Object browser Properties Statistics Dependencies Dependents Ej Servers 1 El PostgreSQL 8 4 localhost 5432 s G if E Property Value SS Databases 4 E sad PR p EJ fipdata EzIOID 16803 B Catalogs 2 E Owner ws 3 Schemas 2 Tables
127. soft FTP DEMO FTP 11 3 2015 13 40 FTP File 1 KB _ GSM_to_Indusoft_FTP_DEMO GPR 11 3 2015 13 40 GPR File 1 KB _ 65M to Indusoft FTP DEMO IBN 11 3 2015 13 40 IBN File 0 KB GSM to Indusoft FTP DEMO 17 6 2013 14 55 Text Document 40 KB _ 65M to Indusoft FTP DEMO PHF 11 3 2015 13 40 PHF File 1 KB 65M to Indusoft FTP DEMO PRG 11 3 2015 13 40 PRG File 3 KB _ 68M TO INDUSOFT FTP DEMO SMS 11 332015 13 52 SMS File 12 KB GSM to Indusoft FTP DEMO TTB 11 3 2015 13 40 TTB File 0 KB Test was successful Troubleshooting If you see that the files are received but you cannot see the files in the project directory check the security settings of the project folder In Windows 7 the Program Files directory is by default set as read only You can make new project directory to e g CAGSMProgrammer Projects and copy the View gt Source code Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 60 TESTING FTP DEMO 7 1 1 Here s one GSM PLC GSMProgrammer source code version for sending FTP files Frogram FTF program Version 1 1 Date EU Oum i Author Antti Moijanen v 1 1 Jouni Paavonen v1 0 base code peewee FTP LOG amp SEND PARAMETERS xx x message in format SFTP 5 60 where 5 defines log interval in minutes and 60 defiens the tx interval in minutes P SFTP MO WM35 WMO WM36 WM1 MO Log interval WM35 seconds Tx interval WM36 seconds 254 Check for incorrect values M100 M100 WM35
128. soft Web Studio GSM SMS and GPRS FTP drivers User Manual 95 TESTING FTP DEMO array s flag back to zero after reading 9 Save a history column to the history db Trend sender var History data storing to thehistory database Note that the DSN is WS Hispool not SMSIndusoft Flags 0000000000000 10 Receive report messages Received Report Flag71 Receive report messages 13 Read DB2SMS s state from database ErorMesage ReadDB2SMS state from database 7 Remove ck send all messages 18 Remove old send single messages Index Crosslink ID 19 Watchdog alarm resetting oend Watchdog Name IWS AND Enabled 71 Watchdog alarm resetting Watchdog should be active and name should be IWS For every message type there is own receiver scheduler task These tasks are about identical for all message types only the tag names differs This table represents the scheduler task which controls the event receiving process Clock 00 00 05 Event Receiver B 1 Event Receiver Active egin Mtrig 1 DBC ReceiveHistory Event Receiver S DBC ReceiveEvent Status0 0 AND Event Receiver State 0 Event Receiver Active Transaction tateO Mtrig AND Event Receiver State2 MTrig 0 AND 0 Event Receiver Begin MTrig 0 AND NOT DB ReceiveEvent Phone Change DBC ReceiveHistory Event Receiver DBC ReceiveEvent Status0 0 AND Event Receiver Active MTransaction State1 Mtrig DBC_ReceiveEvent Status1 0 AND Event
129. sql tool 1 Open psal tool Start gt All Programs gt Postgre SQL gt SQL shell psal SOL Shell psql Server localhost Database TER DE EE IEEE 10103 OR E ER uil Port 5432 Username posturesl Password for user postgres Click Enter to select Server localhost Change database to smshistory Click Enter to select Port 5432 Click enter to select Username postgres Write the password for user postgres it was defined during the installation process J SOL Shell psql Server localhost Database postgres smshistory Port 5432 Username postgres Password for user postgres peql 8 4 18 gt WARNING Console code page 48560 differs from Windows code page 12525 88 bit characters might not work correctly See psql reference page Motes for Windows users For details Type help for help smshistory CREATE SCHEMA smshistory AUTHORIZATION ius 2 Creating a new schema CREATE SCHEMA smshistory AUTHORIZATION iws Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 3 CONFIGURATIONS 3 Creating a new table Example bellow CREATE TABLE trend 1 time stamp timestamp without time zone NOT NULL time stamp ms integer DEFAULT 0 p1 run time 24h integer p1 start count 24h integer p2 run time 24h integer p2 start count 24h integer wm99 integer aiO real ai1 real ai2 real ai3 real isalarm integer DEFAULT O CONSTRAINT trend 1 pkey PRIMARY KEY time s
130. stamp clause will just check that the saved time stamp has correct value and filter others time_stamp gt 2012 05 28 10 56 00 ORDER BY time stamp desc FTP timestamp time stamp FTP wm20 wm20 FTP wm21 wm21 FTP wm22 wm22 FIP wm23 wm23 FTP wm100 wm100 FTP RO98 ro98 You can copy the above values to the Tag Name Column fields You need to create new tags for every tag name FTP timestamp type string FTP_wmXx type integer FTP ROSS type integer Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 8 TESTING FTP DEMO 7 4 1 Starting the FTP_parser from the Indusoft Web Studio Startup Su MATHOOS Language Built inl T MATHOO9 Language Built in X Description FTP init mirig Execution FTP init mirig 1 Tag Name 1 FTP Parser ret 2 3 sendEvent FIP Parser ohjelma k ynnistetty 4 FTP init mTrig 0 You can use the following Math task to start FTP_parser automatically Make the following scheduler task lines to start the FTP_init_mTrig 30 seconds after starting the application clock 7 00 00 05 init_timer if init timer 1000 init timere1 1 Change init timer FIP init mTrig IKFTP init mTrigz and init timer 6 1 Indusott Web Studio GSM SMS and GPRS FTP drivers User Manual 82 TESTING FTP DEMO 7 4 2 Controlling ODBC task from the scheduler task to read data from the database Event Trigger Time Date Tag Expression Disable mco 00 00 05 select fip not select fip
131. t 24h history M80 1 WM17 WM14 WM18 WM15 WM19 WM16 WM24 WM23 WM14 0 WM15 0 WM16 0 WM23 0 Pl Operating time move and reset empty 4 1 START COUNT amp OPERATING TIME ALARMS 5 11 PACKING BINARY STATES TO ONE 16 BIT WORD MEMORY AND SENDING M504 M50 WM99 MO SPECIAL COMMAND WHICH PACKS BINARY MEMORIES MO M15 TO ONE 16 BIT WORD MEMORY empty MO High water level alarm bit value 1 alarm DIO 0 0 normal state DIO 1 M1 Pump 1 heat relay alarm bit value 1 alarm DI1 0 0 normal state DI1 1 M2 Pump 1 Manual 0 Auto 1 DI2 M3 Pump 1 Operating state 1 Running 0 Stopped M10 High presure alarm bit Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual IO Appendix WM50 WM53 analog input raw values 0 4000 Note 12 bit Analog inputs are calibrated to 0 4000 not 0 4096 for easier handling WM60 maximum SMS count per day safety limit WM11 Pl START COUNT LAST 24H HISTORY CLOCK 7 00 klo 7 00 WM12 Pl TOTAL START COUNTER low byte 0 9999 WM13 Pl TOTAL START COUNTER high byte 10000x WM24 Pl OPERATING TIME IN SECONDS sssss last 24h history WM22 Pl OPERATING TIME HOURS TOTAL HHHHH 0 65535 hours 5 1 ALARM MESSAGE Alarm message is send when any of the alarm bit changes its value to alarm state or normal state After the GSM PLC is booted only active alarm generates sms MO M127 are reseted when GSM PLC boots up Alarm activation delay should
132. tal input status and alarms Indusoft Web Studio SCADA with DB2SMS GSM driver using PostgreSgl database interface List of all used inputs outputs and memories in this program AIO water level 4 20mA gt 0 4 m AIL water pressure 4 20mA gt 0 10 bar AI2 water pumps station temperature Pt100 gt 50 150 C note that GSM 8 has only 2 analog inputs DIO High water level limit switch NC Normally Closed 0 alarm 1 normal state DIO MO DIL Pump 1 heat relay alarm NC DI2 Pump 1 control switch state Manual 0 Auto 1 DI3 Pump 1 Operating state 1 Running 0 Stopped DI3 M3 MO M1 WM50 for initialization condition Contents of this program 0 0 Version 0 1 Initiallizatiorns PROGRAM STARTS HERE E KR GR E OE NOE ORO He Ae EO EGRE EO E OO EO I EO IE OM OE EOM IC ROS EORR EROGO NOE OG S Meo 0 0 Version M50 M50 AO222 100 Version number can be placed e g on A0222 variable which is hardly used in other purposes It is recommended that you define variables for program type numbers if you make many variants Empty lines reserved for program updates without changing the line numbers of other programming lines These lines are useful if you need to download program changes remotely through GSM network later on ty ty LY emp emp emp empty empty 0 1 INITIALISATIONS M2 Pump 1 Manual 0 Auto 1 DI2 DI2 M2 Pump 1
133. tamp WITH OIDS FALSE ALTER TABLE trend 1 OWNER TO iws Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual CONFIGURATIONS 5 1 3 Creating FTP interface database for FTP_Parser GSM GPRS FTP file parsing This is needed for GPRS FTP communication only if you are using GSM SMS communication you can skip this step Overview of using WebStudio GSM GPRS Driver AutoLog GSM RTU s GSM SMS GPRSI FTP Call m Controls Communication gt gt Alarm sending via SMS gt gt Measurement History data l S sending via FTP or SMS p i GPRS FTP needs gt gt Report sending via SMS static Internet IP address SMS controls parameters Milia rdi l to server PC i Q Remotely programmable Provider LL 2 Free call controllable incoming phone number identification t Full programmable PLC features I O Modbus M S pesas History data SCADA software Alarm handling programmable time controls WLAN FTP server Saving history data Ask more Creating alarms User Interface Trends GSM SMS CallControl EMEN Graphics over 200 drivers Web support Etc SMS Interface Alarms Reports Serial History Group port messages etc GSM Phone s receive SMS alarms acknowledge alarms GSM SMS send controls Call Controls CNN All Applications can run in the same PC ask measurement report
134. the system Index part is showing all the example configurations codes and interface descriptions Needed files Contact FF Automation to get the permission to the FTP server to download the latest versions of the manuals and Demo applications 3 2 Needed components 3 2 1 Needed hardware components Windows PC Suggested Operating System Windows 7 Pro Serial ports 1 minimum 2 suggested Ethernet port 1 minimum Display 24 or bigger is suggested for SCADA but smaller can be used too 8GB or more RAM suggested for SCADA 500 GB hard disk suggested 2 hard disk RAID system is suggested for SCADA Normal known reliable brand like HP desktop PC woks ok but for 24 7 365 SCADA application it is suggested to have server like reliability FF Automation can suggest suitable PC for your application 3 2 2 Needed hardware accessories AutoLog GSM PLC s GSM 4 GSM 8 GSM 16 or GSM 20 Also GSM PLC demo kit is available for training and testing your application Order from FF Automation GSM PLC programming cable AL Programming Cable PC AL RJ45 Length 2 5m order code 903195 GSM modem Unit for PC WAVECOM FASTRACK XTEND GSM GPRS modem stubby antenna power enclosure and PC to modem cable can be ordered from FF Automation SIM cards for GSM PLC and PC s GSM modem Order these from your local operator Small screw driver and about 2m red and blue I O testing wires Needed software components DB2SMS driv
135. tion section includes information about PLC and its variable configuration 12 3 6 PLC description section format Bytes 0 3 PLC ID Bytes 4 5 Variable count Bytes 6 gt Variable descriptors Variable descriptors consist from two bytes The first byte defines the variable type and the second byte defines the id of the variable E g If the first variable has value 5 and the second value 230 then the variable is RO230 12 3 7 Variable data block After PLC description block exists data block The format is quite a simple Bytes 0 3 Date and time Byte 4 Variable values two bytes per variable The timestamp is encoded so that it need only four bytes First byte s seven most significant bits represents the value of year The least significant bit of first byte and four most significant bits of second byte represents the value of month Fife least significant bits of second byte represents the day Third byte represents hour and fourth byte represents minute 12 3 8 Date Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 140 Appendix 1 byte 2 byte YYYYYYYM MMMDDDDD 12 3 9 Time 3 byte 4 byte HHHHHHHH MMMMMMMM Variable values are located after timestamp The variable sort should be same as in the PLC description block 12 3 10 Example file FF AA FF AA 00 01 07 00 OE 21 09 00 FF FF First four bytes represents the id so the PLC id is FFAAFFAA The file has only one variable 00 01 and it is AIO 07
136. tp Path p Ftp Password securetest PLC ID should have 8 HEX characters HEX characters are 0123456789ABCDEF DEPIOLIMIT FTP After changing the PLC ID you need to compile the project and transfer it to GSM PLC and start the PLC Look GSM PLC User Manual how to do that Every GSM PLC you have should have unique PLC ID you can use numbers 0 9 and letters A F Ftp path means that the files are send to the root directory home directory of the FTP Server Ftp password should be same as defined in GsmProgrammer Ftp password e g securetest Click OK Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 74 7 2 6 Restarting the FTP Server File Action View Help E Bg Sia Services Local Fis aa Services Local FileZilla Server FTP server Stop the service Restart the service Fytended Shancdared Mame Sy Cryptographic Servis 84 DCOM Server Proc Sa DHCP Client 5 Distributed Link Tra Sa Distributed Transac Sa DNS Client fy Error Reporting Ser Sy Event Log Sa Extensible Authenti iy Fast User Switching g Filezilla Server FTP amp Firebird Server De SBa FTP Publishing Sa Google Desktop Ma Sy Google Software U I7 Ana Lindaka Tae CONFIGURATIONS Description Provides th Provides la Manages n Maintains li Coordinate Resolves a Allows erro Enables ev Provides wi Provides m
137. uld see a login dialog Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 90 TESTING FTP DEMO FF Automation Variable configuration FF Automation History table configuration Server localhost Username postgres Password History database name smshistory Interface database name srpsindusoft C Create history database Owner of new tables Ws Continue Write password for user postgres If you don t have a history database yet you may create it by checking checkbox Create history database Normally you don t need to change Default schema name value Click Continue when you re done After a while the program opens the main window FF Automation Variable configuration Seles Add new PLC Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 9 TESTING FTP DEMO 4 By double clicking Add new PLC you may create a new PLC FF Automation Variable configuration Add new variable Add new PLC PLC enabled Delete Hename Duplicate selected selected selected 5 You may change PLC properties by selecting it from the list You can remove it Delete selected rename it Rename selected or create duplicates of it Duplicate selected Please note that duplicating creates also new history tables You can also change the phone number of the PLC or enable disable it By double clicking Add new variable you may create a new variable for the selected PLC 6
138. y Please specify the directory where PoskgreSQL will be installed Installation Directory C Program Files PostgresQLi8 4 BitRock Installer Leave default settings and Click Next gt SE Password R a os A Please provide a password For the database superuser postgres and service account postgres IF the service account already exists in Windows vou must enter Ehe current password Far the account IF the account does not exist it will be created when you click Next Retype password BitRock Installer write password for superuser REMEMBER IT AFTERWARDS Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual ie INSTALLATIONS BitRock Installer Leave default click Next gt Seles Advanced Options R Select the locale to be used by Ehe new database cluster Locale fM EE iau Install plipasql in template database BitRock Installer Leave default click Next gt Indusoft Web Studio GSM SMS and GPRS FTP drivers User Manual 12 INSTALLATIONS Ready to Install Setup is now ready to begin installing PostgreSQL on your computer BitRock Installer Click Next gt Wait until installation is finished Completing the PostgreSQL Setup Wizard Setup has Finished installing PostgreSQL on your computer Launch Stack Builder at exit Stack Builder may be used to download and install additional tools drivers and applications ta complement y

Download Pdf Manuals

Related Search

Related Contents

Standalone Software for TileCal ROD Characterization and  lab safety manual - University of the Fraser Valley  Philips 8000 series 46PFL8686H 46" Full HD 3D compatibility Wi-Fi Black  Umirs RADON user manual  User Manual for the GROOVE Tool Set  取扱説明書 - 三菱電機  Connecting the Content Repository to Primavera Unifier  USER GUIDE GUIDE DE L`UTILISATEUR  Boas Práticas de Distribuição  

Copyright © All rights reserved. Failed to retrieve file