Terminal base Collection Managers?

haemogoblin · 04-23-2017, 04:48 AM

I'm looking for a no frills program that works via the console, which will let me compile a list of all my old games. I know theres MOLL, but apparently it doesn't have a search function.

Was just wondering if anyone might be able to suggest a program.

Many thanks

Habitual · 04-23-2017, 05:54 AM

Might get better results editing the subject to
Consoled-based Collection Managers?

Just sayin'

haemogoblin · 04-23-2017, 12:08 PM

Sadly I cant change the subject heading, just the post body.

fatmac · 04-23-2017, 01:06 PM

How about using Sqlite3 - you can set up how to organise it & make your own queries to extract what info you want.

Habitual · 04-23-2017, 03:28 PM

Quote:

Originally Posted by haemogoblin

I'm looking for a no frills program that works via the console, which will let me compile a list of all my old games. I know theres MOLL, but apparently it doesn't have a search function.

Was just wondering if anyone might be able to suggest a program.

Many thanks

http://bashscripts.org/forum/viewtopic.php?f=7&t=414
is a script for just such a thing.

haemogoblin · 04-23-2017, 04:55 PM

Thanks for that, i notice the script is for a phonebook though.

Sqlite3 seems like an aweful lot of leg work for what is essentially a list, I dont think i need an SQL server for just one database lol

Scrub what i said, i just read further and saw its stand alone. Still not entirely sure its what i need :-/

Habitual · 04-23-2017, 06:04 PM

Quote:

Originally Posted by haemogoblin

Thanks for that, i notice the script is for a phonebook though.

You are welcome.

I too noticed that a phonebook is a collection.

haemogoblin · 04-23-2017, 06:27 PM

Managed to edit the script and seems to be working. Going to see if i can add another field or two.

ondoho · 04-24-2017, 12:29 AM

Quote:

Originally Posted by Habitual

http://bashscripts.org/forum/viewtopic.php?f=7&t=414
is a script for just such a thing.

a little down the page there's a link to version 2:
http://bashscripts.org/forum/viewtopic.php?f=7&t=1252

haemogoblin · 04-24-2017, 10:59 AM

I saw that but wasn't sure how easy it would be to modify what with it using SQL instead of Bash. I know only a little about Bash and even less about SQL :-(

Shadow_7 · 04-25-2017, 09:32 AM

You could use find to locate your files / mods.

$ find . -iname '*.mod'

To bridge the gap between text file and DB, you could use a CSV, comma separated values. If there's a fixed number items and no exotic characters, fairly simple. Assume 3 items per line in a text file.

Code:

$ cat FILE.text | while read LINE; do echo \"$LINE\" | awk '{ print $1","$2","$3; }' | sed 's/\,/\"\,\"/g'; done > FILE.csv

Okay, not as simple as I had envisioned it. But importing CSV's into a DB or spreadsheet is simple-er than writing SQL and other more complex things.