It is currently 15 Jul 2019, 22:34
   
Text Size

Importing a csv from MTGO

Moderators: charmer, CCGHQ Admins

Importing a csv from MTGO

Postby kristijanH » 07 Jan 2012, 10:25

Could someone post the quickest and easiest way to import a csv from MTGO into MA?

Edit: Found it out finaly :)

1. Don't open a file in Excel but make a new file.
2. Import the csv file and choose "," as seperater instead of "tab".
3. Rearange the columns as folows: Set, Card Name, Empty [MTGO soesnt export the version number of a card], Online, Empty [if you don't have foils] then add 0 value for foils.
OR
Set, Card Name, Empty [MTGO doesn't export the version number of a card], Empty, Online [for foiled cards] then add 0 value for nonfoils.
4. For cards with multiple versions (exp. Basic Lands) add the value for Version. Exp. first Swamp add 1, second add 2 etc.
5. Delete the rest columns.
6. Replace the Set names - from ISD to Innistrad for example.
7. Delete the first row - Set, Card name etc.
8. Paste your data into the Import Example.csv in the Magic Album/Help folder.
9. Go to MA and import the Import Example.csv file.
10. That's it!

Flip cards will not be added. You have to add them manualy.
kristijanH
 
Posts: 218
Joined: 24 Nov 2009, 13:49
Has thanked: 52 times
Been thanked: 11 times

Re: Importing a csv from MTGO

Postby woogerboy21 » 13 Feb 2012, 13:52

kristijanH wrote:Flip cards will not be added. You have to add them manualy.
I haven't had a chance to look at the export of flip cards from MTGO (since I don't own any) but my guess on why they don't import is there probably not named as MA is expecting them to be. I have found when doing price imports you have to name the flip cards with a "|" character between the two cards. For example: "Garruk Relentless|Garruk, the Veil-Cursed"

If you want them to import properly you may give this a try.
User avatar
woogerboy21
HQ Team Member
 
Posts: 1136
Joined: 19 Jul 2009, 00:15
Location: USA
Has thanked: 21 times
Been thanked: 153 times


Return to Magic Album

Who is online

Users browsing this forum: No registered users and 1 guest


Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 10 minutes)
Most users ever online was 287 on 31 Mar 2019, 04:11

Users browsing this forum: No registered users and 1 guest

Login Form