Creating scheduled jobs in Space Work in progress

Overview

Creating scheduled jobs refers to creating custom jobs. This functionality differs from default scheduled jobs in that default scheduled jobs are preset system jobs. You can create the following types of scheduled job on the system:

• Automatic CSV file synchronization
• Automatic database table synchronization
• Automatic audit trail exports
• Automatic entity exports
• Automatic users inactivity exportation

When you create a job, it is displayed on the Scheduled jobs screen. The following sections describe how to create these jobs.

Automatic CSV file synchronization

CSV file synchronization allows you to synchronize user data from external system files with Space. For example, in a university installation, you can synchronize with the data in a student record system. You use data from a CSV or a text file to create entries and populate specified fields in Space. This means you can automatically transfer data from other systems (rather than entering the same data manually in Space).

The automatic CVS file synchronization process consists of four steps:

• Step one: Job configuration
• Step two: Mapping configuration
• Step three:Schedule
• Step four: Confirmation

Step one: Job configuration

To complete step one:

1. Select Tools > Scheduled jobs. The Scheduled jobs screen is displayed.

2. Click Add. The Add scheduled job dialog box is displayed.

3. Select CSV file synchronization from the drop-down list.

4. Click OK. The Job configuration screen is displayed.

CSV job configuration

5. Type a name for the job in the Name of scheduled job field.

6. Type the name of the file that you want to import in the Select file to import/synchronize field. You can click Verify to verify the file directory exists and is correct.

7. Select the appropriate format from the File format drop-down list.

8. Select the required number of rows by using the up and down arrows in the Skip rows field. This specifies the row in the file where you want to begin importing data.

9. Select either the Tabbed or Custom option. The Secondary separator and Text qualifier fields are automatically populated but you can change the characters in these fields if required. The secondary separator is used to separate each access level ID in the file. The text qualifier is used for text fields that contain spaces.

10. Select the Entity to import. Five entities can be selected: User, Door, Zone, User access level and Operator.

11. Select a partition from the Partition drop-down list if required.

12. Click Next step. The Mapping configuration screen is displayed.

Step two: Mapping configuration

To complete this step:

1. Click Add on the Mapping configuration screen. The number 1 is displayed in the Source fields column.

2. Click the arrow on the right-hand side of the entry to view the Destination fields drop-down list. The [Do not import] option is selected by default. The destination fields are the targeted Space options.

3. Select the destination field to which you want to map the data from the source field. The selected option is displayed in the Destination fields column.

CSV mapping configuration

4. Repeat steps 1, 2, and 3 until you have specified the mapping between all the appropriate source and destination fields and the order of the fields.

5. Click Next step. The Schedule screen is displayed.

Step three: Schedule

You can schedule CSV file synchronization to occur as frequently as required, for example, every 24 hours or every second. All the schedule steps for the jobs described in this section are done in the same way. See Step two: Schedule for more information and a description of the procedure you should follow.

Step four: Confirmation

All the confirmation steps for the jobs described in this section are done in the same way. See Step three: Confirmation for more information and a description of the procedure you should follow.

Automatic database table synchronization

Database table synchronization allows you to synchronize user data from external databases with the SALTO Space database. For example, in a university installation, you can synchronize with the data in a human resources database. You can access data stored in an external database and use it to create entries and populate specified fields in Space. This means you can automatically transfer data from other databases (rather than entering the same data manually in Space).

The automatic database table synchronization process consists of three steps:

• Step one: Job configuration
• Step two: Mapping configuration
• Step three: Schedule
• Step four: Confirmation

Step one: Job configuration

To complete Step one:

1. Select System > Scheduled jobs. The Scheduled jobs screen is displayed.

2. Click Add. The Add scheduled job dialog box is displayed.

3. Select DB table synchronization from the drop-down list.

4. Click OK. The Job configuration screen is displayed.

DB table job configuration

5. Type a name for the job in the Name of scheduled job field.

6. Select the appropriate data source type from the Data source type drop-down list. The available options SQL server, Oracle and ODBC data sources.

