Light Profile .csv

Configuration
1

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
2

Anyone able to help?

3

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.

4

I have looked all over the place, with very little luck, however will keep trying and will let you know!!

5

@erikaugl

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
1 Like
6

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.

7

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.