Xml data from ywam.org

From YWAMKnowledgeBase
Jump to: navigation, search

XML Data Feeds From the YWAM.org Database

When XML first came out as a standard I was curious to understand what it was all about. It seemed that so many saw great potential in the technology so I wanted to wrap my brain around what it was all about. So after some heavy reading and a few books later I also began to see the real potential behind XML.

Simply put html describes page layout out and xml describes information.

Ok so I can describe information with XML but how does that help. Well XML by is self is a nice way to describe information but the real power comes when you combine it with something else XSLT. XSLT is short for Extensible Style sheet Language Transformations. If you have ever done a "mail-merge" then you will understand the concept. You have a data document (your xml file) and you have template your (XSLT) and when you run your merge you get the result of two combined. XSLT however is more then just a template file it's a language for defining how transform xml into something else. So your information or data in XML can be transformed into HTML, XML, plain text, or something else.

Here is an example -- data feeds from ywam.org -- when we change our location e-mail address it's seems like there are so many sites where we need to change the information. Our location's web site, the national web site, ywam.org, uofn.edu and the list goes on. Usually one of these sites is left out or forgotten. So how about keep one central database and just feed the information from there. That way we make the change once and everyone feeding from that database will automatically be updated.

--Colin 15:24, 6 July 2007 (BST)

Data Sets

  • Operating Locations (bases)
  • Ministries
  • Named Ministries
  • Staff Opportunities
  • UofN Registered Schools
  • Countries
  • Regions
  • Fields

Filtering - How do I Get the Data That I Need?

The XML feeds from YWAM.org can be easily filtered so you can quickly get only the data that you need!

For example the Staff Opportunities data set can be filter by

  • Field
  • Region
  • Country
  • Operating Location(Base)

UofN Registered Schools can be filterd by:

  • College
  • Course Number
  • Field
  • Region
  • Country
  • Operating Location

So how do filter the data - easy ... when making the request simply add the correct paramaters to the URL request.

staffopps_by_name.xml?fid=2 - Would return only the staff opportunities for Europe (field id 2 = Europe)

staffopps_by_name.xml?cid=52 - Would return only the staff opportunities for England (country id 52 = England)

So how do I know what the the Field(fid), Region(rid), Country or Base(bid) IDs are so that I can use them for filtering?

Simply request the xml feed for Field, Region, Country or Location and you will see both the ID and the proper name then you can use the ID number when making the request.

How do I do This on My Site?

XML Data ASP Example

XML Data PHP Example

XML Data PHP Example2

For More Information

For more information about XML feeds from ywam.org cforbes(at)ywam.org.