Swansea

Create an Empty IBID Database for the Swansea data on IBID2 (once only)

Perform the following on UHSM-IBID2 before the first import attempt only:

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

An empty database, called Swansea is now created.

Point AquilaServer at the Swansea database (IBID1)

Perform the following on UHSM-IBID1. This needs doing only once, unless you switch back to the training database.

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=UHSM-IBID2\SQLEXPRESS;Database=IBID_TRAINING;UserID=sa;Password=ehspass123;
   ConnectionString=AnyDAC?AuxDriver=MSSQL;Server=UHSM-IBID2\SQLEXPRESS;Database=SWANSEA;UserID=sa;Password=ehspass123;
   SessionTimeout=240

6) Press File > Save

7) Notepad can be closed at this point.

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.

Install the Import Application (IBID2)

Perform this operation back on UHSM-IBID2. Again, this should need doing once only, but there may be upgrades to download & install:

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 FIRST (see later)

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 checkbox). The settings will be remembered. Click Login, then Next.

  Username:   QSECOFR
  Password:   partlypourneedleplanet
  Server URL: http://UHSM-IBID1:8099/bin

4) Load the Field Mapping file FIELD_MAP_SWANSEA_to_IBID_Version_3.FMAP & press Next

5) Select the Swansea IBID CSV file & press Next

6) Tick the "No Dependency file" checkbox & click Next

7) Check the following settings carefully:

• tick Validate Database - and enter the earliest date you want to be validated. Any records BEFORE this date won't be validated. Useful to ensure only most recent validation messages appear in the database.
• Double check the import file names.
• Tick Run Analysis Calcs for IBID & Dependency. Note, dependency calcs will simply be ignored as there's no file
• Set a prefix for the imported Trauma Network ID's, or leave blank for no prefix.
• The default Unit ID -- ensure this is the Swansea Unit ID. This is only used where the Unit ID is missing from an imported record.

and finally, when you're happy, tick the Confirm all settings are correct, and press Next.

8) Press Run Import & wait.

9) When the import has finished (or failed) copy the contents of the log using the "Copy Log" button & paste into an email (please no screen-shots)

Deleting Clinical Data After an Import Test

1) Open MS SQL Server Management Studio

2) Open the SWANSEA_IBID_DELETE_ALL_DATA.sql (File > Open > File ...)

3) Press Execute on the toolbar.

4) Watch for confirmation of deleted records in the bottom half of the screen.