Karaoke Forums

I'm sure this may have been asked before but I can't seem to find anything

But can anyone help me -

My song books are seriously out of date and I want to somehow "import" the song info (Disc no-track-no - Title - Artist) from my karaoke database file INTO a file that I can then sort and print out.

I'm using sax and dotties and the database file is the usual Zipped mp3 and cdg files.

For my songbooks I've used in the past Lotus 123 (not sure if this will now work in Vista) and I've also got the OpenOffice.org speadsheet thing free from Java.

I've not got Microsoft Office (too expensive).

If no-one can help I've got a hell of a lot of typing to do !

Thanks in advance

_________________
[font=Fantasy][/font] "Travellin' at the speed of light"

I think you mean "export" a list from your song database.

Browse to the Sax & Dotty Hoster folder (C:\Program Files\Sax And Dotty's Show Hoster), you will see a file called "Song List" right click ond open this file using Excel (or openoffice Calc). When Excel opens, select "Karaoke Tracks" this will give you a complete listing of your current Sax & Dotty data base songs by Title/Artist/Disc/Location). Save the file to your desktop and then edit to suit your Song Book requirements.

Thanks for your reply Michaelangelo.

I tried what you said but all I got in the OpenOffice calc screen was gibberish.

It seemed to import/export the whole file but just a load of :-

################################################
################################### etc etc

Any suggestions ?

_________________
[font=Fantasy][/font] "Travellin' at the speed of light"

_________________
Join The Karaokle Singers Social Network. Upload Your Music!!

I believe sax & dotty's has an "export" function. It exports it to a .CSV file, which can be opened by a spreadsheet program like OO Calc.

Oh YES !!!!!

Now I'm getting somewhere but I'm gonna have to play about with it for a bit I think

That EXPORT facility in Sax and Dotties seems to work.

Thanks once again guys - as always you came up trumps

_________________
[font=Fantasy][/font] "Travellin' at the speed of light"

Correction to that - IT DOES WORK

It's exactly what I wanted.

Feel a bit stupid now - it was right under my nose.

_________________
[font=Fantasy][/font] "Travellin' at the speed of light"