nycmeshnet / meshdb

A convenient, stable, and sane database for tracking Members and Nodes for use with robots and humans
https://db.nycmesh.net
MIT License
12 stars 14 forks source link

Audit dropped data in device & link import #530

Closed Andrew-Dickinson closed 1 month ago

Andrew-Dickinson commented 2 months ago

Make sure none of this is important lol

[ERROR] Couldn't find NN in device named: HDHomeRun
[ERROR] Couldn't find NN in device named: nycmesh-xxxx-af24
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 135
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 664
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 1049
[WARNING] Discarding information for 2 unmatched spreadsheet rows for NN 1126
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 1384
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 1932
[WARNING] Discarding information for 2 unmatched spreadsheet rows for NN 1933
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 2282
[WARNING] Discarding information for 4 unmatched spreadsheet rows for NN 2299
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 3461
[WARNING] Discarding information for 1 unmatched spreadsheet rows for NN 3606
[ERROR] Could not find Node for NN 4106 while loading device: nycmesh-4106-omni
[ERROR] Could not find Node for NN 4106 while loading device: nycmesh-lbe-4106
[ERROR] Could not find Node for NN 2794 while loading device: nycmesh-2794-omni
[ERROR] Could not find Node for NN 668 while loading device: nycmesh-668-omni
[ERROR] Could not find Node for NN 668 while loading device: nycmesh-lbe-668
[ERROR] Could not find Node for NN 3640 while loading device: nycmesh-lbe-3640
[ERROR] Could not find Node for NN 3723 while loading device: nycmesh-3723-omni
[ERROR] Could not find Node for NN 3162 while loading device: nycmesh-lbe-3162
[ERROR] Could not find Node for NN 3162 while loading device: nycmesh-3162-omni
[ERROR] Could not find Node for NN 606 while loading device: nycmesh-606-467-epr6
[ERROR] Could not find Node for NN 7840 while loading device: nycmesh-7840-omni
[ERROR] Could not find Node for NN 658 while loading device: nycmesh-lbe-658
[ERROR] Could not find Node for NN 658 while loading device: nycmesh-658-omni
[INFO] Importing links from UISP & 'spreadsheet_data/links.csv'
[WARNING] Skipping link 4396 to 713. Can't find one or more building objects for this entry
[WARNING] Skipping link 6581 to 1350. Can't find one or more building objects for this entry
[WARNING] Skipping link 7297 to 6581. Can't find one or more building objects for this entry
...
Andrew-Dickinson commented 1 month ago

This is fine. Checked today and fixed a few issues but ultimately these are edge cases and invalid data, and we're never gonna hit 100%