Configure data Sources and schedule imports
Set up the data source for the integration framework (for example, badging spoke data) and schedule the import job to retrieve data from the data source periodically.
Before you begin
Role required: sn_wsd_wc.admin
Procedure
Navigate to All > System Import Sets > Data Sources.
Open the data source form by selecting Create New.
Import the badging data record of employees to Workplace Connectors by selecting the imported file (for example, the CSV badging file).
On the form, fill in the fields.
| Field | Description |
|---|---|
| Name | Name for the data source. |
| Import set table label | Label for the import set table. For example, Badging Data. |
| Import set table name | Name of the import set table. For example, badging\_data. |
| Type | Option to select the connection type from the source to the Badging Data table. For example, select File. |
| File retrieval method | Option to select the appropriate method from the drop-down list to import the file.For example, SFTP, FTP, and so on. |
| Format | Option to indicate the data format type. For example, CSV. |
Select Save.
Navigate to All > Scheduled Import Sets > Scheduled Imports.
Select Create New.
Configure the scheduled job according to your requirements, including the frequency of execution, and mapping to the data source.
On the form, fill in the fields.
| Field | Description |
|---|---|
| Name | Name of the installed workplace hardware,sensor data provider, or spoke. For example, occupancy sensor, badging spoke data, and so on. |
| Data Source | The source data table \(Badging Data table\) and the target table \(Employee Attendance Data table\). |
| Run as | User that executes the scheduled job. For example: System Administrator. |
| Run | Desired import frequency for the scheduled job. For example, Daily. |
| Daily | The time at which the scheduled job should be imported. For example: 10:30:00 |
- Select Execute Now.
Parent Topic:Setup Workplace Connectors for badging data
Previous topic:Setup Workplace Connectors for badging data
Next topic:Create a badging data provider