1 (edited by Tux 2014-05-19 06:35:34)

Topic: Data Exports from market

CSVmarketexport wrote:

"Quantity","Price","Base","Expiration"
"145 876","9.00 NIC","Asintec Beta Terminal","2215-08-13 00:53:00"
"1 000 000","9.50 NIC","ICS Alpha Terminal","2215-08-17 05:21:00"
"3 245 643","9.70 NIC","Hershfield Main Terminal","2215-05-29 06:47:00"
"29 051","10.00 NIC","Truhold-Markson Alpha Terminal","2215-05-19 20:55:00"

Above is an example of a market export.

The first column quantity returns what looks like numerical value that can be used in a spreadsheet or program to represent the value intended, but because of the formatting its considered to be a non numerical value and cant be used as a numerical value when exported.

The second column "Price" it returns a "name" non numerical value that can not be used as its intended value.

Has anyone come up with a solution to convert this easily I dont want to manually re enter all of this data. Im hoping for a better way.

DEVS: Can you fix this ...

I see a fix by moving the NIC from value and putting it in the column header

and formatting the values as true values like 1253456 not 1 253 456

Tux ~ Kill the messenger, he was part of it all along.
Euripides ~ Ten soldiers wisely led will beat a hundred without a head.
Bertrand Russell ~ War does not determine who is right - only who is left.

2 (edited by Inda 2014-05-19 09:33:06)

Re: Data Exports from market

I just simply changed the "." = "," and than I got correct value (but it may be in Hungarian Excel I am not sure about others.).

But I did that with my personal container, so the quantity was 5.0 => 5,0

Energy to Earth!

18.01.2014. [12:57:58] <BeastmodeGuNs> after that i remembered all those warning about 1v1 you lol, and i found out why xD

3 (edited by Elendil 2014-05-19 10:21:55)

Re: Data Exports from market

made a small python script:

https://www.dropbox.com/s/pgcelcsb5tsx6mr/parse.py

Put your file in the same folder as the script and name it "in.csv".
Run parse.py. That gives you an edited file "out.csv"

you need python 3.2 to run it.

Standalone for windows:
https://www.dropbox.com/s/kft7chb515pm9 … tParse.rar

example output:

1, 545207.13, Tellesis Main Terminal, 2215-05-29 09:20:00,
2, 550000.00, Tellesis Main Terminal, 2215-06-15 09:41:00,
13, 588396.06, Asintec Alpha Terminal, 2215-11-14 21:12:00,
1, 610000.00, Shinjalar Main Terminal, 2215-07-22 19:53:00,
12, 616999.00, Tellesis Main Terminal, 2215-10-30 17:34:00,
5, 619999.00, Truhold-Markson Alpha Terminal, 2215-08-08 06:08:00,

Re: Data Exports from market

Or simply run a replace (CTRL+F), replacing NIC with, well, nothingness.

Re: Data Exports from market

The issue here is that the export function doesn't really process what's in the grids, it just dumps the data out straight as it is.

[14:15:15] <Freya Sabbat> ...Dear god, the Devs are as bad as us

6 (edited by Tux 2014-05-19 16:04:41)

Re: Data Exports from market

DEV Gargaj wrote:

The issue here is that the export function doesn't really process what's in the grids, it just dumps the data out straight as it is.

I understand this ... is there a better way to format it in game for easy "usable" export ...

Ill try to run the suggested script, Im not too familiar with with python.

I may have write a Perl script to do it .. i was looking for a better way but thx Elendil ill try after work today.

Tux ~ Kill the messenger, he was part of it all along.
Euripides ~ Ten soldiers wisely led will beat a hundred without a head.
Bertrand Russell ~ War does not determine who is right - only who is left.

Re: Data Exports from market

I made an exe version too (standalone), you don't need to install python for that.
np

8 (edited by oaisdj98asd 2014-05-19 16:26:53)

Re: Data Exports from market

try to begin from common string handling functions like search and replace in any scripting language

9 (edited by Martha Stuart 2014-05-19 17:39:20)

Re: Data Exports from market

isn't there a way to convert strings to ints within excel?

10 (edited by Elendil 2014-05-19 18:29:55)

Re: Data Exports from market

I'm not that good with excel. I wrote the script as a python exercise for me smile
However I figured out how to remove stuff in excel:

=SUBSTITUTE(A:A;"""";" ")

but you can also let them remove by excel in the data import window.

=VALUE(SUBSTITUTE(SUBSTITUTE(B:B;" NIC";""); " ";""))

or whatever the substitute command is in your language.

11

Re: Data Exports from market

Martha Stuart wrote:

isn't there a way to convert strings to ints within excel?

If you find a way let me know ... ill be working on this more tonight

Tux ~ Kill the messenger, he was part of it all along.
Euripides ~ Ten soldiers wisely led will beat a hundred without a head.
Bertrand Russell ~ War does not determine who is right - only who is left.