It is currently 17 Nov 2018, 12:46
   
Text Size

Importing a collection from xls/csv/tsv

Moderators: charmer, CCGHQ Admins

Importing a collection from xls/csv/tsv

Postby Talzaroff » 06 Oct 2011, 18:06

Hello there!

I'm new to these forums, because I was looking for a good program to document my collection. Magic Album seems to be perfect for it. Thing is, I have a couple thousand cards, and they're all sorted and accounted for in a huge spreadsheet. I have the Gatherer ID, the name, set and quantity all in there. Is there any way to import data into Magic Album from an xls file, or from a csv or tsv file?
If so, what format should it have?
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Goblin Hero » 07 Oct 2011, 05:53

Currently you can only import inventories from MWS or suitcase programs. Send me a part of your spreadsheet file.
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1913
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 136 times
Been thanked: 310 times

Re: Importing a collection from xls/csv/tsv

Postby Talzaroff » 07 Oct 2011, 06:18

I've just sent you an e-mail with my spreadsheet file. Remember, you don't have to import them all, just the quantity and the combination of cardname and set. Or use the GathererID
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Goblin Hero » 07 Oct 2011, 07:58

Received. One question: all cards are considered nonfoil?
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1913
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 136 times
Been thanked: 310 times

Re: Importing a collection from xls/csv/tsv

Postby woogerboy21 » 07 Oct 2011, 13:18

This functionality in general would be a nice addition. Does anyone know if its included in an request yet?
User avatar
woogerboy21
HQ Team Member
 
Posts: 1136
Joined: 19 Jul 2009, 00:15
Location: USA
Has thanked: 21 times
Been thanked: 153 times

Re: Importing a collection from xls/csv/tsv

Postby Talzaroff » 07 Oct 2011, 13:23

Goblin Hero wrote:Received. One question: all cards are considered nonfoil?
Yes, I have not marked foiled cards seperately. Ofcourse you could use one more column for that, and leave it optional, considering no value a non-foil card.
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Talzaroff » 07 Oct 2011, 13:32

One more addition: it's a good idea to include a report after importing, so you can check if all cards were imported correctly. A misspelling is easily made, and the system is only good if it's reliable.
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Goblin Hero » 14 Oct 2011, 09:09

Done and will be available soon. See "Help\Import Example.txt" and "Help\Import Example.csv".
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1913
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 136 times
Been thanked: 310 times

Re: Importing a collection from xls/csv/tsv

Postby Talzaroff » 15 Oct 2011, 23:31

You're a true (Goblin) Hero!
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Talzaroff » 17 Oct 2011, 16:55

I updated to the latest version, and noticed the import examples. I can't import my collection however. Actually, I can't import the example you provided either. Does that mean the function isn't available yet? Or is something else wrong?
Talzaroff
 
Posts: 6
Joined: 06 Oct 2011, 17:31
Has thanked: 0 time
Been thanked: 0 time

Re: Importing a collection from xls/csv/tsv

Postby Goblin Hero » 17 Oct 2011, 17:46

Talzaroff wrote:I can't import the example you provided either.
Run MA. Inventory->Import->Select example csv file. It works.
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1913
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 136 times
Been thanked: 310 times

Re: Importing a collection from xls/csv/tsv

Postby sho » 04 Nov 2014, 12:20

Couple of observations and suggestions to improve the experience:
1. include headers in the example file and the import code (set, name, number, foil, etc)
That way it becomes much easier for the average Joe to create the mandatory trailing notes field that is empty 99,99% of the time. Otherwise Excel just skips the column when saving and the import fails without explanation.

2. While it can be argued that a tab delimited file is a csv file, I believe it is not technically correct. Perhaps the program should allow importing of txt files? (Excel 2013 saves Tab delimited files as *.txt)
If nothing else it saves you a step in an otherwise convoluted process (renaming).

3. My version of Excel saves tab delimited files as ANSI/UTF-8 (depending on the apostrophes used). Allowing more encoding options would ease the process further (can it be a western/Cyrillic difference?).
Incorrect encoding will result in an an aborted import with an unexplained error.

Also, regarding export. Given that Magic Album uses a proprietary database schema and no way to export your inventory, it will never become my primary inventory tool, no matter how much I like its other features. I would kindly ask you to reconsider your stance regarding exporting of data. The output and what can be done with it is my problem after all.
sho
 
Posts: 11
Joined: 24 Aug 2013, 17:43
Has thanked: 1 time
Been thanked: 1 time

Re: Importing a collection from xls/csv/tsv

Postby Goblin Hero » 04 Nov 2014, 12:37

sho wrote:Given that Magic Album uses a proprietary database schema and no way to export your inventory, it will never become my primary inventory tool
Right click on any card in your inventory -> All Data -> Export to .csv.
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1913
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 136 times
Been thanked: 310 times

Re: Importing a collection from xls/csv/tsv

Postby sho » 04 Nov 2014, 13:32

Thanks, I was referring to this thread.
viewtopic.php?f=32&t=3075
I was unaware of the feature, good to know things have changed for the better ;)
sho
 
Posts: 11
Joined: 24 Aug 2013, 17:43
Has thanked: 1 time
Been thanked: 1 time


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 279 on 11 Jul 2013, 22:03

Users browsing this forum: No registered users and 1 guest

Login Form