Click here to Skip to main content
15,442,578 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: I'm not a very good electrician... Pin
Sandeep Mewara20-Sep-20 3:00
mveSandeep Mewara20-Sep-20 3:00 
GeneralRe: I'm not a very good electrician... Pin
Sander Rossel20-Sep-20 3:14
professionalSander Rossel20-Sep-20 3:14 
GeneralRe: I'm not a very good electrician... Pin
DRHuff20-Sep-20 4:21
MemberDRHuff20-Sep-20 4:21 
GeneralRe: I'm not a very good electrician... Pin
Ron Anders20-Sep-20 3:16
MemberRon Anders20-Sep-20 3:16 
GeneralRe: I'm not a very good electrician... Pin
PIEBALDconsult20-Sep-20 4:57
professionalPIEBALDconsult20-Sep-20 4:57 
GeneralRe: I'm not a very good electrician... Pin
obermd21-Sep-20 4:01
Memberobermd21-Sep-20 4:01 
GeneralRe: I'm not a very good electrician... Pin
trønderen22-Sep-20 1:48
Membertrønderen22-Sep-20 1:48 
GeneralLateral thinking wins the day! Pin
Chris C-B19-Sep-20 20:48
MemberChris C-B19-Sep-20 20:48 
Earlier in the week I posted a request for DB software for cataloging a largish classical CD collection, and received several useful replies. In the end I decided to roll my own in Access, and built the structure and relationships, and even got as far as loading 40 principal instruments, 100 genres and 900 composers. The base item of the DB was the 'work', a CD comprising of one or more works, and some works appearing on more than one CD. Great stuff - I was pleased with the flexibility of the design for what I wanted.

Then I stopped to think. I estimated about 10,000 separate works in the collection. Even with everything for the 'work' being in drop-downs, just typing in the work title was going to be a very long pain in the asterisk, even before entering all the CD titles.

Time for a rethink, and copious hot caffeinated liquids!

I am an enthusiastic amateur photographer, with a good and fast Epson scanner, and Adobe Lightroom.

Solution - scan the front and back of all the CD 'jewel boxes' - my scanning software lets me join two JPEGS - and keyword the hell out of them. I can then browse through the covers and works by using simple keywording for composer, genre, sub-genre, key instrument und so weiter. By having the scan of the CD cover I will be able to recognize the album straight away. The filename will be the location of the CD - drawer number, rank, and position in rank. My plan for using Lightroom fell apart as I have only a single licence, and the hi-fi laptop is not my main machine. A quick web search located an open-source project, 'digiKam', which is perfect because it supports hierarchical keywording.

Yesterday I went out and bought a cheapo knock-up desk (or 'study table', as it grandly calls itself) and am about to put the thing together in the drawing room, and then stick the hi-fi laptop and scanner on it. In a trial run on my rather cluttered upstairs desk it took less than 15 seconds each to scan a batch of CDs front and back. Then it is just half a dozen clicks to register the keywords.

The beauty of this system is that I can pretend to be doing useful work while actually sitting down and listening to my favourite music! Cool | :cool:

modified 20-Sep-20 8:13am.

GeneralFilter Time column greater than zero in typescript Pin
kasimmohamed19-Sep-20 20:10
Memberkasimmohamed19-Sep-20 20:10 
GeneralRe: Filter Time column greater than zero in typescript Pin
Chris C-B19-Sep-20 20:53
MemberChris C-B19-Sep-20 20:53 
GeneralRe: Filter Time column greater than zero in typescript Pin
OriginalGriff19-Sep-20 21:16
mveOriginalGriff19-Sep-20 21:16 
GeneralRe: Filter Time column greater than zero in typescript Pin
GuyThiebaut19-Sep-20 22:12
professionalGuyThiebaut19-Sep-20 22:12 
GeneralRe: Filter Time column greater than zero in typescript Pin
Pete O'Hanlon20-Sep-20 7:14
mvaPete O'Hanlon20-Sep-20 7:14 
GeneralRe: Filter Time column greater than zero in typescript Pin
GuyThiebaut20-Sep-20 7:41
professionalGuyThiebaut20-Sep-20 7:41 
JokeInto a bar Pin
Greg Utas19-Sep-20 7:08
mveGreg Utas19-Sep-20 7:08 
JokeWord Crimes! Pin
Randor 19-Sep-20 11:45
professional Randor 19-Sep-20 11:45 
JokeBMW! PinPopular
Sandeep Mewara19-Sep-20 6:02
mveSandeep Mewara19-Sep-20 6:02 
GeneralAnd I have nowhere to keep it ... :sigh: Pin
OriginalGriff19-Sep-20 4:12
mveOriginalGriff19-Sep-20 4:12 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
honey the codewitch19-Sep-20 4:17
mvahoney the codewitch19-Sep-20 4:17 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
OriginalGriff19-Sep-20 4:32
mveOriginalGriff19-Sep-20 4:32 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
Mike Hankey19-Sep-20 4:35
professionalMike Hankey19-Sep-20 4:35 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
Amarnath S19-Sep-20 5:53
professionalAmarnath S19-Sep-20 5:53 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
PIEBALDconsult19-Sep-20 5:58
professionalPIEBALDconsult19-Sep-20 5:58 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
Nelek19-Sep-20 8:09
protectorNelek19-Sep-20 8:09 
GeneralRe: And I have nowhere to keep it ... :sigh: Pin
Sander Rossel20-Sep-20 1:29
professionalSander Rossel20-Sep-20 1:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

What topics would you like to learn more about?
Contributed by Marc Clifton.
  Results   139 votes