Massive Player Collections

[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

[JLange]

With regard to displaying the cards, I am a big fan of using card saver 1s and placing them in 4 pocket sheets (postcard size pockets) the card savers easily slip in with a little room to spare,but don't slip around or turn in the pockets. This is the best of both worlds because you can put roughly 240-250 cards in a binder (single sided) but then easily remove ones you want for some other project, and they are always protected. It beats keeping the in a box.

[brookdodger55]

Never thought of that, great idea thinking about doing that with my 1952-57 Brooklyn dodgers team sets, that solves the problem of the sheets fitting the
52-54's.
Mike

[cwazzy]

My Campanella collection is small compared to the massive collections modern players can have. I only have about 200 different cards in my collection. To keep me organized I created a checklist in Excel using beckett.com as my guide. I printed it off and check the appropriate box as I get a new card. Of course it's MUCH easier with '50s player that only has around 1,500 cards including modern 1/1s. I keep scans of every card in photobucket split out between vintage, modern base/inserts, and game-used cards. For storage I use a Roop style box that I purchased off the internet for about $30. Eventually I will display some of my favorites in a curio cabinet or wall display but haven't gotten that far yet.

[dabigyankeeman]

Originally Posted by brookdodger55

Never thought of that, great idea thinking about doing that with my 1952-57 Brooklyn dodgers team sets, that solves the problem of the sheets fitting the
52-54's.
Mike

Whats the problem with sheets for the 52-54's (actually thru 1956)? They make 8-pocket sheets to fit these cards. Am i missing something? Unless do you not want them in the sheets horizontally? That i can understand as i am not crazy about that myself!!

[brookdodger55]

Originally Posted by dabigyankeeman

Whats the problem with sheets for the 52-54's (actually thru 1956)? They make 8-pocket sheets to fit these cards. Am i missing something? Unless do you not want them in the sheets horizontally? That i can understand as i am not crazy about that myself!!

No you are not missing something, I didn't want to store/display the cards raw
in the pages, I thought that the card saver idea was new to me along with the postcard pages. Hope this clears it up.
Mike

[Julz24]

Quick Update:

I signed up on Beckett for a recurring monthly subscription. I was able to download the entire Griffey collection of cards, over 14,200!!

I copied and pasted the list into Excel for Mac. Now I just need to organize all of the information. It transfered over into one row unfortunately.

[cdn_collector]

Originally Posted by Julz24

Quick Update:
I copied and pasted the list into Excel for Mac. Now I just need to organize all of the information. It transfered over into one row unfortunately.

The problem with copy/pasting directly from your browser into the spreadsheet is that the formatting data may also have been copied (this is how it works with Excel on Windows, at least).

Two things two try rather than manually breaking that data into rows:

a.) Copy and paste it into a basic text editor and THEN copy it again and paste it into your program. In the Windows world, I'd use Notepad and then Excel. This will cause any formatting data that may have also been copied to be lost and *should* respect the proper rows/columns.

b.) If (a) above doesn't work, then again use the text editor but this time save the file and import (as opposed to open) it into your program. It *should* allow you to specify the where each column starts and ends, and should recognize each individual row.

Good luck!

Richard.

[baez578]

Haven't tried it yet..but it might work for you


http://download.cnet.com/Sports-Card...-10435152.html

[vintage954]

Wow, I'm a Griffey collected as well but I only have around 900 different cards. Nice collection

[jrbeasley]

I just use zistle. No tech headaches.

[brewing]

Originally Posted by 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

Never knew this. Absolutely love this method. Thank You

[Julz24]

The cell hovering technique is definitely intriguing. I'm not that savvy with Microsoft Excel yet but I have started the research process. I've also heard about hyperlinking the photos to the spreadsheet as well as inserting images into a comment box, (which may or may not be the same as cell hovering)??

I wonder if cell hovering will decrease the size of the saved file? If it does, that might help increase my speed.

This weekend I'm planning on downloading Griffeys entire card checklist from Beckett. Apparently you have to subscribe to Beckett for at least one month in order to save the checklist as a pdf or download it into Excel. I think for nine bucks it's worth it. He has over 14,000 baseball cards so it might take a minute!

[brookdodger55]

If you would like, I can post a link to the steps to do this,very easy to do in a couple of steps. Post to let me know
You have some of it correct,one of the steps is clicking on the comment icon.
Thanks
Mike

[Julz24]

Originally Posted by brookdodger55

If you would like, I can post a link to the steps to do this,very easy to do in a couple of steps. Post to let me know
You have some of it correct,one of the steps is clicking on the comment icon.
Thanks
Mike

Absolutely!

That will give me somewhere to start for this weekends project.

Thanks.