1. Creating Unix and PostgreSQL Accounts
2. Checking out the erp_cs440 application
3. Generating Web-Scripts
4. Using Microsoft Visio

Creating Unix and PostgreSQL Accounts

You can create your Linux and PostgreSQl accounts by visiting

http://toba.een.orst.edu/acc_creationS06/

You can currently access this page only from a machine in Hovland, Milne, Kelly, and Dearborn. The secret key was announced in class. Please use only letters, numbers, and "_" in your account name and password. DO NOT USE SPECIAL CHARACTERS. Your account is needed for a demo session scheduled in Milne 201 at 2pm on Tuesday next week.

Once your account is created, please check that you can login on toba.een.orst.edu by using ssh. In order to be able to use PostgreSQl and CVS, do the following in your home directory

cp ~minouray/.bash_profile .
cp ~minouray/.bashrc .
source .bash_profile

You can activate the PostgreSQL SQL command interpreter by executing Unix command:

psql

Checking out the erp_cs440 Application

You mcan check out the erp_cs440 application by executing the following Unix commands:

cd ~
mkdir public_html
chmod -R a+rX .
cd public_html
cvs co -P ms_apps_cs440/erp_cs440
cvs co -P ms_apps_cs440/framework_v3
cvs co -P ms_apps_cs440/web_gen
cvs co -P ms_apps_cs440/treeview

Generating Web-Scripts

In order to access your database, edit the database connection parmeters in file ~/public_html/ms_apps_cs440/erp_cs440/forms/datasource.php:

$Database_Name = "your_database_name";
$Database_User ="your_database_account_name";
$Database_Password ="your_database_password";
$Database_Host = "localhost";

You can generate Web-scripts for database table xxx in directory yyy as follows:

cd ~
cd public_html/ms_apps_cs440/forms
mkdir yyy
confgen xxx
webgen xxx

You can now access the Web-scripts generated, starting with the search script at

http://toba.een.orst.edu/~your_account_name/ms_apps_cs440/erp_cs440/forms/yyy/xxx_search.phtml

Using Microsoft Visio

Once you create tables in your PostgreSQL database, you can semi-automatically generate a schema diagram for them by using Microsoft Visio. In order to connect to a Postgresql database from a Windows machine, you need to create a Data Source by following the following menu:

Start --> Settings --> Control Panel -> Administrative Tools
 --> Data Sources (ODBC)

User DSN --> PostgreSQL Unicode --> Add
 --> PostgreSQL Unicode

Programs --> Microsoft Office --> Microsoft Visio 2003

File --> New --> Database --> Data Model Diagram (Metric)

Database --> Reverse Engineer -->
 ODBC Generic Driver, PostgreSQL Unicode --> Select Tables --> ...

Use the Help facility of Visio for further details.