EVE Technology Lab

As teh name suggests im haveing a big issue with xml and eve central atm. I compare selling prices of 2 stations. Jita and Dodixie. Jita always has data just fine but even when i upload myself with the uploading client., hours later my xml query still returns all 0's. When i go to the site the info is there. just not given in xml queries i guess.

So are there any more reliable alternatives to eve central?

Mort.

In your opinion what one is most reliable?

I might make 3 spreadsheets based of all sites. Unfortanatly each sheet i make has every single item in game. Ive already sunk 40 hours in this one and im not half done. Error checks. doesn't give false profit readings if xml returns 0. Long if statements that took me 3 hours to develop as a error check. Think my road just gor a little bump but i appreciate your input. Fly safe friend and thanks.

Mort.

Spreadsheets have their place, but when you get larger data sets, databases tend to be the way to go. Though you'll normally need to use something else to manage the data load into them. a scripting language like perl or php is a reasonable option. Easier to debug, too.

As for getting the data back out, in a usable form, a scripting language, or a suite like crystal reports (jasperserver is free. iReport isn't bad for writing the reports) helps. Or excel, as you can hook that up too.

You will need to know SQL though.

Also, for little things - Google spreadsheets with the ImportXML() function perform wonderfully.

Great for planning out T1 production (ammo, drones, modules, ships) where it's easy to put 1 item per row and you can decide which regions to check for market prices.

T2 invention is a little trickier in a Google spreadsheet, but you can easily set something up to do 20-30 different items in the same sheet, then summarize it on a front page.

You think?

I just launched a centralized market order update system, just came out of alpha test with some friends, it may be of interest so I'm posting...

You point it at a MySQL or MSSQL database.

It scrapes cache data from the market as you click in game and injects the buy/sell orders into the database (with some help from libevecache's dumper). Then syncs the orders with a central database, picking up universe wide data for you as it goes.

In simple terms...

1. You view the ingame market for "Raven" in "The Forge".
2. Wait a minute for sync.
3. Your local SQL database contains all known available public buy/sell orders for "Raven" from every region in the universe.

Notes...

1. Order sync data is compressed, 500 orders is about 50KB of data.
2. It syncs known active orders, it does not sync historical data, but history does build up in your local SQL database as orders disappear from the market.

Details here

Best way to get help/support is show up in the ingame channel - see the FAQ for details.

Enraged:

I tried to download your program but the zip file is corrupt.

What you've used to unpack it?
("Windows explorer" is a wrong answer.)