Monday, 29 January, 2007
Normally, I keep track of my audio CDs on a spreadsheet. This weekend, I decided to transfer all that information over to the Tellico Collection Manager. Tellico can handle all kinds of collections. I already use it to keep track of my Videos.
I started adding items from the spreadsheet, one at a time, by hand. I did about 60 of them and decided it would take me forever to finish, since I have 1,456 CDs. So I tried another tactic. Tellico has an import capability, and one of the formats it can read is CSV (comma separated values). I decided that would be perfect, as most spreadsheet programs can export to something like that.
Unfortunately, the OpenOffice.org spreadsheet program can’t export to CSV. It can export to DIF, though, so that’s what I did. I then moved the DIF file over to a Windows system so I could use the macro capabilities of a text editor I wrote to change the DIF format into CSV. That was very straightforward, and I ended up with a CSV, which I then imported into Tellico.
All this activity took me a bit less than an hour. I now have all my CDs in Tellico, but I’m not finished. I couldn’t bring over my album ratings, so I have to go into each Tellico item and add the rating. Now THAT will take a while. At the end of this all, I will have an easily-maintainable record of what CDs I already have.
Silly sign of the day:

Free/Open Source Software
- A Vista vs. Linux matchup — Part 1: Leveling the Playing Field
- A Vista vs. Linux matchup — Part 2: Dual-booting Vista and Linux
- Firms to Develop Linux Distro for High-End PCs
- Passive entertainment with Democracy TV
- Install Linux… from Windows?
- Open source Campcaster empowers independent radio broadcasters
RIAA/MPAA/ESRB/IFPI/BSA/FCC
- Poll: Americans think downloading no big deal
- Hollywood blames Canada for half of movie piracy
- FCC not playing fair
- Take a Stand Against the Madness; Stop the RIAA!
- How to Find Fake Torrents Uploaded by the MPAA and RIAA
- RIAA names and shames USC - I think the worst group of pirates in the country is the RIAA…
Stupid Patent Tricks, DRM and Other IP Nonsense
- Qualcomm’s patent case goes to jury
- Microsoft Copies Idea, Admits It, Then Patents It
- E-Learning Software Patent Under Scrutiny
- DRM, Vista and your rights
- AACS Attack: a Clear and Present Danger to DRM
Other News
- Did Microsoft want to ‘whack’ Dell over its Linux dealings?
- European committee chair accuses Microsoft of hijacking the web
- Let them have their pot
- MSNBC Poll: 87% of Americans would like to see Bush impeached
- DAVOS: Microsoft To Set Up Online Payment System
- PayPal and PriceGrabber Pitfalls
- Vista “upgrade” drops compliance checking, requires old OS to install
- Retiree, 77, from Sarasota fights $31,000 cell phone bill
Security/Our Rights
- Terrorists in Texarkana?
- Kaspersky takes Vista security apart
- TomTom admits Satnav device is infected with virus
- SEC Files Suit Against Suspected Pump-and-Dump Schemer
- Hillary: The Privacy Candidate?
- Why identity thieves love the government
Big Brother
No Comments
No comments yet.
RSS feed for comments on this post. TrackBack URI
Sorry, the comment form is closed at this time.