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 ... |