The weekend closes on goodness....

After fighting a hangover and watching some basketball I cleaned up the Market Analysis Tool. Carl spent a couple of hours getting me a mail server that won't choke on the Eve Central dumps. And I set to making a production import tool.

As of now the Import Tool is working. The basic functions are as follows:

• Create an IMAP connection to the email server
• Select those emails from Eve-Central
• Parse these emails for orders and delete the mail
• Connect to the MySQL database
• Purge old orders that are being updated (those with the same Items and Region as the new ones)
• Insert the new orders
• Sleep for 3 minutes and repeat

The script has been running about two hours and has 28,576 orders in it. Not sure how large it will get or if the script will kill my PC. Stay tuned.

This week I'll work on creating the MySQL queries that should provide actual trade data.