Artisan Archive

All,

I wrote a windows program in .Net for processing vendor emails. Heres the gist:

1. Use the /mailsave function and you will get the emails in a local folder.

2. You set up a project that is an XML file (the program does it for you) that contains the Email folder for your char and the output file for the XML.

3. You hit 'Process Emails' and you get an XML file with the sales data.

4. You can then open that file in Excel or your program of choice.

The program is availabel in a zip file at http://www.thedotcommakesitfunny.com/swg/it is called the SWG Merchant Email Processor.

A couple of things to keep in mind:

1. This program is an ALPHA release. It works, it might have bugs, but it does work. It's definitely pre-beta.

2. The program fulllyrecreates the output XML from the email foldereach time it is run. So if you move the emails or delete them, you will get a new file without the ones you deleted. You could get around this by dating or otherwise revisioning your output files and then combining them. I left this open, cause it was troublesome to code and because I figured everyone would want to deal with their emailsdifferently so this is more flexible.

3. The program looks for emails from SWG.*ServerName*.Auctioner ... it skips the emails about items delisting. However, I am unsure what other emails the auctioner might send and have been unable to test them all. One example might be if the vendor sends an email when its maintenance gets low, not sure what the program will do in that situation (probably blow up).

4. The program is written in .Net so you will need to have the .Net framework. You can get it from Windows Update or from Microsofts site.

5. The current version is Alpha 5. It tracks vendor and bazzar sales seperately.

Enjoy! Andplease send any comments, bug reports, feature requests, etc. to [email protected]

Thanks,

Sorry, if I seems stupid..

I am a Master Merchant selling many wares throughout the galaxy.

How will this benefit me? I am very interested, but I don't exactly understand what it does..

No, you're not stupid. Basically it will allow you to make a spreadsheet in excel that lists every item you sold, the vendor who sold it (or bazzar), the price it sold for, the date and time it sold, and what planet and city it sold in. People have been tracking this by hand, this makes that more convenient and *much* faster and more accurate. Some people don't track any of this and do it by gut(if it's sold out, restock).

This tool would be massively helpful if we could parameterize it directly. The information is useful, but I receive thousands of emails a week and I really hate deleting any of them. Any advice would be helpful.

I'll look into parsing the mail into XML and seeing if I can format it nicely in Excel.

Would be great to be able to use Excel to store and sort all email. Not just matching vendor strings.

Yours,

Wonderzen,

You do not have to delete any messages for the program to run. It will currently only process those that are from Vendor or Bazzar sales. I may make an addition to allow you to sort emails into folders, but that would be a pretty large feature set to do it right, so for now I am concentrating on the vendor and bazzar sales. But you do not have to remove, delete or move any emails. In fact it is easier if you do not, at least for this program.

Thanks,

/bump