US Spec SIF_Provision unable to handle TestAccommodation Object

While working with a client we found that the TestAccommodation object does not validate within the SIF_Provision message. Check this out for yourself by pointing your browser to http://compliance.sifinfo.org/validate/ and paste this in.


<?xml version="1.0" encoding="UTF-8"?>
<SIF_Message Version="2.3" xmlns="http://www.sifinfo.org/infrastructure/2.x">
<SIF_Provision>
<SIF_Header>
<SIF_MsgId>BD5070007BDF012D83B2001FF3502BAD</SIF_MsgId>
<SIF_Timestamp>2010-07-27T15:04:43</SIF_Timestamp>
<SIF_SourceId>Zone1Provider</SIF_SourceId>
</SIF_Header>
<SIF_ProvideObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_ProvideObjects>
<SIF_SubscribeObjects/>
<SIF_PublishAddObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_PublishAddObjects>
<SIF_PublishChangeObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_PublishChangeObjects>
<SIF_PublishDeleteObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_PublishDeleteObjects>
<SIF_RequestObjects/>
<SIF_RespondObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_RespondObjects>
</SIF_Provision>
</SIF_Message>

As of July 27th 2010 this won’t validate. Now try this XML SIF Message:


<?xml version="1.0" encoding="UTF-8"?>
<SIF_Message Version="2.3" xmlns="http://www.sifinfo.org/infrastructure/2.x">
<SIF_Provision>
<SIF_Header>
<SIF_MsgId>23D54AA07BE1012D83B3001FF3502BAD</SIF_MsgId>
<SIF_Timestamp>2010-07-27T15:14:45</SIF_Timestamp>
<SIF_SourceId>Zone1Provider</SIF_SourceId>
</SIF_Header>
<SIF_ProvideObjects>
<SIF_Object ObjectName="TestAccommodation"/>
</SIF_ProvideObjects>
<SIF_SubscribeObjects/>
<SIF_PublishAddObjects/>
<SIF_PublishChangeObjects/>
<SIF_PublishDeleteObjects/>
<SIF_RequestObjects/>
<SIF_RespondObjects/>
</SIF_Provision>
</SIF_Message>

It validates successfully!

This is interesting – We are reporting this to the SIF association immediately. This error is within SIF 2.1, 2.2, 2.3 and 2.4 as far as we can tell. If you are able to provide it you should be able to Publish! With so many objects its hard to imagine that we don’t find more of these… but the SIF Association does a great job.

To fix this you will need to update your XSD SIF_SubscribeObjectNamesType. We have updated the XSD for OpenZIS.

Installation from GitHub

These steps are based on a new installation on a Ubuntu Server 9.10

user/password: openzis/openzis

pwd => /home/openzis

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install build-essential
sudo apt-get install git-core

git clone git://github.com/cwhiteley/OpenZIS.git

cd OpenZIS
pwd => /home/openzis/OpenZIS

sudo apt-get install mysql-server
user/pass root/openzis

sudo apt-get install mysql-client
sudo apt-get install php5-mysql
sudo apt-get install libmysqlclient-dev

mysql -u root -p
> source ZISDB.sql
> use openzis
> show tables

You should have 32 rows returned.

> quit

sudo apt-get install apache2
sudo apt-get install php5 php5-common
sudo apt-get install libapache2-mod-php5 php5-gd php5-dev
sudo apt-get install php-pear

Add two lines to php.ini file located at: /etc/php5/apache2/

sudo vi php.ini

extension=pdo.so
extension=pdo_mysql.so

sudo pecl install pdo_mysql

sudo a2enmod rewrite

move to /etc/apache2/

sudo vi apache2.conf

Near the end of the file add:

NameVirtaulHost *

move to /etc/apache2/sties-available

sudo vi admin


ServerAdmin someone@openzis.org
DocumentRoot /home/openzis/OpenZIS/OpenZIS/ADMIN_SERVER
Servername admin.openzis.us

Options Indexes FollowSymLinks
AllowOverride All
Order deny,allow



Save your admin file

sudo vi zis


ServerAdmin someone@openzis.org
DocumentRoot /home/openzis/OpenZIS/OpenZIS/ZIT_SERVER
Servername zis.openzis.us

Options Indexes FollowSymLinks
AllowOverride All
Order deny,allow


Save your zis file

