Karaoke Scene's Karaoke Forums
https://mail.karaokescenemagazine.net/forums/

Import song list from Song Database ? - HELP
https://mail.karaokescenemagazine.net/forums/viewtopic.php?f=1&t=16271		 Page 1 of 1
Author:  mr.fahrenheit [ Fri Mar 27, 2009 4:42 am ]
Post subject:  Import song list from Song Database ? - HELP
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
Author:  Michaelangelo1 [ Fri Mar 27, 2009 6:53 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
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.
Author:  mr.fahrenheit [ Fri Mar 27, 2009 7:25 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
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 ?
Author:  karyoker [ Fri Mar 27, 2009 7:34 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
link
Author:  Michaelangelo1 [ Fri Mar 27, 2009 7:49 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
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.
Author:  mr.fahrenheit [ Fri Mar 27, 2009 8:17 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
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
Author:  mr.fahrenheit [ Fri Mar 27, 2009 8:37 am ]
Post subject:  Re: Import song list from Song Database ? - HELP
Quote:
That EXPORT facility in Sax and Dotties seems to work.


Correction to that - IT DOES WORK

It's exactly what I wanted.

Feel a bit stupid now - it was right under my nose.
Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/