7. Enter the required information in the fields in the Connection parameters panel. The information you must enter in the Connection parameters panel varies depending on which option you select from the Data source type drop-down list. Type the name of the database table in the Table name field. The Separator field is automatically populated but you can change the character in this field if required.

8. Select the Entity to import. Five entities can be selected: User, Door, Zone, User access level and Operator.

9. Select a partition from the Partition drop-down list if required. See Partitions for more information about partitions. The data is only imported to the partition you select.

10. Click Next step. The Mapping configuration screen is displayed.

Step two: Mapping configuration

To complete this step:

1. Click Add on the Mapping configuration screen. The number 1 is displayed in the Source fields column.

2. Click the arrow on the right-hand side of the entry to view the Destination fields drop-down list. The [Do not import] option is selected by default. The destination fields are the available SALTO Space database fields to which you can import data. Once imported into the SALTO Space database, the information is then displayed in the appropriate field in Space.

3. Select the destination field to which you want to map the data from the source field. The selected option is displayed in the Destination fields column.

DB table mapping configuration

4. Repeat steps 1, 2, and 3 until you have specified the mapping between all the appropriate source and destination fields and the order of the fields. You must select the following options as destination fields to proceed to the next step:

• Ext ID
• Control field (to be processed by SALTO)
• Control field (processed date/time)
• Control field (error code)
• Control field (error message)

The system uses these fields to write a report after database table synchronization occurs. If all of these options are not selected, the synchronization job cannot be performed.

5. Click Next step. The Schedule screen is displayed.

Step three: Schedule

All the schedule steps for the jobs described in this section are done in the same way. See Step two: Schedule for more information and a description of the procedure you should follow.

Step four: Confirmation

All the confirmation steps for the jobs described in this section are done in the same way. See Step three: Confirmation for more information and a description of the procedure you should follow.

Automatic audit trail exports

You can export audit trail data from the SALTO Space database as a CSV file. This allows you to use the data in another system, for example, a time recording system.

The automatic audit trail export process consists of five steps:

• Step one: Job configuration
• Step two: Field configuration
• Step three: Mapping configuration
• Step four: Schedule
• Step five: Confirmation

Step one: Job configuration

To complete step one:

1. Select Tools > Scheduled jobs. The Scheduled jobs screen is displayed.

2. Click Add. The Add scheduled job dialog box is displayed.

3. Select Audit trail export from the drop-down list.

4. Click OK. The Job configuration screen is displayed.

'Job configuration' screen - Audit trail export

5. Type a name for the job in the Name of scheduled job field. The default option in the Type of file to export field is CSV file. This is the only file format currently supported.

6. Type a name for the file that you want to export in the File to export field, such as C:\SALTO\audit-trail, and follow the steps below:

• Press F2 to display the File path dialog box and insert macros in the file name if required. Using macros, for example, ($YEAR)_($MONTH)_($DAY), allows you to save the file with a unique name so it is not overwritten by the next file that is created.
• Double-click the appropriate macro to insert it in the file name. Each macro you insert is displayed in the file name in the File to export field.
• Click OK when you have finished inserting macros and the appropriate file name is displayed in the File to export field.
• You can click Verify on the Job configuration screen to verify the file directory exists and is correct.

The audit trail export file can be also sent out to a given email by activating the Send file by email option, which will show up three additional fields to fill in:

• To: The email address the file will be sent to must be defined here.
• Subject: This field can be filled in with a subject that will be included on the email title.
• Content: This field can be filled in with a suitable text that will be included on the email body.

7. Click Next step. The Field configuration screen is displayed.

Step two: Field configuration

To complete step two:

1. Select a format from the File format drop-down list on the Field configuration screen. This specifies the format of the file containing the exported audit trail data.

2. Select either the Tabbed or Custom option. This specifies how the audit trail data is stored in the file. The Separator and Text qualifier fields are automatically populated but you can change the characters in these fields if required.

3. Select the Include column names on first row checkbox if required. If you select this, the column names are included in the first row of the file.