sudo a2ensite admin
sudo /etc/init.d/apache2 reload
sudo a2ensite zis
sudo /etc/init.d/apache2 reload

move to /home/openzis/OpenZIS/OpenZIS
update the config.ini at a minimum you should update your password and your
application.root.directory. In this example your application.root.directory should look like this:

application.root.directory = /home/openzis/OpenZIS/OpenZIS;

Now you should be able to connect to your admin site as admin.openzis.us with the user/pass as admin/admin.

If you setup your Apache with a different URL you will need to update the ZIS setting from within the UI interface.

Download OpenZIS from GitHub.

Getting OpenZIS from GitHub

Ubuntu 9 64 bit Server Version

Install Git
sudo apt-get install git-core

Clone OpenZIS Repositories
git clone git://github.com/cwhiteley/OpenZIS.git


Statewide Longitudinal Data Systems (SLDS) going Open Source

Statewide Longitudinal Data Systems (SLDS) or even (LDS) are intended to aid state educational agencies to efficiently and accurately manage, analyze and use education data. Most often this means turning out tons for CSV files which are then loaded in staging areas and the pushed into reporting system to include but not limited to a data warehouse. Many of these systems are built over time and recollect the same data over and over.

There is a better way to integrate data and it is to start your SLDS with a SIF enabled Operational Data Store (ODS). According to Bill Inmon, an ODS, is a subject-oriented, volatile, current-valued, detailed-only collection of data in support of an organizations need for up-to-the-second information. Wikipedia states that its designed to integrate data from multiple sources and contains low level (atomic) data with a limited history captured in realtime.

Basically this means that the education agency that implements an ODS has detailed or non-summarized data about the students within its reporting structure. This gives the agency capability to offer services that before might have been more difficult to provide. For example a state agency could construct and support a Parent Portals, Student records transmissions, or even a district reporting system.

So why are we talking about this within OpenZIS blog today – well over the next few months we will begin to document an open source longitudinal data system (SLDS)(LDS) with our first step being the development of a SIF enabled operational data store (ODS).

Thanks

Christopher

SIF Association UK Quarterly Meeting – Connect-a-thon

We will be at the SIF Association’s UK Quarterly Meeting on Oct 7th and 8th. If your a SIF Agent Developer and would like to test your agents with OpenZIS – as well as have an interest in discussing all things SIF related – we will be hanging out with the gang from Equiinet’s.

Cheers.

Christopher

Install UK SIF 1.1 Specification in your ZIS

Introduction
This post will talk you through the installation of UK SIF Spec 1.1 in to a properly installed ZIS. I will be login in as the user ZIT for this example.
Ubuntu versions tested
Ubuntu 9 64 bit Server Version

Step 0: download SIF 1.1

wget http://www.openzis.org/download/uk_1_1_lib_install.zip
unzip uk_1_1_lib_install.zip
cd uk_1_1_lib_install

Step 1: Load MySQL Data

mysql -u root -p
mysql> use zit
mysql> source uk_1_1_lib_install/install.sql
mysql> commit;
mysql> exit

Step 2: Move the ’sif_schema’ directory

mv uk_1_1_lib_install/sif_schema ZIT_CommunityEdition/ZIT_APPLICIATION

Step 3: Move the ‘uk_1_1_lib’ directory

mv uk_1_1_lib_install/lib/uk_1_1_lib ZIT_CommunityEdition/ZIT_APPLICIATION


Install US SIF 2.0r1 Specification in your ZIS

Introduction
This post will talk you through the installation of US SIF Spec 2.0r1 in to a properly installed ZIS. I will be login in as the user ZIT for this example.
Ubuntu versions tested
Ubuntu 9 64 bit Server Version

Step 0: download SIF 2.0r1

wget http://www.openzis.org/download/us_2_0_r_1_lib_install.zip
unzip us_2_0_r_1_lib_install.zip
cd us_2_0_r_1_lib_install

Step 1: Load MySQL Data

mysql -u root -p
mysql> use zit
mysql> source us_2_0_r_1_lib_install/install.sql
mysql> commit;
mysql> exit

Step 2: Move the ’sif_schema’ directory

mv us_2_0_r_1_lib_install/sif_schema ZIT_CommunityEdition/ZIT_APPLICIATION

Step 3: Move the ‘us_2_0r1_lib’ directory

mv us_2_0_r_1_lib_install/lib/us_2_0r1_lib ZIT_CommunityEdition/ZIT_APPLICIATION