Computer: SQLape® tools are designed to run with Windows 8-11 and Microsoft Office software package (Access + Excel 2013 to 2026. Dates must be configured in Windows in DD.MM.YYYY format (example: 30.05.2019). The standard version is the 64-bit version; if you are still using a 32-bit version, please let us know.

Data: All data come from the Swiss medical statistics in the format « SpiGes », defined by the Swiss Federal Statistical Office. The data must be place in the sub-directory where you want to run SQLape® tool (for instance: D:\SQLape-2026), with the name of .xml file including the word “SPIGES”. If you wish to analyse the costs, you can include them in the « SpiGes » file or place them in a separate .xml file, named without the word « SPIGES ».

If you wish to use the old formats « SQLape_input.txt » and « REKOLE.txt files », for convenience or to analyze older data with the latest version of SQLape, you can certainly do so; the tool will automatically detect the format of the data provided.

Implementation:

  1. Run the SQLape_SERIAL_NUMBER.accde tool and send us the “SQLape_AUTHORIZATION.csv file” automatically generated. We’ll introduce the serial number(s) of your computer in the SQLape application. If you use several computers or new ones, please send us the correspondent files.
  2. Copy the SQLape.accde application in the subdirectory you want to use to run SQLape® tool (for instance: D:\SQLape-2026). Double-click on SQLape.accde application and wait for results.
  1. Review process (optional, after step 2)

Calculating readmission rates:

Since « SPIGES » data does not include patient identifiers, you need to add a separate file in the same directory (format .txt), with two variables separated by a semi-colon (« ; »)
– Stay identifier
– Patient identifier.

This step is not necessary if you are using the traditional SQLape_input.txt file.

Help: If if you encounter any difficulties in installing or running SQLape® tool: HELP