Contents

Member Sign in

admin

Exporting Data from Sermons Online

DataManagement.Export History

Show minor edits - Show changes to output

August 27, 2016, at 12:34 PM EST by Dave Marney - Update to add information about the Sermon Archiver
Changed lines 3-4 from:

All of the information about
your sermons can be exported so they can be re-used by other other applications and services. Exporting is done via a web interface.  The syntax is:
to:
There are two ways your sermon information can be exported from Sermons Online.

The easiest and most complete method is to use the [[DataManagement.Backup|Sermons Archiver]] command-line utility to create a complete archival backup copy. This method exports both metadata (information about your sermons such as title, author, etc.) and all the associated multimedia and attachment files. The Sermons Archiver is a separately installed and launched application.

The second method, described below, only exports metadata, and uses a web interface. You could use this, for example, to integrate your sermons with other applications and services.
The syntax is:
Added line 2:
August 14, 2011, at 03:58 PM EST by DaveM - Update to output formats
Changed line 12 from:
* &'''format'''='''''csv'''''|'''''html'''''|'''''xml''''' - the format of the exported data; one of 'CSV' (default), 'HTML', or 'XML'
to:
* &'''format'''='''''csv'''''|'''''html'''''|'''''xml'''''|'''''json''''' - the format of the exported data; one of 'csv' (default), 'html', 'xml', or 'json'
Changed lines 30-33 from:
!!Output Formats

!!!
XML
to:
!!Notes on XML Output
Changed lines 181-193 from:
-></customers>
to:
-></customers>

!!JSON Output

Sermons exported in JSON follow the same structure as XML, but serialized according to the rules of JSON formatting.

!!CSV Output

Sermons exported in CSV format are structured for editing with a spreadsheet application.  Each row in the output represents a sermon, and the columns, its metadata.

!!HTML Output

Sermons exported in HTML are formatted for viewing on the web.  Each sermon is displayed within a table, with a link to the sermon's multimedia and file attachments.
August 14, 2011, at 02:38 PM EST by DaveM - Update to output formats
Changed lines 78-79 from:
!!!!Optional Sermon Sub-Elements
to:
!!!Optional Sermon Sub-Elements
Changed lines 82-83 from:
!!!Hymns
to:
!!!''Hymns''
Changed lines 97-98 from:
!!!Scripture References
to:
!!!''Scripture References''
Changed lines 113-114 from:
!!!Sermon Multimedia
to:
!!!''Sermon Multimedia''
Changed lines 132-133 from:
!!!File Attachment
to:
!!!''File Attachment''
Added lines 146-183:
!!!XML Example

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<?xml version="1.0"?>
-><customers>
--><customer>
---><custid>nhpca</custid>
---><sermons>
----><sermon>
-----><date>2011-08-07</date>
-----><timeofday>Morning</timeofday>
-----><creator>David Coffin, Jr.</creator>
-----><title>Remember the Rebellion of the Angels</title>
-----><description>Jude 6</description>
-----><body></body>
-----><subject>Jude</subject>
-----><rights>Copyright 2011, David Coffin, Jr., New Hope Presbyterian Church. All rights reserved. Powered by SermonsOnline.com.</rights>
-----><hymns/>
-----><scriptures>
------><scripture>
-------><book>Jude</book>
-------><passage>6</passage>
------></scripture>
-----></scriptures>
-----><multimedia>
------><media>
-------><format>MP3</format>
-------><type>Audio</type>
-------><bandwidth>32K</bandwidth>
-------><filesize>10474626</filesize>
-------><enclosure>http://media.sermonsonline.com/nhpca_47117_32K.mp3</enclosure>
------></media>
-----></multimedia>
-----><attachments/>
----></sermon>
---></sermons>
--></customer>
-></customers>
August 14, 2011, at 02:24 PM EST by DaveM - Update to output formats
Changed lines 16-17 from:
Example:
to:
Examples:
Changed line 19 from:
../util_pub.php?'''action'''=export_sermons&'''custid'''=mychurch&'''format'''=xml&'''startdate'''=2010-10-16&'''disposition'''=stream
to:
../util_pub.php?'''action'''=export_sermons&'''custid'''=mychurch
Changed lines 22-27 from:
Will export all sermons preached since October 16, 2010 by "mychurch".  The output format will be XML which will be returned to the web browser as a stream of web data.

