Construct CT - Offline Data Management

Overview

This article outlines the rules and features supported in Offline mode in Construct CT.

For more information, please refer to Construct CT - Offline Support.

General Rules

The following rules apply when creating, updating, and deleting records while offline.

New Records

Without uniqueness restrictions:

  • After a new record is created offline and the device comes back online, the local record will be created on the server.

  • If a “similar” record has already been created, the entry will be “duplicated”

  • No conflicts will be raised.

With uniqueness restrictions:

  • After a new record is created offline and the device comes back online, the local record will fail to upload.

  • A conflict resolution will be needed, which means an action is expected from the user.

  • Conflicts will be raised.

  • Users will have 3 possible actions to take to resolve the conflict:

    1. Rename the unique field: The new record will then be uploaded to the server.

    2. Discard the local record: The new record will be locally deleted.

    3. Merge the local and server record: All child records of the local record will be attached to the server record.

      • If child records don’t exist in the server, they will be inserted.

      • If child records exist in the server, they will be updated.

Updated Records

  • When a record is updated offline and the device comes back online, the local record will update the server record.

  • The server record will be updated regardless of being changed by another user in between the device going offline and coming back online.

  • If the server record has been deleted, the local record will recreate that record on the server with the data as it exists in the device (as locally changed while offline).

  • No conflicts will be raised.

Deleted Records

  • When a record is deleted offline and the device comes back online, the system will delete the server record.

  • The server record will be deleted regardless of being changed by another user in between the device going offline and coming back online.

  • If the server record has already been deleted, the local record will be deleted seamlessly.

  • No conflicts will be raised.

Data Availability

This section describes the features supported in Offline mode for Construct CT.

General

  • Main data objects: Fully supported.

  • LOV fields: Based on favorites.

Specific Screens

Home

  • Project field LOV: Only favorites will be available.

  • Crew field LOV: Only favorites will be available.

  • Information Dashboards: Not supported offline.

Schedules Maintenance

  • Fully supported.

  • Schedule code: Must be unique.

  • Online records will be available offline for update/deletion.

  • New records will be available for creation.

Crew Maintenance

  • Partially supported.

    • Online records will be available offline for update/deletion.

    • New records will be available for creation.

  • General Info:

    • Crew Code: Must be unique.

    • Schedule LOV: Only favorites will be available.

    • Responsible Person LOV: Only favorites will be available.

    • Foreman LOV: Only favorites will be available.

  • Members:

    • Online records will be available offline for update/deletion.

    • Adding new members LOV: Only favorites will be available.

    • Adding union LOV: Fully supported; all records available.

    • Adding trade LOV: Fully supported; all records available.

    • Adding equipment LOV: Only favorites will be available.

  • Activities:

    • Online records will be available offline for update/deletion

    • Adding new activities:

      • Company LOV: Only favorites will be available

      • Job LOV: Only favorites will be available

      • Cost Code LOV: Only favorites will be available

      • Category LOV: Only favorites will be available

      • Sector LOV: Only favorites will be available

      • Schedule LOV: Only favorites will be available

      • WBS Fields: Not supported offline.

  • Equipment:

    • Online records will be available offline for update/deletion.

    • Adding new equipment:

      • Equipment LOV: Only favorites will be available.

      • Transaction LOV: Only favorites will be available.

Timesheet

  • Partially supported.

  • Online records will be available offline for update/clear.

  • New records will be available for creation.

    NOTE: Time entry restriction against Trade by Job Union Location is not supported offline. When the device comes back online, any time entry against a trade not part of a trade class setup for the Union Location assigned to the job will result in conflict, and the only solution will be to discard that record.

  • General Info

    • Timesheet header date: Must be unique.

  • Crew Tab: Members

    • Online records will be available offline for update/deletion.

    • Adding ad-hoc members (LOV): Only favorites will be available.

    • Adding union (LOV): Fully supported; all records available.

    • Adding trade (LOV): Fully supported; all records available.

    • Adding equipment (LOV): Only favorites will be available.

  • Crew Tab: Activities:

    • Online records will be available offline for update/deletion.

    • Adding new activities (LOV): Only favorites will be available.

    • Creating new activities:

      • Company LOV: Only favorites will be available.

      • Job LOV: Only favorites will be available.

      • Cost Code LOV: Only favorites will be available.

      • Category LOV: Only favorites will be available.

      • Sector LOV: Only favorites will be available.

      • Schedule LOV: Only favorites will be available.

      • WBS Fields: Not supported offline.

  • Crew Tab: Time Entries:

    • Online records will be available offline for update/deletion of time.

    • Adding hour types (LOV): All hour types available for E-Time will be shown.

      NOTE: This LOV will not be restricted by favorites and will not be restricted by all payroll system setup related to hour types. When the device comes back online, any hour type used that is restricted to the employee will result in conflict.

  • Equipment Tab: Equipment

    • Online records will be available offline for update/deletion.

    • Adding new equipment:

      • Equipment LOV: Only favorites will be available.

      • Transaction LOV: Only favorites will be available.

  • Equipment Tab: Time Entries:

    • Online records will be available offline for update/deletion of time.

    • Adding/changing transaction (LOV): Only favorites will be available.

  • Expenses Tab: Expenses

    • Online records will be available offline for update/deletion.

    • Adding new expenses (LOV): Only favorites will be available.

    NOTE: Rate calculation for rate-based expenses is not supported offline.

Crew and Foreman Checklists

Supported offline.

Employee Sign-off (+Checklist)

Not available offline yet (coming soon).

Stand-alone Employee Dashboard to enable Sign Off (+Checklist)

Not available offline yet (coming soon).

Weekly Dashboard

Not supported offline.

Real-Time Dashboard

Not supported offline.

Productivity Dashboard

Not supported offline.