Importing and Exporting Transaction Files

Using Integration Manager, you can perform imports and exports of device transaction files in Device Manager. You can export a log of all the transactions that are collected from the device. The exported transactions from one log file are tagged to prevent the same transaction from being exported twice.

Notes about the import and export processes:

• Using Event Manager, schedule data recovery backups for every 15 minutes. If you are using a test system, schedule your data recovery for once a day.
• If you are exporting transaction files, device transactions for a specified device or device group are exported to a mapped folder.
• If you are importing transaction files, the transactions from a file in the mapped export folder are imported into Device Manager and processed in the same way as transactions coming from a device.

The following tasks can be performed using the .KNX files found on the Product DVD located at Service/Transaction_Access:

• Import_DevTrx_By_FileName.KNX — Use the Import From XML File Link to import device transactions.
• Export_DevTrx_By_DeviceNum.KNX — Use the Export By Device ID Link to export device transactions from a specific device.
• Export_DevTrx_By_GroupName.KNX — Use the Export By Device Group Link to export device transactions from a device group.

Important: After you install Interface Designer, create a directory for mapped folders:
C:\kronos\interfacedesigner\Transaction_Access\<filename>

Detailed documentation of these processes is delivered as part of the Device Manager application, along with the links. You can refer to the following manuals for Integration Manager.

Performing import and export of device transactions

Prepare to import and export device transactions:

• Configure and deploy the .KNX files

Configure Integration Manager and Interface Designer for use with Device Manager

Perform these steps in Setup > Data Integration.

Set up the Mapped Folder and Connections: Integration Manager uses Mapped Folders as a reference in links to a particular folder that is configured on the server. All text files that are referenced by Integration Manager must be placed in a mapped folder.

1. Mapped folder setup

   1. Select Mapped Folders
   2. Click New
   3. Enter the Name. For example, DevMgrFiles.
   4. Enter the Path. For example: C:\Kronos\InterfaceDesigner\Transaction_Access\DevMgrFiles
   5. Click Test
   6. Ensure that the message “The folder” <path> “has write access” is returned
   7. Click Save and Return

2. Connection Setup:

   1. Select Connections
   2. Click New
   3. Select the type “wfc XML API”
   4. Enter the Name “API Connection”
   5. Enter the description: API Connection used for Device Manager Interfaces
   6. Enter the Server Name (Example: kvm-us-yourname)
   7. Enter the Instance Name. Note: The instance name is case sensitive and is a user name to log into the application, not the database.
   8. Enter the Password associated with the username
   9. Click Test
   10. Ensure that the message “Successful” is returned
   11. Click Save and Return

Configure and deploy the .KNX files

Navigate to the Windows directory where the KNX files are located. For Example: C:\kronos\interfacedesigner\Transaction_Access\DevMgrFiles.Double-click the link to open the file in Interface Designer.

Configure the appropriate settings on the Source tab, Output tab, and Functions & Variables tab:

1. Click the Source tab

   1. Select the "UKG Workforce Central XML API" Connection.
   2. Verify the database version is correct or select the correct one from the list.

2. Click the Output tab

   1. Select the mapped folder that was set up earlier (DevMgrFiles).

3. Click the Functions & Variables tab

   1. Double click the ‘Action’ column on the variable :groupName or :DeviceNum
   2. Select ‘Static text’ and OK
   3. Enter the Group name or Device Num desired, Click OK and SAVE link

4. Create the corresponding interface

   1. Click the Make Interface button and a new KNI file will be created
   2. Click on the General tab and in the Interface Name box give the interface a short descriptive name (This is the Interface Name that will display on the Data Integration interface list).
   3. Save the Interface

5. Deploy interface from Interface Designer to Integration Manager

   1. The results of the run will be posted in the instance Data Integration Results tab.
   2. The file: “exported_<:groupName>_<:dateTime>.xml will be created in the mapped folder.
   3. This file will be used as the source for the next link Import_DevTrx_By_FileName.KNX
6. Run the interface.