Importing to TappedOut via CSV
Posted on April 14, 2017, 12:07 a.m. by Dnomy
So I have my collection already listed on an app on my phone. The problem is that it only exports in CSV. I want to put the collection on TappedOut to use some of the website's features, but seeing as I only have a CSV, I'm kinda stuck. Does anybody know how to either import to TappedOut directly by CSV or convert from CSV to regular list? (4 forest 4 plains 4 swamp etc.)
Any help greatly appreciated.
I'd assume your using Decked Builder, as it's the only one I know of using .CSV. I have the same app, and I've tried to do this numerous times myself with no avail, so I'm afraid your going to have to manually add it.
April 14, 2017 12:12 a.m.
Please use the contact form and we can arrange a manual import.
April 14, 2017 12:15 a.m.
What about importing in a *.dck format? Is there a way?
April 16, 2017 5:15 p.m.
maybe. could you paste a sample of what you've got so i can take a look?
April 16, 2017 5:38 p.m.
sorry meant to come back and say i figured it out. I had to open the file in excel, copy/paste and format but i got it done. Thanks for the quick response!
April 16, 2017 6:23 p.m.
Is importing via csv a planned future feature?I manage a collection of over 35k cards on another platform and not really looking to change that method. I would however like to use features here that involve the inventory function. I would like to periodically update my inventory here, deleting the current inventory and importing a fresh file.
April 17, 2017 12:06 p.m.
Send to contact form and I'll load you up. One thing is I'd like to see what kind of formats people are using before crafting something, moxy
April 18, 2017 1:21 p.m.
you can now upload your inventory via CSV. please let me know if you have any problems.
April 24, 2017 5:11 p.m.
Is there a tappedout.net page that shows desired format for CSV imports?
I think it looks like you want the following fields (and in this order?):
qty,card,set tla,set name,language,condition,foil qty,foil
May 19, 2017 9:41 a.m.
Ahhh I see, I can set it to take whatever I've got. This is great! Thanks!
May 19, 2017 1:33 p.m.
I'm having problems with Commas in names, e.g. sample of my CSV: -
1, "Braids, Cabal Minion", ODY, 1.35, 0, 0, 0, 29/10/2017.
Columns are: Quantity, Name, TLA, PurchasePrice, Foil, Condition, Language PurchaseDate (export from MTG Manager). I have used 1, 2, 3, N/A, N/A, N/A, 5, N/A on the import form for column numbers (some columns of input aren't used). I get errors: -
Tla: TLAs not found: JUD, STH, TMP, MEMORY OF LOYALTY", THE BLOOD WITCH", HOUSE OF SHADOW", SOK, DST, LGN, RAV, 4ED, THE RESTLESS TOMB", ONS, WTH, NATURE'S ARTISAN", MRD, LORD OF SECRETS", KLD, ICE, PDS, CHK, DDQ, 3ED, SPIRES OF ORDER", DDJ, DDH, ULG, CABAL MINION", BFZ, GPT, 7ED, NMS, ZEN, FIRST TO DREAM", WHO SPLIT THE HEAVENS", MMQ, OGW, PLS, INV, M15, QUEEN OF THE GOLGARI", SOI, APC, USG, SCG, 8ED, PYROGENIUS", ATQ, BOK, DIS, 5DN, MIR
I have already renamed H09 to PDS. In the above I noted the commas in names causing issues. The import is not honouring the quotes around the names.
November 1, 2017 1:13 a.m.
I worked out the problem was the spaces after commas. I got rid of the spaces and it worked. Every card shows in the inventory twice once as a foil and once as not, most foils have qty 0. In the source CSV the foil column seems to be a boolean (0=not foil, 1=foil), so I made sure I was specifying that column as a Foil not Foil Qty. Also I processed the CSV so it used FALSE/TRUE rather than 0/1. After I removed the spaces after the commas, I was able to import names that had commas in them (names are quoted).
November 1, 2017 2 a.m.
For some reason it is missing the last 37 items. My input CSV has 1299 unique cards, and the upload has only 1262. The missing items are the last 37. The input list is sorted alphabetically on name. The first missing item is Weight of Spires and the last missing item is Zur's Weirding. The last item that made it in was Wear Away.
November 1, 2017 2:14 a.m.
My bad, it's my bad PowerShell kungfu, the missing cards were basic lands. Makes sense.