My 02 beetles sunroof is draining into floorboard it leaks Midway of the doors how do I get it unclogged do it will drain properly

SOURCE: 2002 Toyota Sienna Sunroof

There are 4 drains on the sunroof (2 in each front corner, 2 in each rear corner).
If you want to check to see if they are clear, you can do this.

Get a squeeze bulb (about the size of a turkey baster) and squirt water down each drain, look for water draining out at the bottom of the car. For the rear drains, park the car on a slight uphill, and gently squeeze water down the drain trough on each side, here again, look for water draining out of the car.
If those ar clear, next step is to check the seal of the glass. The drains are only designed to take in a small amount of water, if there is too big of a gap between the panel and the body, it will over run the drain troughs (kind of like when the gutters on a house get stuff in them).

Finding water leaks is kind of a pain, but not if you take it a step at a time.
One thing to remember, water does not run uphill.

So to further water test it. Find a place where you can park it uphill or downhill, grab a flashlight, a friend and a hose.
Start at a low spot, and work your way around the sunroof (one person inside with the light, one outside with the hose). Just let the water run slowly, you don't want to use a nozzle or a spray.
Once you can see when the water starts leaking on the inside, you can narrow down the cause.

SOURCE: sunroof leak

there are drain hoses on all all four corners of the sunroof. to access the front ones, remove the front inner fender liners. you'll probably see a plastic grommet/spout that the drain hose attaches to. in the rear, remove the trunk liners on the side. you should see the drain hoses running down the inside of the quarter panel.

SOURCE: clogged drain hose in sunroof

ok open sunroof there are 2 drain holes use piano wire or something equeal take a low psi air tip nozzle and blow into drain then take a small cup of water and pour like an ounce of water into drain it should come out by lower door and fender area note mine was plugged down by fender hose was submerged in sand

SOURCE: leaking sunroof in 98 Saturn SC2

The drain hoses get clogged behind the kick panels. Pull back the kick panel and reach in grab the hose and pull it out from the hole in the lower panel. Then I just cut off the end and watch the mud and water flow out then reinstall. There is also one in the rear wheel wells as well for the back drains.
There is no reason to remove the headliner unless its broke.

SOURCE: floor board on passenger side door gets wet when it rains. i am sure a vent drain is clogged

The drains in the wiper wells are probably clogged. You need to remove the plastic 'vent screen' under the wipers to clear out the debris. Remove the wipers and a few screws, not difficult at all. Also, under the hood, you will see a vertical tube on each side of the car under the wiper wells. These can be removed from under the hood without removing the wipers, but you will probably have to clear the wells anyway. What happens is the water backs up and enters the car through the fresh air inlet and comes in around the blower fan. Good Luck.