meldon44 wrote:[color=blue]@cepragassen[/color] and [color=blue]@beliard[/color] — I'm thinking of doing a poll, though I'm not sure where it would get the most exposure, to see what the community would overall prefer for default condition. Already just between you two, there's already disagreement between Mint vs NM. That's the whole reason I didn't include a condition in the first place — some people will be using it to add still-sealed products (mint) while others will be adding precons they've played with with their kids a ton (LP-MP). However, since two people have expressed desire for a default condition, it's possible more people than just you guys would prefer some condition to none.

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 :D 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 :D 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! :D

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.

Hello, meldon44!

Thank you for the CSV work, and quick question for you: are you able to fix things like names that don't show up properly in exports, like Dandan, Marton Stromgald, and others with special characters? Or like Surgeon General Commander where the tildes in the name cause search errors when looking up to a CSV export?

Not sure if this is your realm, but figured I'd check.

Thank you!

Solseek wrote:are you able to fix things like names that don't show up properly in exports, like Dandan, Marton Stromgald, and others with special characters?

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.)

Solseek wrote:Or like Surgeon General Commander where the tildes in the name cause search errors when looking up to a CSV export?

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.

meldon44 wrote: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.

Hello, meldon44, thank you for looking at this! I'm using Excel on a Mac, and I'm still getting "Márton Stromgald", "Lim-Dûl's Vault", "Ghazbán Ogre", and "Dandân", for example. This is from a CSV export from last night.

Also, none of my issues are with importing (it's all export-related).

I'll check with Sebi if we can change the name of "Surgeon ~General~ Commander" to "Surgeon -General- Commander". Specifically those tildes mess up searches.

Thank you!

Solseek wrote:I'm using Excel on a Mac, and I'm still getting "Márton Stromgald", "Lim-Dûl's Vault", "Ghazbán Ogre", and "Dandân", for example. This is from a CSV export from last night.

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.

Solseek wrote:I'll check with Sebi if we can change the name of "Surgeon ~General~ Commander" to "Surgeon -General- Commander". Specifically those tildes mess up searches.

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?

meldon44 wrote: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?

Tilde in Excel is a wildcard, so it's impossible to look up Surgeon ~General~ Commander with anything requiring an exact match (vlookup, for instance). The minus sign is a character (not a wildcard), so that can be found exactly.

All this said, I put this in the "nice to have" bucket... I work around this issue when analyzing collection data, but it would be nice to change it (and never use a tilde again). ;-)

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

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

You beat me to the punch! :) I started working on them earlier this week, till life got in the way. But I'm finishing them up tonight and will have them posted soon.

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

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

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

[u]Corrected rows[/u]
5 Island 235 Magic 2012 English
5 Island 236 Magic 2012 English
4 Island 237 Magic 2012 English

I noticed you didn't have the following pre-con available, so I made one for you.

Intro Pack - Battle For Zendikar - Rallying Cry (Hero of Goma Fada)

bragaul wrote:M12-Illusionary-Might ... Contains invalid rows

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

bragaul wrote:I noticed you didn't have the following pre-con available, so I made one for you.
Event Deck - Battle For Zendikar - Rallying Cry (Hero of Goma Fada)

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.

meldon44 wrote: That's actually an intro pack, not an event deck.
...
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.

Good catch on the distinction! Here's the link to the intro pack: https://drive.google.com/file/d/14ZkF7Tne3_yVhUew0xDeXkwz8GOby_9m/view?usp=sharing

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!

meldon44 wrote: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!

I have the Anthology version of Elves vs. Goblins. Would reviewing that help in any way?

meldon44 wrote: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!

I still can't believe they managed to screw up Upgrades Unleashed so badly. That kind of screwup should be completely unthinkable.

Solseek wrote:I have the Anthology version of Elves vs. Goblins. Would reviewing that help in any way?

Maybe. I just can't remember whether or not the Anthology versions are exact 1-to-1 duplicates of the originals in the basic land distribution. If they are, then yes, I think we could state with very high confidence that the OG deck is verified if it matches the Anthology deck.

I'm at work and can't check till later. If you're able, compare the other three decks and let me know if they're identical in the basic lands.

RDPARTY wrote:I still can't believe they managed to screw up Upgrades Unleashed so badly. That kind of screwup should be completely unthinkable.

100% agree that it's an absolutely egregious error. Sadly, though, considering their recent track record of quality control, I can totally believe it and these screwups no longer surprise me.

That does remind me, though, that I should probably add a little note to that CSV on the page. Thanks for pointing it out!

meldon44 wrote:If you're able, compare the other three decks and let me know if they're identical in the basic lands.

The Bitly links are blocked for me, so I can't compare these to anything, but here's the land distribution for the four Duel Decks Anthology pairings (not sure how to make this pretty):

