How to Include the Scriptures with the Song Titles

The following information is applicable to the Sing Out Joyfully to Jehovah publication.

By following the steps below you will be able to include the scriptures on your Workbook or Worksheet.

Step 1

Create a XML data file that includes all of the scripture citations. The following is correct for English:

<?xml version="1.0" encoding="utf-8"?>
<ScripturesForSongs>
  <Song Number="1">(Revelation 4:11)</Song>
  <Song Number="2">(Psalm 83:18)</Song>
  <Song Number="3">(Proverbs 14:26)</Song>
  <Song Number="4">(Psalm 23)</Song>
  <Song Number="5">(Psalm 139)</Song>
  <Song Number="6">(Psalm 19)</Song>
  <Song Number="7">(Isaiah 12:2)</Song>
  <Song Number="8">(Psalm 91)</Song>
  <Song Number="9">(Psalm 97:1)</Song>
  <Song Number="10">(Psalm 145:12)</Song>
  <Song Number="11">(Psalm 19)</Song>
  <Song Number="12">(Exodus 34:6, 7)</Song>
  <Song Number="13">(1 Peter 2:21)</Song>
  <Song Number="14">(Psalm 2:12)</Song>
  <Song Number="15">(Hebrews 1:6)</Song>
  <Song Number="16">(Revelation 21:2)</Song>
  <Song Number="17">(Luke 5:13)</Song>
  <Song Number="18">(Luke 22:20)</Song>
  <Song Number="19">(Matthew 26:26-30)</Song>
  <Song Number="20">(1 John 4:9)</Song>
  <Song Number="21">(Matthew 6:33)</Song>
  <Song Number="22">(Revelation 11:15; 12:10)</Song>
  <Song Number="23">(Revelation 11:15)</Song>
  <Song Number="24">(Isaiah 2:2-4)</Song>
  <Song Number="25">(1 Peter 2:9)</Song>
  <Song Number="26">(Matthew 25:34-40)</Song>
  <Song Number="27">(Romans 8:19)</Song>
  <Song Number="28">(Psalm 15)</Song>
  <Song Number="29">(Isaiah 43:10-12)</Song>
  <Song Number="30">(Hebrews 6:10)</Song>
  <Song Number="31">(Micah 6:8)</Song>
  <Song Number="32">(Exodus 32:26)</Song>
  <Song Number="33">(Psalm 55)</Song>
  <Song Number="34">(Psalm 26)</Song>
  <Song Number="35">(Philippians 1:10)</Song>
  <Song Number="36">(Proverbs 4:23)</Song>
  <Song Number="37">(Matthew 22:37)</Song>
  <Song Number="38">(1 Peter 5:10)</Song>
  <Song Number="39">(Ecclesiastes 7:1)</Song>
  <Song Number="40">(Romans 14:8)</Song>
  <Song Number="41">(Psalm 54)</Song>
  <Song Number="42">(Ephesians 6:18)</Song>
  <Song Number="43">(Psalm 95:2)</Song>
  <Song Number="44">(Psalm 4:1)</Song>
  <Song Number="45">(Psalm 19:14)</Song>
  <Song Number="46">(1 Thessalonians 5:18)</Song>
  <Song Number="47">(1 Thessalonians 5:17)</Song>
  <Song Number="48">(Micah 6:8)</Song>
  <Song Number="49">(Proverbs 27:11)</Song>
  <Song Number="50">(Matthew 22:37)</Song>
  <Song Number="51">(Matthew 16:24)</Song>
  <Song Number="52">(Hebrews 10:7, 9)</Song>
  <Song Number="53">(Jeremiah 1:17)</Song>
  <Song Number="54">(Isaiah 30:20, 21)</Song>
  <Song Number="55">(Matthew 10:28)</Song>
  <Song Number="56">(Proverbs 3:1, 2)</Song>
  <Song Number="57">(1 Timothy 2:4)</Song>
  <Song Number="58">(Luke 10:6)</Song>
  <Song Number="59">(Psalm 146:2)</Song>
  <Song Number="60">(Ezekiel 3:17-19)</Song>
  <Song Number="61">(Luke 16:16)</Song>
  <Song Number="62">(Psalm 98)</Song>
  <Song Number="63">(Isaiah 43:10-12)</Song>
  <Song Number="64">(Matthew 13:1-23)</Song>
  <Song Number="65">(Hebrews 6:1)</Song>
  <Song Number="66">(Revelation 14:6, 7)</Song>
  <Song Number="67">(2 Timothy 4:2)</Song>
  <Song Number="68">(Matthew 13:4-8)</Song>
  <Song Number="69">(2 Timothy 4:5)</Song>
  <Song Number="70">(Matthew 10:11-15)</Song>
  <Song Number="71">(Joel 2:7)</Song>
  <Song Number="72">(Acts 20:20, 21)</Song>
  <Song Number="73">(Acts 4:29)</Song>
  <Song Number="74">(Psalm 98:1)</Song>
  <Song Number="75">(Isaiah 6:8)</Song>
  <Song Number="76">(Hebrews 13:15)</Song>
  <Song Number="77">(2 Corinthians 4:6)</Song>
  <Song Number="78">(Acts 18:11)</Song>
  <Song Number="79">(Matthew 28:19, 20)</Song>
  <Song Number="80">(Psalm 34:8)</Song>
  <Song Number="81">(Ecclesiastes 11:6)</Song>
  <Song Number="82">(Matthew 5:16)</Song>
  <Song Number="83">(Acts 20:20)</Song>
  <Song Number="84">(Matthew 9:37, 38)</Song>
  <Song Number="85">(Romans 15:7)</Song>
  <Song Number="86">(Isaiah 50:4; 54:13)</Song>
  <Song Number="87">(Hebrews 10:24, 25)</Song>
  <Song Number="88">(Psalm 25:4)</Song>
  <Song Number="89">(Luke 11:28)</Song>
  <Song Number="90">(Hebrews 10:24, 25)</Song>
  <Song Number="91">(Psalm 127:1)</Song>
  <Song Number="92">(1 Chronicles 29:16)</Song>
  <Song Number="93">(Hebrews 10:24, 25)</Song>
  <Song Number="94">(Philippians 2:16)</Song>
  <Song Number="95">(Proverbs 4:18)</Song>
  <Song Number="96">(Proverbs 2:1)</Song>
  <Song Number="97">(Matthew 4:4)</Song>
  <Song Number="98">(2 Timothy 3:16, 17)</Song>
  <Song Number="99">(Revelation 7:9, 10)</Song>
  <Song Number="100">(Acts 17:7)</Song>
  <Song Number="101">(Ephesians 4:3)</Song>
  <Song Number="102">(Acts 20:35)</Song>
  <Song Number="103">(Ephesians 4:8)</Song>
  <Song Number="104">(Luke 11:13)</Song>
  <Song Number="105">(1 John 4:7, 8)</Song>
  <Song Number="106">(1 Corinthians 13:1-8)</Song>
  <Song Number="107">(1 John 4:19)</Song>
  <Song Number="108">(Isaiah 55:1-3)</Song>
  <Song Number="109">(1 Peter 1:22)</Song>
  <Song Number="110">(Nehemiah 8:10)</Song>
  <Song Number="111">(Matthew 5:12)</Song>
  <Song Number="112">(Philippians 4:9)</Song>
  <Song Number="113">(John 14:27)</Song>
  <Song Number="114">(James 5:8)</Song>
  <Song Number="115">(2 Peter 3:15)</Song>
  <Song Number="116">(Ephesians 4:32)</Song>
  <Song Number="117">(2 Chronicles 6:41)</Song>
  <Song Number="118">(Luke 17:5)</Song>
  <Song Number="119">(Hebrews 10:38, 39)</Song>
  <Song Number="120">(Matthew 11:28-30)</Song>
  <Song Number="121">(Romans 7:14-25)</Song>
  <Song Number="122">(1 Corinthians 15:58)</Song>
  <Song Number="123">(1 Corinthians 14:33)</Song>
  <Song Number="124">(Psalm 18:25)</Song>
  <Song Number="125">(Matthew 5:7)</Song>
  <Song Number="126">(1 Corinthians 16:13)</Song>
  <Song Number="127">(2 Peter 3:11)</Song>
  <Song Number="128">(Matthew 24:13)</Song>
  <Song Number="129">(Matthew 24:13)</Song>
  <Song Number="130">(Psalm 86:5)</Song>
  <Song Number="131">(Matthew 19:5, 6)</Song>
  <Song Number="132">(Genesis 2:23, 24)</Song>
  <Song Number="133">(Ecclesiastes 12:1)</Song>
  <Song Number="134">(Psalm 127:3-5)</Song>
  <Song Number="135">(Proverbs 27:11)</Song>
  <Song Number="136">(Ruth 2:12)</Song>
  <Song Number="137">(Romans 16:2)</Song>
  <Song Number="138">(Proverbs 16:31)</Song>
  <Song Number="139">(Revelation 21:1-5)</Song>
  <Song Number="140">(John 3:16)</Song>
  <Song Number="141">(Psalm 36:9)</Song>
  <Song Number="142">(Hebrews 6:18, 19)</Song>
  <Song Number="143">(Romans 8:20-25)</Song>
  <Song Number="144">(2 Corinthians 4:18)</Song>
  <Song Number="145">(Luke 23:43)</Song>
  <Song Number="146">(Revelation 21:1-5)</Song>
  <Song Number="147">(Psalm 37:29)</Song>
  <Song Number="148">(2 Samuel 22:1-8)</Song>
  <Song Number="149">(Exodus 15:1)</Song>
  <Song Number="150">(Zephaniah 2:3)</Song>
  <Song Number="151">(Job 14:13-15)</Song>
