[Resource] Precon / Sealed "Quick Add" (Page 3 of 5)

Oh my goodness! Thank you for reminding me. I got the CSVs created a couple nights ago, but it was super late so I decided to update the webpage later. Totally forgot to do so, as I'd sort of mentally checked off the Kaldheim decks. LoL

They have been added now.

Last edited by meldon44 (2021-06-03 22:11:17)

Superb resource!
Could you add a condition:NM column to .csv files going forward?

Just used this for the umteenth time and wanted to say thank you for the great work again. Saves me lots of time, thanks!

You can use some editor like Excel or Libre office Calc
Beware they sometimes corrupt CSV files with default settings
and might need checking some "advanced" options or manual fixes to work correctly in some cases.

CSV is a really simple format,
yet office software doesn't treat it seriously
there are often issues with:
- weird special character encodings
- random reinterpretations of data in cells (e.g. converting some numbers to dates, cutting digits from longer numbers)
- incorrect escaping of characters like comma or quote that have special meaning

Most of them based on the fact that CSV is simply text in row/column cells, and those programs try to do more...
If anyone knows good simpler CSV handling program I'd love to hear about it.
I tried looking for one online and what i found wasn't better than office software
And I had a lot of CSV files in my old job.
But combination of office software + notepad + some simple scripts in C# or python worked best.
Some file diff tool to check if office software changed something it shouldn't also helps sometimes.

Last edited by NamespaceV (2021-04-08 12:12:08)

Thanks for swift response I knew that Excel works (as PC automatically recommends it for .CSV) but was mostly hoping it can be change all at once somehow Ofc still much more better copy-paste Mint to all rows then doing changes in inventory after. So appreciate detailed guide!

Regarding the condition. I know it would sound suspiciously convenient for me but Mint condition as default for sealed products sounds like right choice imo. Played precons are usually modified and would not match CSV anyway. Also older products may be open for speculation but from lets say now on with new products just after release, everyone will have them in Mint condition - and if not shame on them!

Other point of view would be at least NM as we should assume MTG players are not animals and they care about they cards, therefore majority of us would have cards in decent condition.

Last edited by beliard (2021-04-09 06:06:40)

So I did some research, and this has to do with how specifically Excel on Windows interprets and displays UTF-8 encoded files. In short, it doesn't like them, and shows you weird character strings instead of the correct ones. However, if you were to view the CSV in another program, like Notepad++, the correct characters are visible in the file.

I found a way to fix this issue that doesn't seem to interfere with Deckbox import. Let me know if you encounter any issues, but now you should be able to download and view the files in Excel without issue, as well as import them into Deckbox.

(For those interested, I batch-converted all the CSVs to use UTF-8 with BOM. Excel apparently needs that Byte Order Mark to know it's actually UTF-8 and not Windows-1252. Dumb.)

This is a different issue than the above. The tildes are part of Deckbox's naming convention for that card, just as quotation marks are part of Kongming, "Sleeping Dragon" or the exclamation point is part of To Arms!. Deckbox won't let you import those cards without the tilde/quote/exclamation included. In other words, there's nothing to "fix" in this case. Instead, you'll just have to account for those characters when searching within your CSV export.

That said, I could see a valid argument for Deckbox accepting both To Arms! and To Arms as equivalent names. Going back to special characters, you're already able to import either Dandân or Dandan into Deckbox without error. The same could easily be true for card names that have punctuation in them. If you think that would help you, I'd suggest bringing it up to Sebi via a support ticket. It might not be that hard for him to implement since he already has some version of it in place for accented vowels and the like.

That's frustrating. Thank you for letting me know. Interestingly, the names got garbled in a completely different way than on Windows. I'm sure it has to do with how Excel is (mis)interpreting the character encoding again. Unfortunately, I don't have a Mac to test on, but I'll see if I can find a solution.

As a temporary solution, you could consider trying to open them in Google Sheets or another non-Excel spreadsheet program. I read that Sheets doesn't have this issue. Other programs may not have all the features you need, though.

Just out of personal curiosity, what type of searches are you performing that get messed up by tildes but wouldn't by hyphens? And how do they get messed up, as in, what's the messed-up result look like?

Any chance of the new Commander decks being posted any time soon?  Thanks for all you do!

https://bit.ly/MTG-M12-Illusionary-Might
100% Accurate CSV
Contains invalid rows

Reported by Deckbox [incomplete!]
4     Island         237     Magic 2015     English
5     Island         236     Magic 2014     English

invalid rows [complete]
5    Island        235    Magic 2013    English
5    Island        236    Magic 2014    English
4    Island        237    Magic 2015    English

Corrected rows
5    Island        235    Magic 2012    English
5    Island        236    Magic 2012    English
4    Island        237    Magic 2012    English

Dang Excel auto-incrementing cell values! I thought I had caught all those — thanks for pointing this out! It's corrected now.

You had me worried for a second that I had somehow missed the existence of a whole other event deck! LoL. That's actually an intro pack, not an event deck. So I feel better now. 

And yes, most of the intro packs are missing, nor do I plan on creating CSVs for them (there's just such a huge quantity of intro and theme decks). So thank you for taking the time to create a CSV for it — that's how they'll get added.

Unfortunately, Deckbox's forum attachments are still broken. It gives me a SQL error when I try to download it. If you're able to provide it via a cloud storage share link (Dropbox, Google Drive, whatever is fine), I'll get it added.

NEW CONTENT

Neon Dynasty Commander

• Buckle Up

• Upgrades Unleashed

VERIFIED CONTENT

Verified the following decks via unboxing videos:

• Gleeful Flames (DKA event deck)

• Deathfed + Hold the Line (ISD event decks)

• Into the Breach (MBS event deck)

• Duel Decks: Jace vs. Chandra

• Deckmasters: Garfield vs. Finkel

• Rakdos Raid (RTR intro pack)

Still can't find anything for the original duel deck, Elves vs Goblins, or a couple of the oldest event decks. Would love if someone who has those could verify their contents!