Bazaar log parsing

[Caela]

I did a search for this informatin, but couldn't find what I was looking for.

At one time, someone posted a batch file for parsing your bazaar log to find out what you had sold.

I'm looking for either the batch file, or maybe another log parser that can give me info on what I sell in the bazaar.

Thank you!

[Nolrog]

Interesting question. I don't know if this info get's put into your log file or not. I never did check, although I turn the log on sometimes when I'm trading. If I remember tonight, I'll check and see.

[Dunthor Warsmith]

Originally posted by Nolrog
Interesting question. I don't know if this info get's put into your log file or not. I never did check, although I turn the log on sometimes when I'm trading. If I remember tonight, I'll check and see.

There's a second "bazaar log" file generated, which records all text in the /trader window, whether you have normal logging on or not.

The filename is bzrlog_CharName_shortServerName.txt I believe. For example, for my mule that yields bzrlog_Dunsarms_tunare.txt

[Caela]

Originally posted by Nolrog
Interesting question. I don't know if this info get's put into your log file or not.

There is a seperate log for the Bazaar that logs what items you have for sale and what was bought, and who bought it - it's just not all that easy to read. It's called bzrlog_server_character.log

[Itek]

Ok, I thought ... "hmm... never really thought of this, but I suppose it might be more difficult than I thought..."

1) Navigate to your Everquest directory. (varies by where you put it... TheWife d:\everquest\everquest ... Itek c:\Program Files\Everquest)

2) Sort by "Modified" or, if it's been quite a while, sort by "type"

3) Find a Text type (notepad icon) file that starts baz or bzr and includes your server name or number and the trader name.

4) Double click to open. (Ok the "use wordpad" if you need to. Mine at 7k didn't need to, TheWife needed to at 77k)

5) Click in somewhere near the top.

6) Ctrl+f to open the "find" window.

7) Enter "purchased" without quotes in the window.

Eight) Click "next"

Now, here it gets tricky. Every time you "begin trader" it reminds you that stuff can be purchased at the prices it just quoted you. So every time you start trader mode you will see a "purchased" with the Find.

9) Hit F3 button. This will automaticlly take you to the next time "purchased" appears. (Avoiding useless mouse clicking. Oh, wait, this is EQTraders... *grin*)

10) Tada.

Went thru a 77k log file in about 2 to 3 minutes with this handy dandy feature.

Who bought what when for how much. Where is a given. Why, we may never know.

The following conversation ACTUALLY took place.

Itek's Sister (age 10 or so): "I can't get the last olive out of the jar." (in her defense the jar was very tall, longer than her finger, narrow at the top, so a fork wouldn't go in it, and she'd managed to get all BUT that last olive with just her finger)

Itek (age 13 or so): "Um, see the directions on the bottom of the jar."

Itek's Sister: "Oh. That works."

It's not a silly question... you are just making it too hard. "I want a way to parse a simple flat text file for a single word." *smile*

[Mridule]

I put together a really cheesy bazaar parser one night

I put together a really cheesy bazaar log parsor one night. I canceled my accounts and wanted to see what I had sold over my EQ tradeskilling career.

It simply ran through a list of log files (I had more than one trader) and kept track of the total pp earned, the pp spent per buyer, and the quantity of each item sold. The output format is just a simple text file. If you want to see what it looks like I posted some of the results on following boards.

Stormhammer server board:
http://pub116.ezboard.com/flegends11...cID=1593.topic

Tinkering.org message board:
http://www.tinkering.org/board/viewtopic.php?t=198

I was going to add on to it so I could parse my regular log for all the combines I did for people but that would be a lot more work and I am retired (frome EQ anyway, although for some strange reason I still browse these boards ).


When I get home tonight I will try to post it if I still have it laying around.

[jawn]

Re: Bazaar log parsing

Originally posted by Caela
I did a search for this informatin, but couldn't find what I was looking for.

At one time, someone posted a batch file for parsing your bazaar log to find out what you had sold.

The subject of the post you want is: Perl script to extract info from a log file

The output is a list of all items sold, buyers, totals for the items, and a grand total at the end of the list, sort by item. Someone made a modificaton to sort by buyer. There is a way to run perl on your Microsoft system, read the post for further information.

[Mridule]

here it is

Here is the log parser I threw together one night. I make no promises that it works and if it dosen't I really can't fix it since I am swapped with homework at the moment. I included the executable with some example files as well as the source file. You can mess with the (hastely written) code all you like. I hope somebody finds this useful.

[Sadine]

Here ya go!

http://mboards.eqtraders.com/upload/...threadid=11897

http://mboards.eqtraders.com/upload/...threadid=11696

[growly]

I used the log parser I found here to figure out how much Fuzzlecutter I sold over the course of a year.