!!!XML Output Format

The character set of the XML
file is UTF=8.  The root element of the XML is named <customers>.  It contains at least one <customer> element.
to:
->Result: exports all sermons on record for "mychurch", as a .CSV file
Changed lines 25-32 from:
<customers>
-><customer>
-->
'''<custid>''' customer identifier '''</custid>'''
-></customer>
->:
->:
''for each customer passed in '''''custid''''' URL option''
->:
</customers>
to:
../util_pub.php?'''action'''=export_sermons&'''custid'''=mychurch&'''format'''=xml&'''startdate'''=2010-10-16&'''disposition'''=stream
Changed lines 28-29 from:
Within each <customer> is a list of <sermons>, each containing one <sermon> element for each sermon which was preached on or before the '''''startdate''''' URL option. The sermons are listed in reverse date order.
to:
->Result: exports all sermons preached since October 16, 2010 by "mychurch", as a stream of XML data.

!!Output Formats

!!!XML

The character set of
the XML file is UTF=8.  The root element of the XML is named <customers>.  It contains at least one <customer> element.
Added lines 37-51:
<customers>
-><customer>
-->%red%'''<custid>'''%% customer identifier %red%'''</custid>'''%%
-></customer>
->:
->: ''for each customer passed in '''''custid''''' URL option''
->:
</customers>

%red%''Required elements shown in red''
>><<

Within each <customer> is a list of <sermons>, each containing one <sermon> element for each sermon which was preached on or before the '''''startdate''''' URL option.  The sermons are listed in reverse date order.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
Changed lines 55-58 from:
--->'''<date>''' date sermon was preached '''</date>'''
--->'''<timeofday>''' time of day sermons was preached; one of "Morning", "Evening", or "Other" '''</timeofday>'''
--->'''<creator>''' name of the person who preached the sermon '''</creator>'''
--->'''<title>''' title of the sermon '''</title>'''
to:
--->%red%'''<date>'''%% date sermon was preached %red%'''</date>'''%%
--->%red%'''<timeofday>'''%% time sermon was preached; one of "Morning", "Evening", or "Other" %red%'''</timeofday>'''%%
--->%red%'''<creator>'''%% name of the person who preached the sermon %red%'''</creator>'''%%
--->%red%'''<title>'''%% title of the sermon %red%'''</title>'''%%
Changed lines 62-63 from:
--->'''<rights>''' copyright notice '''</rights>'''
to:
--->%red%'''<rights>'''%% copyright notice %red%'''</rights>'''%%
Added lines 74-75:

%red%''Required elements shown in red''
Changed lines 80-81 from:
A <sermon> element may optionally contain a <hymns> element that describes the hymns which were associated with the sermon.
to:
The following optional sub-elements may be enclosed with the <sermon> element.

!!!Hymns

