When you try to close the file in Excel, it'll ask you to save the changes. 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).Īssuming you caught all the edition name errors, you should be golden! Otherwise, repeat steps 12-15 until you get it right. Then press Ctrl+S (or click the save icon) and click "Yes" at the warning Use Ctrl+H to Replace All for each affected edition. You'll find the Deckbox equivalent on the "Editions" page. (I've provided a list below that I encountered in this specific inventory.) Make note of the incorrect edition names. I say attempt, because you're going to get a long list of errors due to non-matching edition names. 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.Īttempt a first upload. TIP: To easily select all the correct data, delete row 1 on the copied sheet (the header row), then press Ctrl+A. Don't worry about all the rows with a count of 0 - they won't matter. Now select all the entries in the copied sheet (your foils) and copy it to the end of the data in the original sheet. TIP: If you have all the cells selected, press F2 to enable entry in the active cell, type "foil", then press Ctrl+Enter. Important: On the copied sheet (your foils), fill the entire "Foil" column with "foil". Now you should only have one "Count" column on each sheet. In the copied sheet, delete column A (Reg Qty). In the original sheet, delete column B (used to be Foil Qty). Right-click the sheet's tab, choose "Move or Copy.", and check the checkbox for "Create a copy". See step 9 for a tip on quickly filling an entire column. If you don't do this, Deckbox will display them without a condition or language, rather than applying your defaults. 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". 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. (Yes, both columns A and B should be named Count. Important: Change the column headers as follows: Reg Qty & Foil Qty > Count, Card > Name, Set > Edition. 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. TIP: If you have any notes saved, keep the "Notes" column. TIP: To fully delete, highlight the columns, right click, and choose Delete. Major time saver! After running the macro, pick back up at Step 12.ĭelete column A ("Total Qty"), then delete the new columns E - M ("Mana Cost" - "Price Source"). NOTE: Stop here and use the macro listed below in bburrows reply. Save your file and click "Yes" at the warning. Open in Excel (I'm using 2010, so some instructions may differ). csv (either directly by manually typing it in from your file browser, or by opening the. Many people may not need every step detailed like this, but for those that do, they'll appreciate not having to ask!Ĭhange the file extension to. ![]() I apologize for the verbosity of these instructions. 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. Yu-Gi-Oh! content and related materials are trademarks and copyrights of ©Konami Digital Entertainment.I just went through the following steps, and successfully imported your inventory into Deckbox. This app is not affiliated with Yu-Gi-Oh! or Konami. * Test draw from your decks to find out how well it would work on your first turns. * Advanced filter makes it really easy to find the cards you need. * Download already finished decks made by others, or share your own creations. ![]() If internet connection is lost, download will continue when it is back.) * Fast card download in background (using your phone and putting it in sleep mode will not cancel the download. * More than 8200 released cards included and a feature to add new cards to keep it up to date with new releases. * Simple and user-friendly drag-n-drop layout. This deck builder is the most complete deck builder application for the game Yu-Gi-Oh! and includes several new handy features, including an online database where complete decks can be uploaded or downloaded in notime! Deck Builder for Yu-Gi-Oh! is a FREE user friendly Yugioh deck building app that enables you to build, download and test different decks on the go.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |