Can someone explain how to format the light profiles csv works?
I am trying to achieve my lounge lamp always turn on at 75% brightness unless otherwise set. The bulb is a hue that has no ability to change colour temp. I have tried to follow the instructions online, but can’t get it to work.
The light profiles csv is in the same folder as config.ymal and I have this code so far.
profile,color_x,color_y,brightness,transition
light.lounge_lamp_2.default,color_x,color_y,190
Anyone able to help?
Hi,
I have also been trying to figure this out without any luck. Currently I use a blueprint called “Default turn-on brightness and color temperature for light(s)”, it works but I rather want to change something in a config file than creating automations.
Please let me know if you find a solution with the csv file.
I have looked all over the place, with very little luck, however will keep trying and will let you know!!
You need to supply a valid value for the X/Y color values even if your light doesn’t support colors. They will just be ignored. Only the transition value is optional.
profile,color_x,color_y,brightness,transition
light.lounge_lamp_2.default,0.41334,0.43663,190,0
This is old thread but I have not found much other info about this.
The correct format for header is:
id,x,y,brightness,transition
Do not use the example above eg. profile,color_x etc. (maybe things changed since now?)
Here is my working light_profiles.csv which sets my lights to 5000K and 65%
*Must restart home assistant after editing.
id,x,y,brightness,transition
light.computer_room_ceiling.default,0.372,0.35,255,1
I determined the correct x,y values by first setting color temp to 5000K then reading the x,y back in developer tools, states.
Also seems to only affect with a turn_on… calling service to turn_on with a color or brightness etc. bypasses this so can make scenes still.
I’ve been struggling with this on and off for ages. All I want is to set lights to a preferred colour and brightness when turned on, rather than whatever values they were turned off at.
Here’s my light_profiles.csv contents (which is in same folder as config.yaml).
id,x,y,brightness,transition
light.office_light.default,0.410,0.391,255,3
but it just comes on at whatever colour and brightness it was went it was turned off.
I am using scenes but it’s not ideal.
Would really appreciate some guidance.
I have created a light_profiles.csv that consists of all W3C colors (~140 colors). Just stick it in the /config folder and reboot. Test them by using dev tools actions, light.turn_on, then click advanced and at the bottom see the “profile” option. Works a charm.
profile,color_x,color_y,brightness
default,0.313,0.329,255
relax,0.321,0.154,56
aliceblue,0.304,0.322,255
antiquewhite,0.336,0.349,244
aquamarine,0.266,0.380,255
azure,0.304,0.329,255
beige,0.328,0.354,233
bisque,0.353,0.361,255
blanchedalmond,0.346,0.359,255
blue,0.150,0.060,253
blueviolet,0.227,0.115,193
brown,0.561,0.330,96
burlywood,0.387,0.386,187
cadetblue,0.258,0.325,90
chartreuse,0.335,0.572,255
chocolate,0.531,0.399,164
coral,0.505,0.373,254
cornflowerblue,0.215,0.209,216
cornsilk,0.334,0.356,255
crimson,0.583,0.306,182
aqua,0.225,0.329,255
darkblue,0.150,0.060,66
darkcyan,0.225,0.329,67
darkgoldenrod,0.474,0.457,123
darkgray,0.313,0.329,102
darkgreen,0.640,0.330,33
darkkhaki,0.379,0.427,130
darkmagenta,0.321,0.154,66
darkolivegreen,0.355,0.471,38
darkorange,0.528,0.419,254
darkorchid,0.260,0.139,154
darkred,0.640,0.330,66
darksalmon,0.427,0.361,208
darkseagreen,0.310,0.395,129
darkslateblue,0.221,0.162,66
darkslategray,0.264,0.313,12
darkturquoise,0.223,0.324,163
darkviolet,0.246,0.113,166
deeppink,0.465,0.237,254
deepskyblue,0.201,0.244,254
dimgray,0.313,0.329,37
dodgerblue,0.185,0.179,254
firebrick,0.590,0.330,114
floralwhite,0.322,0.339,255
forestgreen,0.302,0.560,66
gainsboro,0.313,0.329,183
ghostwhite,0.309,0.322,255
gold,0.450,0.481,255
goldenrod,0.464,0.457,179
gray,0.313,0.329,56
green,0.640,0.330,55
greenyellow,0.358,0.538,255
honeydew,0.312,0.344,255
hotpink,0.400,0.255,254
indianred,0.475,0.330,156
indigo,0.221,0.099,57
ivory,0.321,0.343,255
khaki,0.378,0.423,222
lavender,0.300,0.309,244
lavenderblush,0.319,0.324,255
lawngreen,0.335,0.573,248
lemonchiffon,0.343,0.373,255
lightblue,0.275,0.312,202
lightcoral,0.440,0.329,222
lightcyan,0.294,0.329,255
lightgoldenrodyellow,0.337,0.369,244
lightgray,0.313,0.329,167
lightgreen,0.307,0.449,218
lightpink,0.366,0.318,255
lightsalmon,0.441,0.368,254
lightseagreen,0.232,0.342,114
lightskyblue,0.242,0.276,243
lightslategray,0.279,0.300,82
lightsteelblue,0.281,0.311,187
lightyellow,0.331,0.359,255
lime,0.300,0.600,255
limegreen,0.302,0.566,156
linen,0.325,0.339,244
magenta,0.321,0.154,254
maroon,0.640,0.330,55
mediumaquamarine,0.267,0.380,156
mediumblue,0.150,0.060,155
mediumorchid,0.292,0.180,166
mediumpurple,0.249,0.187,181
mediumseagreen,0.274,0.449,116
mediumslateblue,0.217,0.155,217
mediumspringgreen,0.262,0.462,244
mediumturquoise,0.238,0.336,163
mediumvioletred,0.425,0.218,146
midnightblue,0.173,0.098,42
mintcream,0.309,0.334,255
mistyrose,0.333,0.332,255
moccasin,0.363,0.377,255
navajowhite,0.371,0.379,255
navy,0.321,0.154,56
oldlace,0.330,0.342,253
olive,0.419,0.505,56
olivedrab,0.367,0.516,70
orange,0.500,0.441,254
orangered,0.606,0.357,254
orchid,0.322,0.216,179
palegoldenrod,0.357,0.394,218
palegreen,0.307,0.450,246
paleturquoise,0.274,0.329,218
palevioletred,0.402,0.288,181
papayawhip,0.340,0.355,255
peachpuff,0.363,0.363,255
peru,0.469,0.411,156
pink,0.356,0.318,255
plum,0.316,0.261,185
powderblue,0.278,0.322,202
purple,0.321,0.154,56
rebeccapurple,0.245,0.148,82
red,0.640,0.330,254
rosybrown,0.361,0.329,129
royalblue,0.228,0.247,72
saddlebrown,0.525,0.400,66
salmon,0.465,0.344,243
sandybrown,0.451,0.400,230
seagreen,0.275,0.448,66
seashell,0.323,0.336,255
sienna,0.500,0.382,90
silver,0.313,0.329,135
skyblue,0.249,0.293,212
slateblue,0.218,0.157,156
slategray,0.279,0.300,72
snow,0.316,0.329,255
springgreen,0.273,0.504,255
steelblue,0.220,0.241,117
tan,0.373,0.378,165
teal,0.313,0.329,56
thistle,0.314,0.301,176
tomato,0.538,0.353,254
turquoise,0.239,0.351,190
violet,0.318,0.219,218
wheat,0.359,0.374,233
white,0.313,0.329,255
whitesmoke,0.313,0.329,233
yellow,0.419,0.505,255
yellowgreen,0.367,0.520,156