What database do you use for your collection?

Discussion issues on Beer Cans,, Breweriana, Attended Shows etc...

Moderators: Forum Moderator, Current Officers, Previous Officers

User avatar
pinnacle-project
Rust Governor
Rust Governor
Posts: 2596
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
Zodiac:
Status: Offline
United States of America

What database do you use for your collection?

#1

Post by pinnacle-project » Wed Aug 08, 2018 6:45 pm

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.


Focus: Cones and flats from MI, South Bend, Fort Wayne, and Toledo. Foreign cans only if I bought them myself in the country of origin.

2018 Shows Attended

* Michigan Chapter Winterfest, January 20, Frankenmuth Michigan
* Beer Can's 83rd Birthday Celebration, January 24, Online
* Cabin Fever Reliever, February 24, South Bend Indiana
* Buckeye Chapter, March 10, Toledo Ohio
* Rusty Bunch April Fools Show, Online
* Patrick Henry, May 19, Kalamazoo Michigan
* Website 20th Anniversary Online Show. June 18, Online
* SummerSwap, July 20 & 21, Frankenmuth Michigan

Advertisement
MI-Cans
Grand Marshall of Rust
Grand Marshall of Rust
Posts: 1000
Joined: Mon Jan 07, 2013 8:19 am
Rusty Bunch Member Number: 1128
BCCA Number: 12484
Status: Offline
United States of America

Re: What database do you use for your collection?

#2

Post by MI-Cans » Wed Aug 08, 2018 8:11 pm

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)
Remember...Recycling is FOREVER!!

User avatar
oldmoneytexan
Rust Governor
Rust Governor
Posts: 2683
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#3

Post by oldmoneytexan » Wed Aug 08, 2018 8:15 pm

I used to use it until I got all Apple products. :(

User avatar
Rand
Forum Moderator
Forum Moderator
Posts: 4316
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
Zodiac:
Contact:
Status: Offline
United States of America

Re: What database do you use for your collection?

#4

Post by Rand » Wed Aug 08, 2018 8:16 pm

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.
Rand 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

User avatar
huberman
Rust Master
Rust Master
Posts: 462
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#5

Post by huberman » Wed Aug 08, 2018 9:17 pm

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 Huber
BCCA #30790
Rustybunch #828

User avatar
golf_lover44
Grand Marshall of Rust
Grand Marshall of Rust
Posts: 1046
Joined: Mon Nov 11, 2013 7:57 pm
Rusty Bunch Member Number: 0
BCCA Number: 34341
Year Started Collecting: 2013
Status: Offline

Re: What database do you use for your collection?

#6

Post by golf_lover44 » Thu Aug 09, 2018 6:52 pm

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/
golf_lover44
BCCA #34341
Collector of current micro and craft brewery cans

view my cans for trading:
http://s1313.photobucket.com/user/brian ... 12-oz-cans
http://s1313.photobucket.com/user/brian ... 16-oz-cans
http://s1313.photobucket.com/user/brian ... 24-oz-cans
http://s1313.photobucket.com/user/brian ... 12-oz-cans

Searching for cans of beer brewed or sold in Chicago

User avatar
renokenn
Grand Marshall of Rust
Grand Marshall of Rust
Posts: 1251
Joined: Wed May 07, 2008 6:17 am
Rusty Bunch Member Number: 838
BCCA Number: 32784
Year Started Collecting: 1978
Location: Reno
Zodiac:
Status: Offline

Re: What database do you use for your collection?

#7

Post by renokenn » Thu Aug 09, 2018 7:03 pm

There is a MS Excel app for Android available. Use it all the time on my phone and keep the data in the cloud.
Why are laboratories recruiting lawyers for experiments?
There are things that rats just won't do.

User avatar
Sea Monkey
Overlord of Rust
Overlord of Rust
Posts: 5270
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#8

Post by Sea Monkey » Fri Aug 10, 2018 12:48 am

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.
Scott Gray
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6

User avatar
Rand
Forum Moderator
Forum Moderator
Posts: 4316
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
Zodiac:
Contact:
Status: Offline
United States of America

Re: What database do you use for your collection?

#9

Post by Rand » Fri Aug 10, 2018 1:37 am

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.
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.
Rand 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

User avatar
Sea Monkey
Overlord of Rust
Overlord of Rust
Posts: 5270
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#10

Post by Sea Monkey » Fri Aug 10, 2018 9:41 am

Rand wrote:
Fri Aug 10, 2018 1:37 am
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.
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.
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.....
Scott Gray
BCCA# 33638 / RB# 958 / Qwarts-R-Us #8 / Iron Guts #6

User avatar
Rand
Forum Moderator
Forum Moderator
Posts: 4316
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
Zodiac:
Contact:
Status: Offline
United States of America

Re: What database do you use for your collection?

#11

Post by Rand » Fri Aug 10, 2018 12:23 pm

Sea Monkey wrote:
Fri Aug 10, 2018 9:41 am
Rand wrote:
Fri Aug 10, 2018 1:37 am
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.
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.
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.....
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.
Rand 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

Matt Menghini
Rust Master
Rust Master
Posts: 365
Joined: Mon Aug 21, 2006 10:50 pm
Status: Offline

Re: What database do you use for your collection?

#12

Post by Matt Menghini » Fri Aug 10, 2018 1:45 pm

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

User avatar
JohnLi67
Rust Master
Rust Master
Posts: 240
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#13

Post by JohnLi67 » Fri Aug 10, 2018 1:50 pm

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).

