Visit the XML feed located at: [url removed, login to view]
For each record in the XML feed, read it into a mySQL table:
- TABLE "OFFERS_LINKSHARE"
ID (INT 11) - should be simply an autoincremented number
VENDOR_NAME (VARCHAR 255) - maps to <advertisername>
URL (VARCHAR 255) - maps to <clickurl>
DESCRIPTION (VARCHAR255) - maps to <offerdescription>
START_DATE (DATETIME) - maps to <offerstartdate>
EXP_DATE (DATETIME) - maps to <offerenddate>. If offerenddate is "ongoing", the field should be set to '0000-00-00 00:00:00'
PROMO_TYPE - maps to <promotiontype>