Adding Trucks to Asset Panda

Overview

CRST is currently the only customer actively using Asset Panda to pair and unpair trucks. For this process to work, you must first add the truck as a Vehicle in Asset Panda. Customers cannot add assets themselves—only Maven can add trucks to Asset Panda.

If you enter even one value incorrectly, Maven and Asset Panda will not sync, and pairing/unpairing will fail. Follow these steps carefully.

Before You Start

You must be able to log in to:

1. CRST Production

2. Asset Panda

3. Maven Production DB – SQL (Read access)

ModSquad cannot do this work. They do not have access to Asset Panda or SQL.

Step 1: Get the Maven Vehicle Asset ID from Maven Manager

1. Go to Maven Manager:
   Maven Machines | Sign In

   • Username: crstexp@mavenmachines.com

   • Password: crstexp

2. Go to Fleet Administration → Vehicles.

3. Search for the truck by truck number and open that vehicle.

4. Look at the browser URL for that vehicle page.
   Copy the long ID after the last / (for example):

   537d9c53-dc72-4aed-8c51-e5329c8947b6

   This value is the Maven Vehicle Asset ID (assetId).
   You will use it in SQL and in Asset Panda.

Step 2: Look Up the Truck in SQL (Maven Production – Read)

1. Connect to the Maven Production SQL database (read-only).

2. Run this query, replacing the value in quotes with the assetId you copied:

    

    

   SELECT * FROM company_assets_service.powerUnit WHERE assetId = 'acf5699b-6652-4d8d-9341-f1aaea5af0eb';

3. Run the query.

4. In the results, confirm that powerUnitNumber matches the truck number from the request/ticket.

5. Keep this result open. You will copy several fields into Asset Panda:

   • powerUnitNumber

   • model

   • vin

   • assetId

   • powerUnitId

   • make

   • year

Step 3: Add the Truck as a Vehicle in Asset Panda

1. Log in to Asset Panda.

2. Go to the Vehicles tab.

3. On the far right, click Add New.

4. Fill in these fields:

   • Vehicle Id = powerUnitNumber

     • Copy from SQL.

   • Customer = CRST The Transportation Solution Inc. (723)

     • Select from the dropdown.

   • Model = model

     • Copy from SQL.

   • VIN = vin

     • Copy from SQL.

   • Maven Vehicle Asset ID = assetId

     • Copy from SQL (same ID you used in the query).

   • SQL PowerUnitId = powerUnitId

     • Copy from SQL.

   • Customer ID = 723

     • Type 723.

   • Make = make

     • Copy from SQL.

   • Year = year

     • Copy from SQL.

5. Leave all other fields blank or at their default values.

6. Review your entries:

   • Confirm each field matches the SQL row exactly.

   • Make sure there are no extra spaces and no digits swapped or missing.

7. When everything looks correct, click Save.