EXgarde EXfusion User Manual
Contents
1. y Next The show the current value while a sequence is running It starts at the value of First and runs up to Last after the Run button has been pressed otherwise it shows the value of First F Insert button This will insert a single entry based on the command string If the command contains a then it is substituted by the value of First F View button This displays the Source Table screen as described in Section XXXX to allow the user to inspect the result of any inserts they have carried out Command Area This is the area for a user to manually enter a script command It can be any of the available commands and repeated sequences of commands can be carried out by inserting the character The is then replaced by the next sequence number between the range specified by First and Last Y Data Area This allows data to be entered into the Data column of a command This feature is not used at present EF OK button Indicates that the user has completed all data entry and will return to the Service screen If data has been entered but not committed then the changes are automatically committed Cancel button Indicates that the user wish to stop entering data and return to the Service screen If data has been entered but not committed the user will be asked to confirm whether to commit or not EXgarde EXfusion User Manual Last Change Copyright 2014 TDSi 09 July 2015 Page 11 Tosi ACCESS EVERYWHERE 9 Dest2. defaultgroups Yes No removefromcommunity keyholder name community 20 characters defaultgroups Yes No setcommunityinfo keyholder name community 20 characters info1 30 characters info8 30 characters Only jog bmp and gif image types are recognised by EXgarde EXgarde EXfusion User Manual Last Change Copyright O 2014 TDSi 09 July 2015 Page 19 Command Table Definition 11 5 System Specific Data The following are a list of constants or the Technology and the Status parameter in Key commands It should also be noted that the format of dates used within Key commands should specified in the same format as the System Locale settings of the PC on which Fusion is installed on Key Technologies Microcard 37 bit Wiegand ASR Prox 34 bit Wiegand Magnetic Octopus 44 bit Wiegand TDSi Wiegand Me Lucky 34 bit Wiegand 26 bit Wiegand Universal Decode kevpad Key status Available In use Lost Damaged Suspended EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change Page 20 09 July 2015 Command Table Definition 11 6 Status Codes 0 Unexecuted 1 Processed OK 1 End of file 2 Error 3 Unknown command 4 Unknown object type 5 Unknown parameter name 6 Key Holder already ex
3. Add to Community Remove from Community Set Community Info Key New Key Modify Key Delete Key Issue Key to Keyholder Set Key Status Move Key to Box Key Box New Box Modify Box Delete Box EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 TDS ICCESS EVERYWHERE 3 Quick Installation and setup Last Change 09 July 2015 Install EXgarde as required Install EXfusion on the same PC as the EXgarde database server or any EXgarde client In the EDB create a table which corresponds to the format described at the back of this document Start EXfusion and select New from the Client menu or toolbar button Enter the details for the EDB Press Test button to confirm connection to EDB Create a Fusion operator on Exgarde Select Properties from Server menu and enter the required details for the EXgarde database If not started already by virtue of its set up start the service EXgarde EXfusion User Manual Copyright 2014 TDSi Page 3 4 Login Screen The first time you start EXfusion you will see a login screen Tenant Landlord Uperator Password ENTERPRISE This requires that you login to EXgarde and sets the context for all Fusion transactions By logging in it means that 2 Time amp Data Systems htenationd Ltd 201 opyright 1996 2 rights reserved D i F Any comm
4. values nSeq sDBName sCommand 0 Call SqiConnect hSqlSeg Call SqlRetrieve hSqlSeg GetUniquelD nSeq nSeg On Procedure Execute Trace sCommand if sCommand STRING_Null return 0 Get unique ID for new command Call SqlExecute hSqlSeg Call SqiFetchNext hSq Seq nFetch H Insert new command Call SqlExecute hSqiCmd return 0 On Procedure Close Call SqlDisconnect hSq Seq Call SqiDisconnect hSqlCmd The following is a simple trigger called key_insert placed on the Visitors table key which on the insertion of a new record inserts a create key command in UG_COMMAND The command uses the number and technology fields from that record and has the keybox hard coded to Visitors and the status to Available create trigger key_insert after insert on key execute UGCOMMAND create key number box Visitors technology technology status Available for each row The following creates a keyholder when a new visitor is created Very similar to the above key creation but to simplify the viewing of the UG_COMMAND the keyholder creation is split into two commands The first creates the keyholder including the first two info fields and the next modifies the same keyholder and enters info fields 3 amp 4 It is not necessary to split the command like this create trigger visitor_insert after insert on visitor execute inline name company vrn
5. win32client odb32 No other data goes in this section but under that another new section is required with the following entry This establishes the alias for Fusion to use EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 Last Change 09 July 2015 Command Table Definition when referring to the Data Source where DataSourceName is the name specified with the ODBC Data Source Administrator odbcrtr remotedbname EDBalis DSN DataSourceName The following is an example of a SQL IBI file from a stand alone installation of EXgarde that has been update to include a Data Source called My Thingy Database which will be referred to as Fred EXgarde EXfusion User Manual Copyright 2014 TDSi Page 23 Command Table Definition Page 24 11 9 Implementation The customer s application can be altered to enter the required commands into the UG_COMMAND table but a more seamless method is to use database triggers to create the appropriate commands when particular changes occur to the EDB via normal operation This allows the customer s application to remain unchanged but still to be able to pass information to the EXgarde system For example if the EDB is a personnel system on the insertion of a record in the person table a trigger would insert a create keyholder command in UG_COMMAND with data extract from the EDB The following are example triggers taken from TDSi s Visitor Manageme
6. Data Systems International Ltd Unit 10 Concept Park Innovation Close Poole Dorset BH12 4QT UK 44 0 1202 723535 44 0 1202 724975 htto www tdsi co uk sales tdsi co uk marketing tdsi co uk support tdsi co uk
7. F Setup button This will show the Source Database screen to allow alteration of the service setup information F View Source Table button This will show data currently in the command table on the EDB for this service If you have chosen the option Delete Successfully Processed Entries and a Polling operation has taken place since data was last placed in the table then the table will only contain error messages F View System Error Log This will display the error log F Fill Source This will open a screen which allows script commands to be directly entered into the command table on the source database EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 TOs ACCESS EVERYWHERE 7 Source Command Table 7 1 Last Change 09 July 2015 E Source Command Table Provider SQLNCLILL1 Persist Security Info False User ID saiIni Seq Database Command Status Status Description i 2 create keyholder 1 T Processed OK create keyholder 2 Right Click Menu The right click mouse button allows you to carry out certain functions against the UG_COMMAND table allowing a user to carry out simple administration task from Fusion Refresh Updates the table contents with the latest information from the source s UG_COMMAND table y Save Amendments The contents of the columns Database and Command can be changed by selecting the cell Once changed th
8. The screen displays details about the operation of an individual service The top left hand side shows the script mode and the current status of the service This section show details of the commands and polling operation of the service ervice Details FUSION x Script Mode Manual Last Error Current Status Stopped Close r Service Details ai Start Next Poll ai Poll Now Last Task Last commited lo Setup Processed o is Total E lo a Sege soe View Source Table View System Error Log Script Entry F Next Poll This is the time that the source command table will be polled for any new commands F Last Task The time that the last script command was executed by Fusion F Last committed The sequence number of the last successfully executed command F Processed The total number of commands processed by the service This includes successful and unsuccessful commands F Total Errors The total number of commands that where unsuccessfully executed EXgarde EXfusion User Manual Last Change Copyright 2014 TDSi 09 July 2015 Page 7 Script Service Page 8 Close button This closes the window and returns to the Fusion main screen EF Start button If the service was set to Manual or was Halted then this will start the service polling F Poll Now button This will force EXfusion to poll the table and execute any commands overriding the service poll timer
9. R 4 Not Null 2 DBNAME CHAR 8 Not Null 3 COMMAND LONG VARCHAR 0 Not Null Not Null 4 STATUS INTEGER 4 w Default 0 5 DATA LONG VARCHAR 0 OK CMD_SEQ A unique incremental identification number but not necessarily sequential A specified sequence number method is used to identify a particular row so as to make the system less database specific as some do not automatically generate a ROWID The method for generating this number is dependent on the database and will be left to the user to implement all that is required is that Fusion can use the number to order and uniquely identify a single row DBNAME Name of database to execute commands against COMMAND The script command string STATUS Indicates the status of the command It has a default value of 0 to indicate a non processed command On successful execution it is set to 1 If execution was not successful against the EXgarde system then a negative error code is entered DATA Additional data for the command such as a BLOb containing an image For future expansion only The following is an example SQL definition of the Command table The data types may vary between databases Create Table UG_COMMAND CMD GEO INTEGER NOT NULL DBNAME CHAR 8 NOT NULL COMMAND LONG NOT NULL STATUS INTEGER NOT NULL WITH DEFAULT DATA LONG EXgarde EXfusion User Manual Copyright O 2014 TDSi Last Change Page 16 09 July 2015 11 2 Last Change 09 July 2015 Command Table Defini
10. ands executed by Fusion are taken in relationship to objects belonging to the Tenant login as l e when a Key Holder is added then that Key Holder is added to this Tenant F The EXgarde event log will show Fusion transactions as Operator events for this particular Operator F Fusion will not be able to perform transactions unless this particular Operator has the necessary rights If you wish once you have logged in you can set automatic log in to save you having to log in each time Fusion is launched see Server Database Properties screen EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change Page 4 09 July 2015 5 Script Service Manager 5 1 Main Screen When EXfusion is started you will see the main screen Exgarde f Destination Source Options x es Manual Stopped This contains three menus Destination Source amp Options The Source menu contains operations related to the Source databases the EDBs F The Destination menu contains operations related to the single destination database EXgarde The New Delete and Properties buttons on the Toolbar are duplicates of the Source menu options The Options menu is used for configuring OPC 5 2 Destination Menu Suspend e This will halt all services without exiting Fusion Y Hide e This will hide the screen but Fusion will continue to run To re display the screen re launch Fusion i e run eXfusion exe x Properties T
11. d commands is possible by the use of the wildcard in the script text which is then substituted by a value taken from the range specified in the First and Last number For example the above command would cause 50 Key Holders called Test100 Test 101 etc to Test150 to be added to the Group Everyone when the Run button is pressed Sequence This is the command sequence number inserted in the Sequence column in the Command table This is an automatically incrementing number but the user can override this at any time and the sequence will continue from the user entered number on each insert of a command Database Name This is the name of the destination database This is usually blank as default y Status This is the initial status value the command is inserted with It is usually set to 0 so the command is executed next poll cycle by the service but can be set to Complete 1 or any of the error codes if required EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change Page 10 09 July 2015 Manual Script Entry y First For automatic sequence runs this is first number in the sequence to be substituted for in the command string y Last For automatic sequence runs this is last number in the sequence to be substituted for in the command string F Run button This inserts multiple entries of the command string substituting with the next number in the sequence range specified by the First and Last fields
12. ds against the EXgarde system This involves data transformation i e the translation of data fields in the EDB into the corresponding EXgarde data fields Each EDB must therefore contain a new table which is in effect a stream of commands to EXgarde Fusion will then process each entry in the table securely without operator intervention The customer will be responsible for maintaining the content of the command table and error handling It is important that both the customer s data and EXgarde are adequately protected from accidental or deliberate damage F Access to the EDB will remain under the customer s control in that the name and password granting access only to the Command Table will be entered by the customer during installation of EXgarde Fusion and thus need never be known to TDSi Access to other tables can be completely prevented by the customer Access to EXgarde will be only be possible via EXfusion This prevents the EDB user from accessing other parts of the EXgarde database Fusion is logged into in the same manner as EXgarde so Fusion will only have access to data belonging to the specified Tenant EXgarde EXfusion User Manual Last Change Copyright 2014 TDSi 09 July 2015 Page 1 y e erre 2 Supported commands Page 2 The following EXgarde Commands are currently supported Key Holder New Keyholder Modify Keyholder Delete Keyholder Add to Group Remove from Group
13. e new data can be save to UG_COMMAND by this option This automatically resets the status flag to 0 so the amendments will be executed by Fusion on the next poll F Delete Selected Rows Any highlighted rows will be removed from UG_COMMAND table y Clear Status for Selected Rows The status of any selected row is reset to 0 and so will be executed by Fusion on the next polling of the table This is useful if the data in a command was correct but EXgarde did not have the matching data once EXgarde had been corrected the originally failed command can be re run by clearing its status y Select All Selects all the rows in the table for use by some of the above commands EXgarde EXfusion User Manual Copyright 2014 TDSi Page 9 Tosi ACCESS EVERYWHERE 8 Manual Script Entry This screen allows a user to manually enter a command or sequence of commands into the Command table for execution by EXfusion This a simple method of testing scripts without using an external application The commands are entered in the format described in Section XXX and must be terminated with a semicolon A ER A E Manual Script Entry Provider SQLNCLIL1 1 Persist Security Info False User ES Sequence 14 DB Name Status lo Command NB all s are substituted by Next No on each insert create keyholder New keyholder First 1100 Last 1150 Next mm Insert Data Y View Ok Cancel A sequence of repeate
14. ent info16 Aardvarks modify keyholder bob picture C bobsmith bmp delete keyholder bob create box Visitor modify box Visitor Visitors delete box Visitors create key 1111 technology Proximity modify key 1111 technology Proximity keyholder fred box Vistitors pin 1234 fromdate 26 05 2001 todate 28 05 2001 delete key 1111 technology Proximity issue key 1111 technology Proximity keyholder fred addtogroup keyholder bob group Students removefromgroup keyholder bob group Students ODBC Connections The most common method of connecting Fusion to an EDB is via ODBC As well as declaring the Data Source within Windows ODBC Data Source Administrator the SQL INI file within the EXgarde directory will require updating The following changes enable the use of an ODBC connection and specify the details of the EDB In the section win32client add the following line where EDBalias is alias associated in the odbcrtr section This is the Database name to be specified in the Service Configuration screen dbname EDBalias sqlodb32 In the section win32client dll add the following line to enable odbc connections for the client Also check that the file sqlodb32 dll is installed in the EXgarde directory comdll sqlodb32 Create a new section at the bottom of the file by typing
15. exgar de EXFUSION User Manual UM0048 GB Issue 4 09 07 2015 www tdsi co uk TDSi Unit 10 Concept Park Innovation Close Poole Dorset BH12 4QT UK Tel 44 0 1202 723535 Fax 44 0 1202 724975 Sales Enquiries sales tdsi co uk Marketing Support marketing tdsi co uk Technical Support support tdsi co uk ACCESS EVERYWHERE Foreword Copyright 2011 TDSi All rights reserved Time and Data Systems International Ltd operate a policy of continuous improvement and reserves the right to change specifications colours or prices of any of its products without prior notice Guarantee For terms of guarantee please contact your supplier Trademarks Copyright 2011 Time and Data Systems International Ltd TDSi This document or any software supplied with it may not be used for any purpose other than that for which it is supplied nor shall any part of it be reproduced without the prior written consent of TDSi Microsoft and Windows are registered trademarks of Microsoft Corporation All other brands and product names are trademarks or registered trademarks of 8their respective owners Cautions and Notes The following symbols are used in this guide CAUTION This indicates an important operating instruction that should be followed to avoid any potential damage to hardware or property loss of data or personal injury NOTE This indicates important information to help you make the best use o
16. f this product 5 1 5 2 5 3 5 4 5 5 6 1 7 1 10 11 11 1 11 2 11 3 11 4 11 5 11 6 11 7 11 8 11 9 Last Change 09 July 2015 Contents RTE 1 Supported COMMANOS surreal 2 Quiek Installation app Setup ao 3 COIN 4 Script Service EE TE 5 Main ee 5 D stination E EE 5 HEED 6 Options TEE 6 Source Database E 6 Script SEA ea 7 Se 7 Source Command WE usara dara 9 Right Click el D 9 Ma ual Script Eti EE 10 Destination SEE Nossa 12 Script Service Configuration Screen sessssssesssessesssesssessesssesssessesssessssssesssessssssesssesseessesseeees 14 Command Table Dent air 16 A e a 16 Script Command Omaira 17 DEE 17 t EE 19 Syst m Specific Data EE 20 Status get 21 Reuter 22 ODBC CMG TC 22 Ip 24 EXgarde EXfusion User Manual Copyright 2014 TDSi Page i A d aeee 1 Overview EXfusion is a mechanism for allowing the EXgarde access control system to respond automatically to changes in an external SQL database EDB system The goal is that whenever changes are made to source tables in the EDB then EXgarde will respond to those changes as if an EXgarde operator made them For example as new people are added into a Personnel database those same people could be added into EXgarde without operator action This includes automatically updating Access Control Units ACUs where necessary Fusion is a scripting tool taking script commands from the EDB and executing the relevant comman
17. his opens the Destination Database screen Exit This will close down EXfusion altogether S 3 EXgarde EXfusion User Manual Last Change Copyright 2014 TDSi 09 July 2015 Page 5 Script Service Manager Page 6 5 3 5 4 5 5 Source Menu F New This opens a blank Source Database screen which allows you to define a new link to an EDB F Delete This will delete the currently selected database service in the list F Properties This opens the selected Script Service screen This allows you to view and control the status of the service as well as altering the Source database configuration F Start amp Stop This will start or stop polling for the selected service Options Menu y OPC This is used to enable OPC and specify the OPC keyholder group Source Database list When first started the list will be empty Once source database are entered the relevant service is displayed with the run mode and present status The Delete Properties and Start Stop options from the source menu require that the user has already highlighted an entry in this list Double clicking on an entry automatically displays its Script Service screen EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 L e 6 Script Service 6 1 Service Details The service details screen is obtained by double clicking the service or clicking the toolbar icon Destination Source Options n x a
18. idity duration of 700 days exist The command will not be executed if the time between the from and to date is greater than this or if only a to date is specified that then time between the date of execution and the specified date is not greater than this To set a validity date to unrestricted use a blank value e g todate EXgarde EXfusion User Manual Copyright O 2014 TDSi Page 17 Command Table Definition Page 18 Although validity dates can be specified down to the minute this is ignored and the nearest whole day is used e g fromdate 02 03 03 12 30 todate 05 03 03 13 30 the card will be valid from 02 03 03 00 00 to 06 03 03 00 00 To keep image storage to a minimum all images are reduced to a maximum width of 300 pixels and will keep their aspect ratio If the original image is not in the aspect ratio100 110 width height then the image will need to be cropped within EXgarde to be printed correctly The parameters can be in any order except Technology must follow key number AddToCommunity RemovefromCommunity and SetCommunityInfo all refer to Key Holder groups AddToCommunity amp RemovefromCommunity affect the Keyholder Group membership of a key holder If the parameter DefaultGroups YES is included then the keyholder is automatically added to or removed from the Default access groups of that keyholder group Previous Fusion scripts for keyholders will still work with info1 to info8 placed in tenant inf
19. ination Setup Screen As well as defining the connection properties to the destination database this screen can be used to set up unattended log in when Fusion is launched and to cause Fusion to be launched when the PC is booted and to hide itself once connected It also defines the interval between executing commands against the EXgarde system Destination Configuration Ea Database Name Operator lu 2000 Admin Tenant Password Landlord E I Automatic log on EK Ma art Service Timer Interval lo System Error Log File Browse Cancel Database This is the name of the EXgarde database Operator A valid EXgarde Operator within the context of the Tenant F Tenant A valid EXgarde Tenant F Password The password for the Operator F Automatic Log on If checked the log in screen is bypasses when Fusion is launched Hide when connected If checked the Fusion user interface is hidden after a successful automatic login F Auto start service If checked Fusion starts when the PC is booted this does not require a shortcut to Fusion in the Startup group Y Timer interval Interval in 1 10th of a second between the execution of each command in UG_COMMAND l e a value of 10 executes a command every second This is used for all Host databases This should always be less than the Polling Interval for any Host database System Error Log File The name including path of a log file EXgarde EXfusion User Man
20. ists 7 Key Holder does not exist 8 Cannot delete Key Holder 9 Cannot modify Key Holder 10 Box already exists 11 Box does not exist 12 Cannot delete Box 13 Cannot modify Box 14 Key already exists 15 Key does not exist 16 Cannot delete Key 17 Cannot modify Key 18 Cannot set Key status 19 Key technology missing 20 Key number missing 21 Box name missing 22 Key Holder name missing 23 Invalid Key Technology 24 Invalid Key 25 Invalid PIN Number 26 Invalid From Date 27 Invalid Until Date 28 Invalid Key State 29 Access Group does not exist 30 Missing Group name 31 Key Holder is Already in Group 32 Unable to add Keyholder to Group 33 Unable to remove Keyholder from Group 34 Insufficient Operator rights 35 Unable to open image 36 Image conversion failed 37 Unsupported image format 38 Key is un issued 39 Validity duration exceeds maximum 40 Key Holder Group does not exist 41 Missing Key Holder Group name 42 Key Holder is Already a member of Key Holder Group 43 Unable to add Key Holder to Key Holder Group 44 Unable to remove Key Holder from Key Holder Group 45 Key Holder is Not a member of Key Holder Group Last Change 09 July 2015 EXgarde EXfusion User Manual Copyright O 2014 TDSi Page 21 Command Table Definition Page 22 11 7 11 8 Command Examples create keyholder bob longname bob smith comment Test person info1 Stud
21. nt System which is based on a SQLBase database called Visitors The triggers use two main database procedures GetUniquelD and UGCOMMAND GetUniquelD retrieves a unique sequence number using SQLBase s sysdbsequence functionality to be inserted into CMD_SEQ and UGCOMMAND inserts the final row into the UG_COMMAND table This procedural method was used as these steps are repeated for each trigger but could be coded in each trigger if procedures are not available PROCEDURE GetUniquelD static parameters Receive Number nUniquelD local variables Sql Handle hSql Number nSeq Number nFetch actions On Procedure Startup Call SqlConnect hSql On Procedure Execute call SqlPrepareAndExecute hSgql select sysdbsequence nextval from syscolumns into nSeq call SqlFetchNext hSql nFetch set nUniquelD nSeq call SqiCommit hSq return 0 On Procedure Close Call SqlDisconnect hSq PROCEDURE UGCommand static parameters Long String sCcommand local variables Sql Handle hSqiSeq Sql Handle hSqiCmd Number nSeq Number nFetch Long String sData String sDBName actions On Procedure Startup l connect cursors and retrieve stored procedures EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 Last Change 09 July 2015 Command Table Definition Call SqlConnect hSqiCmd set sDBName UG2000 Call SqlPrepare hSqiCmd insert into UG_COMMAND CMD_SEQ DBNAME COMMAND STATUS
22. nually MANUAL by pressing the start button or started automatically AUTOMATIC when Fusion is started Polling Interval The interval between polling queries to the UG_COMMAND table to check for new entries Specified in seconds EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change Page 14 09 July 2015 Last Change 09 July 2015 Script Service Configuration Screen F Delete all processed commands If checked successfully processed entries will be deleted from the table in the host database F Delete successfully processes commands If checked successfully processed entries will be deleted from the table in the host database y Test To confirm that the connection details entered are correct pressing this button will attempt to connect to the database and report whether it succeeded or failed This command has a long timeout so be patient if it does not respond immediately y OK This stores the data entered by the user and returns to the previous screen Cancel This abandons any changes by the user and returns to the previous screen EXgarde EXfusion User Manual Copyright 2014 TDSi Page 15 ACCESS EVERYWHERE 11 Command Table Definition 11 1 Table Definition Fusion works off a table called UG_COMMAND created on the EDB by the customer UG_COMMAND is to be defined with the five columns as specified below Column Name Data Type Width Nulls 1 CMD_SEQ INTEGE
23. o and info9 to info 16 placed in All Key Holders keyholder group EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 11 4 Commands Command Table Definition Command Object Object name Parameter Parameter type Name value create keyholder 20 characters longname 50 characters comment 50 characters info1 30 characters info2 30 characters info15 30 characters info16 30 characters modify keyholder name name 20 characters longname 50 characters comment 50 characters info1 30 characters info2 30 characters info16 30 characters info16 30 characters picture filename delete keyholder name create box name modify box name name 20 characters delete box name create key 8 digit number keyholder 20 characters b 20 characters OX technology see list below modify key 8 digit number box 20 characters technology see list below Status see list below pin 0000 9999 fromdate see note below todate see note below delete key number technology see list below issue key number technology see list below keyholder 20 characters addtogroup keyholder name group 20 characters removefromgroup keyholder name group 20 characters addtocommunity keyholder name community 20 characters
24. phone unique_id procedure Create Visitor static parameters String sName String sSCompany String sVrn String sPhone String sSUniquelD local variables Sql Handle hSqiCmd String sVisitorGroup Long String sCcommand actions On Procedure Startup EXgarde EXfusion User Manual Copyright 2014 TDSi Page 25 Command Table Definition Page 26 H connect cursor and retrieve stored procedure Call SqlConnect hSqiCmd Call SqlRetrieve hSqiCmd UGCOMMAND sCommand On Procedure Execute set sCommand create keyholder sName info1 sSCompany info2 em Call SqlExecute hSqiCmd set sCommand modify keyholder sName info3 sPhone info4 I sUniquelD Call SqlExecute hSqlCmd set sVisitorGroup Visitors set sCommand addtogroup keyholder sName Group sVisitorGroup mar Call SqlExecute hSqlCmd return 0 On Procedure Close Call SqiDisconnect hSqlCmd for each row Non directly related tables could use multiple calls For example for an entry to the Visit table the trigger modifies the key status and adds the keyholder to a group The flexibility and amount of automation that can be obtained with Fusion is only reliant on the strength of the trigger language of the EDB and the amount of relevant information it contains EXgarde EXfusion User Manual Copyright 2014 TDSi Last Change 09 July 2015 Time and
25. tion Script Command Format Commands are of the format Command Object type Object name Parameter Name Parameter value Parameter Name Parameter Value Parameter Name Parameter Value 11 3 Rules y all objects must be uniquely named a Create or Modify command that would result in a duplicate will be rejected There is an equals sign between each Parameter Name and Parameter Value Parameters are optional in the case of a Create command and are ignored in the case of a Delete command Multiple parameters can be concatenated in one command Commands objects and constant values are all non case sensitive All commands must be terminate by a semi colon Any data over the specified length of a data field will be truncated to that length All strings names and parameter values should be enclosed in single or double quotes All key operations MUST include the technology parameter For Keyholder photograph s UG_COMMAND contains a filename of the image file instead of the binary image The filename must contain the full path to file from the location of the Fusion application The image can be in BMP JPEG GIF or TIFF To store a photograph of a keyholder the keyholder must first be created and then modified with the image path specified Keys cannot enter a PIN or validity period for a key until it has been issued the key can then be modified with the required details A maximum val
26. ual Copyright 2014 TDSi Last Change Page 12 09 July 2015 Destination Setup Screen F Browse This allows a user to use the file browser to specify the location of the log file y OK This stores the data entered by the user and returns to the previous screen F Cancel This abandons any changes by the user and returns to the previous screen EXgarde EXfusion User Manual Last Change Copyright 2014 TDSi 09 July 2015 Page 13 Tos ACCESS EVERYWHERE 10 Script Service Configuration Screen The screen defines the connection to the EDB and the operation of the service once connected Service Configuration Service Title Ce Connection String I User Name Password Comments Schema Mode Polling Interval Disabled e 0 J Delete all processed commands Delete successfully processed commands 1 Disable Bind Variables in updates and deletes MySQL Tet Cancel Service title Free text Connection String The connection details required should be in the form of an OLE DB initstring y Comments Free text y User Name User name if required for accessing the host database F Password Password name if required for accessing the host database F Schema Some databases require the specification of particular schema to log on to If this is required it is entered here otherwise leave this field empty F Mode Is the execution of script commands disabled DISABLED started ma
Download Pdf Manuals
Related Search