open All Channels
seplocked EVE Technology Lab
blankseplocked Excel help
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Atima
Minmatar
House of Marbles
Posted - 2011.04.05 11:27:00 - [1]
 

I'm using reverence to create some .csv dumps

What I need is some method to autoimport these .csv's into a database sheet in the following format :


DATE - ITEM1avg - ITEM2avg - ITEMXavg


I can then use this to manipulate the data elsewhere.

I've been doing this with copypasta sofar, but I often screwup my copypasta work and get it everywhere :(. Also it takes ****ing ages.

Can throw 100mill your way for a successfull solution. Probably will make it easier if you have skype / teamspeak or whatever and a remote desktop app.




dexington
Caldari
Baconoration
Posted - 2011.04.05 12:13:00 - [2]
 

Could you maybe post a sample of the datadump, and make a sample of what you want the data to look like.

Atima
Minmatar
House of Marbles
Posted - 2011.04.05 12:32:00 - [3]
 

Edited by: Atima on 05/04/2011 12:34:47
Filenaming system : [Region]-[Item]-[date] [some number i think maybe item ID? notsure ] e.g. The Forge-Technetium-2011.04.05 102552

datadump content :

historyDate lowPrice highPrice avgPrice volume orders
2010.03.01 00:00:00 27102 28891.1 27500 1409622 112
2010.03.02 00:00:00 28183.85 29500 28920.93 1257279 127
2010.03.03 00:00:00 29298 29899 29500 1571289 122
2010.03.04 00:00:00 27809.89 29893.99 28943.2 1140575 138
2010.03.05 00:00:00 28260.94 29999.98 29985 1947975 163
2010.03.06 00:00:00 28498.25 29800 28995.02 901008 127
2010.03.07 00:00:00 29044.78 29997.82 29990.48 1373531 132
2010.03.08 00:00:00 28345 29800 28545.57 1430193 168
2010.03.09 00:00:00 28058 29690.94 29575 1092838 105




imported into the following format


DATE - ITEM1avg - ITEM2avg - ITEMXavg


my issue is that the date on the datadumps changes also, so it would need to replace old values.


It could be put into the following format :

DATE ITEM HIGH LOW AVG VOLUME QUANTITY

If you have 5mins to do some vlookup help.

I pick things up fast if anyone has the time for this.

Lutz Major
Posted - 2011.04.05 16:59:00 - [4]
 

102552 is 10 o'clock, 25 minutes and 52 seconds - the time of the export :)

Other than that, I don't think this is an easy task for an Excel macro either. I tried something similar years ago for work (multiple files for one item, (partialy) same content, ...) with not much of a success.

So I wrote a small converter in perl and imported the resulting CSV.

If you'd be happy with such a 'intermediate step', I wrote a MarketLog reader in Java and this could be easily adaptable ...


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only