Deltek Ajera Cloud Time Entry Export

If you are using Deltek Ajera Cloud without ODBC, you can set up a custom report to export time for importing into Mosaic.

Create a Table Widget

1. Navigate to the Widget Designer by selecting the Ajera logo > Hammer & Wrench icon

2. In the Design Mode, you will see all the tabs available to your users + a new modal called Tab Properties

3. Select Add Tab to create a new tab

4. You can either copy an existing widget (by selecting the ^ icon and Copy) or create a new widget (by clicking on + Add Widget under the Tab Properties)

5. Select Timesheet for the Widget Base

6. Add in the following Columns and Formulas to your Widget:

Add the Standard Columns:

• Employee
• Date
• Project ID
• Project Description
• Regular Hours
• Billed Rate
• Activity
• Activity Type

Add the following three Formulas for the Email, Phase Name and Phase Number custom columns:

• Email: select vecemail from AXVEC where VECKEY = [employee key]

• Phase Name: select prjDescription from axProject where prjKey = [Phase Key] and prjIsDetailPhase = 1

• Phase Number: select prjID from axProject where prjKey = [Phase Key] and prjIsDetailPhase = 1

7. Click OK and select Exit Design Mode on the Tab Properties

Exporting a table widget to Excel

1. Click on the ^ icon on the top right of your Table Widget and select Export Excel (.xlsx format)

2. Open the .xlsx file in Excel and click "Save as" and select CSV UTF-8 (.csv) to save your file in .csv format

Please note:

• Only include data that has already been imported into Mosaic in the report for:

  • Employees
  • Projects
  • Phases

• Ensure your data is accurate and all Employees, Projects and Phases are spelled correctly and match what's in Mosaic.

• Export should be in a .csv format, or be converted to a .csv format before trying to import it into Mosaic

For more information, please refer to the Ajera Learning Center for:

• Creating a table widget
• Editing a table widget
• Exporting a table widget to Excel

Timesheet Import Guide

Step 4

Schedule a call with your Customer Success Manager to review your Timesheet Import

With your CSV exported, you are now prepared to upload your timesheet time.
Simply schedule a call with your Customer Success Manager via the “Book A Meeting” link included in their
email signature to review!