Changed lines 97-98 from:
A <sermon> element may optionally contain a <scriptures> element which contains the Scripture references associated with the sermon.
to:
!!!Scripture References
Changed lines 113-114 from:
A <sermon> element may optionally contain a <multimedia> element which contains information about the multimedia associated with the sermon.  Up to four multimedia files may be associated to a sermon.
to:
!!!Sermon Multimedia
Changed lines 132-133 from:
A <sermon> element may optionally contain an <attachments> element which contains information about the file attachment associated with the sermon.  Only one file may be attached to a sermon.
to:
!!!File Attachment
Deleted line 44:
--->'''<sermonid>''' the identifier of the sermon record in SermonsOnline.com '''</sermonid>'''
Deleted line 88:
--->'''<scriptureid>''' identifier to the reference in SermonsOnline.com '''</scriptureid>'''
Deleted line 104:
--->'''<mediaid>''' identifier to the media metadata in SermonsOnline.com '''</mediaid>'''
Deleted line 123:
--->'''<attachid>''' identifier to the attachment metadata in SermonsOnline.com '''</mediaid>'''
Changed line 19 from:
../util_pub.php?'''action'''=export_sermons&'''custid'''=mychurch&'''format'''=xml&'''startdate'''=2010-10-16&disposition=stream@]
to:
../util_pub.php?'''action'''=export_sermons&'''custid'''=mychurch&'''format'''=xml&'''startdate'''=2010-10-16&'''disposition'''=stream
Changed line 19 from:
[@.../util_pub.php?action=export_sermons&custid=mychurch,mychurch-subaccount&format=xml&startdate=2010-10-16&disposition=stream@]
to:
[@../util_pub.php?action=export_sermons&custid=mychurch&format=xml&startdate=2010-10-16&disposition=stream@]
Changed line 19 from:
[@.../util_pub.php?action=export_sermons&custid=mychurch&format=xml&startdate=2010-10-16&disposition=stream@]
to:
[@.../util_pub.php?action=export_sermons&custid=mychurch,mychurch-subaccount&format=xml&startdate=2010-10-16&disposition=stream@]
Changed line 11 from:
* &'''custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported (required)
to:
* &'''custid'''=''id1'',''id2'',... - a comma-separated list of your customer ids (required)
Changed lines 3-4 from:
This feature exports information about your sermons in a format that can be used by other applications and services. Exporting is done via a web interface.  The syntax is:
to:
All of the information about your sermons can be exported so they can be re-used by other other applications and services. Exporting is done via a web interface.  The syntax is:
August 12, 2011, at 06:42 PM EST by DaveM - Added page on export options
August 12, 2011, at 06:41 PM EST by DaveM - Added page on export options
Changed line 112 from:
--->'''<enclosure>''' URL of the media file '''</enclosure>'''
to:
--->'''<enclosure>''' download URL of the media file '''</enclosure>'''
Changed lines 121-183 from:
$sql = 'SELECT
mediaid
format
type
bandwidth
enclosure





The Sermon Data XML Document contains the sermon data that is being added, and will be returned as the <param><value> of the RPC-formatted XML string. The format of the Se-rmon Data document is as follows (literal values are shown in Courier typeface).  A colon (:) after an element indicates that it is repeatable.

%block bgcolor=#f0f9ff border='1px solid gray' padding=5px%[@<sermon>
<data>
<custid>[=''Internal Sermon Site customer identification string''=]</custid >
<sermonid>Internal Sermon Site sermon identification number</sermonid>
<status>Active</status>
<title>The title of the sermon</title>
<description>Description of the sermon</description>
<creator>Name of the person who preached the sermon</creator>
<date>Date preached, in YYYY-MM-DD format</date>
<timeofday>Morning, Evening, or Other</timeofday>
<subject>Sermon series name or topc</subject>
<subjectorder>Part number of the sermon within the series</subjectorder>
<rights>The copyright message for the sermon</rights>
<body><![CDATA[ Sermon notes or outline, in HTML format ]]></body>
<multimedia>
<media>
<format>Windows Media, Real Media, or MP3</format>
<type>Audio or Video</type>
<bandwidth>16K or 32K</bandwidth>
<href type="streaming"><![CDATA[ URL of playlist file ]]> </href>
<href type="download"><![CDATA[ URL of multimedia file ]]> </href>
</media>
: (repeatable)
</multimedia>
<hymns>
<hymn>
<title>Title of hymn</title>
<href><![CDATA[ URL of hymn (optional) ]]></href>
</hymn>
:
</hymns>
<scriptures>
<scripture>
<sortorder>Sort key of first book, chapter, and verse in the citation</sortorder>
<book>Normalized name of the first book in the citation</book>
<passage>All citation text following the first book</passage>
<href><![CDATA[ URL to scripture citation on biblegateway.com ]]>
</href>
</scripture>
:
</scriptures>
<attachments>
<attachment>
<title>Title of attachment</title>
<href><![CDATA[ URL of attachment ]]></href>
</attachment>
:
</attachments>
</data>
</sermon>@]
to:
A <sermon> element may optionally contain an <attachments> element which contains information about the file attachment associated with the sermon.  Only one file may be attached to a sermon.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<sermon>
-><attachments>
--><attachment>
--->'''<attachid>''' identifier to the attachment metadata in SermonsOnline.com '''</mediaid>'''
--->'''<title>''' title of the attached file '''</format>'''
--->'''<filesize>''' size of the attached file, in bytes '''</filesize>'''
--->'''<enclosure>''' download URL of the attached file '''</enclosure>'''
--></attachment>
-></attachments>
</sermon>
>><<

August 12, 2011, at 06:38 PM EST by DaveM - Added page on export options
Changed lines 69-70 from:
A <sermon> element may optionally contain a <hymns> element which contains one or more <hymn> elements that associate a hymn with the sermon.
to:
A <sermon> element may optionally contain a <hymns> element that describes the hymns which were associated with the sermon.
Changed lines 84-85 from:
A <sermon> element may optionally contain a <scriptures> element which contains one or more <scripture> elements that associate a Scripture reference to the sermon.
to:
A <sermon> element may optionally contain a <scriptures> element which contains the Scripture references associated with the sermon.
Changed lines 101-103 from:


to:
A <sermon> element may optionally contain a <multimedia> element which contains information about the multimedia associated with the sermon.  Up to four multimedia files may be associated to a sermon.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<sermon>
-><multimedia>
--><media>
--->'''<mediaid>''' identifier to the media metadata in SermonsOnline.com '''</mediaid>'''
--->'''<format>''' format of the media, one of "Audio" or "Video" '''</format>'''
--->'''<type>''' encoding type of the media, one of "MP3", "Real Media", "Windows Media", or "Quicktime" '''</type>'''
--->'''<bandwidth>''' encoded bandwidth of media, expressed as KBytesPerSecond '''</bandwidth>'''
--->'''<filesize>''' size of the media file, in bytes '''</filesize>'''
--->'''<enclosure>''' URL of the media file '''</enclosure>'''
--></media>
-->:
-->: ''for each item of multimedia''
-->:
-></multimedia>
</sermon>
>><<

$sql = 'SELECT
mediaid
format
type
bandwidth
enclosure




August 12, 2011, at 06:27 PM EST by DaveM - Added page on export options
Added line 59:
Changed lines 67-68 from:

to:
!!!!Optional Sermon Sub-Elements

A <sermon> element may optionally contain a <hymns> element which contains one or more <hymn> elements that associate a hymn with the sermon.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<sermon>
-><hymns>
--><hymn>
--->'''<title>''' the title of the hymn '''</title>'''
--></hymn>
-->:
-->: ''for each associated hymn''
-->:
-></hymns>
</sermon>
>><<

A <sermon> element may optionally contain a <scriptures> element which contains one or more <scripture> elements that associate a Scripture reference to the sermon.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<sermon>
-><scriptures>
--><scripture>
--->'''<scriptureid>''' identifier to the reference in SermonsOnline.com '''</scriptureid>'''
--->'''<book>''' the Book name of the reference (e.g., "Genesis", etc.) '''</book>'''
--->'''<passage>''' the chapter and verse of the reference '''</passage>'''
--></scripture>
-->:
-->: ''for each Scripture reference''
-->:
-></scriptures>
</sermon>
>><<



August 12, 2011, at 06:16 PM EST by DaveM - Added page on export options
Changed lines 54-57 from:
--->'''<scriptures>''' ''see below'' '''</scriptures>'''
--->'''<hymns>''' ''see below'' '''</hymns>'''
--->'''<multimedia>''' ''see below'' '''</multimedia>'''
--->'''<attachments>''' ''see below'' '''</attachments>'
''
to:

