Import cabinet asset in Data Tracker

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services

17 stars 2 forks source link

Import cabinet asset in Data Tracker #17629

Open atdservicebot opened 1 month ago

atdservicebot commented 1 month ago

What application are you using?

AMD Data Tracker

Describe the problem.

Please import cabinet asset for:

Comm Type Switch Model

With spreadsheet sent to Christina T. 6/3

Describe the outcome you'd like to see when this feature is implemented.

Please import cabinet asset for:

Comm Type Switch Model

Describe any workarounds you currently have in place or alternative solutions you've considered.

None

Is there anything else we should know?

By end of June 2024

Requested By Allyson R.

Request ID: DTS24-115250

ChristinaTremel commented 2 weeks ago

6/21/24

Met with Allyson and Gus to clean up the spreadsheet: DTS import.xlsx
Test imported two records:
- Cabinet_ID: 2 - Comm Type Fiber
- Cabinet ID: 12 - Comm Type Cell Modem
- QCed those records and the Comm Type and Switch Model were populated as expected
Imported 1054 additional cabinet records
- QCed some random records to confirm successful import:
  - 4057 ✅
  - 1051 ✅
  - 919 ✅
- Let Allyson and Gus know that this has been completed.

susannegov commented 6 days ago

Markus reached out to me concerned about the signal cabinet IDs on Teams since the modified by/modified date listed it as me and 04/03/2024 as the modified date. The record history of those records said 06/21/2024.

basically the effect is that whatever is happening 'on the backend' is affecting the cabinet record. This example, INT# 536 FM 2222 RD/ CITY PARK RD I had previously changed to 'no UPS present'

Said that it greatly effect BBS deployment effort because the Power BI reads from the cabinet record