Importing to TappedOut via CSV

TappedOut forum

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.

Atony1400 says... #2

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.

yeaGO says... #3

Please use the contact form and we can arrange a manual import.

April 14, 2017 12:15 a.m.

Dnomy says... #4

Thank you! I just didn't know how.

April 14, 2017 12:20 a.m.

yeaGO says... #5

Yeah there's no way but I do it manually upon request

April 14, 2017 12:32 a.m.

sawyerrt10 says... #6

What about importing in a *.dck format? Is there a way?

April 16, 2017 5:15 p.m.

yeaGO says... #7

maybe. could you paste a sample of what you've got so i can take a look?

April 16, 2017 5:38 p.m.

sawyerrt10 says... #8

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.

moxy says... #9

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.

yeaGO says... #10

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.

yeaGO says... #11

you can now upload your inventory via CSV. please let me know if you have any problems.

April 24, 2017 5:11 p.m.

izlosst says... #12

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.

yeaGO says... #13

It's flexible, take a look at the form

May 19, 2017 11:07 a.m.

izlosst says... #14

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.

November 1, 2017 2:23 a.m.

Please login to comment