Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Managing a collection part two...in photoessay format.
>
Reply to Thread
Message:
<p>[QUOTE="Stork, post: 3124170, member: 71642"]Oh, and using boxes I already have, here is an 'Ancients' box started. I can line them up anyway I want, they are not held to the tracking number as that is just for the documentation envelopes. So, NGC shaped holders work here. (The small purple box are the coins that are cataloged, but I don't have the right holder for yet).</p><p><br /></p><p>Oh, and I set up a table format in a Word document that are the correct size for the label and typed in whatever I wanted, using font sizes as I chose.</p><p><br /></p><p>[ATTACH=full]795669[/ATTACH]</p><p><br /></p><p>So, finally, the software. I played around with about 4 different spreadsheets (Numbers, Open Office, Google Sheets, Excel). I am not a power user of these, but I did cobble together some examples. My OC little heart though wanted something a little less spread-sheety with potential for tons of fields. Some of it was just borderline Luddite issues with 'how do I keep the photos from not scrolling over and blocking other cells' sort of things.</p><p><br /></p><p>I found three collecting software options that worked with a Mac.</p><p><br /></p><p><b>RECOLLECTOR</b> <a href="http://www.collectingcatalog.com/" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.collectingcatalog.com/" rel="nofollow">http://www.collectingcatalog.com/</a> is pretty nice. All the features a collector can want. Modifiable--the developer is actually a map collector. Lots of view options. Uploading format for a webpage. Great support. Very tempting. Almost went with it.</p><p><br /></p><p><b>ExactChange</b> <a href="http://www.exactchange.info/Series_page.htm" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.exactchange.info/Series_page.htm" rel="nofollow">http://www.exactchange.info/Series_page.htm</a> is also tempting. More costly. Great support/free upgrades. If all I was doing was world coins I very well might have gone with it. Has license to Krause, and if you have the books uploaded, you can get that information in the program. Pictures if you don't have them. Customizable. Upload your own. Make checklists. KM numbers, weights/diameters/metal content pre loads. A bit dated looking, but very nice for the world coins. And Krause isn't exactly error free so there are some limitations there. CAN make stuff for medals/Ancients, but then the extra features there aren't so useful.</p><p><br /></p><p>I went with <b>Tap Forms. </b><a href="https://www.tapforms.com/" target="_blank" class="externalLink ProxyLink" data-proxy-href="https://www.tapforms.com/" rel="nofollow">https://www.tapforms.com/</a> It's a Mac exclusive, but I'm sure there are some Windows versions out there. It's a user friendly personal (or small business) friendly. Super support (I emailed a question on Saturday and had a several email back and forth with support within 10 minutes as the guy walked me through a fix). I didn't expect any response until Monday! </p><p><br /></p><p>Not only did it look slick and work well for a database newbie (no Filemaker or Office Access level stuff, or coding for me!), but it's very flexible. </p><p><br /></p><p>Screenshots to follow and I'm sure more experienced people will do better. But a borderline Luddite like set this up pretty quickly. </p><p><br /></p><p>The basic work screen looks like this--views are very modifiable but this is the default view. They call the individual databases forms. The entries are records. It has a default record view too, but there are options there. You can even make a record view that ends up printing labels (I avoided that as too many variables in what fields I'd want on a label...like I said someone could probably fix that too). </p><p><br /></p><p>[ATTACH=full]795676[/ATTACH]</p><p><br /></p><p>More pictures...can click on the thumbnail to see the photo:[ATTACH=full]795677[/ATTACH]</p><p><br /></p><p><br /></p><p><br /></p><p>[ATTACH=full]795678[/ATTACH]</p><p><br /></p><p><br /></p><p><br /></p><p>[ATTACH=full]795679[/ATTACH]</p><p><br /></p><p>I blocked the seller's name/price. I don't want to know if I overpaid yet!</p><p>[ATTACH=full]795680[/ATTACH]</p><p><br /></p><p><br /></p><p>[ATTACH=full]795681[/ATTACH]</p><p><br /></p><p>Drop down menus are easily done. I added separate fields so I can have a text field for my tracking number, but can sort by 'grade'. The program will sequentially number records for me which I use for my tracking.</p><p><br /></p><p>[ATTACH=full]795686[/ATTACH]</p><p><br /></p><p>[ATTACH=full]795687[/ATTACH]</p><p><br /></p><p>I have sections to add jpgs (other formats acceptable) of the documents in the envelope, and I can add any other photos too.</p><p><br /></p><p>There are other ways to see the data. Including a spreadsheet view. You can collapse the side bar on the left (I think on the right too), so there is more horizontal viewing if you want.</p><p>[ATTACH=full]795688[/ATTACH]</p><p><br /></p><p><br /></p><p>To be continued...(eventually, I seem to be on uploading hold right now).[/QUOTE]</p><p><br /></p>
[QUOTE="Stork, post: 3124170, member: 71642"]Oh, and using boxes I already have, here is an 'Ancients' box started. I can line them up anyway I want, they are not held to the tracking number as that is just for the documentation envelopes. So, NGC shaped holders work here. (The small purple box are the coins that are cataloged, but I don't have the right holder for yet). Oh, and I set up a table format in a Word document that are the correct size for the label and typed in whatever I wanted, using font sizes as I chose. [ATTACH=full]795669[/ATTACH] So, finally, the software. I played around with about 4 different spreadsheets (Numbers, Open Office, Google Sheets, Excel). I am not a power user of these, but I did cobble together some examples. My OC little heart though wanted something a little less spread-sheety with potential for tons of fields. Some of it was just borderline Luddite issues with 'how do I keep the photos from not scrolling over and blocking other cells' sort of things. I found three collecting software options that worked with a Mac. [B]RECOLLECTOR[/B] [url]http://www.collectingcatalog.com/[/url] is pretty nice. All the features a collector can want. Modifiable--the developer is actually a map collector. Lots of view options. Uploading format for a webpage. Great support. Very tempting. Almost went with it. [B]ExactChange[/B] [url]http://www.exactchange.info/Series_page.htm[/url] is also tempting. More costly. Great support/free upgrades. If all I was doing was world coins I very well might have gone with it. Has license to Krause, and if you have the books uploaded, you can get that information in the program. Pictures if you don't have them. Customizable. Upload your own. Make checklists. KM numbers, weights/diameters/metal content pre loads. A bit dated looking, but very nice for the world coins. And Krause isn't exactly error free so there are some limitations there. CAN make stuff for medals/Ancients, but then the extra features there aren't so useful. I went with [B]Tap Forms. [/B][url]https://www.tapforms.com/[/url] It's a Mac exclusive, but I'm sure there are some Windows versions out there. It's a user friendly personal (or small business) friendly. Super support (I emailed a question on Saturday and had a several email back and forth with support within 10 minutes as the guy walked me through a fix). I didn't expect any response until Monday! Not only did it look slick and work well for a database newbie (no Filemaker or Office Access level stuff, or coding for me!), but it's very flexible. Screenshots to follow and I'm sure more experienced people will do better. But a borderline Luddite like set this up pretty quickly. The basic work screen looks like this--views are very modifiable but this is the default view. They call the individual databases forms. The entries are records. It has a default record view too, but there are options there. You can even make a record view that ends up printing labels (I avoided that as too many variables in what fields I'd want on a label...like I said someone could probably fix that too). [ATTACH=full]795676[/ATTACH] More pictures...can click on the thumbnail to see the photo:[ATTACH=full]795677[/ATTACH] [ATTACH=full]795678[/ATTACH] [ATTACH=full]795679[/ATTACH] I blocked the seller's name/price. I don't want to know if I overpaid yet! [ATTACH=full]795680[/ATTACH] [ATTACH=full]795681[/ATTACH] Drop down menus are easily done. I added separate fields so I can have a text field for my tracking number, but can sort by 'grade'. The program will sequentially number records for me which I use for my tracking. [ATTACH=full]795686[/ATTACH] [ATTACH=full]795687[/ATTACH] I have sections to add jpgs (other formats acceptable) of the documents in the envelope, and I can add any other photos too. There are other ways to see the data. Including a spreadsheet view. You can collapse the side bar on the left (I think on the right too), so there is more horizontal viewing if you want. [ATTACH=full]795688[/ATTACH] To be continued...(eventually, I seem to be on uploading hold right now).[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Managing a collection part two...in photoessay format.
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...