These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Is there a software that will convert market cache into CSV?
Author
Previous Topic Next Topic
Megalex QC
Sebiestor Tribe
Minmatar Republic
#1 - 2014-04-01 18:53:35 UTC  |  Edited by: Megalex QC
Sup guys

I've been using evementat to check over all of my sales and such, it's really great.

I love how it scrapes your market cache.

I use another software that compares prices between systems to find good trades, but that software only works with "marketlogs" exported from within the game.

Exporting those marketlogs are a pain in the ass, and I have pain from it.

Is there such a thing as a software that will convert the market cache into the marketlogs format, for use in another software??

EDIT: Well I looked around more and it seems like "libevecache" has a utility called dumper.exe which does what I want, but the tool has been abandoned and is not working with the new cache files, giving error messages. I guess I'm looking for something similar...
Thur Barbek
Republic University
Minmatar Republic
#2 - 2014-04-01 20:25:27 UTC  |  Edited by: Thur Barbek
if you know python this library has a bunch of calls to convert stuff - https://forums.eveonline.com/default.aspx?g=posts&t=6501

You could also use evemon's uploader and it will do some conversions.

This code will essentially do what you want - https://github.com/fuzzysteve/evemon-local-endpoint The writer said something about it doesnt clean up old entries well, but that should be easily added with a date timeout type thing.

http://eve-marketdata.com/ if you upload data they will sort it.

Note: ccp has been messing with the api stuff a lot in the least year so a lot of things might need slight adjustments.


Or you could go look at the eve api wiki's and make a simple program to sort it and dump into a csv file.
Megalex QC
Sebiestor Tribe
Minmatar Republic
#3 - 2014-04-01 20:55:08 UTC
Hi thanks for your answer.

Reverence is also outdated, giving this error: RuntimeError: Could not determine MachoNet protocol version.

Evemon local endpoint isn't exactly what I'm looking for. I want it to scan the cache of items I've viewed, not my orders.

You know how when you go to the market, under an item, you can click "Export to File"? I'm looking for a way to batch export the files.

I figured since the game doesn't let you do it, it could be possible to convert the cache into a CSV, but looks like all the tools are outdated!!
Megalex QC
Sebiestor Tribe
Minmatar Republic
#4 - 2014-04-01 22:08:48 UTC
Did more googling and reading. I was able to find this C# library that decodes the cache files, and it's actually pretty easy to use.

Using that library, it'll be easy to make a program that creates a CSV out of the cache!!

The idea is to use EVE Mentat's IGB thing that goes thru the market, but then I'll convert all those caches into an excel sheet to analyze the data!

This is the library that does it: https://bitbucket.org/Desmont_McCallock/evecacheparser
Vaerah Vahrokha
Vahrokh Consulting
#5 - 2014-04-02 07:04:50 UTC
Megalex QC wrote:
Did more googling and reading. I was able to find this C# library that decodes the cache files, and it's actually pretty easy to use.

Using that library, it'll be easy to make a program that creates a CSV out of the cache!!

The idea is to use EVE Mentat's IGB thing that goes thru the market, but then I'll convert all those caches into an excel sheet to analyze the data!

This is the library that does it: https://bitbucket.org/Desmont_McCallock/evecacheparser


Have you tried my EvE Market History Dump utility? It does some things including creating CSV files (in various "formats") of what you specify in a INI file.

EvE Online portal | EvE markets tutorials
Megalex QC
Sebiestor Tribe
Minmatar Republic
#6 - 2014-04-02 10:03:59 UTC
Thanks for the suggestion but I'm not sure that's what I want. I just wanted a regular CSV like the "export to file" function from EVE.

Anyway I was able to make the program using that library, works fine.

If anyone wants it I can share the source code, you can compile it with free visual studio 2013.
Adunh Slavy
#7 - 2014-04-03 01:27:42 UTC
Megalex QC wrote:

If anyone wants it I can share the source code, you can compile it with free visual studio 2013.



Feel free to share, new toys are new toys

Necessity is the plea for every infringement of human freedom. It is the argument of tyrants; it is the creed of slaves.  - William Pitt