Import SBO May Inventory into the tracking module

[ChristinaTremel]

Richard sent over the May inventory list following their count.

• File: SBO_asset_inventory_MAY.csv
• Delete existing records from asset_inventory object
• Import the file into asset_inventory object in the Street & Bridge Operations Knack Application

[dianamartin]

6/14/24

• [x] Delete existing records from asset_inventory object - 43 records
• [x] Import the file into asset_inventory object in the Street & Bridge Operations Knack Application - 460 records

[dianamartin]

6/25/24

• [x] Reviewed import table SBO_asset_inventory_MAY
• [x] Removed the last two columns (Status, Notes)
• [x] Importing 460 records from spreadsheet SBO_asset_inventory_MAY
• [x] Spot Check records
  • Batch Updating missing fields
  • [x] Division Name - connection
  • [x] DM - Central - 118 records
  • [x] DM - North - 49 records
  • [x] Utilities & Structures - UER - 96 records
  • [x] Utilities & Structures - CRC - 103 records
  • [x] Utilities & Structures - CRC - 37 records

    Need to make new Division Name

  • [x] Pavement & Infrastructure - Overlay - 29 records
  • [x] Pavement & Infrastructure - Seal Coat 1 - 8 records
  • [x] Pavement & Infrastructure - Seal Coat 2 - 20 records
• [x] Updated "Asset Status" to ACTIVE - `460 records
• [x] Updated "Created By" to Richard D. - `460 records
• [x] Updated "Created Date" to 6/25/24 - `460 records

Tasks for 6/26/24

• [ ] Need to update "Assigned To"

[ChristinaTremel]

Schedule meeting to go through the inventory that was imported.

[dianamartin]

7/8/24

• Met with stakeholders on 7/1/24
• Talked about normalizing several fields:
  • Divisions
  • Asset Location
  • Brand
• Richard emailed letting us know he's finished updating the "SUBCATEGORY" domains
• Deleting DUP/Marked "SUBCATEGORY" domains records using - SBO_Inventory_Domains.xlsx
  • [x] Chain Saw - used Chainsaw
  • [x] Grinder - used Grinder (w/o space)
  • [x] Impact Driver Drill - used Impact Driver
  • [x] Impact wrench - used Impact Wrench
  • [x] Level (Survey Instrument) - use Level (new!)
  • [x] N/A
  • [x] n/a
  • [x] Pole Saw - used Pole Saw (w/o space)
  • [x] Rotary hammer - used Rotary Hammer
  • [x] Sawzall - used Reciprocating Saw
  • [x] Walk behind saw - used Walk Behind Saw
  • [x] Weed Eater - used Weed Eater (w/o space)
  • [x] Welding Hood A40 - used Welding Hood
• Ask Richard about these ones:
  • [x] Chainsaw Cordless - Chainsaw
  • [x] Drill (1/2) - Drill
  • [x] Drill (3/8) - Drill
  • [x] Drill (3/8) (battery oper)- Drill
  • [x] Driver (3/8) - Driver
  • [x] Grinder (battery oper) - Grinder
  • [x] Impact (1/2) - Impact Driver
  • [x] Trimmer - Keep

[dianamartin]

7/9/24

• Updated filters on "SBO Workgroups" page
• [ ] Update Seal Coat 1 - Seal Coat - all records
• [ ] Update Seal Coat 2 - Fog Seal - all records