print index possible??

StTK · April 9

We have a lot of songs in our Song tab and even more Custom slides in the custom tab (liturgy etc). I've been doing some tidying and culling, removing duplicates and old stuff, and wondered whether there was any quick way of printing a list as we see it in the tabs. I know I could add everything to a service or series of services and print them (unexpanded as I just want the titles) but I wondered whether there was another neater, less time consuming way; I've culled it from about 650 custom slides to around 550 but more will be added.. Not a major request for a feature but just asking whether there's a simple way for housekeeping purposes.

My big wish for a new feature is folders for the Custom tab!

PaulRowell · April 10

The database used by OpenLP is sqlite, if you are comfortable with SQL then that might be a way forward?

StTK · April 11

I did wonder whether there was a way to open the sqlte files. I've not got any experience with SQL at all. I used to do very basic website stuff so get how the formatting tags are done, but that's my limit!

Is there a simple way of getting into SQL to simply open a file and extract the contents? Do I need to download SQL as a program?

Thanks

jednou · April 11

https://sqliteviewer.app/

PaulRowell · April 11

I use a program called DB Browser for SQLite.

The structure of the custom slides database is very simple, with only one table. The columns are id, title, text, credits, theme_name.

Select title from custom_slide

Would give you a list of titles.

StTK · April 12

Brilliant, thanks @PaulRowell! Can see what I want to see. Bonus that I can check the theme_name as well

Thanks @jednou as well, but unfortunately the sqliteviewer.app wouldn't open the custom.sqlte file as it said it had system files in it. But this information may work for someone else

print index possible??

Comments