# New Feature: My Collection on Gems of War Database **URL:** \ **Category:** Community Content\ **Created:** [January 3, 2017, 8:36am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646 "2017-01-03T08:36:22Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Emos](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/emos/32/5163_2.png) [@Emos](https://community.gemsofwar.com/u/Emos)\ **Post date:** [January 3, 2017, 5:53pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/21 "2017-01-03T17:53:07Z")
Out and about now I’ll try once I get home. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 3, 2017, 5:56pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/22 "2017-01-03T17:56:01Z")
> [@SkittishSloth](#): > > One thought: what about troop count? I know that might be less important than knowing how many of a particular traitstone you need to farm, since you can’t very well farm a particular card, but it’d still be good to keep track of. E.g. how many more peasants do I need to make it mythic? I thought about it, and might end up making that an optional column to fill in. I know that for some people, tracking this is important, but it’s also something that goes out of sync a lot and is hard to manually update (think of opening 50 chests and having to update 30 rows of the database each time!) Traitstones are like that too but at least there are only 40 of them to update. If the devs ever give me an API I can use to query user collection stats (@Sirrian, if you’re listening!) then I can accomodate that easily. (Though if I had that API, the whole page could become read-only and simplify things considerably…) ---
**Author:** ![Gabbryrose](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@Gabbryrose](https://community.gemsofwar.com/u/Gabbryrose)\ **Post date:** [January 3, 2017, 5:56pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/23 "2017-01-03T17:56:24Z")
Good gracious. It looks like he is there, I must have had one of the filters applied and didn’t see him. Apologies! Thanks again for a wonderful site though, it has been immensely helpful! ---
**Author:** ![SkittishSloth](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/skittishsloth/32/15154_2.png) [@SkittishSloth](https://community.gemsofwar.com/u/SkittishSloth)\ **Post date:** [January 3, 2017, 6:15pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/24 "2017-01-03T18:15:53Z")
> [@Lyya](#): > > I know that for some people, tracking this is important, but it’s also something that goes out of sync a lot and is hard to manually update (think of opening 50 chests and having to update 30 rows of the database each time!) Yeah, I was thinking about that as I wrote it. I know on Mondays, my guild kicks out a ton of keys - yesterday it was like 400+. Do I really want to have to go through 400 new cards to update it? And then when I ascend a troop, I need to update it _again_? The answer was “ugh, kinda :/” Another thought (now that I’ve finished putting everything in): on classes, maybe a checkbox to flag that you obtained the weapon? I don’t know what DB you’re using (SQL or NoSql) so I don’t know how much of a PITA it is to add a new field like this; this is something that I think would be good, but also not terribly important. (I’m really torn on the original suggestion; I’m sure it’d need adding a new field or something, but I almost want it enough to where it’d be worth it.) And I agree - some kind of user API would be awesome for this 🙂 Even if they just worked something out with you specifically and didn’t make it actually “public”, since you’re obviously dedicated to this community. ---
**Author:** ![Youdz](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/youdz/32/16683_2.png) [@Youdz](https://community.gemsofwar.com/u/Youdz)\ **Post date:** [January 3, 2017, 8:30pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/26 "2017-01-03T20:30:13Z")
Regarding Traitstones, any way you could accept some kind of import too? Because right now these 40 inputs are a bit painful to fill. Fantastic job overall, this is exactly what I was looking for. ❤ ---
**Author:** ![MarvelKit](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/marvelkit/32/7072_2.png) [@MarvelKit](https://community.gemsofwar.com/u/MarvelKit)\ **Post date:** [January 3, 2017, 8:34pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/27 "2017-01-03T20:34:04Z")
You’re amazing @Lyya, thank you! ---
**Author:** ![Mahamoti](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mahamoti/32/19354_2.png) [@Mahamoti](https://community.gemsofwar.com/u/Mahamoti)\ **Post date:** [January 3, 2017, 10:03pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/28 "2017-01-03T22:03:14Z")
Just noticed you can filter your collection by clicking on the traitstones in the checklist… that’s _awesome_. ---
**Author:** ![SkittishSloth](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/skittishsloth/32/15154_2.png) [@SkittishSloth](https://community.gemsofwar.com/u/SkittishSloth)\ **Post date:** [January 3, 2017, 10:09pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/29 "2017-01-03T22:09:45Z")
Do the checklist amounts update when we update the traits for a troop, like subtract from what we’ve said we have? (It feels like I’m being unclear with this, so if it doesn’t make sense I’ll clarify.) ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 3, 2017, 10:11pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/30 "2017-01-03T22:11:42Z")
Done. Refresh the page and you’ll get a few new columns in the exported CSV, modify the traitstoneCount column as needed and import. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 3, 2017, 10:15pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/31 "2017-01-03T22:15:32Z")
No, they don’t. I debated doing that, but while it makes sense to do it once at steady-state, while people are still entering data it could cause weird behavior – particularly if they enter traitstone info before entering troop info. I could change this behavior, and deduct/refund the needed stones upon changes to the trait counts if people like, but keep in mind that you’re gaining stones all the time from each match, so an automatic update would only be a shortcut for removal, not gain, and I’m a bit unhappy with the half-automatic nature of that behavior. ---
**Author:** ![SkittishSloth](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/skittishsloth/32/15154_2.png) [@SkittishSloth](https://community.gemsofwar.com/u/SkittishSloth)\ **Post date:** [January 3, 2017, 10:21pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/32 "2017-01-03T22:21:31Z")
Yeah, I could definitely see issues with it - if nothing else, another spot for bugs and/or confusion. No worries, just curious if it did or not 🙂 ---
**Author:** ![MilkFedGimp](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/milkfedgimp/32/9988_2.png) [@MilkFedGimp](https://community.gemsofwar.com/u/MilkFedGimp)\ **Post date:** [January 4, 2017, 1:37am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/33 "2017-01-04T01:37:05Z")
Thanks very much for this, Lyya! I found it so much easier to use than the ToDo Monitor 🙂 ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 4, 2017, 6:09am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/34 "2017-01-04T06:09:05Z")
User name, email, and password changing are now available at [Sign In - Gems of War Database](http://ashtender.com/gems/account). ---
**Author:** ![mraider94](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mraider94/32/21939_2.png) [@mraider94](https://community.gemsofwar.com/u/mraider94)\ **Post date:** [January 4, 2017, 6:11am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/35 "2017-01-04T06:11:06Z")
Being able to set everything to mythic lvl 20 is nice, but I have many troops that are mythic lvl 1 and a lot that are max lvl for their rarity. Having a checkbox for selecting a group of troops to change all at once would be AMAZING. ---
**Author:** ![HKdirewolf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hkdirewolf/32/21614_2.png) [@HKdirewolf](https://community.gemsofwar.com/u/HKdirewolf)\ **Post date:** [January 4, 2017, 6:24am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/36 "2017-01-04T06:24:41Z")
Looking forward to trying this out. ---
**Author:** ![Youdz](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/youdz/32/16683_2.png) [@Youdz](https://community.gemsofwar.com/u/Youdz)\ **Post date:** [January 4, 2017, 9:04am UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/37 "2017-01-04T09:04:52Z")
> [@mraider94](#): > > Being able to set everything to mythic lvl 20 is nice, but I have many troops that are mythic lvl 1 and a lot that are max lvl for their rarity. > > Having a checkbox for selecting a group of troops to change all at once would be AMAZING. This is typically the case that Lyya was trying to support with export/import. She can’t handle all the possible batch operations and advanced features everyone might want, so the easiest both for her and for us is to: 1. export to CSV, 2. copy it in Google Docs, Excel, or whatever your favorite spreadsheet editor is, 3. change all the troops you want at the same time with all the super-duper filters, multi-selection and even formulas offered by spreadsheets (max level for rarity = rarity + 14, that’s easy to do in a spreadsheet), 4. copy the whole table again from the spreadsheet, 5. import from CSV on Lyya’s website. It might seem involved, but it’s a great compromise to allow crazy stuff like the formulas I mentioned. ---
**Author:** ![Tacet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/tacet/32/35_2.png) [@Tacet](https://community.gemsofwar.com/u/Tacet)\ **Post date:** [January 4, 2017, 7:08pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/38 "2017-01-04T19:08:25Z")
I just tried your new database system and it works great! I haven’t read everything above, but here are the few things I noticed that may need a few tweaks: - Set all levels to 1. - Modify the side bar so it doesn’t disappear from zoom (on my 1080p monitor it disappears after a 125% zoom, likely even quicker on smaller platforms). - Have a toggleable option for the side bar to show or hide the bar. - When sorted by kingdom, change the side bar to only reflect the souls and traitstones needed for that kingdom sort. - When sorted by kingdom, show kingdom exp, star level, and amount of exp needed for all following star levels based on the data’s current input. ---
**Author:** ![Rasper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/rasper/32/2363_2.png) [@Rasper](https://community.gemsofwar.com/u/Rasper)\ **Post date:** [January 4, 2017, 7:14pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/39 "2017-01-04T19:14:33Z")
> [@Tacet](#): > > - When sorted by kingdom, change the side bar to only reflect the souls and traitstones needed for that kingdom sort. This you can do by clicking the “Count hidden troops” toggle off, so it only counts what is displayed ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 4, 2017, 7:42pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/40 "2017-01-04T19:42:33Z")
> [@mraider94](#): > > Being able to set everything to mythic lvl 20 is nice, but I have many troops that are mythic lvl 1 and a lot that are max lvl for their rarity. > [@Tacet](#): > > Set all levels to 1. I just made the batch operation dialogs take an edit control where you can specify the level / rarity / trait count you want and the page will attempt to accomodate you as best as possible (rarity will be clamped to base rarity). Note that setting level to 20 here will make the troops Mythic automatically, so if you really want “highest level for their current rarity” then you should do what @Youdz suggested and export to CSV. > [@Tacet](#): > > Modify the side bar so it doesn’t disappear from zoom (on my 1080p monitor it disappears after a 125% zoom, likely even quicker on smaller platforms). > Have a toggleable option for the side bar to show or hide the bar. I’ll look into this. The overlapping checklist is a usability issue when someone wants to interact with the table below it, so I’m not sure I want it present when the page can’t accomodate both the troop table as well as the checklist. > [@Tacet](#): > > When sorted by kingdom, show kingdom exp, star level, and amount of exp needed for all following star levels based on the data’s current input. That’s on the todo list. Haven’t gotten to it yet. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 4, 2017, 9:22pm UTC](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646/41 "2017-01-04T21:22:27Z")
> [@Lyya](#): > > Modify the side bar so it doesn’t disappear from zoom (on my 1080p monitor it disappears after a 125% zoom, likely even quicker on smaller platforms).Have a toggleable option for the side bar to show or hide the bar. Just added a pushpin to the checklist panel. When pushed, the panel will persist, even if it would overlap the rest of the UI. Use it if you dare! ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/3/3/33af857aab8ddf24542e41517ad5f26afff9e1e0.jpg) [Previous page](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646.md?page=1) [Next page](https://community.gemsofwar.com/t/new-feature-my-collection-on-gems-of-war-database/17646.md?page=3)