--->'''<scriptures>''' ''see below...''
--->'''<hymns>''' ''see below...''
--->'''<multimedia>''' ''see below...''
--->'''<attachments>''' ''see below...''
August 12, 2011, at 06:14 PM EST by DaveM - Added page on export options
Added lines 54-57:
--->'''<scriptures>''' ''see below'' '''</scriptures>'''
--->'''<hymns>''' ''see below'' '''</hymns>'''
--->'''<multimedia>''' ''see below'' '''</multimedia>'''
--->'''<attachments>''' ''see below'' '''</attachments>'''
August 12, 2011, at 06:12 PM EST by DaveM - Added page on export options
Changed line 31 from:
--><custid>''customer identifier''</custid>
to:
-->'''<custid>''' customer identifier '''</custid>'''
Deleted lines 40-41:

Changed lines 45-54 from:
---><sermonid>''the identifier of the sermon record in SermonsOnline.com''</sermonid>
---><date>''date sermon was preached''</date>
---><timeofday>''time of day sermons was preached; one of "Morning", "Evening", or "Other"'',</timeofday>
---><creator>''name of the person who preached the sermon''</creator>
---><title>''title of the sermon''</title>
---><description>''description of the sermon''</description>
---><body>''notes associated with the sermon, in HTML format''</body>
---><subject>''sermon series/topic''</subject>
---><rights>''copyright notice''</rights>
--</sermon>
to:
--->'''<sermonid>''' the identifier of the sermon record in SermonsOnline.com '''</sermonid>'''
--->'''<date>''' date sermon was preached '''</date>'''
--->'''<timeofday>''' time of day sermons was preached; one of "Morning", "Evening", or "Other" '''</timeofday>'''
--->'''<creator>''' name of the person who preached the sermon '''</creator>'''
--->'''<title>''' title of the sermon '''</title>'''
--->'''<description>''' description of the sermon '''</description>'''
--->'''<body>''' notes associated with the sermon, in HTML format '''</body>'''
--->'''<subject>''' sermon series/topic '''</subject>'''
--->'''<rights>''' copyright notice '''</rights>'''
-->
</sermon>
August 12, 2011, at 06:07 PM EST by DaveM - Added page on export options
Changed lines 3-4 from:
This function exports a customer's sermon data.
to:
This feature exports information about your sermons in a format that can be used by other applications and services. Exporting is done via a web interface.  The syntax is:
Changed line 9 from:
Export options are URL name/value pairs:
to:
Where '''''export options''''' are the following URL name/value pairs:
Changed line 11 from:
* &'''custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported
to:
* &'''custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported (required)
Added lines 26-27:
The character set of the XML file is UTF=8.  The root element of the XML is named <customers>.  It contains at least one <customer> element.
Changed line 31 from:
--><custid/>
to:
--><custid>''customer identifier''</custid>
Added lines 33-35:
->:
->: ''for each customer passed in '''''custid''''' URL option''
->:
Added lines 39-64:
Within each <customer> is a list of <sermons>, each containing one <sermon> element for each sermon which was preached on or before the '''''startdate''''' URL option.  The sermons are listed in reverse date order.



