The warning sounds from the roof will return once its working as will the windows etc, you really need to use the cars own power to power the relay, i mean you could rig another battery up but its a bit of a faff,...
Here is a .CSV file of the data for your roof showing all the correct sensor settings when the roof is working correctly and is closed, you can view the file using a .CSV file viewer, plenty on the internet,...
The picture shows the relays, the relay on the right has the two main wires that power the pump, the White wire powers it closed and the Black wire to the left of the White wire powers it open, you wont be able to power it open though so dont try it, just put some power to the black wire and let the pump run for a second or two to close/reset the roof.
Can you also post the other page of roof data.