cataloguing

[ramtops]

so far, we have catalogued

149 DVDs

585 CDs and vinyl albums (still a lot to go)

86 books (there's a long way to go here)

Comments

[ramtops.livejournal.com]

not quite sure what you mean. We use iTunes to record CDs, and a complex and convoluted process to do vinyl (but all on a Mac, so probably not of any interest to you :)

[kibe.livejournal.com]

i mean with the cataloguing, are you just arranging in alphabetical order or using a program to record which ones you have? :)

[ramtops.livejournal.com]

OIC! Yes, we're using stuff from Bruji (http://www.bruji.com/).

Mac only, AFAIAA

[kibe.livejournal.com]

darn :( I need to find something suitable for home. We're thinking about doing a shite Access Database one. I suppose actually I should have a go at a php/SQL one :D

[ramtops.livejournal.com]

for Windows, Readerware (http://www.readerware.com/") is supposed to be pretty good.

I did access for mine

[the-magician.livejournal.com]

... but got way out of date and need to get back to it.

I've written access routines that open a text file, write HTML headers etc. pulls in a header text file, and then loops through the table writing formatted HTML. To finish it pulls in a standard footer and closes the HTML. For the SF books I've actually done it either as one long list or as 28 individual pages plus index (A-Z, numbers, collections and an index)

For the house inventory, each item has a location so the list is formatted by room.

http://www.magician.co.uk/sfbooks.htm
http://www.magician.co.uk/sfbooks2a.htm
http://www.magician.co.uk/cdlistnav.htm
http://www.magician.co.uk/dvdlist.htm
http://www.magician.co.uk/inventlist.htm
http://www.magician.co.uk/magicbooks.htm

None of these have been updated in years though ...

Evidence of out of dateness

[the-magician.livejournal.com]

The inventory says "about 500 CDs", the CD list says 947 CD albums, and I've actually got something closer to 1,500 now.

[ramtops.livejournal.com]

what I like about the stuff I'm using, and Readerware, is that they go look up the details via that interweb thing. So you get cover art, present price, etc. Which means I get things valued for insurance purposes. And it outputs CSV, so I can dump it into mySQL. We don't do static HTML pages here :)

You're just showing off!

[the-magician.livejournal.com]

The readerware stuff sounds great, not probably so useful for my house inventory, but great for the books ...

... my public webspace is on a site that doesn't do CGI, Perl, PHP, MySQL or anything like that. And my home webspace, well, I'm the only one updating the lists and it only takes clicking on the "update all pages" link for it to update the static HTML. So for my purposes, static HTML actually gives quicker results that having to run a script to rebuild the page each time.

I *do* want to move to a new web provider which will allow me to host a few dozen domain names and give me some PHP/Perl/CGI/MySQL etc. access, but that will take money and time, so it's not going to happen this week!

Sorry

[the-magician.livejournal.com]

Missing smiley after "you're just showing off" in last message, here's a couple of extras!

:-)
;-)
:-]
8-)
8-}

[ramtops.livejournal.com]

use someone else's web space? I think not, thank you :)

our own web servers have PHP, Perl, mod_perl, mySQL, PostgreSQL, ColdFusion, Imagemagick and ghod knows what else on them.

as we earn our crusts writing dynamic web sites for people, we're not prepared to compromise with someone else's server software.

p.s. smilies not required - I knew you were joking.