Installation of palCentre is intended to be simple and safe. The built-in database configuration wizard can create and configure the SQL database and logins for you with a bare minimum of customisable data entry.
...
To install palCentre and its dependencies, follow these steps:
- Unzip the file
- Please note, you can skip over the SQL Server Compact Edition installer as this is not required when placing the database on an SQL server (4th installer) – just click cancel when the installer appears.
Click on the bat file named DOUBLE CLICK HERE TO INSTALL.bat. Multiple installers will pop-up and install the prerequisites before starting the installation of palCentre.
Note palCentre.msi
- You will be prompted for an install folder. palCentre will work when installed in C:\Program Files (x86)\AHSRI\palCentre\ (the default) or any other local (not network) folder available to the machine.
- You will be prompted for a folder in which to store the configuration file. This path should be a location where ordinary users have read and write access. We recommend C:\palCentre\, however, we have allowed this as a configuration option in order to support different partitioning configurations , or even installation of the software and configuration to including storing configuration files on a network drive.
Configuring the SQL Server via the database configuration wizard
...
- Server: the name of the instance of SQL Server installed on the service, will be pre-filled from the previous page
- Database: the name of the database you want to create in SQL Server
- Authentication: the Active Directory option can be chosen for those SQL installs that don’t have any explicit accounts, as long the account of the person installing has access to create databases within SQL Server
- Username prefix: palCentre relies on 3 three SQL logins. So that you can conform to your own naming standards, palCentre asks for a prefix to use for these logins. The default is palCentre. This will create logins palCentre_dbo, palCentre_user and palCentre_reader. You can use any prefix you like which would result in a valid SQL login.
- Owner password, User password and Reader password: you may use the same password for all 3 three logins or different passwords. For higher security we recommend using a different password for each SQL login. For each login, there is a password and confirm password textbox. Note that these passwords are encrypted before being saved in the configuration file, ensuring your password security. Make a note of these passwords because you will need to use them again in the ‘Client Configuration Wizard’. Ordinary users will never need to use or know these passwords.
- Database path: this is the path on the SQL Server (not on the client machine) where the database .MDF and .LDF files will be created. The default is C:\ePPOCPCOC\ but you will probably have a specific folder where SQL Database files are kept. This path must already exist to correctly work.
...
| Info |
|---|
palCentre will use the built-in database create SQL scripts and the database administrator login details provided on the previous step to connect to the SQL Server and create the palCentre database. Steps palCentre uses to create and configure the databaseThe database is created and configured in 3 steps:
Potential Errors when trying to create and configure the databaseIf there were any problems with the data you entered, or with executing the database create scripts, the items which caused the problem will be highlighted and/or an appropriate error message will be displayed. A few errors you may encounter here:
If you successfully created the databaseIf the create and configure step was successful, a message will be displayed indicating success and you will be moved to the next step. You should also check that the database and SQL logins were created in SQL Server and that the .MDF and .LDF files were written to the expected location.
|
...
STEP 4: Database Connection
When using the Database Configuration Wizard this step is very simple. You have already told the system the server, database name and user prefix so palCentre has all the information it needs to connect to the database. The only additional information you will need to provide is:
...
STEP 5: Proxy Settings
PCOC does and PACOP do not require the proxy settings to be used so click Next on this screen.
...
STEP 6: Administrator Account
You now have created a working palCentre database, and configured the connection to that database. Now you need to create an account with Administrator privileges. Later you will be able to use this user account to create other user accounts. On this screen you are required to provide a name, username, email address and password/confirm password.
...
The following box will appear. Click on OK.
STEP 7: Facility
In palCentre, all patient data belongs to a Facility. In most cases an palCentre database will only be used to manage one facility, however the system supports multiple Facilities being used by a single database. Consequently, it is essential to create the first facility before any patient data can be entered. The facility record includes a facility name, a unique 4 digit facility identifier supplied by PCOC or PACOP.
As part of your installation email, you should have received an email with your site specific details below. If you did not receive this, please contact Alanna Connolly on (02) 4221 5640 or Sam Allingham on (02) 4221 4476contact us at pcoc@uow.edu.au (for PCOC) or pacop-data@uow.edu.au (for PACOP).
Field | Value |
Facility Name | Your Facility Name |
Facility Identifier | XXXX |
...
| Tip |
|---|
Congratulations, you have completed the Database Setup Wizard. An XML file called palcentre.config will be created in the folder you specified during the install procedure (the default is C:\palCentre\). That file is very important. It should be backed up and we ask services to send it to us so that we can also keep it on our secured server. Please send this configuration file to pcoc@uow.edu.au (for PCOC) or pacop-data@uow.edyu.au (for PACOP). The Database Configure Wizard only needs to be run once to create and configure the palCentre database. After this has been run, all palCentre clients can be configured pasting the palcentre.config file in the C:\palCentre\ folder. |
...