Announcement

Collapse
No announcement yet.

Keeping Track of your sales.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Keeping Track of your sales.

    Do any of you use/have a bazzar log prasing program?

    I would like to get meaning full data out of my bazzar log.

    I want to know WHO bought HOW MANY Afternoon Tea's and what did I sell them for on that day.

    Would like to keep records on all my trade skill items.

    Thanks
    Brewing 250
    Fletching 199
    Baking 154
    Fishing 15
    Tailorying 15

  • #2
    I am currently working on a chunk of code to do that in C, but it will take some time before I can complete it. I'm running into memory issues with huge bazaar files, and my programming skills tend to leave something to be desired.

    Comment


    • #3
      isn't there a link for parsing proggies on the site somewhere?

      Comment


      • #4
        There was a script written in PERL by Jawan; Linked here for your reference; Perl script to extract info from a log file.

        You can get PERL at the PERL.ORG site.
        Lothay retired from EQ in 2003
        EQ Traders - Moderator - MySpace or LiveJournal

        Comment


        • #5
          I wrote an app to do this. I hate a few problems with reporting.. but if you would like I could try to get it working so you can look it over, I know my app parses correctly and puts into a DB but crystal reports is being a pain hehe. Lemme know if there is a big interested of people that would like to see this developed a bit more ill work on it some.

          Comment


          • #6
            This is something I have been loooking for... I would love to see something added.

            I want to know I have sold item x how many times? What was my High price? What was my Low price? What was my average price?

            Can any body add this to the last script plz?
            Brewing 250
            Fletching 199
            Baking 154
            Fishing 15
            Tailorying 15

            Comment


            • #7
              Originally posted by Lothay
              There was a script written in PERL by Jawan; Linked here for your reference; Perl script to extract info from a log file.

              You can get PERL at the PERL.ORG site.

              errrrr last post was to go in that perl thread LOL

              sorry
              Brewing 250
              Fletching 199
              Baking 154
              Fishing 15
              Tailorying 15

              Comment


              • #8
                Ok i think i got my app working.. I need someone to test this. Due to I dont want it to go crashing randomly.. working fine for me now ... but anyone wanna help me test this.

                Comment


                • #9
                  Originally posted by Britneyy
                  Ok i think i got my app working.. I need someone to test this. Due to I dont want it to go crashing randomly.. working fine for me now ... but anyone wanna help me test this.
                  I would love to test it for you.

                  email me a copy

                  my email is my user name you see in the thread @cminet.net

                  I will be at pc ALL day.
                  Brewing 250
                  Fletching 199
                  Baking 154
                  Fishing 15
                  Tailorying 15

                  Comment


                  • #10
                    Originally posted by mrchaos101
                    I would love to test it for you.

                    email me a copy

                    my email is my user name you see in the thread @cminet.net

                    I will be at pc ALL day.
                    Ran into a slight problem with deployment need to get a real crystal reports key by buying the software my app only works on my machine atm cuz vs.net 2003 comes with crystal. Im in the process of getting a serial then i can ddeploy.

                    Comment


                    • #11
                      I've added this feature to my program (see http://mboards.eqtraders.com/eq/showthread.php?t=19659). The .pdf file is a little out of date atm, but if you go through all the steps and run the program once, then add
                      Code:
                       
                      [CHARACTERS] 
                      sellerguy=vendor
                      (where sellerguy is the name of your character) to the end of the ItemDataManage.ini file it will make a file called sellerguy.csv with each sale reported. That csv file can be read into excel or any other program that accepts comma separated values. From there, you can sort and arrange the data in any manner you wish.
                      -- Mewkus: 2100 dings on the server formerly known as Solusek Ro
                      try: Inventory/Flags/Spells tracker program - (sample output)

                      Comment


                      • #12
                        Ok I revamped my entire app to a new reporting software, which allows me to distribute without HUGE merge modules, my last installer i made was 40megs for a 100k app This is just a few send dlls with the app and it runs. Now I got the basics done now, it will show 1 report im currently working on the addition of new reports and filters, ect.. Ill make a post later to show yall the work so far. Gotta do a little more testing to prevent crashability.

                        Comment


                        • #13
                          Britneyy's Bazaar Log Analyzer

                          Ok folks ive talked about it and here it is!

                          Few things.

                          This was built and compiled under VB.NET hance you must have the .NET framework installed on your machine.
                          Report SharpSHooter was used as my reporting source, So if you deceide to print or view a report it will be watermarked in the top right, there fee is $375 for a single basic liscence which is a bit outta my reach atm ;p

                          I wanted to just get it deployed so I didn't have much time to write my TODO ill include on a future relase
                          TODO:
                          Adding a ton of more report filters


                          Now when running this i think i got all my test buttons and popup msg boxes out if not please let me know. IF your able to crash this also please let me know
                          SFV is included. Check out "QuickSFV" for checking.


                          Rar Fans Click Here
                          Zip Fans Click Here
                          CRC32 SFV File Here

                          Any feedback via email or post would be nice even if you think it sucks! Hate mail makes good reading. But anyways for anyone wondering this only has 1 rpt generating atm, will take me a little while to create more and filters due to a complete workover of my reporting system.

                          Also, if you feel this should be moved to guides and UI please do change
                          Last edited by Britneyy; 01-14-2005, 07:37 PM.

                          Comment

                          Working...
                          X