You can try to print the TOC (from the File menu) to a PDF or XPS printer and then try to select, copy and paste the text from the created document to excel.
Also, Songs are saved as individual files by the name of the song, without a file extension. So, you can create a list of songs from a shell or some other program which can create lists of files.
for example you can use dir /b
from OpenSong\Songs as your working dir
or, if you have subfolders and want to strip these for /R . %S IN (*) DO @ECHO %~nS
If you need the contents of the Title text box of a song, rather than it's name as it appears in the list of songs, you can extract that using some xml tool (song files are xml files). I have used xmllint from the libxml2 package and xml starlet in the past to extract ccli reporting data from set and song files in the past (and to prepare the songs for use in OpenSongApp and Worshipper on Android). You need to be somewhat comfortable using command line tools from some shell.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2024-12-13
Thanks very much for this. I will certainly try it. Any chance of adding an export in the future?
Regards
Hein Zentgraf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is no excel export in OpenSong.
You can try to print the TOC (from the File menu) to a PDF or XPS printer and then try to select, copy and paste the text from the created document to excel.
Also, Songs are saved as individual files by the name of the song, without a file extension. So, you can create a list of songs from a shell or some other program which can create lists of files.
for example you can use
dir /bfrom OpenSong\Songs as your working dir
or, if you have subfolders and want to strip these
for /R . %S IN (*) DO @ECHO %~nSIf you need the contents of the Title text box of a song, rather than it's name as it appears in the list of songs, you can extract that using some xml tool (song files are xml files). I have used xmllint from the libxml2 package and xml starlet in the past to extract ccli reporting data from set and song files in the past (and to prepare the songs for use in OpenSongApp and Worshipper on Android). You need to be somewhat comfortable using command line tools from some shell.
Thanks very much for this. I will certainly try it. Any chance of adding an export in the future?
Regards
Hein Zentgraf