Difference between revisions of "Swansea"
| Line 52: | Line 52: | ||
Perform this operation back on '''UHSM-IBID2''': | Perform this operation back on '''UHSM-IBID2''': | ||
| − | 1) From where you downloaded the files earlier on, find & run the file ''' | + | 1) From where you downloaded the files earlier on, find & run the file '''IBID_Import_1.7.3.exe''' |
| − | 2) Click Next until installed | + | 2) Click Next until installed - a desktop shortcut should be created |
| Line 61: | Line 61: | ||
1) ''If this is NOT the first time you've run the import, you must delete all existing clinical data'' | 1) ''If this is NOT the first time you've run the import, you must delete all existing clinical data'' | ||
| − | 2) Run the Import VP program: Start Menu > All Programs > | + | 2) Run the Import VP program: shortcut on desktop or "Start Menu > All Programs > IBID > CSV Import to IBID" |
3) If it's your first run, then please login with the following settings (you will need to tick the Edit Server URL) | 3) If it's your first run, then please login with the following settings (you will need to tick the Edit Server URL) | ||
| Line 69: | Line 69: | ||
Server URL: http://UHSM-IBID1:8099/bin | Server URL: http://UHSM-IBID1:8099/bin | ||
| − | 4) | + | 4) to do.... |
Revision as of 16:16, 2 November 2015
Contents
Create a Blank IBID Database (IBID2)
Perform the following on UHSM-IBID2:
1) Download the 3 files from the Swansea section of the downloads on www.IBIDB.org into a folder called "Swansea" (or something equally as memorable)
2) Open Microsoft SQL Server Management Studio
3) Open the menu File -> Open -> File...
4) Navigate to the folder from step 1) and select the file called SWANSEA_IBID_38.25_DB.SQL
5) Click Execute on the toolbar
You're blank database, called Swansea is now created.
Point AquilaServer at the Swansea database (IBID1)
Perform the following on UHSM-IBID1:
1) Open the Notepad application (Start menu > All Programs > Accessories > Notepad)
2) File > Open
3) Change the drop down list from Text Documents (*.txt) to All Files
3) Go to the folder C:\Program Files\Evolution Healthcare Systems Limited\AquilaServer\
4) Open the file AquilaServer.INI.
5) Change the ConnectionString to point to the Swansea database by altering the name of the database (in bold), like this:
[Settings] ConnectionType=MSSQL ConnectionString=AnyDAC?AuxDriver=MSSQL;Server=BLACKBOX;Database=SWANSEA;UserID=sa;Password=ehspass123; SessionTimeout=240
6) Press File > Save
Now we must restart the AquilaSever for the changes we just made to take effect
1) Open the Start Menu & choose Run...
2) type services.msc and press OK
3) In the list of services, locate the AquilaServer entry and click on it.
4) On the toolbar, click the Restart Service button - looks like a square and triangle together.
Now install the Import Application (IBID2)
Perform this operation back on UHSM-IBID2:
1) From where you downloaded the files earlier on, find & run the file IBID_Import_1.7.3.exe
2) Click Next until installed - a desktop shortcut should be created
Running the Import
1) If this is NOT the first time you've run the import, you must delete all existing clinical data
2) Run the Import VP program: shortcut on desktop or "Start Menu > All Programs > IBID > CSV Import to IBID"
3) If it's your first run, then please login with the following settings (you will need to tick the Edit Server URL)
Username: QSECOFR Password: partlypourneedleplanet Server URL: http://UHSM-IBID1:8099/bin
4) to do....
