AdminServers/SEQTA: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Created page with "none|thumb|656x656px ====SQL Server==== DNS or IP address of the Microsoft SQL server where the Scyllabus database is stored. ====Database..."
 
Kia (talk | contribs)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:AdminServer Scyllabus.jpg|none|thumb|656x656px]]
[[File:AdminServer SEQTA.jpg|none|thumb|656x656px]]


====SQL Server====
===SQL Server===
DNS or IP address of the Microsoft SQL server where the Scyllabus database is stored.
DNS or IP address of the Postgre SQL server where the database is stored.


====Database====
===Database===
Scyllabus database name.
Database name.


====Port number====
===Port number===
The port number of the SQL server.
The port number of the SQL server.


====Username====
===Username===
SQL Username to access database.
SQL Username to access database.


====Password====
===Password===
SQL Password to access database.
SQL Password to access database.
===Add year to groupname===
When UMS extracts classes from SEQTA it will add "'''_YEAR'''" to the end of the groupname.


This must match the one under the data source for templates.
===Add semester to groupname===
When UMS extracts classes from SEQTA it will add "'''_Code'''" to the end of the groupname. This comes after '''YEAR''' if it is selected.
This must match the one under the data source for templates.
===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===

Latest revision as of 09:42, 14 April 2020

SQL Server

DNS or IP address of the Postgre SQL server where the database is stored.

Database

Database name.

Port number

The port number of the SQL server.

Username

SQL Username to access database.

Password

SQL Password to access database.

Add year to groupname

When UMS extracts classes from SEQTA it will add "_YEAR" to the end of the groupname.

This must match the one under the data source for templates.

Add semester to groupname

When UMS extracts classes from SEQTA it will add "_Code" to the end of the groupname. This comes after YEAR if it is selected.

This must match the one under the data source for templates.

Export settings