4. Click Add in the Field configuration panel. The Select fields dialog box, showing a list of fields, is displayed.

'Select fields' dialog box - Audit trail exportation

The SaltoAutomaticExportOfAuditTrail document contains more information about these fields.

5. Select the required fields.

6. Click Accept. The selected fields are displayed in the Fields list on the Field configuration screen.

'Field configuration' screen - Audit trail export

The order of the fields in the Fields list determines the order in which the fields are exported. You can select fields and click the up and down arrows to change the order of the fields if required.

7. Click Next step. The Filter configuration screen is displayed.

Step three: Filter configuration

The filter configuration step allows you to filter the type of audit trail data that is exported within a specified time period. The default option is to export all of the audit trail data within the previous 12-month period.

You can filter audit trail events by:

• Cardholders and/or operators
• Access points, nodes, alarm inputs, and/or relays
• Operations
• Date and time period

'Filter configuration' screen - Audit trail exportation

To complete this step:

1. Click Add/Delete in the Who panel. The Add/Delete dialog box, which contains a list of cardholders and operators on two tabs, is displayed.

2. Select the required cardholders in the left-hand panel and click the arrow. The selected cardholders are displayed in the right-hand panel. You can hold down the Ctrl key while clicking the fields to make multiple selections. As soon as you select a cardholder, the default Any cardholder option is automatically moved to the left-hand panel. You can use the default option if you want to export audit trail data for all the cardholders in the system.

3. Click the Operators tab if you also want to filter by operator. A list of operators is displayed.

4. Select the required operators in the left-hand panel and click the arrow. The selected operators are displayed in the right-hand panel.

5. Click OK. The selected cardholders and operators are displayed in the Who panel.

6. Follow the same procedure described in the previous steps to add the access points, nodes, alarm inputs, and/or relays you want to filter to the Where panel.

7. Follow the same procedure described in the previous steps to add the operations you want to filter to the What panel.

8. Click Add/Delete in the When panel. The Add/delete periods dialog box, showing the default period, is displayed.

9. Click the Edit icon to change the date period and time interval if required. You can also click Add to add additional periods. For example, you can add a period to export the audit trail data between 09:00 and 11:00 each day within a specified date period, and add another period to export the audit trail data between 14:00 and 17:00 each day within the same date period.

10. Click OK when you have finished editing or adding periods. The changes are displayed in the When panel.

11. Click Next step. The Schedule screen is displayed.

Step four: Schedule

All the schedule steps for the jobs described in this section are done in the same way. See Step two: Schedule for more information and a description of the procedure you should follow.

Step five: Confirmation

All the confirmation steps for the jobs described in this section are done in the same way. See Step three: Confirmation for more information and a description of the procedure you should follow.

Automatic entity exports

You can export entities from the SALTO Space database as a CSV file. This allows you to use the data in another system, for example, a time recording system.

The automatic entity export process consists of four steps:

• Step one: Job configuration
• Step two: Field configuration
• Step three: Schedule
• Step four: Confirmation

Step one: Job configuration

To complete step one:

1. Select Tools > Scheduled jobs. The Scheduled jobs screen is displayed.

2. Click Add. The Add scheduled job dialog box is displayed.

3. Select Entity exportation from the drop-down list.

4. Click OK. The Job Configuration screen is displayed.

'Job configuration' screen - Automatic entity exports

5. Type a name for the job in the Name of scheduled job field. The default option in the Type of file to export field is CSV file. This is the only file format currently supported.

6. Type a name for the file that you want to export in the File to export field, such as C:\SALTO\entity-export, and follow the steps below:

• Press F2 to display the File path dialog box and insert macros in the file name if required. Using macros, for example, ($YEAR)_($MONTH)_($DAY), allows you to save the file with a unique name so it is not overwritten by the next file that is created.
• Double-click the appropriate macro to insert it in the file name. Each macro you insert is displayed in the file name in the File to export field.
• Click OK when you have finished inserting macros and the appropriate file name is displayed in the File to export field.
• You can click Verify on the Job configuration screen to verify the file directory exists and is correct.

