Swansea

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....