Massive Player Collections

[Julz24]

For anyone here with large collections of baseball cards of the same player:

I collect Ken Griffey Jr and have 2600 different cards. I've been trying to organize them so that I don't purchase any that I already have. Also, it's good to know what doubles I have to use for trade bait.

Here's a few questions...

First - How do you digitally organize your collection? Do you have a photo of the card alongside the card's information?

For me, I have been using Numbers - an Apple spreadsheet. I have all my cards organized by: Photo/Year/Set Name/Description/Number/Serial Number/Quantity/Notes/Grade.

It has been extremely useful to me. I tried to attach a few rows of the spreadsheet to this thread and was unsuccessful. Which is fitting because I'm having problems with it's size. Since around Row 2000 - the file has gotten slower and slower and slower. It is almost unmanageable now. I contacted Apple and they told me the spreadsheet was not meant for what I'm using it for and that I've exceeded expectations already, lol.

Also, it will not export in any format and to any other program, (that I know of yet) with the photos. I've tried Excel and many others. I think I need to get them out of Numbers and into a Database that will accept the photos. But how and to which one?


Second - How do you store/display your player collection?

Right now half of mine are completly raw in 2 800ct boxes. The other half are in toploaders in a giant box. Not very convenient or sexy.

I'd love to put some in pages and binders but the only pages I like are "Super Pro 2000 Gold" and they're hard to find. Not a fan of Ultra Pro, Platinum, MVP or BCW as the cards tend to slide up and thru the top opening.

So any other player collectors out there got any ideas or solutions?

[doug.goodman]

Use excel.

My Topps cards file has 12 worksheets, a couple of them have nearly 30,000 lines of info (one for each card), with as many as 12 columns of info per card I make changes to it in moments.

I have various other files helping me to keep track of various things, and all of them have multiple pages with many thousands of rows.

Sounds like "Numbers" isn't much of a spreadsheet program.

Doug

[Julz24]

No, its actually amazing but it isn't built for large amounts of data. The problem is definitly made worse by the size and amount of images in my file.

So do you have photos in Excel?

I've been researching databases like Filemaker and Bento only because they will accept an import from my Numbers file. I have tried exporting from Numbers to Excel and the text moves over fine. But the photos won't go.

[doug.goodman]

I don't have photos in my files, I keep them separate,

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.

Doug

[Julz24]

Originally Posted by doug.goodman

I don't have photos in my files, I keep them separate,

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.

Doug

Ok, so all your photos ate stored separately. That's helpful in that I want to keep both photos and text together.

As far as the Numbers spreadsheet: I can only relay what Apple told me... Spreadsheets are basically for sorting ,organizing and number manipulation. Anytime one is dealing with massive amounts of information, a database is necessary.

Either way, there's no doubt Excel is superior between the two of them.

[Zach Wheat]

I mainly a set collector but also have a side collection of Mantle cards. I don't collect modern Mantle cards so the card management issue isn't too significant. I keep my cards stored graded by year in an ammo box which is water and fire resistant in a secure spot.

I keep digital images of each card on my PC staing year, maker, name, grade, price, description. I use the same format for name each picture for each photo. This makes it easy to sort and find what I am looking for.

I have started but not completed using ACT database to sort and catalogue cards and images. I imagine using Access would have worked the same but am familiar with ACT.

Z Wheat

[bsuttonosu]

Originally Posted by doug.goodman

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.
Doug

Agree with Doug, but I think it's the images weighing down your file not the data elements. Spreadsheets aren't made to handle image storage. Also, and I don't know the technical aspects of it, but functionally Apple products are not built the handle spreadsheets the same way. I have both Apple and PC computers and work with spreadsheets alot. The PCs are always faster with them.

I use an Excel spreadsheet for my lists but I don't store images of everything.

[brookdodger55]

I have a massive collection of 1800 Mike Piazza cards , I use excel spread sheet
with. pictures of each card. I used what is called the cell hovering technique.
You place the mouse over the corner of he cell (small ear flap in corner and picture appears, double click it disappears. Using office Xp for many years and have never had a performance problem with excel with a massive amount of pictures.
Mike

[HOF Auto Rookies]

Originally Posted by Julz24

For anyone here with large collections of baseball cards of the same player:



I collect Ken Griffey Jr and have 2600 different cards. I've been trying to organize them so that I don't purchase any that I already have. Also, it's good to know what doubles I have to use for trade bait.



Here's a few questions...



First - How do you digitally organize your collection? Do you have a photo of the card alongside the card's information?



For me, I have been using Numbers - an Apple spreadsheet. I have all my cards organized by: Photo/Year/Set Name/Description/Number/Serial Number/Quantity/Notes/Grade.



It has been extremely useful to me. I tried to attach a few rows of the spreadsheet to this thread and was unsuccessful. Which is fitting because I'm having problems with it's size. Since around Row 2000 - the file has gotten slower and slower and slower. It is almost unmanageable now. I contacted Apple and they told me the spreadsheet was not meant for what I'm using it for and that I've exceeded expectations already, lol.



Also, it will not export in any format and to any other program, (that I know of yet) with the photos. I've tried Excel and many others. I think I need to get them out of Numbers and into a Database that will accept the photos. But how and to which one?





Second - How do you store/display your player collection?



Right now half of mine are completly raw in 2 800ct boxes. The other half are in toploaders in a giant box. Not very convenient or sexy.



I'd love to put some in pages and binders but the only pages I like are "Super Pro 2000 Gold" and they're hard to find. Not a fan of Ultra Pro, Platinum, MVP or BCW as the cards tend to slide up and thru the top opening.



So any other player collectors out there got any ideas or solutions?

I'll try to post what I have for Mayer, I just use a simple spread sheet that I'll screen shot


Sent from my iPhone using Tapatalk