Generate devices csv

[benolayinka]

Summary

Can we generate a flat list of devices as a csv? We can then sync this to airtable

Why do we need this?

Sync data to airtable

What is already there? What do you see now?

Folder hierarchy

What is missing? What do you want to see?

name, vendor, description, image link, sensors, radios, height, width, length, weight, battery?, ip rating, urls, mac version?, rp version?, supports class b / class c?,

[johanstokking]

Most of this is quite straight forward and is readily available per end device.

The data model has a hierarchy:

• Vendor
  • Profile
  • End device
    • Hardware version
    • Firmware version (links to one or more supported hardware versions and a profile for each region)

The MAC version, RP version and LoRaWAN classes are in the profile. There may be differences between regions, and there can be devices with multiple firmware versions so we need to add some heuristics here.

For example, we could take the last firmware version and the first profile to determine these fields.

[KrishnaIyer]

@LDannijs: When there's a PR for an issue, please add the in progress label.

[LDannijs]

Iirc i wasn't able to change the labels before but i will remember it for next time.

[LDannijs]

PR #749 was merged, closing this.