Expansion # Name Qty
Duel Decks Anthology, Elves vs. Goblins 28 Forest 5
Duel Decks Anthology, Elves vs. Goblins 29 Forest 5
Duel Decks Anthology, Elves vs. Goblins 30 Forest 5
Duel Decks Anthology, Elves vs. Goblins 31 Forest 4
Duel Decks Anthology, Elves vs. Goblins 59 Mountain 6
Duel Decks Anthology, Elves vs. Goblins 60 Mountain 6
Duel Decks Anthology, Elves vs. Goblins 61 Mountain 5
Duel Decks Anthology, Elves vs. Goblins 62 Mountain 5
Duel Decks Anthology, Jace vs. Chandra 30 Island 6
Duel Decks Anthology, Jace vs. Chandra 31 Island 6
Duel Decks Anthology, Jace vs. Chandra 32 Island 6
Duel Decks Anthology, Jace vs. Chandra 33 Island 5
Duel Decks Anthology, Jace vs. Chandra 59 Mountain 6
Duel Decks Anthology, Jace vs. Chandra 60 Mountain 6
Duel Decks Anthology, Jace vs. Chandra 61 Mountain 6
Duel Decks Anthology, Jace vs. Chandra 62 Mountain 6
Duel Decks Anthology, Divine vs. Demonic 26 Plains 6
Duel Decks Anthology, Divine vs. Demonic 27 Plains 6
Duel Decks Anthology, Divine vs. Demonic 28 Plains 6
Duel Decks Anthology, Divine vs. Demonic 29 Plains 6
Duel Decks Anthology, Divine vs. Demonic 59 Swamp 6
Duel Decks Anthology, Divine vs. Demonic 60 Swamp 6
Duel Decks Anthology, Divine vs. Demonic 61 Swamp 6
Duel Decks Anthology, Divine vs. Demonic 62 Swamp 6
Duel Decks Anthology, Garruk vs. Liliana 28 Forest 6
Duel Decks Anthology, Garruk vs. Liliana 29 Forest 5
Duel Decks Anthology, Garruk vs. Liliana 30 Forest 5
Duel Decks Anthology, Garruk vs. Liliana 31 Forest 5
Duel Decks Anthology, Garruk vs. Liliana 60 Swamp 6
Duel Decks Anthology, Garruk vs. Liliana 61 Swamp 6
Duel Decks Anthology, Garruk vs. Liliana 62 Swamp 6
Duel Decks Anthology, Garruk vs. Liliana 63 Swamp 5

Alright, got a chance to check everything. First, I went through and compared the basic land artwork in the Deckbox editions for anthology vs OG. All artworks / collector numbers line up and go in the same order. Second, I compared the CSVs for Garruk v Liliana and Jace (unfortunately, Divine Demonic and Chandra all have equal 6/6/6/6 distributions, so they aren't helpful). The quantities matched between anthology and OG.

Based on this consistency, I'm going to go ahead and consider the Elves v Goblins CSV verified.... unless someone ever opens up this $200+ sealed product and can tell me otherwise!

Hi @meldon44. Will you be adding 2022 standard challenger decks soon?

cepragassen wrote:Hi @meldon44. Will you be adding 2022 standard challenger decks soon?

Oh dang! I didn't even know these released! Totally slipped past my radar -- I apologize. Thank you for pointing them out.

I can try to get them up tomorrow night.

meldon44 wrote:

cepragassen wrote:Hi @meldon44. Will you be adding 2022 standard challenger decks soon?

Oh dang! I didn't even know these released! Totally slipped past my radar -- I apologize. Thank you for pointing them out.

I can try to get them up tomorrow night.

Thanks!

Would it be possible to repost the link in the main message? The current one is being blocked by bitly for some reason.

cheesestring wrote:Would it be possible to repost the link in the main message? The current one is being blocked by bitly for some reason.

Uuuugh. I opened a dispute with Bitly a while ago and apparently nothing ever came of it.

Alright, I just went ahead and edited the link to go directly to the page. I was only using Bitly to track page visits anyways, in order to measure interest and utilization. But that's not helpful if people can't even visit the page!!

NEW CONTENT

Challenger Decks 2022

• White Aggro
• Dimir Control
• Rakdos Vampires
• Gruul Stompy

EDIT: Apologies for the broken links. See my comment below. But they are fixed now. :) Please report any others that crop up and I'll fix them as well.


IMPORTANT NOTE: Many of the tokens will not import until Sebi adds them to the database. UNFORTUNATELY, this will stop the entire CSV from importing. I used to be able to add the tokens as "information only" without putting a number in the Count column, and Deckbox would ignore those rows during import. However, now any missing Count value will throw an error.

So I had a choice between leaving the tokens out of the CSV until they're in the database, or creating a CSV that doesn't fully import yet. I went with the latter "more info is always better" approach and kept the token info intact, trusting that most MTG players will be able to figure out how to get the rest of the CSV to import. However, if this is a major problem for multiple people, I may change my mind.

(And I've brought this issue up with Sebi; waiting on a response.)

meldon44 wrote:NEW CONTENT

Challenger Decks 2022

• White Aggro
• Dimir Control
• Rakdos Vampires
• Gruul Stompy

Thanks! sadly the links are still blocked by bitly

Reap the Tides also being blocked by bitly currently. I did open a ticket with them saying it should be fine yesterday though.

meldon44 wrote:NEW CONTENT

Challenger Decks 2022

• White Aggro
• Dimir Control
• Rakdos Vampires
• Gruul Stompy

Been blocked by Bitly for a while. I even filled out the form a few days ago, but no luck so far.

I'm sorry guys for all the issues. I saw all the broken link reports right before I went out of town, so I couldn't do much over the weekend. I've temporarily fixed the issue for the ones reported so far (Challenger 2022, Reap the Tides, C19), but it's not a permanent solution, so please continue to report any broken links and I'll fix them as they come up.

I've been working on a huge new release for a while now, with new features and a move away from Bitly / Dropbox. It's not as polished as I want it to be, but apparently it'll be necessary to release it ASAP as a permanent fix to the Bitly shutdowns.

Came across issues with:

KHC Elven Empire
CMR Armed for Battle
C21 Silverquill Statement
ZNC Sneak Attack

I reported them as "Falsely marked as abuse" but since you've had no luck contacting them I doubt it will make a difference.

I also don't see those CSVs on your github repository, you may be able to upload a mirror on mega or zippyshare if you're having issues with bitly.