The reason the window and lock don't operate is the connector not being put back properly. Do I'm sure you'd get it working once you get the door open. As for the door, I did the rod trick (3 years ago) and it worked for me, the rod had to be inserted between the glass and weather seal though (in the corner) and not the door jam.

Sent from my SM-G900F using Tapatalk

__________________
BMW X5 E53, 4.8iS - 2005
Professional Stereo/Nav with DSP (modified BM54 module) - Converted to Eonon GA5166X with Reverse cam
4-Corner Air Suspension - Converted to BC Coilovers