I recommend a secretary.
but I use an openoffice table
Comment has been collapsed.
“Hello. You have reached the office of Mr. E. Edward Grey. Please leave your message, and the time you called, along with your phone number and the best time to reach you. And we will get back to you as soon as possible.”
Comment has been collapsed.
A Notepad file. :P
If I had more keys and stuff, I'd create a sheet. Maybe a private Google sheet. I like Google's system, because even if I fuck up by wrecking my hard drive, I won't lose my documents.
Comment has been collapsed.
There are two kinds of people: those who make backups, and those who are going to wish they did :D
Comment has been collapsed.
yeah i was like you until i took arrow... err until i couldnt find a $#)((#$ anymore because i had like 400 different notepad files created (: so i moved to google documents thingy too, and im loving it!
Comment has been collapsed.
This is my current Steam keys Notepad file.
Comment has been collapsed.
haha. well tbh my biggest problem became ... having too many of those damn notepad icons on my desktop. i really had like 20-30 different notepad files for different stuff, so at some point i said screw it. And im 100% positive how i forgot to import tons of keys (or just wasnt sure if they are working anymore or not because it was all too damn confusing).
google spreadsheet is awesome, even for people like me, who have no idea what are they doing :P
Comment has been collapsed.
I'm proud to say that my entire desktop is 99% clean of any icons or shortcuts. :P
99%, because I do still have the recycle bin and a folder (which for a reason, had to be on my desktop to function properly with some tools and stuff). Though, I also installed an application which hides desktop items until you click on the desktop. I really love it.
Comment has been collapsed.
create a spreadsheet in google drive and manage it from there.
Comment has been collapsed.
I have an Excel Spreadsheet. I set rules for color coding for games with cards as well.
Comment has been collapsed.
I would like to use solution where I can make queries and set filters: eg. display all square enix titles from HB bundles where gift link is avaialble (unredeemed to particular email) and ROW (before region restrictions applied) AND only those having cards.
Comment has been collapsed.
Woah. Interesting. :P
Would you consider using an online or an offline solution for this?
Comment has been collapsed.
If you want to do something like that then cook yourself up a database and learn the power of SQL!
Comment has been collapsed.
Or learn VBA for Excel. Seriously, you are overcomlicating things.
Comment has been collapsed.
That would work too, but I'm not sure I'd say learning VB would necessarily be easier than learning some Microsoft Access. I was taught Microsoft Access in high school. In college, half of my class failed programming 101 (VB.Net) on their first go around.
IMO SQL hides a lot of the complexity of array manipulation by putting queries in human understandable terms (SELECT * FROM users WHERE users.firstname = 'john' AND users.lastname = 'doe').
Comment has been collapsed.
Access is good, too, but I think Access 2007 has become something really complex comparing to Access 2003, and using Access to manage a mere Steam key collection is overkill. Excel can handle queries like in your example pretty easily with AutoFilter, and everything is visually display, with no coding needed. VBA is just optional, used for the userform to help speed up data input.
Comment has been collapsed.
Same as Mullins I use google spreadsheet. My columns include game name, retail price, key/link, date acquired, source (bundle name), notes (additional activation key or whatever), winner name, date given away. I can sort by any of those columns easily if I want to see high value not given away, or sort by bundle name, or whatever.
Comment has been collapsed.
isnt database more handy solution?To create particular views or queries.
Comment has been collapsed.
same here for Excel Spread Sheet and uploaded to Google Drive.
Comment has been collapsed.
Google Sheets are the best think that comes up to my mind. I use them for storing GA links, Keys, SG events, pretty much everything actually. It's noob-friendly (I love that) and comes up pretty handy.
Comment has been collapsed.
Excel, multiple tabs, formulas, conditional formatting...moderate complexity.
Comment has been collapsed.
Comment has been collapsed.
i have a mysql database, with data output in browser
Comment has been collapsed.
i wrote simple website for it.
looks like this
on top i have input into database, then i have a print option that makes nice list and than i have listing of all keys. for me they are obviously looking like keys instead of random strings.
Comment has been collapsed.
I do believe you can assign a port of localhost to a specific database and use it to communicate with SQL. I may be wrong, though.
Comment has been collapsed.
Get the data from the DB through Python and format it nicely in HTML, send that to the browser -> done. ^^
Also good luck fiddling with the feature lacking Steam API. xD
Comment has been collapsed.
Sorry, I've never used Python.
And from my personal experience: Stay away from SQLite, slightly different syntax than SQL, less features and it will lock your HDD, if you want to do something more (advanced) with it.
Comment has been collapsed.
i'm a PHP programmer, so it's made with PHP. in old version, it was one simple php file, with html parts. now it's updated to cms i'm writing, it is built with PHP on backend and have HTML views with RainTPL (stripped down Smarty) templater placeholders.
to process data, i have simple posts that are sent to backend and processed.
Comment has been collapsed.
RainTPL is templater -> meaning I don't write PHP code into HTML code (really dislike writing PHP code in HTML), than pass that template file to php and templater builds php file with all those placeholder replaced with values I created and passed to it in PHP side.
I'm pretty sure there are same stuff like this for Python. Or you can make one yourself. I'm using bit outdated RainTPL version, just have made changes to it to suit my needs
Comment has been collapsed.
send is when i give key to someone, mostly by sending giveaway game to winner or doing trading. it just marks as sent in database and is no longer displayed in list below. created is when i create a giveaway or need that key for something, just to mark that it's reserved and i don't use it for something else, it's also then is not printed in that trading list. uncreated just undo creation option
Comment has been collapsed.
The Indie Gala 2 Happy Hour concept totally validated my spreadsheet method. :)
Comment has been collapsed.
I'm tattooing them on my arms. Probably not the smartest way of doing it. :)
Comment has been collapsed.
You're welcome! Now I just have to get that tattoo removed...again. :)
Comment has been collapsed.
I imagine you often get into that awkward situation when you're trying to talk to random strangers and they just stare on the monitor of their PC eagerly typing some letters and numbers real fast while sporadically admiring your tattoos.
Comment has been collapsed.
Yeah, it was kind of annoying at first, but you get used to it. :)
Comment has been collapsed.
I can store them for you in a very secure place (͡° ͜ʖ ͡°)
Comment has been collapsed.
I have a gamelist in excel, and in a column next to it, i keep the few keys i have (i just tend to give them away).
Comment has been collapsed.
Who would use a real CMS for storing steam keys?! :D
Comment has been collapsed.
A spreadsheet of some sort is probably the most efficient way to handle it from a time investment : usability ratio perspective, unless you are really fluent with database programming.
Comment has been collapsed.
ArchiBoT connected to my MySQL database, although that is pretty much overkill but I can !drop random key on 2hu chat :3.
Comment has been collapsed.
What would you suggest for steam gifts and keys for trade management?Some sort of database or custom CMS or text file/Excel table?
What do YOU use?
Comment has been collapsed.