gridlox Posted January 1, 2006 Share Posted January 1, 2006 I know this has been covered somewhere, but since the SEARCH function isn't working right I couldn't look. Other than the online trading sites, how do you keep track of what you've ordered, who you ordered(pre-ordered) from, and if you've paid? I know I've posted on several pre-order threads (or sent emails) in the past few weeks that I was interested in ordering, but for the life of me I can't remember which ones I need to be expecting an invoice on. I had a bit of extra cash on hand to let me purchase several different ones at one time back before Christmas. But now that I've used that up, I need to keep better track of what I'm obligating myself to, to keep from over spending beyond my means. Dang It!! If everyone would quit putting out such cool coins, I wouldn't be in this predicament! D-man Quote Link to comment
+pdxmarathonman Posted January 1, 2006 Share Posted January 1, 2006 Never delete any email!! Quote Link to comment
+Damenace Posted January 1, 2006 Share Posted January 1, 2006 Excel spreadsheets have become my best friend!! Quote Link to comment
gridlox Posted January 1, 2006 Author Share Posted January 1, 2006 (edited) Never delete any email!! Good advice! "But" it's kinda hard to keep them when your hard drive crashes and you loose everything (INCLUDING almost a years worth of graphic designs & invoices) THANK GOD FOR MONTHLY BACK UPS ON THE BOTH OF THEM!! At least all I lost on those were 2 weeks worth! (Glad December is slow! ) That's the main reason for looking for other options that others use that I could start doing. Preferably something that could be saved to disc so I wouldn't run into the loose everything HD crash thing again. I was thinking maybe using a spreadsheet like in Excell? Anyone have something set-up in that already that they'd like to share? D-man EDIT: Damenace posted as I was typing, but I see that I'm at least going in the same direction as at least one other person Edited January 1, 2006 by gridlox Quote Link to comment
+Damenace Posted January 1, 2006 Share Posted January 1, 2006 Never delete any email!! All my geocaching corresponding is done through my Gmail account. I really like Gmail because I do not have to store anything on my hard drive. I never have to worry about loosing any information unless Gmail crashes. I save all my emails ( over 9000 emails saved to date), then I just search my emails if I need any information. Quote Link to comment
+Damenace Posted January 1, 2006 Share Posted January 1, 2006 (edited) Never delete any email!! Good advice! "But" it's kinda hard to keep them when your hard drive crashes and you loose everything (INCLUDING almost a years worth of graphic designs & invoices) THANK GOD FOR MONTHLY BACK UPS ON THE BOTH OF THEM!! At least all I lost on those were 2 weeks worth! (Glad December is slow! ) That's the main reason for looking for other options that others use that I could start doing. Preferably something that could be saved to disc so I wouldn't run into the loose everything HD crash thing again. I was thinking maybe using a spreadsheet like in Excell? Anyone have something set-up in that already that they'd like to share? D-man EDIT: Damenace posted as I was typing, but I see that I'm at least going in the same direction as at least one other person The other thing I do is run duel hard drives. I store all important documents on the non OS hard drive. If a hard drive is going to get corrupted and crash it usually is going to be OS related. Unless you loose a disc sector on your hard drive, but if you are not using the second hard drive for anything other than storage the chances of something going wrong have drastically decreased. OOPS edit: One more thing I do is any file that is in an Excel format or Word format I store on my PDA so if the hard drive does crash you have it stored on your PDA. One last thing you can do for storage of info, if you have a free email account somewhere such as Yahoo, Hotmail or Gmail, email your file to yourself so you can store it on there server, it is securely backup up every day. This works great for Gmail since they allow so much storage on their system Just some helpful tips Edited January 1, 2006 by Damenace Quote Link to comment
+Thorny1 Posted January 1, 2006 Share Posted January 1, 2006 Good info, Damenace, my thanks for a couple I hadn't thought of T1 Quote Link to comment
+AtlantaGal Posted January 1, 2006 Share Posted January 1, 2006 Trades are saved in a folder in my yahoo email account. I also have a PayPal payments folder in Outlook. Lastly, the trading lists. Quote Link to comment
+GrandpaKim Posted January 1, 2006 Share Posted January 1, 2006 I use Microsoft Access databases. I have 1 database with individuals, along with their real names and addresses and email addresses. I have another database with coins, along with the coin number, dates ordered, paid, and received, if it's a keeper or trader, has it been traded, etc. I have 1 other database containing my trade info, including who and when and details. I have the trade database tied to the coin database through the trade number and I have the individual database tied to the trade database through the individual number. I can produce reports showing all of my traders, all of my keepers, all of my outstanding trades, coins I've received today, etc. I keep these databases on a flash drive so that I can update them either at work or home (can you say addict ). I then backup the file to both machines. Now if there's a crash, I should be safe because I have it in 3 places. Quote Link to comment
+Damenace Posted January 1, 2006 Share Posted January 1, 2006 I use Microsoft Access databases. I have 1 database with individuals, along with their real names and addresses and email addresses. I have another database with coins, along with the coin number, dates ordered, paid, and received, if it's a keeper or trader, has it been traded, etc. I have 1 other database containing my trade info, including who and when and details. I have the trade database tied to the coin database through the trade number and I have the individual database tied to the trade database through the individual number. I can produce reports showing all of my traders, all of my keepers, all of my outstanding trades, coins I've received today, etc. I keep these databases on a flash drive so that I can update them either at work or home (can you say addict ). I then backup the file to both machines. Now if there's a crash, I should be safe because I have it in 3 places. So when is the next event on how to use Access? Quote Link to comment
+Chaos A.D./aka Arlsdaddy Posted January 1, 2006 Share Posted January 1, 2006 The other thing I do is run duel hard drives. I store all important documents on the non OS hard drive. Oh yes..I have 2 external hard drives. I keep them off unless I'm accessing them, haven't had a virus on them yet either Quote Link to comment
+Nanni&PapK57 Posted January 1, 2006 Share Posted January 1, 2006 Well I guess I'm still in the stone age!!I simply print out the order e-mails and paypal receipts mark them waiting for and stick them it a folder.When orders arrive mark them recieved and move them to another folder.I dont wory about crashes.I also save all e_mails untill orders arive. Happy Caching in 2006. Nanni&PapK Quote Link to comment
+kayakerinme Posted January 1, 2006 Share Posted January 1, 2006 Question: I use Cachemate regularly on my Palm. I was on vacation last week and started to create a coin tracking system for the Palm. Would there be any interest in having a program for your Palm? Quote Link to comment
+SilverMarc Posted January 1, 2006 Share Posted January 1, 2006 ...Other than the online trading sites, how do you keep track of what you've ordered, who you ordered(pre-ordered) from, and if you've paid?... I just create subfolders in my email app for the name of the coin being traded or purchased. All emails that I receive (and send) go into that folder. When the trade is completed, the folder is moved into the "Trades Closed" subfolder. It's an easy way to deal with the emails, and works well. --Marc January 1, 2006 @ 12:24 PM N40° 46.565' W073° 58.756' Quote Link to comment
+workerofwood Posted January 1, 2006 Share Posted January 1, 2006 I try to use several systems so that when I neglect to update one (which is inevitable) I will have a record elsewhere to catch the mistake. I kkep a form (printed from excel) beside the keyboard and make notes of offers and confirmed trades. I save the emails in a Yahoo folder (no loss risk). Finally I print the email once I get a mailing address sent. The only thing that screws me up is procrastination and there is no good system to avoid that... Quote Link to comment
+joefrog Posted January 1, 2006 Share Posted January 1, 2006 Anybody have a decent Excel spreadsheet they can donate? I'm excel-impaired! Quote Link to comment
+Go JayBee Posted January 1, 2006 Share Posted January 1, 2006 So...who wants the excel sheet? gridlox or joefrog? I have a template available.........email me and I'll RE: it to you. Quote Link to comment
+MO Outdoorfamily Posted January 1, 2006 Share Posted January 1, 2006 I use Microsoft Access databases. I have 1 database with individuals, along with their real names and addresses and email addresses. I have another database with coins, along with the coin number, dates ordered, paid, and received, if it's a keeper or trader, has it been traded, etc. I have 1 other database containing my trade info, including who and when and details. I have the trade database tied to the coin database through the trade number and I have the individual database tied to the trade database through the individual number. I can produce reports showing all of my traders, all of my keepers, all of my outstanding trades, coins I've received today, etc. I keep these databases on a flash drive so that I can update them either at work or home (can you say addict ). I then backup the file to both machines. Now if there's a crash, I should be safe because I have it in 3 places. Would you mind sharing this database with others? I have contemplated seting up somethhing similar ot this but haven't dedicatged the time to it. If you dont mind sharing (with our without sample data) I'd like to take a peak. My email is outdoorlady79ATNOSPAMyahoo.com Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.