added several auto generate procedures and some blank url fixes