7. Click Next step. The Field configuration screen is displayed.

Step two: Field configuration

To complete this step:

1. Select a format from the File format drop-down list. This specifies the format of the file containing the exported audit trail data.

2. Select either the Tabbed or Custom option. This specifies how the audit trail data is stored in the file. The Separator and Text qualifier fields are automatically populated but you can change the characters in these fields if required.

3. Select the Include column names on first row checkbox if required. If you select this, the column names are included in the first row of the file.

4. Click Add in the Field configuration panel. The Select fields dialog box, showing a list of fields, is displayed.

'Select fields' dialog box - Automatic entity exports

5. Select the required fields.

6. Click Accept. The selected fields are displayed in the Fields list on the Field configuration screen.

'Field configuration' screen - Automatic entity exports

The order of the fields in the Fields list determines the order in which the fields are exported. You can select fields and click the up and down arrows to change the order of the fields if required.

7. Click Next step. The Filter configuration screen is displayed.

Step three: Schedule

All the schedule steps for the jobs described in this section are done in the same way. See Step two: Schedule for more information and a description of the procedure you should follow.

Step four: Confirmation

All the confirmation steps for the jobs described in this section are done in the same way. See Step three: Confirmation for more information and a description of the procedure you should follow.

Automatic users inactivity exportation

You can export users inactivity from the SALTO Space database as a CSV file. This allows you to use the data in another system, for example, a time recording system.

The automatic users inactivity exportation process consists of four steps:

• Step one: Job configuration
• Step two: Field configuration
• Step three: Schedule
• Step four: Confirmation

Step one: Job configuration

To complete step one:

1. Select Tools > Scheduled jobs. The Scheduled jobs screen is displayed.

2. Click Add. The Add scheduled job dialog box is displayed.

3. Select Users inactivity exportation from the drop-down list.

4. Click OK. The Job configuration screen is displayed.

'Job configuration' screen - Automatic users inactivity exportation

5. Type a name for the job in the Name of scheduled job field. The default option in the Type of file to export field is CSV file. This is the only file format currently supported.

6. Type a name for the file that you want to export in the File to export field, such as C:\SALTO\users-inactivity, and follow the steps below:

• Press F2 to display the File path dialog box and insert macros in the file name if required. Using macros, for example, ($YEAR)_($MONTH)_($DAY), allows you to save the file with a unique name so it is not overwritten by the next file that is created.
• Double-click the appropriate macro to insert it in the file name. Each macro you insert is displayed in the file name in the File to export field.
• Click OK when you have finished inserting macros and the appropriate file name is displayed in the File to export field.
• You can click Verify on the Job configuration screen to verify the file directory exists and is correct.

7. Click Next step. The Field configuration screen is displayed.

Step two: Field configuration

To complete step two:

1. Select a format from the File format drop-down list. This specifies the format of the file containing the exported audit trail data.

2. Select either the Tabbed or Custom option. This specifies how the audit trail data is stored in the file. The Separator and Text qualifier fields are automatically populated but you can change the characters in these fields if required.

3. Select the Include column names on first row checkbox if required. If you select this, the column names are included in the first row of the file.

4. Click Add in the Field configuration panel. The Select fields dialog box, showing a list of fields, is displayed.

'Select fields' dialog box - Automatic users inactivity exportation

5. Select the required fields and click OK. The selected fields are displayed in the Fields list on the Field configuration screen.

'Field configuration' screen - Automatic users inactivity exportation

The order of the fields in the Fields list determines the order in which the fields are exported. You can select fields and click the up and down arrows to change the order of the fields if required.

6. Click Next step. The Schedule screen is displayed.

Step three: Schedule

All the schedule steps for the jobs described in this section are done in the same way. See Step two: Schedule for more information and a description of the procedure you should follow.

Step four: Confirmation

All the confirmation steps for the jobs described in this section are done in the same way. See Step three: Confirmation for more information and a description of the procedure you should follow.