Update Hymnals works together with these other components:

• Study Hymnal
• Hymnals Data
• All Hymnals

Update hymnals is the service that ensures changes made to the All Hymnals Sheets having the hymnals data is updated to the Hymnals Data repo where it is picked by the Study Hymnal.

• Installation
  • Requirements
  • Installing Prerequisites
  • Installing UpdateHymnals
• Usage
• Features
• Todo

• nodejs v>=6
• yarn /npm

• Install yarn

We will presume that you have git installed. If not then grab it!

cd /var/www/html/updatehymnals/
git clone https://github.com/GospelSounders/updatehymnals.git
cd updatehymnals/
yarn install
cd install
cp -r lib/ /
cd ../hymnals-data
git clone https://github.com/GospelSounders/hymnals-data.git .

Change also localhost to the url of your server in the google scripts. The default port(defined in .env.example) is 3002

cd /var/www/html/updatehymnals/resources

./changeurl.sh  http://localhost:3002 your-url:your_port

Then use the import All Hymnals.xlsx from resources to google sheets and create a script with the contents from script.gs

Enable the service after installation

systemctl daemon-reload
systemctl enable updatehymnals.service
systemctl start updatehymnals.service

• Goto All Hymnals.xlsx
• Open the tab of the hymnal to update
• Click on Update hymnals menu and wait until a msgbox appears
• Copy link from message box and paste into bin/resources/csvuploads/{HYMNALNAME}.enc
• remove the part of the url that is equal to https://www.gospelsounders.org/updatehymnals/hymnals/SDAH/
• sync with server by running (from /path/to/updatehymnals/)

rsync -a bin/csvuploads/ [email protected]:/var/www/html/updatehymnals/bin/csvuploads/

• Open your browser to https://www.gospelsounders.org/updatehymnals/hymnalsv1/{hymnalname}
• Go back to sheets and open AllHymnalsSheet and increment fixed for that hymnal and change updated to 1
• Go to github and merge changes to master

Then just peek in to see if things work fine

journalctl -f -u updatehymnals

• Automatic updates

• Create forms
• Update from sheets hourly