| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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 :
historyDatelowPricehighPriceavgPricevolumeorders
2010.03.01 00:00:002710228891.1275001409622112
2010.03.02 00:00:0028183.852950028920.931257279127
2010.03.03 00:00:002929829899295001571289122
2010.03.04 00:00:0027809.8929893.9928943.21140575138
2010.03.05 00:00:0028260.9429999.98299851947975163
2010.03.06 00:00:0028498.252980028995.02901008127
2010.03.07 00:00:0029044.7829997.8229990.481373531132
2010.03.08 00:00:00283452980028545.571430193168
2010.03.09 00:00:002805829690.94295751092838105
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 ...
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |