Skip to Content

Jitterbit AcuTrack App

Overview

Jitterbit provides the AcuTrack app through Jitterbit Marketplace. Built with Jitterbit App Builder, it is a mobile-first asset tracking app for managing physical inventory. Teams check assets in and out, track their location and department, schedule preventative maintenance, and scan asset tags with a mobile device camera. The data model is generic, so the same app can track IT hardware, tools, equipment, or fleet vehicles.

You download the app as an App Builder release package (an .LP file) from Marketplace and install it into your own App Builder instance, where you can configure and extend it to fit your process.

This page describes how the app works, its core features and data model, and covers the prerequisites, how to download and install it, how to configure it for your environment, how access is controlled, the business rules it uses, and common troubleshooting steps.

How it works

At a high level, an administrator sets up the asset catalog, users record asset movements (including from a mobile scan), and the app updates each asset and drives the tracking dashboards:

flowchart TD A["Administrator configures
asset types, locations,
departments, and statuses"] --> B["Add assets
to the registry"] B --> C["User checks an asset
in or out"] B --> F["Scan asset QR code
on mobile"] F --> C C --> D["Movement logged:
location, department,
timestamp, optional photo"] D --> E["Asset status and
location updated"] B --> G["Maintenance interval
schedules service"] G --> H["Maintenance calendar
and repair movements"] E --> I["Dashboard: status totals,
map, and maintenance calendar"] H --> I

Core features

When you install and configure AcuTrack, it provides the following capabilities:

  • Asset lifecycle management: Administrators define asset categories, departments, locations, and operational statuses from a single configuration page.

  • Check-in and check-out: Users record asset movements from the home page. Each movement tracks the from and to location and department, a timestamp, the user's session, and optional photo verification at checkout and return.

  • Preventative maintenance scheduling: Each asset type has a maintenance interval (in days). The app builds a maintenance calendar from that interval and each asset's last maintenance date. Setting an asset type's interval to 0 suppresses maintenance scheduling for that type.

  • Mobile QR scanning: On a mobile device, a dedicated scan page uses the device camera to read an asset tag's QR code and stage a record for a quick tracking update.

  • Dashboards: The home dashboard shows asset totals by status, a map panel for geographic distribution, and a calendar for upcoming maintenance. All are filterable by location, department, status, and asset type, and support drill-down to the underlying asset list.

Data model

AcuTrack stores its tracking data in its own tables, which install as an App Builder data source. Although the app is named AcuTrack, this data source is named Asset Tracking. The app does not require an external database connection; it reads your authenticated App Builder users through a native connection to your App Builder instance.

Table Purpose
Asset Master registry of tracked items, including tags, descriptions, and current location.
AssetType Asset categories and their preventative maintenance intervals.
AssetMovement Transactional ledger of check-ins, check-outs, and repairs, with user and image metadata.
MovementType Validated transaction types (Check-In, Check-Out, Repair).
Status Operational states (for example, Available, Maintenance), with color and action-button label settings.
Location Site index, including addresses, region data, and map codes.
Department Organizational units used for ownership and reporting.
Scan Temporary staging table for camera QR and barcode payloads.
Session Per-user runtime state and dashboard filter values.
User User profile and identity data.
VinylAuditLog Immutable audit log of field changes across the app.
Parameter Global settings, version data, and defaults.
Loop Numeric interval utility used to drive background logic loops.

The Status, MovementType, Location, Department, and AssetType tables ship with sample lookup data so the app works immediately after install.

Relationships

The main foreign-key relationships in the data model are as follows. All foreign keys are indexed.

Table References
Asset Status, Location, Department, AssetType
AssetMovement Asset, Location (from and to), Department (from and to), User, MovementType
MovementType Status
Scan Asset
Session Location, Department, AssetType, Status

Prerequisites

To use AcuTrack, you need the following:

  • A Jitterbit Harmony license with access to App Builder. This enables the Marketplace download; if your organization is not licensed for App Builder, the Download app action is replaced by a Get app request action (see Download and install).

  • An App Builder instance running App Builder 4.63, the version the current package is built for. Each package installs only on its exact App Builder version; if your instance is on a different version, contact Jitterbit support to request a matching package.

  • A PostgreSQL database for your App Builder instance.

  • For QR scanning, a mobile device with a camera, and camera access allowed for the App Builder host in the mobile browser. See related troubleshooting.

Download and install

Download the app from Marketplace

  1. Log in to the Harmony portal at https://login.jitterbit.com and open Marketplace.

  2. Locate the app named AcuTrack. You can use the search bar or, in the Filters pane under Type, select App to show only apps.

  3. Click the app card to open the Details panel. Review the app's Requirements (the App Builder version and database it needs).

  4. Click the app's Go to documentation link to open this documentation in a separate tab, and keep it open for reference.

  5. Do one of the following, depending on whether your organization is licensed for App Builder:

    • Download app: If your organization is licensed for App Builder, click Download app, on either the app card or the Details panel. Your browser saves the .LP file to its download location, and an App Builder file downloaded successfully notification confirms the download.

    • Get app: If your organization is not licensed for App Builder, the action is labeled Get app. The Details panel shows a message that an App Builder license is required, with a Submit button. Click Submit to send a request for a representative to contact you about App Builder; a Message successfully sent notification confirms it.

Install the app in App Builder

Install the downloaded .LP file into your App Builder instance:

  1. Log in to App Builder and go to the IDE.

  2. Under Deploy, click Install Release.

  3. Click + Package, then Browse and select the .LP file you downloaded.

  4. Click Save. The Release panel displays the package information, then close the Package dialog.

  5. Confirm the details are correct, then click Install.

To preview a package's contents before you install it, click the Manifest button.

Modifying the app in a development environment

The app's data source installs sealed. If you deploy the app to a development environment and intend to modify it, unseal the data source so you can edit the app's objects. Leave it sealed in QA and production to preserve equivalence across environments. See Seal or unseal a data source.

Configuration and setup

After you install the app into a new environment, complete the following steps to make it ready to use:

  1. Assign users to groups. Add your users to the appropriate access group, either AcuTrack Administrator or AcuTrack User. See Security and access.

  2. Initialize user profiles. Users are registered automatically on first access. On the Configuration page, assign each user's department and contact number.

  3. Set the dashboard map region. The map panel defaults to a county map of Massachusetts. To deploy in another region, open the map configuration and replace the map data files with those for your region.

  4. Customize lookup labels. You can rename a Status record or edit its description to match your terminology. Do not delete the Status records, because background logic references their IDs through enum values.

  5. Customize action-button labels (optional). The Status table has two columns that set the labels on the action buttons shown for an asset: MoveLabel for the movement button (check-in and check-out) and MaintenanceLabel for the maintenance button (repair and return). If a status leaves one of these columns blank, the matching button is hidden for assets in that status. The default labels are:

    Status MoveLabel MaintenanceLabel
    Available Check-Out Repair
    Checked Out Check-In —
    Deactivated — —
    Maintenance — Return

Security and access

AcuTrack uses App Builder role-based security with two access groups, AcuTrack Administrator and AcuTrack User. Access to each area is as follows:

Area AcuTrack Administrator AcuTrack User
Asset and movement tracking (home page) Full access Create, update, and view
Analytical dashboards (maps and schedules) Full access Read-only, can change local filters
Activity log Full access Read-only
Configuration page and lookups Full access No access (menus hidden)

Historical changes are preserved in the VinylAuditLog audit log, so past movements and edits remain traceable regardless of a user's current access.

Business rules

AcuTrack's logic is implemented as App Builder business rules. Rule names follow App Builder's Target (Purpose or Subtype) Descriptor convention, so the leading word identifies the table the rule acts on. The tables below list the rules by functional area to help you locate and understand them when you extend the app.

Asset and maintenance rules

Rule Purpose
Asset (Business Object) Master data source for assets.
Asset (List) Asset selector list used across forms and grids.
Asset (Assets Tile) Feeds the mobile home-page asset tile.
Assets (By Status) Aggregates asset counts by status for the dashboard.
Asset (Update) Asset Movement Updates an asset's current location, department, and status when a movement is logged.
Asset (Maintenance Calendar) Builds recurring maintenance events from the asset type's interval and the asset's last maintenance date.
Asset (Maintenance Calendar with Today) Unions maintenance events with the current date so the calendar centers on the current month.
Asset (Calendar) (Upcoming Maintenance) Isolates upcoming or overdue service windows.

Movement rules

Rule Purpose
AssetMovement (Business Object) Data source for the movement ledger.
AssetMovement (Activity Log) Aggregates check-in, check-out, and repair events into an activity stream.
AssetMovement (Default) Field Activity Auto-populates tracking values, timestamps, and the user session on check-in and check-out.
AssetMovement (Default) Maintenance Activity Sets baseline values when an asset enters a repair cycle.
AssetMovement (Repair Note Visibility) Makes the repair note field visible and required during maintenance.

Scan rules

Rule Purpose
Scan (Business Object) Data source for the scan staging table.
Scan (Cram) Inserts a temporary scan record tied to the user's session.
Scan (Update) AssetID Matches a scanned QR code to the asset tag and returns the internal asset ID.

Session and filter rules

Rule Purpose
Session (Business Object) Manages the active user's session state and defaults.
Session (Clear Filters) Page rule that resets the dashboard filters.
Session (Update) Clear Filter Clears the location, department, status, and asset-type filter values.

Utility rules

Rule Purpose
Parameter (Today) Injects the current system date for calendar rendering.
User (Business Object) Manages user profile and identity data.
User (List) User selector list used across the app.

Troubleshooting

The scan page does not open the camera

  • Symptom: Opening the mobile scan page does not start the camera, or the scan area stays blank.

  • Possible cause: The mobile browser has blocked camera access for the App Builder host domain.

  • Resolution: In the mobile browser's site permissions, locate the App Builder host domain and set camera access to Allow.

A new asset does not appear on the maintenance calendar

  • Symptom: A newly added asset does not generate events on the preventative maintenance calendar.

  • Possible cause: The asset's asset type has a maintenance interval of 0, which suppresses scheduling for that type.

  • Resolution: On the Configuration page, open the asset type and set its maintenance interval to a positive number of days (for example, 30 for monthly service).

The dashboard map does not render

  • Symptom: The dashboard map panel does not display, or returns a data error.

  • Possible cause: The map codes on your Location records do not match the keys expected by the map data.

  • Resolution: Verify that each location's map code matches the string keys defined in the map data for your region.

For further help, review your App Builder logs and contact Jitterbit support.