Generate SQL stored procedure for XCRI CAP 0.1.7.25
The purpose of this form is to map SQL database locations of course information to their XCRI CAP equivalents, generating a SQL stored procedure on submission of the form which will extract this data as XML.
This is still a prototype, with a number of limitations:
- All the database objects, the course and presentation tables (or views), must currently reside in the same database that the stored procedure will be created in.
- Little parsing or validation of database object names is done.
- Only a small, but valid, subset of XCRI CAP 1.1 is handled.
- All course information must come from the same table (or view). All presentation information must come from the same table (or view). Unless a method of joining new tables can be found, if data is scattered around, a preprocessing step of preparing appropriate course and presentation views may be necessary.
Last updated: 2010-07-30.