Contents Member Sign in |
Exporting Data from Sermons OnlineDataManagement.Export HistoryShow minor edits - Show changes to markup August 27, 2016, at 12:34 PM EST
by - 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 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 - Update to output formats
Changed line 12 from:
to:
Changed lines 30-33 from:
Output FormatsXMLto:
Notes on XML OutputChanged lines 181-193 from:
</customers>
to:
</customers>
JSON OutputSermons exported in JSON follow the same structure as XML, but serialized according to the rules of JSON formatting. CSV OutputSermons 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 OutputSermons 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 - Update to output formats
Changed lines 78-79 from:
Optional Sermon Sub-Elementsto:
Optional Sermon Sub-ElementsChanged lines 82-83 from:
Hymnsto:
HymnsChanged lines 97-98 from:
Scripture Referencesto:
Scripture ReferencesChanged lines 113-114 from:
Sermon Multimediato:
Sermon MultimediaChanged lines 132-133 from:
File Attachmentto:
File AttachmentAdded lines 146-183:
XML Example<?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 - 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 FormatThe 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 FormatsXMLThe 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>
<custid> customer identifier </custid>
</customer>
:
: for each customer passed in custid URL option
:
</customers> 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. Changed lines 55-58 from:
to:
Changed lines 62-63 from:
to:
Added lines 74-75:
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. HymnsChanged lines 97-98 from:
A <sermon> element may optionally contain a <scriptures> element which contains the Scripture references associated with the sermon. to:
Scripture ReferencesChanged 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 MultimediaChanged 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 AttachmentDeleted line 44:
Deleted line 88:
Deleted line 104:
Deleted line 123:
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:
to:
Changed line 19 from:
to:
Changed line 11 from:
to:
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 - Added page on export options August 12, 2011, at 06:41 PM EST
by - Added page on export options
Changed line 112 from:
to:
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. <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. <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 - 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. <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 - Added page on export options
Added line 59:
Changed lines 67-68 from:
to:
Optional Sermon Sub-ElementsA <sermon> element may optionally contain a <hymns> element which contains one or more <hymn> elements that associate a hymn with the sermon. <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. <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 - Added page on export options
Changed lines 54-57 from:
to:
August 12, 2011, at 06:14 PM EST
by - Added page on export options
Added lines 54-57:
August 12, 2011, at 06:12 PM EST
by - Added page on export options
Changed line 31 from:
to:
Deleted lines 40-41:
Changed lines 45-54 from:
to:
August 12, 2011, at 06:07 PM EST
by - 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:
to:
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:
to:
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. <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 - 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:
August 12, 2011, at 05:47 PM EST
by - 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:
to:
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 - Added page on export options
Added lines 1-83:
(:title Exporting Data from Sermons Online:) This function exports a customer's sermon data. https://www.sermonsonline.com/util_pub.php?action=export_sermons&export options Export Options:Export options are URL name/value pairs.
https://www.sermonsonline.com/util_pub.php?action=''' XML Output Format<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. <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> |