It goes directly into your database tables. Then, it is read from there like any other posting.
Regarding your failed message: read what it says and then make changes to your xml. Also, make sure the category, location region/city actually exists in your site. If you still have issues, post your xml here and I will take a look.