Search options (Page 17 of 18)

Hey, no problem! I already had the file created for myself, so I figured I'd share it. (The only work on my part was to type out detailed instructions. LoL)

And to each his own! Honestly, the way you and settlerjoe are doing it sounds like way more work to me. Cuz now that I have all my decks in that Deck Checker, if I make a change to a deck, I just update both the Deck Checker and Deckbox decks (like 30 seconds total). And I've always exported a CSV of my inventory anyways for backup if I make a change to it, so that doesn't take any *extra* time for this Excel-based approach (but even if you're not already doing that, again, takes like 30 seconds, if that). And then all I have to do to see a list of cards I'm missing is to open Deck Checker and my latest Inventory CSV. It's an always up-to-date list of missing cards, with none of the hassle that you and settlerjoe describe.

And adding / removing a deck is super easy and fast. None of that making changes to an "All 14 decks" deck.  :\

You could always give it a shot! You never know. You might like it.

(And now I suddenly have Dr. Seuss' "Green Eggs and Ham" in my head. LoL!)

I agree with this wholeheartedly. I first noticed it with the FTV series -- they should be auto-foil.

I feel like solution #2 is more of a "patch job", and it would better in the long run to fix the core issue (solution #1).

That said, there's no reason both things couldn't be implemented, ultimately. It would probably be a useful Wishlist setting -- choose whether to use "Strict mode" for foiling, which is already possible with "Edition" by simply not setting an edition when you add a card to your wishlist.

If we had both, then you could have one be strict and one not, e.g. "I don't care what edition it's from, just as long as it's nonfoil" or "I don't care if it's foil or not, just as long as it's from this edition with the artwork I love". You could also not care about either, or be very specific about both.

But regardless, the main thing is that it doesn't make sense to be able to add a nonfoil FTV or what have you (and conversely, many cards have no foil counterpart).

Hey, looks like the CSV file failed to upload with your post.  :\

Before attaching it, though, check the CSV to ensure it has "Count" and "Tradelist Count" columns, and that these columns are filled with numbers. Because you can actually include an entry for a card and put a 0 in the Count column (or leave it blank), and the CSV will import without error, but obviously not include that card in your inventory! So your problem might be as simple as that. 

If the CSV does include some sort of "quantity" column, but it's just not named "Count", just rename the header and that should fix it.

If that doesn't help, definitely get the file uploaded, and I or someone else would be glad to check it for you!

Arena League (Card #2)

Hello!

I just went through the following steps, and successfully imported your inventory into Deckbox. I've attached your converted inventory, so that you don't have to actually go through the work, unless you want to try it yourself.

I apologize for the verbosity of these instructions. Many people may not need every step detailed like this, but for those that do, they'll appreciate not having to ask!

INSTRUCTIONS

1. Change the file extension to .csv (either directly by manually typing it in from your file browser, or by opening the .coll2 file in Notepad and Save As... to a .csv with ANSI encoding).

2. Open in Excel (I'm using 2010, so some instructions may differ).

3. Save your file and click "Yes" at the warning.

   
   

   NOTE: Stop here and use the macro listed below in bburrows reply. Major time saver! After running the macro, pick back up at Step 12.

   
   

   #################################
   

4. Delete column A ("Total Qty"), then delete the new columns E - M ("Mana Cost" - "Price Source").
   

   • TIP: To fully delete, highlight the columns, right click, and choose Delete. Don't just clear the cells' contents.

   • TIP: If you have any notes saved, keep the "Notes" column. It won't hurt the import into Deckbox, and you can then more easily re-add the notes to Deckbox by filtering this column and going through the cards.

5. Important: Change the column headers as follows: Reg Qty & Foil Qty > Count, Card > Name, Set > Edition. (Yes, both columns A and B should be named Count. You'll see why in a minute.)

6. Important: Insert a new column (I usually prefer it after the "Name" column, but it actually doesn't matter), and type "Foil" as the header.
   

   • TIP: You most likely will also want to insert 2 more columns, named "Condition" and "Language", and fill the entire Condition column with "Near Mint" or "Good (Lightly Played)", and the Language column with "English". If you don't do this, Deckbox will display them without a condition or language, rather than applying your defaults. See step 9 for a tip on quickly filling an entire column.

7. Right-click the sheet's tab, choose "Move or Copy...", and check the checkbox for "Create a copy".

8. In the original sheet, delete column B (used to be Foil Qty). In the copied sheet, delete column A (Reg Qty). Now you should only have one "Count" column on each sheet.

9. Important: On the copied sheet (your foils), fill the entire "Foil" column with "foil".
   

   • TIP: If you have all the cells selected, press F2 to enable entry in the active cell, type "foil", then press Ctrl+Enter. This auto-fills all the cells.

10. Now select all the entries in the copied sheet (your foils) and copy it to the end of the data in the original sheet. Don't worry about all the rows with a count of 0 -- they won't matter.
    

    • TIP: To easily select all the correct data, delete row 1 on the copied sheet (the header row), then press Ctrl+A.

    • TIP: To quickly jump to the end of your regular cards, press Ctrl+A (Select All), which jumps the view down to the final row.

11. Delete the copied sheet.
    #################################

    
    

12. Save your file and click "Yes" at the warning.

13. Attempt a first upload. I say attempt, because you're going to get a long list of errors due to non-matching edition names. (I've provided a list below that I encountered in this specific inventory.) Make note of the incorrect edition names. You'll find the Deckbox equivalent on the "Editions" page.

14. Use Ctrl+H to Replace All for each affected edition. Then press Ctrl+S (or click the save icon) and click "Yes" at the warning

15. Re-import (you don't even have to click "Browse" again on Deckbox; just click the "Check file and import" button on the already-selected CSV).

16. Assuming you caught all the edition name errors, you should be golden! Otherwise, repeat steps 12-15 until you get it right.

17. When you try to close the file in Excel, it'll ask you to save the changes. Since you just saved it in the previous steps, go ahead and click "Don't Save".

List of Mismatched Editions (in this inventory)

DECKED BUILDER NAME > DECKBOX NAME

• Commander 2013 Edition > Commander 2013

• Duel Decks: Kiora vs. Elspeth > Duel Decks: Elspeth vs. Kiora

• Magic: The Gathering-Commander > Commander

• Magic: The Gathering-Conspiracy > Conspiracy

• Planechase 2012 Edition > Planechase 2012

• Time Spiral ""Timeshifted"" > Time Spiral "Timeshifted" (WHY do they have double quotation marks??)

• Masterpiece Series: Amonkhet Invocations > Amonkhet Invocations

Site-Only Methods

Unfortunately, as you have discovered, there's no easy way to do this, not if you're just wanting to quickly scan through a bunch of cards.

The easiest way to do it for a single random card is to click that card's link (opens its detail page in a new tab), then type Ctrl+W to close the tab and go right back to your friend's inventory. (I love keyboard shortcuts! They make things like that quick.)

If instead you're browsing through multiple cards that are in an easily-definable subset (like a specific edition, or foils), I'd probably find it easiest to open my and my friend's inventory in separate tabs, filter each to show just the desired subset (edition, foils, whatever), apply the same sort, then yes.... flip back and forth between the tabs.  :\

That being said.... What's your specific use case? I'm assuming your goal is something that Deckbox's trade functionality doesn't fulfill....

Possible Tool

The reason I ask is that I've created Excel spreadsheets for almost every set up through Khans block (and it would be very simple to create sheets for later sets/blocks). These sheets allow you to see how many of each card in that set is listed in multiple inventories. It works by typing in the filename of an open inventory file, which then populates that column with the counts from that inventory. You can then "lock" that column, so that the values won't disappear when you close the inventory file. You could compare as many inventories this way as you want.

If you think you'd benefit from these sheets, let me know, and I'll put them all in a ZIP and make them available for download. The obvious limitation is that you DO have to go set by set. That's why I asked how you're trying to compare inventories. If you're already doing it this way, then this should be perfect for you!

Background

I created these spreadsheets because I had originally managed multiple physical inventories, and had a separate digital inventory for each of them, but I ultimately combined the physical inventories. So in order to spot check myself (since I did a lot of the work when I was sleep-deprived!), I created these sheets so that I could go through an edition of already-combined physical cards, and compare the quantities to the Total column in my sheets. Yes, I'm a bit OCD about it.

EDIT: I should note that I still keep foils and foreign cards in separate inventories, both physically and electronically, so if you have e.g. 1 regular, 1 foil, and 1 foreign version of a card, these sheets are going to show that you have 3 of that card. I could potentially customize this functionality depending on what you were needing.

EDIT 2: I just took the time to glance at your inventory, and I noticed that all of your cards are from Shadows Over Innistrad. So tomorrow, I'll create an SOI version and upload it, then you can get more of an idea what I mean!

There's no easy way to do that on the site once they're imported, unfortunately. The easiest way to ensure it's set correctly is to physically sort your cards prior to typing them in, set the relevant edition, type in only the cards from that edition, click import.... then set the next edition and repeat.

In your case, since they're already entered, do this:

1. Sort your inventory by edition. (Even though the edition isn't set, it'll still sort correctly.)

2. Under "Tools", "Export" your inventory to a CSV file.

3. Keep the original downloaded file as a backup and create a copy of the file to edit.

4. Open in Excel or a similar editor.

5. In the Edition column, mass enter the correct edition as appropriate. (Ensure you use the exact spelling and formatting as Deckbox. For instance, "Ravnica: City of Guilds" with the colon, not just "Ravnica".)

6. Saving is a little weird, at least in Excel 2010. I use Ctrl+S (or the Save icon) and click Yes at the prompt. Then when you actually go to close the file, even if you have JUST saved it, it's gonna ask you to save it again. Ignore this prompt by clicking Cancel. It's fully saved the other way, and going through the Save As dialog and creating a new CSV file has caused import issues for me in the past.  :\

7. Back on Deckbox, under "Tools", first "Remove Everything" from your inventory, then "Add Cards" using the "Import from CSV File" option. If you get a list of errors, it's usually simple spelling errors in the edition name (or card name, if you had manually typed those in the file, too), or because you have the wrong edition for that card.

8. If anything goes wrong that you can't fix, just re-import from the backup CSV file.

Let me know if you need further assistance!

You're wanting the "checklist cards", and I agree with you -- the OCD in me needs to add them, too!

If they were on the site, they'd be in the relevant "Extras" edition (e.g. Extras: Shadows Over Innistrad). Sadly, they are not included.... even though other cards that aren't included in Wizard's official token numbering are on the site, such as the poison counters from Scars of Mirrodin.

Hey! Noticed you never got a reply.  :\  I'm guessing by now you just went ahead and did it manually. That sucks! I'm sorry.

The best thing you can do in the future is manually create an "Undo feature", by exporting your inventory prior to importing from CSV. Then if anything goes wrong with the import, you have a "system restore" point.

In the off chance that you haven't already fixed this manually, or for anyone else that may run into this, here's some ideas, depending on your specific situation:

• If you didn't have anything in your inventory prior to the triplicate CSV import fiasco, all you'd have to do is Remove Everything (under Tools) and re-Import from CSV.

  
  

• If you were adding a group of cards that wouldn't have any duplicates in what was already present in the inventory (like a new set, or a CSV for all your foils or foreign cards), then do the following:

  
  

  1. Export inventory as CSV (including the incorrect duplication).

     
     

  2. Remove everything from your inventory.

     
     

  3. Copy the exported CSV file and keep the copy as a backup.

     
     

  4. Use Excel's sorting and filtering feature to look at the correct group of cards (foils, non-English, specific edition(s), etc).

     
     

     NOTE: Use sort to bring the relevant rows together first, or step 7 will fail.* The only reason to use filtering is if it would take a lot of scrolling to get to the entries you want to work on. 

     
     

  5. In an empty column, enter the formula "=A2/n" (without quotes), where you replace the 2 in A2 with the correct row number of the first affected entry, and n is the number of times duplicated (in your case, 3).

     
     

  6. Copy the formula down for all affected entries.

     
     

  7. Copy and paste the new values from that column into column A. Press "Ctrl" (or click the popup) to open it, then type V (or click "Paste Values Only").

     
     

  8. Delete the formulas you entered in steps 5-6.

     
     

  9. Import the new CSV into an empty inventory. Celebrate! Or if something didn't work, and retrying steps 4-8 doesn't fix it, then restore your inventory from the backup CSV. And don't hesitate to ask the community for help!

     
     

• If there is limited duplicates between the original inventory and the inventory after the triplicate-import, and you remember which cards are affected as well as their original Count values, you of course could still utilize the above method while handling those entries manually. Otherwise.... you're SOL, sad to say.  :\

* If there's no way to sort the rows in such a way that will bring all the affected entries together, then sort and filter one group, update the quantities, then sort and filter the next group, etc. E.g. If you're entering your Amonkhet and Hour of Devastation cards, sorting the Edition column won't bring those two editions together.

They all have at least one card whose cost contains hybrid mana. Maybe that's the issue?

Glimpse the Unthinkable -- Pricey money-wise, but worth it for a serious mill deck.