Joripo Desktop

Joripo Desktop is a Windows app that keeps a copy of a workspace's forms, submissions and attachments on your computer, and exports them without a connection. Its exports are the console's own: the same WIDE CSV, Stata do-file, .dta and .sav, made by the same code.

Install it

Open /desktop on this server and download the installer. It installs for you only, without administrator rights, on Windows 10 or 11 (64-bit). The installer is not code-signed yet, so Windows may say Windows protected your PC: choose More info, then Run anyway.

When this server offers a newer version, Joripo Desktop says so. Install it over the old one: your settings, sign-ins, history and study folders stay. Uninstalling removes the program and its scheduled syncs, never your data.

Owners, managers and reviewers can connect Joripo Desktop. In the app, choose Sign in with the browser and enter this server's address. Your browser opens the /device page: sign in as usual and confirm the code the app shows. Your password never passes through the app.

Signing in in the app itself with your password, or with a personal token, works too; the eye button beside the field (Show password, Show token) shows what you typed.

Each computer you connect is listed on Your account under Connected computers, with a Revoke button. Signing out in the app also disconnects it here; if the app cannot reach the server at that moment, it tells you to revoke it on that page.

Workspaces and study folders

Each workspace you copy gets a study folder on your computer, by default Documents\Joripo\<server> - <workspace>. The data is kept in data\FORMID - <form ID>, with the exports beside it.

Sync downloads only what is new or changed: new and edited submissions, attachments (checked against their sha256), every form version, the form's media, and the server datasets the forms use.
A submission removed on the server is marked, never deleted from your computer.
Export only makes the files again from the copy, with no connection.

Exports

The files are named <Form title>_WIDE.csv, import_<form ID>.do, and on request .xlsx, .dta and .sav, the long format, and an export report PDF. Attachments go to a media folder and the CSV cells say media\<file>.

Further options, all off by default:

choice labels instead of the values, or both (a <field>_label column after each choice question);
a code for questions never shown (. or a number such as -999), while a question shown and left blank stays blank;
leave out calculated fields;
a KML file of the GPS answers, for Google Earth.

Run on a schedule

On a workspace's page, Run on a schedule creates a Windows scheduled task that syncs and exports every N minutes, every hour or every day, even with the app closed. It also runs on battery, and a run missed while the computer was off or asleep starts as soon as it is back.

Old SurveyCTO data

Open a SurveyCTO folder exports a SurveyCTO Desktop folder with Joripo's export engine, with the form's XLSForm if you have it, or from the form definition SurveyCTO Desktop kept in the folder. The SurveyCTO folder itself is never changed.