Thanks Roy, all the lights work very well in manual, but no power through a meter to them on the door switch input...
The door switch is simply a switched earth. The same power wire feeds the lamp whether for door switch or manual mode. So the power (live feed) is there all the time and if it works in manual mode then it is there for door switch mode. When you switch them on manually that tiny roller inside the lamp makes contact for the earth wire at the lamp, and they come on. When you change the position of the switch for door operation, the roller does not make clean contact (as it should) so there is no path to the door switch for earthing as the doors are opened. The fault is in the lamp.
Try removing the faulty lamp and fitting one that you know works, to the existing wires, and you will see that it does work. There is no different supply, only a different earth, but the fault is in the lamp. The tiny roller simply does not make contact in the 'auto' position. As I said check, the continuity and you will see it is poor or non-existent. I have seen it many times.
Roy