I found a way to speed up your song editing....This is a bit technical, but you should have no fear of trying it.<br>
Backup your data! The manual can help you backup your data. Make sure you backup your data!
Open OpenLP
Select Settings->Configure Formatting Tags
Find the Tag you created to format text for Right to Left
Write down the TAG.
Close OpenLP
Open the songs directory in your data directory.
Copy the path to your songs directory.
Open 'https://sqliteonline.com/' This is an online SQLITE browser that can read, modify and save your songs database.
Once the website is up, select File then select Open DB.
Paste the path to your songs directory into the 'open' window, refresh the path and select the songs.sqlite file.
The website will update....in the left column labeled 'table' double left click on the table named 'songs'
The website will update....in the top of the right column will be code that should say 'SELECT * FROM 'songs';'
Below the code is the list of the songs in the database....you could scroll through the list to find the songs you need....OR you can paste this next line over the code above the list.<br><br>select id, title from songs where title like '%all%';<br><br>This line will allow you to search for a title with a partial title.
Replace the text 'all' near the end of the line with the title you need to find.
Select Run.
The website will update again and you will see a list of songs that contain your results.
Find the song you were searching for and write down the id number. You can repeat the steps starting when you replaced the text with your title for each song you need to update. Just remember to write down the id numbers.
Once you have all the id numbers you are going to update, copy the following two lines and paste them over the code above the title search results.<br><br>update songs set lyrics = replace(lyrics, '<![CDATA[', '<![CDATA[{TAG}') where id = 1;<br>update songs set lyrics = replace(lyrics, ']]>', '{/TAG}]]>') where id = 1;<br><br>
Select the word TAG in the first line and replace it with the Tag for the right to left formatting tag
Select the word TAG in the second line and replace it with the Tag for the right to left formatting tag
Replace the number 1 on the end of each line with the id number for the song you need to edit.
Double check your work! If you have replaced the word TAG and the number 1 on both lines, select Run
Change the number at the end of each line to the next id number you want to update and select Run
Repeat the step above to update each id number.
When you have updated the songs you needed to update, select File->Save db and select the same song.sqlite file you opened.
Open OpenLP and view the songs you updated. They should all have the verses updated with your right to left formatting Tag.
Close the web browser.
If something is wrong, close OpenLP and copy the backup file over the file you modified and you are back where you started....
