Deltek Ajera Cloud Time Entry Export

If you are using Deltek Ajera Cloud 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
25482548
  1. In the Design Mode, you will see all the tabs available to your users + a new modal called Tab Properties
25582558
  1. Select Add Tab to create a new tab
25442544
  1. 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)
25482548
  1. Select Timesheet for the Widget Base
25442544 10141014
  1. 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
25382538

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

  • Email: select vecemail from AXVEC where VECKEY = [employee key]
15981598
  • 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

15981598
  1. 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:

Timesheet Import Guide

FieldsGuideExample
EmployeeName of the staff memberRobert Smith
DateDate of the time entry01.12.2021
Project IDProject Number/Identifier210050
Project
Description
Name of of Project. This must
match the Project Name as in
Mosaic exactly.
125 Bluestone Way
Regular HoursTotal hours of work associated
with time entry
6
Billed RateBillable rate for the time entry$275
ActivityAlso known as Labor codes,
Activities or Service Items.
If your Mosaic budgets
have existing Work
Categories
- Ensure each
time entry includes the
Work Category the time is
associated with. New Work
Categories will be created
from the import template if
a match isn’t identified on
the project
If your Mosaic budgets
don’t have Work Categories

- time entries will be
imported, no Work
Categories will be created
on your budget
201 Meeting With Client
Activity TypeWhether time entry is Billable or
Non-Billable
True/False (True/False
Format is required)
EmailEmail address for the employee[email protected]
Phase NameProject Phase Name to which time is
being entered
Schematic Design
Phase NumberProject Phase Number to which time is being entered100

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!