search

home-assistant / devices

Collection of devices
https://home-assistant.github.io/devices/
8 stars 13 forks source link

Issue with `via_device` in template #18

Closed mib1185 closed 2 months ago

mib1185 commented 3 months ago

I've used the template from readme to generate the CSV, but each entry with an via_device runs into error when executing script/process.py

my csv

integration,manufacturer,model,sw_version,hw_version,via_device,has_suggested_area,has_configuration_url,entry_type,is_via_device
fritz,"Shelly","Shelly 1PM","20230913-113709/v1.14.0-gcb84623","gen1 (SHSW-PM)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly H&T","20211109-125452/v1.11.7-g682a0db","gen1 (SHHT-1)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly H&T","20211109-125452/v1.11.7-g682a0db","gen1 (SHHT-1)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Button1","20230913-113105/v1.14.0-gcb84623","gen1 (SHBTN-2)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Button1","20220209-093755/v1.11.8-g8c7bb8d","gen1 (SHBTN-2)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
fritz,"AVM","FRITZ!Box Tracked device","None","None","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,False,None,False
shelly,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
shelly,"Shelly","Shelly Plug S","20230913-113421/v1.14.0-gcb84623","gen1 (SHPLG-S)","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,True,None,False
samsungtv,"Samsung Electronics","UE55KU6179","None","None","eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0=",False,False,None,False
synology_dsm,"WDC     ","WDC  WDS100T2B0A-00SM50","415020WD","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
synology_dsm,"WDC     ","WDC  WDS100T2B0A-00SM50","415020WD","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
synology_dsm,"WDC     ","WDC  WDS100T2B0A-00SM50","415020WD","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
synology_dsm,"WDC     ","WDC  WDS100T2B0A-00SM50","415020WD","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
synology_dsm,"WDC     ","WDC  WDS100T2B0A-00SM50","415020WD","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
synology_dsm,"Synology","DS620slim","DSM 7.2.1-69057 Update 5","None","eyJzd192ZXJzaW9uIjoiRFNNIDcuMi4xLTY5MDU3IFVwZGF0ZSA1IiwiaHdfdmVyc2lvbiI6bnVsbCwiaW50ZWdyYXRpb24iOiJzeW5vbG9neV9kc20iLCJtb2RlbCI6IkRTNjIwc2xpbSIsIm1hbnVmYWN0dXJlciI6IlN5bm9sb2d5In0=",False,True,None,False
zha,"LUMI","lumi.weather","None","None","eyJzd192ZXJzaW9uIjoiNy4zLjEuMCBidWlsZCAxNzYiLCJod192ZXJzaW9uIjpudWxsLCJpbnRlZ3JhdGlvbiI6InpoYSIsIm1vZGVsIjoiRVpTUCIsIm1hbnVmYWN0dXJlciI6IlNpbGljb24gTGFicyJ9",False,False,None,False

result

$ script/process.py
/workspaces/homeassistant-devices/to_process/devices.csv: Invalid row: expected str for dictionary value @ data['via_device']['integration']
{'entry_type': 'None',
 'has_configuration_url': 'True',
 'has_suggested_area': 'False',
 'hw_version': 'gen1 (SHSW-PM)',
 'integration': 'fritz',
 'is_via_device': 'False',
 'manufacturer': 'Shelly',
 'model': 'Shelly 1PM',
 'sw_version': '20230913-113709/v1.14.0-gcb84623',
 'via_device': 'eyJzd192ZXJzaW9uIjoiNy41NyIsImh3X3ZlcnNpb24iOm51bGwsImludGVncmF0aW9uIjpudWxsLCJtb2RlbCI6IkZSSVRaIUJveCA3NTMwIEFYIiwibWFudWZhY3R1cmVyIjoiQVZNIn0='}
Error; expected str for dictionary value @ data['via_device']['integration']

Processed: UpdateRecord(created=0, updated=0, ignored=0)
balloob commented 3 months ago

Ah, I guess for some we don't know the exact integration. That should be fixed in an update to HA soon.