search

alexander-pick / MKMTool

MKMTool ist a helper application I wrote for tinkering around with optimization of sale processes on magiccardmarket.eu and the idea of automisation of some tasks most people wouldn’t be able to get done by pure manpower.
GNU Affero General Public License v3.0
65 stars 15 forks source link

Buyexport #16

Closed Brudolfer closed 3 years ago

Brudolfer commented 5 years ago

Hey There,

i had an issue after exporting my "Buys to Excel"

after hitting the Button excel opened smooth and created the list, but i think there went something wrong :-D

Unbenannt2

thanks in advance for your help!

tomasjanak commented 5 years ago

Hi,

do you mean the weird symbols in some of the card names? It is outputting the name in the language of the card, so for Asian & Russian language cards there are sure to be all kinds of problems with character sets. Not sure anybody has the time and interest to make sure it works fine. The most I would be willing to fix about this is to make it write English names.

If you mean the weird numbers in the last column, that is just excel trying to interpret the values as dates, because it sees numbers separated by '.'. Since you are on German locale, the decimal separator is ',', not '.', so it does not see it as numbers because according to your locale, numbers don't have '.' in them. You can either change your system locale to use '.' as decimal separator (probably an overkill) or select the whole column and replace (CTRL+H) all '.' with ',', then I think it will automatically start treating it as numbers (if not, select the whole column -> right click -> cell format -> select Number).

I'm not sure that this is something we will ever change in MKMTool - MKM is sending all numbers with '.' as separators, so outputting something like this is easy. To change it to the locale of the user (you), we would have to parse everything that is a number and re-format it before writing it out. It can be done, but then it also means that any "import" feature would have to change it back to '.'.