</ScripturesForSongs>

Step 2

Next, you need to modify a copy of the XSL stylesheet you are using. It depends upon how your XSL file is constructed. For example:

<!--Open / Close song-->
<xsl:template match="SongOpen|SongEnd">
<td class="textItemWithPadding">
 <xsl:value-of select="//Labels/Song"/>
 <xsl:text> </xsl:text>
 <xsl:value-of select="."/>
 <xsl:text> - </xsl:text>
 <xsl:value-of select="@Title"/>
 <xsl:variable name="ScripturesForSongs" select="document('ScripturesForSongs.xml')"/>
 <xsl:variable name="SongNumber" select="."/>
 &#160;
 <xsl:value-of select="$ScripturesForSongs/ScripturesForSongs/Song[@Number=$SongNumber]"/>
</td>
</xsl:template>

<!--Middle song-->
<xsl:template match="SongMiddle">
<tr>
 <td class="textItemWithPadding">
 <xsl:value-of select="//Labels/Song"/>
 <xsl:text> </xsl:text>
 <xsl:value-of select="."/>
 <xsl:text> - </xsl:text>
 <xsl:value-of select="@Title"/>
 <xsl:variable name="ScripturesForSongs" select="document('ScripturesForSongs.xml')"/>
 <xsl:variable name="SongNumber" select="."/>
 &#160;
 <xsl:value-of select="$ScripturesForSongs/ScripturesForSongs/Song[@Number=$SongNumber]"/>
 </td>
 <td class="textTime">
 <xsl:value-of select="@EndTime12"/>
 </td>
</tr>
</xsl:template>

The above conveys the principles but you will have to adapt it to match the way your XSL style sheet is working.