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.
Please use the contact form and we can arrange a manual import.
April 14, 2017 12:15 a.m.
sawyerrt10 says... #6
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.
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.
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.
notorius-B.D.A.W.G says... #15
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.
notorius-B.D.A.W.G says... #16
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.
notorius-B.D.A.W.G says... #17
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.
notorius-B.D.A.W.G says... #18
My bad, it's my bad PowerShell kungfu, the missing cards were basic lands. Makes sense.
November 1, 2017 2:23 a.m.
JoshebBasshebeth says... #19
I'm trying to bring in a CSV file that I exported from MTGGoldfish, and I'm getting a message that says it's processing, but it doesn't do anything. I'm not familiar with these types of files, please help!
Thanks!
February 1, 2018 10:12 p.m.
Greetings---
Last night, I wrote this Powershell Script to convert my MTGO .dek output to a copy-and-paste-friendly .txt file:
https://github.com/p3hndrx/mtg-sdn/blob/master/dek-to-tappedout.ps1
Just change the paths to something that works for you...
February 13, 2018 5:34 p.m. Edited.
magicguigui says... #21
Hello p3hndrx , i see that you get some great dev skill is it maybe possible to get a script for convert deckbox inventory export csv to tappedout format ?
Thx a lot =)
February 26, 2018 10:02 p.m.
Archerman123 says... #22
I am trying to use the "export as CSV" option of Denvers lens too then import it here, but it keeps telling me there is "and error on line 1". I trying things like keeping the info too minimal (only multiverse ID and quantity) and removing the first line telling the structure of the CSV. I can't seem to be able to make it work
February 24, 2020 11:12 a.m.
I'm having difficulty uploading my .csv. I don't mind manipulating my data myself but I need a template to start with. Is one available?
I applied information such as language, card name, and set codes from the TappedOut formatting guide. I am not sure how to format the foil quantity column. Can I use [blank] (i.e. no text) to represent zero or do I have to use "0"?
I believe most columns are correct, but my current test file has been importing for over 2 hours. I want to make sure I get the formatting right the next time I am allowed to try uploading the file.
notorius-B.D.A.W.G Do you have a copy of your successful .csv you could share with me?
August 22, 2020 6:43 p.m.
notorius-B.D.A.W.G says... #25
Pshar sorry I don't have the file any more, it was a long time ago.
September 2, 2020 7:02 a.m.
Archerman123 says... #26
Here is what it looks like, sorry for late answer (had trouble deleting the first line before, ill try again now):
```
Foil Quantity MultiverseID Name Foil 1 0 Never // Return Foil 4 79204 Hideous Laughter 4 15398 Mischievous Poltergeist 2 389606 Mutilate 3 389507 Everglades Foil 1 447246 Murder 1 469876 Gravewaker 4 242500 Tragic Slip 1 443099 Blackblade Reforged 4 136208 Korlash, Heir to Blackblade 1 476099 Rise from the Grave 1 96969 Caustic Rain 3 190580 Duress Foil 1 205222 Diabolic Tutor Foil 1 259677 Murder 4 442104 Will-o'-the-Wisp 4 213799 Go for the Throat
```
September 2, 2020 4:35 p.m. Edited.
Archerman123 says... #27
ipp, lemme retry. Tapped out css stoped working when I posted that
Foil Quantity MultiverseID Name
Foil 1 0 Never // Return
Foil 4 79204 Hideous Laughter
4 15398 Mischievous Poltergeist
2 389606 Mutilate
3 389507 Everglades
Foil 1 447246 Murder
1 469876 Gravewaker
4 242500 Tragic Slip
1 443099 Blackblade Reforged
4 136208 Korlash, Heir to Blackblade
1 476099 Rise from the Grave
1 96969 Caustic Rain
3 190580 Duress
Foil 1 205222 Diabolic Tutor
Foil 1 259677 Murder
September 2, 2020 6:18 p.m.
Thank you kindly! I reached out to the admin as well and they were a lot of help. The data I am importing doesn't include multiverseID unfortunately. I have set codes, but am having difficulty adding Tappedout Promo set codes. If I figure it out I will post here.
September 5, 2020 12:37 p.m.
magicguigui says... #29
Hi all, i'm still looking for a way to import my deckbox.org inventory to my tappedout one.. still can't find some way to do so. Maybe someone as advice, tips, etc ? Thx guys !
September 14, 2020 6:02 p.m.
magicguigui Can you export a .csv from deckbox? If so you will need to check it against tapped out rules and upload it via TappOut's import csv function. I'm bringing in cards from another app, so the method I am working out will probably not help you but it will be similar. Compare all your deckbox values with the appropriate values for import to TappedOut.
I am going to get in touch with the tapped out site admin over the next several days and try to work out the final kinks in my own spreadsheet. I should have a general steps file that should help you if you are still sorting out the preliminary steps in your method.
September 20, 2020 11:51 a.m.
magicguigui says... #31
Hello Pshar , yes i can export to .csv file with 1column x multiple line. On each line data are like this : Count,Tradelist Count,Name,Edition,Card Number,Condition,Language,Foil,Signed,Artist Proof,Altered Art,Misprint,Promo,Textless,My Price
Oh yes I'm very interested by your current work on this!
October 3, 2020 12:31 p.m.
magicguigui the site admin was quite responsive on discord, highly recommend taking any questions you may have there. I've been having problems with the tappedout css page for the past month, but inquired about it this week. Once that is cleared up I'll finish up my tests.. hopefully everything gets resolved soon, I have a fairly large collection I'm excited to upload here!
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.