>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<customer>
-><sermons>
--><sermon>
---><sermonid>''the identifier of the sermon record in SermonsOnline.com''</sermonid>
---><date>''date sermon was preached''</date>
---><timeofday>''time of day sermons was preached; one of "Morning", "Evening", or "Other"'',</timeofday>
---><creator>''name of the person who preached the sermon''</creator>
---><title>''title of the sermon''</title>
---><description>''description of the sermon''</description>
---><body>''notes associated with the sermon, in HTML format''</body>
---><subject>''sermon series/topic''</subject>
---><rights>''copyright notice''</rights>
--</sermon>
-->:
-->: ''for each sermon preached after '''startdate'''''
-->:
-></sermons>
>><<


August 12, 2011, at 05:48 PM EST by DaveM - Added page on export options
Changed line 19 from:
[@https://www.sermonsonline.com/util_pub.php?action=export_sermons&custid=mychurch&format=xml&startdate=2010-10-16&disposition=stream
to:
[@.../util_pub.php?action=export_sermons&custid=mychurch&format=xml&startdate=2010-10-16&disposition=stream@]
August 12, 2011, at 05:47 PM EST by DaveM - Added page on export options
Changed lines 9-11 from:
!!!!Export Options:

Export
options are URL name/value pairs.
to:
Export options are URL name/value pairs:
Changed lines 11-15 from:
* '''&custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported
* '''&format'''='''''CSV'''''|'''''HTML'''''|'''''XML''''' - the format of the exported data; one of 'CSV' (default), 'HTML', or 'XML'
* '''&startdate'''=''YYYYMMDD'' - the starting sermon date of the sermons to be exported; format of YYYY-MM-DD; default is from the earliest sermon on record
* '''&disposition'''='''''attachment'''''|'''''stream''''' - how to return the exported data; one of 'attachment' (default), or 'stream'
to:
* &'''custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported
* &'''format'''='''''csv'''''|'''''html'''''|'''''xml''''' - the format of the exported data; one of 'CSV' (default), 'HTML', or 'XML'
* &'''startdate'''=''YYYY-MM-DD'' - the starting sermon date of the sermons to be exported; format of YYYY-MM-DD; default is from the earliest sermon on record
* &'''disposition'''='''''attachment'''''|'''''stream''''' - how to return the exported data; one of 'attachment' (default), or 'stream'

Example:

Changed lines 19-21 from:
https://www.sermonsonline.com/util_pub.php?action='''

to:
[@https://www.sermonsonline.com/util_pub.php?action=export_sermons&custid=mychurch&format=xml&startdate=2010-10-16&disposition=stream
>><<

Will export all sermons preached since October 16, 2010 by "mychurch".  The output format will be XML which will be returned to the web browser as a stream of web data.

August 12, 2011, at 05:40 PM EST by DaveM - Added page on export options
Added lines 1-83:
(:title Exporting Data from Sermons Online:)

This function exports a customer's sermon data.

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
[=https://www.sermonsonline.com/util_pub.php?action=export_sermons&=]'''''export options'''''
>><<

!!!!Export Options:

Export options are URL name/value pairs.

* '''&custid'''=''id1'',''id2'',... - a comma-separated list of customer ids to be exported
* '''&format'''='''''CSV'''''|'''''HTML'''''|'''''XML''''' - the format of the exported data; one of 'CSV' (default), 'HTML', or 'XML'
* '''&startdate'''=''YYYYMMDD'' - the starting sermon date of the sermons to be exported; format of YYYY-MM-DD; default is from the earliest sermon on record
* '''&disposition'''='''''attachment'''''|'''''stream''''' - how to return the exported data; one of 'attachment' (default), or 'stream'

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
https://www.sermonsonline.com/util_pub.php?action='''


!!!XML Output Format

>>bgcolor=#f0f9ff border='1px solid gray' padding=5px<<
<customers>
-><customer>
--><custid/>
-></customer>
</customers>
>><<

The Sermon Data XML Document contains the sermon data that is being added, and will be returned as the <param><value> of the RPC-formatted XML string. The format of the Se-rmon Data document is as follows (literal values are shown in Courier typeface).  A colon (:) after an element indicates that it is repeatable.

%block bgcolor=#f0f9ff border='1px solid gray' padding=5px%[@<sermon>
<data>
<custid>[=''Internal Sermon Site customer identification string''=]</custid >
<sermonid>Internal Sermon Site sermon identification number</sermonid>
<status>Active</status>
<title>The title of the sermon</title>
<description>Description of the sermon</description>
<creator>Name of the person who preached the sermon</creator>
<date>Date preached, in YYYY-MM-DD format</date>
<timeofday>Morning, Evening, or Other</timeofday>
<subject>Sermon series name or topc</subject>
<subjectorder>Part number of the sermon within the series</subjectorder>
<rights>The copyright message for the sermon</rights>
<body><![CDATA[ Sermon notes or outline, in HTML format ]]></body>
<multimedia>
<media>
<format>Windows Media, Real Media, or MP3</format>
<type>Audio or Video</type>
<bandwidth>16K or 32K</bandwidth>
<href type="streaming"><![CDATA[ URL of playlist file ]]> </href>
<href type="download"><![CDATA[ URL of multimedia file ]]> </href>
</media>
: (repeatable)
</multimedia>
<hymns>
<hymn>
<title>Title of hymn</title>
<href><![CDATA[ URL of hymn (optional) ]]></href>
</hymn>
:
</hymns>
<scriptures>
<scripture>
<sortorder>Sort key of first book, chapter, and verse in the citation</sortorder>
<book>Normalized name of the first book in the citation</book>
<passage>All citation text following the first book</passage>
<href><![CDATA[ URL to scripture citation on biblegateway.com ]]>
</href>
</scripture>
:
</scriptures>
<attachments>
<attachment>
<title>Title of attachment</title>
<href><![CDATA[ URL of attachment ]]></href>
</attachment>
:
</attachments>
</data>
</sermon>@]