Get the most out of your Bazzar Logs!

[mrchaos101]

First thing,

Hats off and /bow to jawn in this thread
http://mboards.eqtraders.com/eq/show...highlight=PERL
He started this Perl app. Most of this code is his, and I take no credit for it. I just made changes and added things that I also wanted to see it do.

Thanks to EQTRADERS as they are hosting the file you may be downloading. This is being

posted on EQTRADERS, but I will be letting others know about it on Sony Live.


Now for the fun stuff:


If you do not have Active Perl installed (unless you are a programmer you probably don't)

then the bazaar log program will not work.

STOP

Go to

http://downloads.activestate.com/Act...x86-122208.msi



And download active Perl and install it. Let it install to all the default locations it

wants. It should not want to reboot your computer and you should not have to do anything

else with it.


Files included in this package:

readme.txt (this file you are looking at)
buyertoscreen.bat (prints data to your screen about your buyers)
pricetoscreen.bat (prints data to your screen about your items you have sold)
logtoxc.pl (filters out the "crap" in the bazaar log file, and makes an excel spreadsheet)


COPY all the files to your \log folder. The default location is c:\porgram

files\sony\everquest\logs\

Your bazaar Log file is saved in this format:
bzrlog_[serverName]_[charName].txt

So lets say you have a Dru on Tunar named Midget. Midget has been doing some selling in the

bazaar and you would like to get some good data from his logs.

His log file would be seen in the folder like this:

bzrlog_tunar_midget.txt

If you would like to find look up the information of WHO has been buying your stuff... how

much they have bought, and/or how much they have paid then DRAG the bazaar log file to the

buyertoscreen.bat and let go. You will see on your screen all the info on your toons

buyers. YOUR BAZZAR LOG FILLE WILL NOT BE DAMAGED!!! all this does is tell Perl what file to

look at.

Lets say you want information on what your toon has sold? How many times has item x sold?

What was the most paid for it? What was the least paid for it? what is the total?

Drag your log file to the pricetoscreen.bat and let go. Again you will see the data you

want on your screen. Again, your log fill will not be damaged.

NOW for those of you that would rather get all of the "GOOD" data from your log file, but

don’t like these 2 apps....

The last one will turn your bazaar log into an excel spreadsheet.

At the moment you have to do this IN A COMMAND WINDOW... I’m having issues getting this to

work as a .bat like the other 2.

Simply open up a command window and navigate to your log folder where all the files are

installed.

TYPE the following:

logtoxcl.pl <file NAME> then hit enter

Replace <file name> with the name of the log you want made into a excel file. AGIAN your

log will not be damaged.

The screen will still be blank, just close your command prompt. Use Windows Explorer and

navigate Back to where your log files are again. This time you will see a new excel file

there. The excel files are saved as EverquestYEAR-Month-Day@Tim the file was made.xcl
So you can run it over and over and get a new spreadsheet each time.

What is in it?

If you are good with excel you should be able to get a lot out of that data.

Column A = Buyers
Column B = Items Sold
Column C = total Items buyer bought that transaction
Column D = total buyer paid for those items that trans action

I plan to add Dates and Times items were sold down the road.

Hope you all like it.

[mrchaos101]

Ok here are some changs to the excel script.

The new changes allow:

Creates the excel file in the same directory as the .bat

Bazaar log file can now be dragged and droped into the excle file like the others.

Added the date and time a sell was made to the spreadsheet.


KEEP IN MIND this code is obtained from MANY PEOPEL. I know what I wanted and just went looking for the parts needed to make it work.


Unzip the file into your logs dir. Drag and drop the bazaar log you want copied into an excell sheet.

[Chip194]

Wow, thanks for posting this Chaos.

I'm at work so will not be able to d/l for a few hours,
but my questions are

You can find out what OTHER traders have sold, and to whom and for how much they sold them?

And you can add other players to the log to find out when and what they are buying not only from you but from other traders? Talk about marketing data.

Did I understand that right? I guess I'm just excited at the thought of this, so forgive me If I'm asking the obvious, I think some of the wording flew in one ear and out the other.

[mrchaos101]

Wow, thanks for posting this Chaos.


You can find out what OTHER traders have sold, and to whom and for how much they sold them?

And you can add other players to the log to find out when and what they are buying not only from you but from other traders? Talk about marketing data.

Did I understand that right? I guess I'm just excited at the thought of this, so forgive me If I'm asking the obvious, I think some of the wording flew in one ear and out the other.

Nope, Nope sorry...

What happens is when a trader looks at your things and/or buys stuff from you it is LOGGED on your personal computer. There is no log on your computer that keeps track of the sales and prices of every body else.

This thes 3 files will allow you to get a quick output to your screen on the buyers that have bought your stuff... detailed infomation on the items you have sold....

The last file,.. the excel file is probly the best one... as it not only keeps track of all your buys, your itmes you sold... what they sold for and when.... you can then import it into MS Access or SQL or PhP or what ever you want to to use to crunch the data.

Basicly the idea was was to weed out all the "crap" that soe put into the log..
i.e Price updated...
sombody is looking at your stuff.
Items listed for sale
trader mode on
trader mode off

all taht stuff repeats MANY MANY MANY MANY MANY times in the logs and makes it a pain int he ass trying to read and get meaning full data.

[Chip194]

Thanks for clearing that up!

I'll check it out.

[Elyssanda]

Chip, If you're wanting average prices and such for YOUR server, go check out EQECON a one month membership is a negligible price.. *think* under $5. They have all sorts of data regarding prices.. on your server, across all servers.. etc.