User avatar
willssoda
Grand Marshall of Rust
Grand Marshall of Rust
Posts: 1177
Joined: Wed Jan 09, 2013 10:04 pm
Rusty Bunch Member Number: 1063
eBay name: WILLSSODA
Year Started Collecting: 1975
Location: East Tennessee
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#14

Post by willssoda » Sat Aug 11, 2018 1:02 am

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.

User avatar
Rand
Forum Moderator
Forum Moderator
Posts: 4316
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
Zodiac:
Contact:
Status: Offline
United States of America

Re: What database do you use for your collection?

#15

Post by Rand » Sat Aug 11, 2018 3:55 am

willssoda wrote:
Sat Aug 11, 2018 1:02 am
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?
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 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

Uncle Jackson
BCCA Board of Directors
BCCA Board of Directors
Posts: 355
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#16

Post by Uncle Jackson » 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.
Jerry Cole

User avatar
pinnacle-project
Rust Governor
Rust Governor
Posts: 2596
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#17

Post by pinnacle-project » Sat Aug 11, 2018 8:54 am

Rand wrote:
Sat Aug 11, 2018 3:55 am
willssoda wrote:
Sat Aug 11, 2018 1:02 am
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?
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)

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 MI, South Bend, Fort Wayne, and Toledo. Foreign cans only if I bought them myself in the country of origin.

2018 Shows Attended

* Michigan Chapter Winterfest, January 20, Frankenmuth Michigan
* Beer Can's 83rd Birthday Celebration, January 24, Online
* Cabin Fever Reliever, February 24, South Bend Indiana
* Buckeye Chapter, March 10, Toledo Ohio
* Rusty Bunch April Fools Show, Online
* Patrick Henry, May 19, Kalamazoo Michigan
* Website 20th Anniversary Online Show. June 18, Online
* SummerSwap, July 20 & 21, Frankenmuth Michigan

User avatar
Sea Monkey
Overlord of Rust
Overlord of Rust
Posts: 5270
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
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#18

Post by Sea Monkey » Sat Aug 11, 2018 11:59 am

Rand wrote:
Sat Aug 11, 2018 3:55 am

AHHHGGGGG!!!! You're just trolling me now. I've been saying exactly and specifically that throughout this entire thread!
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

User avatar
gorrister
Cone Top
Cone Top
Posts: 86
Joined: Wed Sep 30, 2015 10:22 pm
Rusty Bunch Member Number: 1277
BCCA Number: 34786
eBay name: emefree
Year Started Collecting: 2015
Zodiac:
Status: Offline
United States of America

Re: What database do you use for your collection?

#19

Post by gorrister » Mon Aug 13, 2018 11:31 am

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.
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.

Post Reply Previous topicNext topic

Return to “General Discussion”