CSV exports from ManaBox

[GutterGod]

Hey
I would love to see support for CSV files coming form ManaBox (mobile app). I attached a sample file. Thx in advance.

[Nils]

Hi - the CSV file is actually almost in the right format except for one problem: Either the file has to use a different separator like semicolons or tabs, or card names with a comma in them (like Jolrael, Mwonvuli Recluse) need to be enclosed in quotation marks. Because of that it's not a valid CSV file, which is not really something we can fix on our end.

Could you try asking the authors of the app if they could fix their CSV export?

[GutterGod]

Hey Nils, thanks for your answer. I will try to reach out to devs with your explanation. In the meantime I might be able to transform the files myself.

[GutterGod]

Using Notepad++ I am able to adjust the CSV in seconds. Both replacement actions can be saved in macros:

1. Adjust first line to deckstats standard

Code: [Select]

Search: (?-s)\A^.*$
Replace: card_name,set_name,Set name,collector_number,is_foil,amount,ManaBox ID,Scryfall ID,Purchase price,Misprint,Altered,condition,language,Purchase price currency

2. Adjust foil info

Code: [Select]

Search: (,normal,)|(,foil,)
Replace: (?1,0,)(?2,1,)


[Soubi]

The export format of Manabox changed, they now have a Rarity column.

I just deleted it with Libreoffice before applying the procedure from GutterGod