Script to import songs from one EW 6 database into another

Find out how to do things you didn't know you could do.
PLEASE LOGIN TO READ AND REPLY TO POSTS

Please log in to reply to this post

kristnastova@kristnastova.dk
Posts: 2
Joined: Tue Sep 06, 2016 1:22 pm

Script to import songs from one EW 6 database into another

Postby kristnastova@kristnastova.dk » Tue Sep 06, 2016 1:37 pm

Hi community,

I have created a script that can import all songs from one EW 6 database into another. It can be found on https://github.com/johnsivertsen/easyworship-utils

I am not affiliated with Easyworship and no Easyworship employee has verified the validity of the script. But I have of course use it in my own church with success.

Use at own risk and take backup before running the script :)

jagman@blueyonder.co.uk
Posts: 2
Joined: Fri Sep 09, 2016 9:11 am

Re: Script to import songs from one EW 6 database into another

Postby jagman@blueyonder.co.uk » Fri Sep 09, 2016 9:24 am

Hi John,
Your script looks like it should do just what I need. Unfortunately, it doesn't appear compatible with the version of SQLite that is currently available (3.14.1) as it flags a 'no such collation sequence UTF8_U_CI' on several lines in merge.sql.
The custom collation sequence was built into the original database and the later versions of SQLite3 are not set to ignore non-standard collation sequences. As I'm not an expert on these things, I can't resolve it, nor can I find an old version of the SQLite tools to run your script. Are you able to help, here?
Thanks,
Ian

mrvoltz
Posts: 7
Joined: Tue Apr 28, 2015 6:14 pm

Re: Script to import songs from one EW 6 database into another

Postby mrvoltz » Fri Sep 30, 2016 8:40 am

EW had a script available a while back, works great, it can take a few minutes though because it copies your entire profile.
I have a copy of it here https://drive.google.com/file/d/0B7zcfY ... sp=sharing
The readme.txt file have the instructions in it.
Tech Director
North Central Baptist Church
Gainesville Florida

jagman@blueyonder.co.uk
Posts: 2
Joined: Fri Sep 09, 2016 9:11 am

Re: Script to import songs from one EW 6 database into another

Postby jagman@blueyonder.co.uk » Fri Sep 30, 2016 5:03 pm

mrvoltz wrote:EW had a script available a while back, works great, it can take a few minutes though because it copies your entire profile.
I have a copy of it here https://drive.google.com/file/d/0B7zcfY ... sp=sharing
The readme.txt file have the instructions in it.


Thanks mrvoltz, but your reply addresses the task of backing-up and restoring the folders containing the user profile using a DOS batch file. This thread is dealing with concatenating one song database with another and involves manipulating the SQLite databases containing the songs, i.e. songs.db, songKeys.db, songWords.db and songHistory.db. This is done using SQL statements in a script to manipulate the databases to add the songs from one profile to the songs in another profile.

mrvoltz
Posts: 7
Joined: Tue Apr 28, 2015 6:14 pm

Re: Script to import songs from one EW 6 database into another

Postby mrvoltz » Sun Oct 09, 2016 5:25 pm

Sorry, I re read the original post, I did not realize you were merging two databases.
I thought the goal was just to move the db from one computer to the other, which is what those batch files do.
Tech Director
North Central Baptist Church
Gainesville Florida


Please log in to reply to this post

Return to “Tips & Tricks”