Install Clock Administration

1. Right-click on Signature Clock Administration xx-x-xx.exe and choose Run as Administrator.
2. In the Clock Administration Setup window, choose Next.
3. Accept the End-User License Agreement and then choose Next.
4. In the Select Installation Folder window, accept the default location or navigate to the install location and then choose Next.
5. In the SQL Database window, enter the following fields:
   1. SQL Instance: Enter the server name (or choose the ellipsis button to search for a server name).

   2. System Database: Enter the system database name. This defaults to DYNAMICS.

      If your database name is different, you will need to update the ClockAdmin.exe.config file in \Program Files (x86)\Signature\Clock\Clock Administration.

   3. Username: Displays the SQL user name.
   4. Password: Enter the SQL user name password.
6. Choose Next.
7. In the Companies and eTimeTrack User window, choose the Company Database(s) and validate the eTimeTrack user by entering the Password.
8. Choose Next.
9. Choose Install.
10. Choose Finish.

Verify .NET Features Installed

1. Access Administrative Tools.
2. Double-click Internet Information Services (IIS) Manager.
3. Expand Sites.
4. Expand Default Web Site.
5. Choose ClockService and on the far-right pane, choose Browse *:80 (http).
6. In the browser window, choose ClockService.svc.
   
7. Choose ClockService.svc.
8. The Service 1 Service page displays in your browser.
9. If you do not see the Service1 Service page, verify that the following WCF Services are installed with .Net Framework. Install the features if not already installed. Open Server Manager > Click Manage > Choose Add Roles and Features and navigate to Features. Expand .NET Framework and then expand WCF Services.
   1. HTTP Activation
   2. Named Pipe Activation
   3. TCP Activation
   4. TCP Port Sharing

Verify jx* View Counts

Run the following script against your company's database Microsoft SQL Server Management Studio to obtain a count of employees, activities, cost code labor, cost code expense, pay code labor, pay code expense, and equipment. This will provide an overview of how much data you will be uploading to the Journyx cloud.

SELECT
(SELECT COUNT(*) FROM jxEmployee) AS EmployeeCount,
(SELECT COUNT(*) FROM jxJobServiceCall) AS ActivityCount,
(SELECT COUNT(*) FROM jxCostCodeLabor) AS CostCodeLaborCount,
(SELECT COUNT(*) FROM jxCostCodeExpense) AS CostCodeExpenseCount,
(SELECT COUNT(*) FROM jxPayCodeLabor) AS PayCodeLaborCount,
(SELECT COUNT(*) FROM jxPayCodeExpense) AS PayCodeExpenseCount,
(SELECT COUNT(*) FROM jxEquipmentGLAccount) AS EquipmentCount

SELECT [Employee], COUNT([Job Number]) AS JobApptCount FROM jxJobEmployees GROUP BY [Employee]
SELECT [Employee], COUNT([Service Call]) AS ServiceCallApptCount FROM jxServiceCallEmployees GROUP BY [Employee]
SELECT [Project Manager], COUNT([Job Number]) AS JobCount FROM jxJobProjectManagers GROUP BY [Project Manager]

Verify the TimeTrack Service URL 

Please verify that the TimeTrack Service URL that is stored in the Clock Service web.config file is pointing to the correct server. To verify this is correct, copy and paste the URL into a browser window and navigate to see if it resolves without error.

<applicationSettings>
<Key2Act.Clock.Services.Properties.Settings>
<setting name="Key2Act_Clock_Services_WebReference_TimeTrackService" serializeAs="String">
<value> http://{servername}/TimeTrackService/TimeTrackService.asmx </value>
</setting>
</Key2Act.Clock.Services.Properties.Settings>
</applicationSettings>