Importing data into OpenFIT

Importing ORS and SRS Scores

ORS and SRS scores must follow strict formatting rules. The ORS_Skip and SRS_Skip fields determine whether OpenFIT should import or ignore the scores supplied.

1. Skip Flags (ORS_Skip / SRS_Skip)

Skip = 1 means “no survey was completed” and OpenFIT will ignore all score fields for that session.

ORS_Skip = 1
ORSQ1–ORSQ4 = blank
Total_ORS   = blank

SRS_Skip = 1
SRSQ1–SRSQ4 = blank
Total_SRS   = blank

This clearly identifies the session as “no survey completed”.

Skip = 0 means “a survey was completed” and OpenFIT will import scores — but only if they follow one of the valid formats below.

2. Valid Formats When Skip = 0

When a survey was completed, ORS/SRS data must be supplied in one of the following formats. Any other structure should be assumed to fail validation.

Format A — Subscores Only (Q1–Q4 Provided)

All four subscores must be provided; total must be blank:

ORSQ1–ORSQ4 = numeric values
Total_ORS   = blank

SRSQ1–SRSQ4 = numeric values
Total_SRS   = blank

A score of 0 is valid only when it reflects a genuine client score.

Format B — Total Only (All Subscores Blank)

All subscores must be blank; only the total score provided:

ORSQ1–ORSQ4 = blank
Total_ORS   = numeric

SRSQ1–SRSQ4 = blank
Total_SRS   = numeric

OpenFIT will automatically populate:

Q1 = Q2 = Q3 = Q4 = Total / 4

3. Invalid Combinations

The following structures will fail validation and should not be sent:

• Some subscores present and some blank
• Subscores provided with a total score
• Zero used as a placeholder for missing values
• Any structure outside Formats A or B