HSG (Hysterosalpingogram) AKA Tube flushing

http://www.webmd.com/infertility-and-reproduction/guide/hysterosalpingogram-21590

I just scheduled my appt for next Thursday.

I heard it can be a bit painful but I'm hoping it's not too bad.
I'm actually excited about it because it increases my risk of pregnancy because it clears everything out.

Anyone have one done?
Anyone get pregnant from it?