There are two ways your sermon information can be exported from Sermons Online.
The easiest and most complete method is to use the 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:
Where export options are the following URL name/value pairs:
- &custid=id1,id2,... - a comma-separated list of your customer ids (required)
- &format=csv|html|xml|json - the format of the exported data; one of 'csv' (default), 'html', 'xml', or 'json'
- &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'
Result: exports all sermons on record for "mychurch", as a .CSV file
Result: exports all sermons preached since October 16, 2010 by "mychurch", as a stream of XML data.
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.
<custid> customer identifier </custid>
: for each customer passed in custid URL option
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.
<date> date sermon was preached </date>
<timeofday> time sermon 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>
copyright notice </rights>
<scriptures> see below...
<hymns> see below...
<multimedia> see below...
<attachments> see below...
: for each sermon preached after startdate
Required elements shown in red
Optional Sermon Sub-Elements
The following optional sub-elements may be enclosed with the <sermon> element.
<title> the title of the hymn </title>
: for each associated hymn
<book> the Book name of the reference (e.g., "Genesis", etc.) </book>
<passage> the chapter and verse of the reference </passage>
: for each Scripture reference
<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> download URL of the media file </enclosure>
: for each item of multimedia
<title> title of the attached file </format>
<filesize> size of the attached file, in bytes </filesize>
<enclosure> download URL of the attached file </enclosure>
<creator>David Coffin, Jr.</creator>
<title>Remember the Rebellion of the Angels</title>
<rights>Copyright 2011, David Coffin, Jr., New Hope Presbyterian Church. All rights reserved. Powered by SermonsOnline.com.</rights>
Sermons exported in JSON follow the same structure as XML, but serialized according to the rules of JSON formatting.
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.
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.