Author Topic: Simple Redemption Collection Manager  (Read 1491 times)

Offline Reth

  • Hero Member
  • *****
  • Posts: 1151
    • LFG
    • East Central Region
Simple Redemption Collection Manager
« on: August 26, 2019, 07:31:31 PM »
+3
Hi everybody,

since I want to be able to manage my collection by using some kind of software support and unfortunately I couldn't get it working using a cardpool in LackeyCCG (there seems to be some strange limit which doesn't allow for adding additional cards - only duplicates to existing ones) and using a Lackey deck is far to slow I decided to tinker a small tool for myself. (I already posted that strange behaviour in Lackey forum and wrote Trevor personally last year but it couldn't get resolved yet.)

To make things easy I just used a spreadsheet application (in this case LibreOffice but maybe OpenOffice should work too - if time and motivation allows maybe I will try to create an Excel version in addition). Thanks to EmJayBee I was allowed for using his Redemption LackeyCCG plugin carddata file as well as his picture server. Thank you a lot EmJay!  :D :thumbup:
This also means it has the same "quality" as the current LackeyCCG plugin has (for more details see here for example.

The spreadsheet provides all possibilities for filtering/selecting so that you can easily get to relevant cards or kind of cards (e.g. of one set or of one kind of special ability or of one kind of class [like territory]). Also sorting would be possible but here you need to be careful since if you sort for one column using the dropdown in the headlines all other related columns won't get sorted meaning you'll end up with a messed sheet!

Since it is just a small tool it is far from being perfect - and also never will be.

The current version can be downloaded from here (I had some occasional errors which I couldn't reproduce and hence not really fix yet), for previous versions please see end of this post.

Screenshot can be seen

Spoiler: here (hover to show)

What are you able to do with it (features):
  • Uses LackeyCCG Redemption plugin carddata.txt file as data source in first tab (i.e. first sheet)
  • Clicking on line will show card image
  • Display of card image can be (de-)activated
  • Path to LackeyCCG installation can be chosen, and is also stored now within own sheet - Images will be loaded from there (in case of not yet downloaded by LackeyCCG image will be shown from web source)
  • Pressing Add to Cardpool button copys currently selected cards to your Cardpool (second tab resp. sheet)
  • Copy to Cardpool supports single cell selection, selection of connected cell range and selection of multiple non-connected cell ranges - just select cells in column "Name"
  • Always the entire line will get copied to Cardpool tab/sheet
  • Within your Cardpool tab/sheet you are free to edit/delete/move everything to your needs
  • carddata.txt and Cardpool tab/sheet are protected but no password is set (if you remove protection from carddata.txt and maybe mess up that sheet macros might not be working anymore)

Caution:
  • Needs LibreOffice (maybe OpenOffice might be working too)
  • Macro activation need to be allowed while loading/starting this spreadsheet
  • Sorting for one column (e.g. in Cardpool tab/sheet) using dropdowns in headers will not necessarily sort related columns automatically
  • Downloading and displaying of pictures might take a while from time to time
  • Maybe still a lot of bugs, side-effects, "unwanted features", etc.
  • Certainly lots more ...

Note:
I also added the current All_Sets_Full_List spreadsheet within the carddata.txt tab/sheet just to provide this in addition if someone want to use it too. If I am not allowed to please let me know and I'll remove it.
All additional list sheets have been removed.

If you have any questions, comments, ideas, proposals, etc. feel free to post it here or just drop me a PM.

Enjoy!

Bye

Previous versions:
« Last Edit: August 09, 2020, 10:50:56 AM by Reth »

Offline SiLeNcEd_MaTrIx

  • Tournament Host
  • *****
  • Posts: 1176
  • T1-2P 2003 National Champion
    • -
    • Southeast Region
    • Redemption CCG FL
Re: Simple Redemption Collection Manager
« Reply #1 on: August 26, 2019, 08:54:56 PM »
0
Very cool brother!
Redemption FL - Massive Redemption Resource, Check it Out!

Offline uthminister [BR]

  • Youth Minister
  • Tournament Host
  • *****
  • Posts: 2579
  • Jesus Loves Gamers!
    • -
    • South Central Region
Re: Simple Redemption Collection Manager
« Reply #2 on: August 26, 2019, 10:13:37 PM »
0
Great job!

Offline RedRanger

  • New Member
  • *
  • Posts: 17
    • South Central Region
Re: Simple Redemption Collection Manager
« Reply #3 on: August 26, 2019, 10:35:00 PM »
0
Awesome. Also works on linux, even using an older version of libreoffice 4.3.

Offline Reth

  • Hero Member
  • *****
  • Posts: 1151
    • LFG
    • East Central Region
Re: Simple Redemption Collection Manager
« Reply #4 on: August 27, 2019, 02:48:43 AM »
0
Awesome. Also works on linux, even using an older version of libreoffice 4.3.
Cool! Didn't expect that.

Offline RedRanger

  • New Member
  • *
  • Posts: 17
    • South Central Region
Re: Simple Redemption Collection Manager
« Reply #5 on: August 27, 2019, 05:20:49 PM »
0
Awesome. Also works on linux, even using an older version of libreoffice 4.3.
Cool! Didn't expect that.

Neither did I, but curiosity got the better of me.

Offline Reth

  • Hero Member
  • *****
  • Posts: 1151
    • LFG
    • East Central Region
Re: Simple Redemption Collection Manager
« Reply #6 on: August 29, 2019, 10:04:58 AM »
0
New version uploaded - opening post updated.
« Last Edit: August 31, 2019, 03:28:23 AM by Reth »

Offline Reth

  • Hero Member
  • *****
  • Posts: 1151
    • LFG
    • East Central Region
Re: Simple Redemption Collection Manager
« Reply #7 on: August 30, 2019, 05:28:01 PM »
0
New version uploaded and opening post updated.
« Last Edit: August 31, 2019, 03:28:38 AM by Reth »

AndyDevine1981

  • Guest
Re: Simple Redemption Collection Manager
« Reply #8 on: November 26, 2019, 11:22:04 AM »
0
having trouble linking the card images to my location path... which path should it be linked to?  okay got it!! :)
« Last Edit: November 26, 2019, 06:19:48 PM by AndyDevine1981 »

Offline Reth

  • Hero Member
  • *****
  • Posts: 1151
    • LFG
    • East Central Region
Re: Simple Redemption Collection Manager
« Reply #9 on: August 09, 2020, 10:51:56 AM »
0
New version uploaded containing all the latest cards and some small updates. Intro post adjusted.