I had 4 giveaways come up as duplicate because I had obviously given them away once before and forgot to mark them off or delete them.
That's not always the case. Some bundle sites seem to not be great at the whole "keeping track of their keys", and I've got duplicate keys from them in the past. Or broken keys (I got half a key from Groupees once, wonder who got the second half).
I just use a txt document. So nothing fancy here.
Comment has been collapsed.
+1 but would recommend putting the most recent version on dropbox or another storage site, in case your computer ever poops itself unexpectedly.
Comment has been collapsed.
I had one of those. I stored a bunch of important stuff on it. One day, my computer crashed for no reason and when I rebooted it, don't ask me how, but my external hard drive was WIPED. rip never lucky
Comment has been collapsed.
Did you try using an "undeleting" software to make sure the file path wasn't just unlisted?
Comment has been collapsed.
Nope. Just taking keys from websites I purchased them when time comes.
Comment has been collapsed.
I've been using my trusty Notepad document, but when IndieGala deleted my account with a bunch of keys on it, I stopped trusting any site.
Comment has been collapsed.
Literally no reason. It was just deleted. After sending 3 emails to them, they just never responded. THANKS INDIEGALA!
Comment has been collapsed.
IndieGala has turned to shit lately. They shut down GalaGiveways then replaced it with probably the worst giveaway mechanism I've ever seen. Also I didn't understand redesigning the whole site except their horribly user-unfriendly key library page.
Comment has been collapsed.
I use excel aswell...once I create a GA for a game I mark the key as in progress...once its activated I mark it as gone xD
has worked fine so far
Comment has been collapsed.
Big-ass Excel spreadsheet, and moving all the finished giveaways and trades into a separate tab, which is automatically marking any possible duplicate keys with conditional formatting.
Comment has been collapsed.
well if your forget to remove/modify the used keys i am afraid a program won't help in this case either.
Comment has been collapsed.
Excel, but I do check any old GAs of the game to make sure I have not used the key. I also color code based on bundle/unbundle, whitelist wishlist, free (no GA, just drops), used, waiting on feedback.
Comment has been collapsed.
Ooh colour coding is good..... we like colour coding
Comment has been collapsed.
I have an excel spreadsheet as well and as soon as I create a giveaway for a key I change the background color for it to something else so I know when looking at the list that that key is currently used in a giveaway. Once the giveaway is done and the winner has claimed the key and marked it as received I remove the key from the list.
Comment has been collapsed.
Txt files but I always cut the key from them, not copy. If I manage to screw up and lose the key from clipboard, it's back with a simple ctrl+z.
Comment has been collapsed.
Notepad. I use * symbol beside keys to indicate it's a giveaway I'm running, and # once I've given the key.
Comment has been collapsed.
I store them in a text file. I put a * if front of it when I have a giveaway running and delete it once it's marked as received.
Comment has been collapsed.
I don't store them locally. Usually I immediatly use them or create GA's with them. Sometimes I try to trade them, but I still leave them on the site (in the case of humble at least, but that's also the only site I get keys from to trade).
Comment has been collapsed.
in my vault ofc
(but really i use a text doc and mark used keys with abbreviations so i know what group,whitelist or public they were used for until the giveaway ends then i delete them)
Comment has been collapsed.
I use an excel speadsheet with three pages.
First page is called "To Do" and has the unused keys, it has name of the game, if it's base game or dlc, price on steam without sales, and where the key is from (humble bundle, indie gala, DIG, ...) and a space for any note about the key.
Page 2 is called "Give Aways", once I create a GA I just cut (ctrl x) the line of that game from the 1st page to this page. This page will have all the info about the game that the 1st page had, plus a few things like serial key, link to giveaway and if positive feedback was given.
Page 3 is called Level and it's about my level on SG, so I also paste the info about the game from the 1st page into this one and then when positive feedback is given I update how much my level changed.
Since when I do a GA I move the game right away from the list of games available to do GA, I can prevent doing duplicated GA for the same key.
Comment has been collapsed.
Excel file that's synced to a personal server.
But i usually give my keys away to X people 4C4N2-4FLQ"-"6TE8, so in worst case i probably wouldn't even give a shit about the few that are remaining.
Comment has been collapsed.
In a message to a friend who has it on their wishlist
Comment has been collapsed.
do you want to be my friend? :P
also: excel on onedrive with several different tabs (keys, high tier, freebies, giftlinks, and bundles. move to a different row giveaways in progress and delete key or link after giveaway or trade it's complete so i don't have to deal with dups.
Comment has been collapsed.
Excel spreadsheet or similar ways work fine for me.
The more important point is to use them asap. It's not good to keep them stored all year long and forget where they come from.
Comment has been collapsed.
by redeeming them ?, but don't work really well for ga after all
Comment has been collapsed.
I have about 15 or so games waiting to be given away. The keys originate from 5 or so different sites xD
Comment has been collapsed.
I like this think I am going to start this sort of system.
Comment has been collapsed.
Its kinda messy code but here:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error GoTo Quit
If Target.Count > 1 Then Exit Sub
If Target.Row <= 2 Then Exit Sub
With ActiveSheet
Dim name As String
Dim key As String
Dim source As String
Dim lastrow_give As Long
If Target.Column = .Range("E1").Column Then
.Cells(Target.Row, .Range("A1").Column).Interior.ColorIndex = 6 'Change colour to yellow
.Cells(Target.Row, .Range("B1").Column).Interior.ColorIndex = 6
.Cells(Target.Row, .Range("C1").Column).Interior.ColorIndex = 6
.Cells(Target.Row, .Range("D1").Column).Interior.ColorIndex = 6
name = .Cells(Target.Row, .Range("A1").Column) 'safe GameName
key = .Cells(Target.Row, .Range("B1").Column) 'safe Key
source = Target.Worksheet.name & "| Row " & Target.Row 'safe source (sheet and row)
Call create_giveaway(name, key, source) 'creates a giveway and copies name in clipboard
Cancel = True
End If
If Target.Column = .Range("F1").Column Then
.Cells(Target.Row, .Range("A1").Column).Interior.ColorIndex = 4 'key ok - change colour to green
.Cells(Target.Row, .Range("B1").Column).Interior.ColorIndex = 4
.Cells(Target.Row, .Range("C1").Column).Interior.ColorIndex = 4
.Cells(Target.Row, .Range("D1").Column).Interior.ColorIndex = 4
Cancel = True
End If
If Target.Column = .Range("G1").Column Then
.Cells(Target.Row, .Range("A1").Column).Interior.ColorIndex = 3 'key not ok - change colour to red
.Cells(Target.Row, .Range("B1").Column).Interior.ColorIndex = 3
.Cells(Target.Row, .Range("C1").Column).Interior.ColorIndex = 3
.Cells(Target.Row, .Range("D1").Column).Interior.ColorIndex = 3
Cancel = True
End If
If Target.Column = .Range("H1").Column Then
.Cells(Target.Row, .Range("A1").Column).Interior.ColorIndex = 0 'reset colour
.Cells(Target.Row, .Range("B1").Column).Interior.ColorIndex = 0
.Cells(Target.Row, .Range("C1").Column).Interior.ColorIndex = 0
.Cells(Target.Row, .Range("D1").Column).Interior.ColorIndex = 0
Cancel = True
End If
End With
Quit:
End Sub
Function create_giveaway(name As String, key As String, source As String)
Dim nextRow As Long
Sheet4.Activate
With Sheet4
nextRow = .Cells(1, 10)
.Cells(nextRow, 1) = name 'GameName
.Cells(nextRow, 1).Copy 'copy GameName to clipboard
.Cells(nextRow, 2) = key 'key
.Cells(nextRow, 3) = source 'source
.Cells(1, 10) = nextRow + 1
End With
End FunctionComment has been collapsed.
i think that you have miss screenshotted those sheets, we can't see the cd key of all those game
Comment has been collapsed.
oh my bad totally unintentional...
here maybe you want those totally awesome games:
Journey To The Center Of The Earth 3PD28-NY0D0-R0WFI
Unforgiving Trials: The Darkest Crusade J0MYN-WW9D4-EFG5C
The Big Space Mess 9YXDV-D24G6-JZB7R
Weapons Genius FJWCM-CRW37-I9MQ2
Yellow: The Yellow Artifact 67NTJ-WG2JK-KKA7H
Freebie 09EYB-60TYE-FRV5A
Comment has been collapsed.
that was uninspected
thx a lots lol
(Freebie and Unforgiving Trials: The Darkest Crusade has been used )
Comment has been collapsed.
I have always stored keys in an excel spreadsheet and then deleted them when used but recently I had 4 giveaways come up as duplicate because I had obviously given them away once before and forgot to mark them off or delete them.
Are there any programs for storing keys?
Or if not how do you all do it?
Comment has been collapsed.