Exporting Time to Sympaq

This help page will address a number of topics having to do with exporting time data from Unanet into Sympaq.  

Topics covered on this help page include:

• Assumptions

• Export the Unanet Time Data

• Import Time Cards (Unanet Time Data)

• Copy Imported Time Cards (Unanet Time Data)

• Verify Time Import Success

Assumptions

A Unanet to Sympaq Time Export template file has already been loaded into your Unanet system and customized to meet your Unanet and Sympaq SQL configuration.

Export the Unanet Time Data

As a Unanet Administrator, export the .csv file out of Unanet by clicking on:  Admin > Export > Blue Sideways Triangle next to the Unanet to Sympaq Time Export file (export file name may vary) > select the appropriate criteria (Date Range, etc) > Run Export.

Once the export is run, scroll to the bottom of the page and click:  ’Download the file’.  

Save the file (.csv format) in a location where you may find it later for import into Sympaq SQL.

Import Time Cards (Unanet Time Data)

Login to your Sympaq SQL system as an Administrator

Import the .csv file into Sympaq by clicking on:  External > Electronic Time Cards > Process > Import Time Cards

• Click on the button labeled ’…’

• Find and select the .csv file that you wish to import

• Click ’Open’

• Click ’OK’

After you click on ’OK’ you should receive the following message:

Copy Imported Time Cards (Unanet Time Data)

Copy the imported Unanet Time Cards by clicking on:  External > Electronic Time Cards > Process > Copy Imported Time Cards

Click ’OK’

Verify Time Import Success

To verify that the imported time is on the timecard, click on:  Modules > Labor & Leave > Time Cards > Browse > Click on the appropriate Time Card