print list of songs in database

[MaFt]

i learnt this last night... here's a fairly straight forward way to get a file which lists all the songs in the database so you can print it or do whatever you want with it. could be useful to email to visiting preachers etc?

anyhoo, here goes:

open 'command prompt' (i'm assuming you have win xp!) 'start/programs/accessories/command prompt' or more simply 'start/run/ command'

once open, use dos commands to find your song directory eg: 'c:\documents and setting\zionworx\songs' or wherever your songs are.

then type:

Code: Select all

dir *.* >> allsongs.txt

this will make a file called allsongs.txt with the directory listing in it. it can then be opened into excel and you can specifiy which parts of the file you want to import (i.e. you can select just the area with file names and ignore the file size/date etc). then run a find and replace to get rid of the '.sng' extensions and there's your list of songs

hope that's useful for someone.

maybe in version 3.0 there will be an 'export list of songs' feature?

MaFt

ps - i don't do capitalisation!!

[Peter_in_Christ]

Thanks MaFT,

I think I may have another use for that, but do check out this:
http://zionworx.org.uk/forum/viewtopic.php?p=1337#1337

I've created a program to do the job

Peter

[MaFt]

cheers for that that'll be quicker!!

like you said though, the ">> file.txt" is a useful tool.

cheers again

MaFt