What database do you use for your collection?
Moderators: Forum Moderator, Current Officers, Previous Officers
- pinnacle-project
- Rust Governor
- Posts: 4660
- Joined: Sun May 19, 2013 1:23 pm
- Rusty Bunch Member Number: 1111
- eBay name: pinnacle-project
- Year Started Collecting: 1975
- Location: Grand Rapids, MI
- Has thanked: 1125 times
- Been thanked: 1294 times
- Zodiac:
- Status: Offline
What database do you use for your collection?
I would like to take pictures of all of my cans and save them in a database. Canventory looks like a nice product but it requires Windows. Ideally, I would like this to work on my Android based tablet so I can conveniently take the database to shows. I do not want to carry around a laptop. For those of you using tablets at shows, are you using some kind of database software of do you simply have all the pictured stored on the tablet without the benefit of any database software?
Thanks in advance for your thoughts.
Thanks in advance for your thoughts.
Focus: Cones and flats from Michigan, South Bend, and Fort Wayne. Foreign cans only if I bought them myself in the country of origin.
2023 Shows Attended
* Michigan Chapter Winterfest, January 14, Frankenmuth Michigan
* Cabin Fever Reliever, February 24, Mishawaka Indiana
* Buckeye, March 11, Toledo Ohio
* SummerSwap, July 21 & 22, Frankenmuth Michigan
2023 Shows Attended
* Michigan Chapter Winterfest, January 14, Frankenmuth Michigan
* Cabin Fever Reliever, February 24, Mishawaka Indiana
* Buckeye, March 11, Toledo Ohio
* SummerSwap, July 21 & 22, Frankenmuth Michigan
-
- Rust Governor
- Posts: 2661
- Joined: Mon Jan 07, 2013 8:19 am
- Rusty Bunch Member Number: 1128
- Has thanked: 4743 times
- Been thanked: 1638 times
- Status: Offline
Re: What database do you use for your collection?
Bryan,
I use Mr. Karasek's CANdb program. Easy to learn and work with. I have it on Windows 10 laptop as well as my Surface Windows 10 tablet. I posted some info pics at this site:
https://www.therustybunch.com/phpBB3/vi ... 68#p359068
Here's a link:
http://www.mbcinfo.com/CanDB/
I'm sure he'll answer any questions you might have.
(MI-Cans)
I use Mr. Karasek's CANdb program. Easy to learn and work with. I have it on Windows 10 laptop as well as my Surface Windows 10 tablet. I posted some info pics at this site:
https://www.therustybunch.com/phpBB3/vi ... 68#p359068
Here's a link:
http://www.mbcinfo.com/CanDB/
I'm sure he'll answer any questions you might have.
(MI-Cans)
- oldmoneytexan
- Rust Governor
- Posts: 2918
- Joined: Sat Feb 14, 2009 7:56 pm
- Rusty Bunch Member Number: 880
- BCCA Number: 32879
- eBay name: oldmoney_texan
- Year Started Collecting: 1972
- Location: Prosper, Texas
- Has thanked: 190 times
- Been thanked: 230 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
I used to use it until I got all Apple products. :(
- Rand
- Rust Governor
- Posts: 4955
- Joined: Sat Aug 19, 2006 6:46 pm
- Rusty Bunch Member Number: 727
- BCCA Number: 28177
- Year Started Collecting: 1967
- Location: Yosemite National Park, CA
- Has thanked: 415 times
- Been thanked: 493 times
- Zodiac:
- Contact:
- Status: Offline
Re: What database do you use for your collection?
Recommend supporting Randy's effort with CanDB.....but a side note.
What I did with canventory at one point, is that canventory will export your entire database to an HTML website format. I took that and put it on my tablet and surfed the HTML with a browser....and it worked pretty well.
What I did with canventory at one point, is that canventory will export your entire database to an HTML website format. I took that and put it on my tablet and surfed the HTML with a browser....and it worked pretty well.
Rand "The Can't Man" Lindsly....Foot Soldier in the OI Wars....Honorably Discharged
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
- huberman
- Rust Master
- Posts: 484
- Joined: Mon Oct 23, 2006 6:52 pm
- Rusty Bunch Member Number: 828
- BCCA Number: 30790
- eBay name: huberman
- Year Started Collecting: 1975
- Location: San Jose
- Been thanked: 21 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
I have my collection inventoried in an Excel spread sheet but without photos. I suspect I could import photos but that seems like allot of work. The reason I put the cans in a spreadsheet is so I could know what I had to prevent duplicate purchases (it did happen). Also I can document the history of the acquisition. My computer is a 2 in 1 and can be used like a tablet if I like.
-Chris
-Chris
Chris Huber
BCCA #30790
Rustybunch #828
408-568-5175
BCCA #30790
Rustybunch #828
408-568-5175
- golf_lover44
- Grand Marshall of Rust
- Posts: 1806
- Joined: Mon Nov 11, 2013 7:57 pm
- Rusty Bunch Member Number: 0
- BCCA Number: 34341
- Year Started Collecting: 2013
- Has thanked: 5 times
- Been thanked: 482 times
- Status: Offline
Re: What database do you use for your collection?
I have an Excel spreadsheet with links to every can photo. Then I wrote a program to make searching and displaying all of the information quick and easy. I copy my photos to my Android tablet and have it all in the Memento database app. It's free and works well enough.
https://mementodatabase.com/
https://mementodatabase.com/
golf_lover44
BCCA #34341
Collector of current micro and craft brewery cans from Chicago and the USA
BCCA #34341
Collector of current micro and craft brewery cans from Chicago and the USA
- renokenn
- Grand Marshall of Rust
- Posts: 1601
- Joined: Wed May 07, 2008 6:17 am
- Rusty Bunch Member Number: 838
- Year Started Collecting: 1978
- Location: Reno
- Has thanked: 292 times
- Been thanked: 211 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
There is a MS Excel app for Android available. Use it all the time on my phone and keep the data in the cloud.
- Sea Monkey
- RB Raffle Coordinator
- Posts: 5887
- Joined: Wed Dec 15, 2010 11:04 pm
- Rusty Bunch Member Number: 958
- BCCA Number: 33638
- eBay name: Pollywoggray
- Year Started Collecting: 1976
- Location: Myrtle Beach, SC
- Has thanked: 791 times
- Been thanked: 709 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
I use Canventory. When I go to show I have one of those small laptops that the screen detaches to make it a tablet. I run Canventory on that. Works great. It has really cut down on buying the same can twice and actually being able to tell if it is an upgrade or not BEFORE I buy a can.
I contacted the creator of Canventory and he confirmed he had NO plans to have it run on Apple products.
I contacted the creator of Canventory and he confirmed he had NO plans to have it run on Apple products.
Scott Gray
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
- Rand
- Rust Governor
- Posts: 4955
- Joined: Sat Aug 19, 2006 6:46 pm
- Rusty Bunch Member Number: 727
- BCCA Number: 28177
- Year Started Collecting: 1967
- Location: Yosemite National Park, CA
- Has thanked: 415 times
- Been thanked: 493 times
- Zodiac:
- Contact:
- Status: Offline
Re: What database do you use for your collection?
Here again.....Canventory will export the whole database to a neutral format that Apple can use.....it's called HTML....it's ubiquitous. I guarantee Apple can "run" it.Sea Monkey wrote: ↑Fri Aug 10, 2018 12:48 am
I contacted the creator of Canventory and he confirmed he had NO plans to have it run on Apple products.
Rand "The Can't Man" Lindsly....Foot Soldier in the OI Wars....Honorably Discharged
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
- Sea Monkey
- RB Raffle Coordinator
- Posts: 5887
- Joined: Wed Dec 15, 2010 11:04 pm
- Rusty Bunch Member Number: 958
- BCCA Number: 33638
- eBay name: Pollywoggray
- Year Started Collecting: 1976
- Location: Myrtle Beach, SC
- Has thanked: 791 times
- Been thanked: 709 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
I was thinking more of an Apple app so I could get it onto my Ipad. Without a USB connection, I'm not sure how to get the info on to it.....Rand wrote: ↑Fri Aug 10, 2018 1:37 amHere again.....Canventory will export the whole database to a neutral format that Apple can use.....it's called HTML....it's ubiquitous. I guarantee Apple can "run" it.Sea Monkey wrote: ↑Fri Aug 10, 2018 12:48 am
I contacted the creator of Canventory and he confirmed he had NO plans to have it run on Apple products.
Scott Gray
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
- Rand
- Rust Governor
- Posts: 4955
- Joined: Sat Aug 19, 2006 6:46 pm
- Rusty Bunch Member Number: 727
- BCCA Number: 28177
- Year Started Collecting: 1967
- Location: Yosemite National Park, CA
- Has thanked: 415 times
- Been thanked: 493 times
- Zodiac:
- Contact:
- Status: Offline
Re: What database do you use for your collection?
Here again, it doesn't need to be an "apple app". Your apple no doubt has a browser. Use the browser to surf the HTML files like they were a website. Just put the HTML files on your apple. As to how to get it there, I would be surprised if there wasn't some sort of data connection thing like firewire. But if not, most computers will take an SD chip/card that you could write to, then move the chip to the apple....or you could just transfer it through "the cloud" which could take many different forms (PC -> Dropbox -> Apple) etc.Sea Monkey wrote: ↑Fri Aug 10, 2018 9:41 amI was thinking more of an Apple app so I could get it onto my Ipad. Without a USB connection, I'm not sure how to get the info on to it.....Rand wrote: ↑Fri Aug 10, 2018 1:37 amHere again.....Canventory will export the whole database to a neutral format that Apple can use.....it's called HTML....it's ubiquitous. I guarantee Apple can "run" it.Sea Monkey wrote: ↑Fri Aug 10, 2018 12:48 am
I contacted the creator of Canventory and he confirmed he had NO plans to have it run on Apple products.
Rand "The Can't Man" Lindsly....Foot Soldier in the OI Wars....Honorably Discharged
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
-
- Rust Master
- Posts: 497
- Joined: Mon Aug 21, 2006 10:50 pm
- Been thanked: 74 times
- Status: Offline
Re: What database do you use for your collection?
Recommendation: Put your spreadsheet on Google, and then make sure that you share it with one or more family members and another can guy that you trust. That way if you should die, others will understand what you have so they can properly take care of things. Also, once it's on Google, you cannot possibly lose it, which is a nice feature. I tried linking photos one time, but it was a pain in the ***, plus it made the spreadsheet too wide and you couldn't print it which was bad. So I removed the photos from the spreadsheet. Matt
- JohnLi67
- Rust Master
- Posts: 242
- Joined: Mon Oct 28, 2013 4:40 pm
- Rusty Bunch Member Number: 1103
- BCCA Number: 34303
- eBay name: johnlij
- Year Started Collecting: 2000
- Location: Cloquet, MN
- Been thanked: 15 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
I use Canventory on a Microsoft Surface tablet. Works good and the pictures are invaluable. Wish it could run on Apple products (have Macbook pros for most computing needs). Like SeaMonkey said - works great so you don't buy same can twice, and is a good tool for comparing upgrades. Contains all history of purchase also (Date, price paid, who it was acquired from).
- willssoda
- Rust Governor
- Posts: 2988
- Joined: Wed Jan 09, 2013 10:04 pm
- Rusty Bunch Member Number: 1063
- eBay name: WILLSSODA
- Year Started Collecting: 1975
- Location: East Tennessee
- Has thanked: 529 times
- Been thanked: 440 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
Curious. If and when I get all my cans loaded onto canventory will I be able to upload the information if I create my own website through blue host or Go Daddy?
Interested in all flat and Cone Soda and Water cans.
- Rand
- Rust Governor
- Posts: 4955
- Joined: Sat Aug 19, 2006 6:46 pm
- Rusty Bunch Member Number: 727
- BCCA Number: 28177
- Year Started Collecting: 1967
- Location: Yosemite National Park, CA
- Has thanked: 415 times
- Been thanked: 493 times
- Zodiac:
- Contact:
- Status: Offline
Re: What database do you use for your collection?
AHHHGGGGG!!!! You're just trolling me now. I've been saying exactly and specifically that throughout this entire thread! Here....this is my canventory on a website...ON "MY OWN WEBSITE"
http://yosemiterefuge.com/beercans/oi/
(it may bark at you because i've screwed up my ssl certificate....nothing to worry about....just pictures of beer cans. accept the risk and go through)
Rand "The Can't Man" Lindsly....Foot Soldier in the OI Wars....Honorably Discharged
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
"I'm a solipsist and, I have to say, I'm surprised there aren't more of us."
Acme. Genesee. - Feigenspan Uinta
-
- Rust Master General
- Posts: 529
- Joined: Mon Sep 13, 2010 9:09 pm
- Rusty Bunch Member Number: 929
- BCCA Number: 953
- eBay name: JLC0953
- Year Started Collecting: 1969
- Location: North East, PA
- Has thanked: 2 times
- Been thanked: 108 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
Rick says that I am the largest user of Canventory. I have put all the cans from USBC I and II on it with pictures. Now I can easily see what I have and what I need. He had to change my software to allow for ~20,000 items. I love the software but have the following comments:
- as Rick has allowed this to be free, you get what you pay for. He is not actively updating this based on people’s requests. That said, it is still about everything I need.
- the only bugs I have found were self created. Deleting items can cause problems, so be careful.
- I do not know if there is any risk of the underlying software going away or not working on future Windows releases. That is always a worry.
- it is trivial to download the data into a spreadsheet, but you do that without images.
Again, I am a heavy user and love the ease of use. Should you have any questions, please let me know.
- as Rick has allowed this to be free, you get what you pay for. He is not actively updating this based on people’s requests. That said, it is still about everything I need.
- the only bugs I have found were self created. Deleting items can cause problems, so be careful.
- I do not know if there is any risk of the underlying software going away or not working on future Windows releases. That is always a worry.
- it is trivial to download the data into a spreadsheet, but you do that without images.
Again, I am a heavy user and love the ease of use. Should you have any questions, please let me know.
Jerry Cole
- pinnacle-project
- Rust Governor
- Posts: 4660
- Joined: Sun May 19, 2013 1:23 pm
- Rusty Bunch Member Number: 1111
- eBay name: pinnacle-project
- Year Started Collecting: 1975
- Location: Grand Rapids, MI
- Has thanked: 1125 times
- Been thanked: 1294 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
Rand wrote: ↑Sat Aug 11, 2018 3:55 amAHHHGGGGG!!!! You're just trolling me now. I've been saying exactly and specifically that throughout this entire thread! Here....this is my canventory on a website...ON "MY OWN WEBSITE"
http://yosemiterefuge.com/beercans/oi/
(it may bark at you because i've screwed up my ssl certificate....nothing to worry about....just pictures of beer cans. accept the risk and go through)
In case anyone looks at Rand's collection and wonders why he only has three pictures of each can, that was a limitation of Canventory at one time. That was changed at some point and you can now have six pictures of each can.
Focus: Cones and flats from Michigan, South Bend, and Fort Wayne. Foreign cans only if I bought them myself in the country of origin.
2023 Shows Attended
* Michigan Chapter Winterfest, January 14, Frankenmuth Michigan
* Cabin Fever Reliever, February 24, Mishawaka Indiana
* Buckeye, March 11, Toledo Ohio
* SummerSwap, July 21 & 22, Frankenmuth Michigan
2023 Shows Attended
* Michigan Chapter Winterfest, January 14, Frankenmuth Michigan
* Cabin Fever Reliever, February 24, Mishawaka Indiana
* Buckeye, March 11, Toledo Ohio
* SummerSwap, July 21 & 22, Frankenmuth Michigan
- Sea Monkey
- RB Raffle Coordinator
- Posts: 5887
- Joined: Wed Dec 15, 2010 11:04 pm
- Rusty Bunch Member Number: 958
- BCCA Number: 33638
- eBay name: Pollywoggray
- Year Started Collecting: 1976
- Location: Myrtle Beach, SC
- Has thanked: 791 times
- Been thanked: 709 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
LOL Rand. It is obvious we are not as computer savvy. We DO appreciate you bearing with us in our educational journey!
Scott Gray
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6
- gorrister
- Cone Top
- Posts: 146
- Joined: Wed Sep 30, 2015 10:22 pm
- Rusty Bunch Member Number: 1277
- BCCA Number: 34786
- eBay name: emefree
- Year Started Collecting: 2015
- Has thanked: 30 times
- Been thanked: 24 times
- Zodiac:
- Status: Offline
Re: What database do you use for your collection?
Can you share your empty database with everyone so that we can all start with a good set of known data instead of having to recreate the “checklist” ourselves. I created one for just the don’t tops, but would love a complete version to know what I don’t have instead of just showing what I do have.Uncle Jackson wrote: ↑Sat Aug 11, 2018 7:18 am Rick says that I am the largest user of Canventory. I have put all the cans from USBC I and II on it with pictures. Now I can easily see what I have and what I need. He had to change my software to allow for ~20,000 items. I love the software but have the following comments:
- as Rick has allowed this to be free, you get what you pay for. He is not actively updating this based on people’s requests. That said, it is still about everything I need.
- the only bugs I have found were self created. Deleting items can cause problems, so be careful.
- I do not know if there is any risk of the underlying software going away or not working on future Windows releases. That is always a worry.
- it is trivial to download the data into a spreadsheet, but you do that without images.
Again, I am a heavy user and love the ease of use. Should you have any questions, please let me know.