Data Source | Default Extension | Description |
---|---|---|
CSPro DB | .csdb | Cases are stored in a SQLite database in a relational format. This data source has the most functionality and you are encouraged to use it when possible. |
Encrypted CSPro DB | .csdbe | A version of the CSPro DB data source that supports AES-256 encryption. |
Text | .dat | Cases are represented as text lines, with one record per line, one case following another in the file. |
JSON | .json | Cases are represented in JSON as an array of case objects. |
None | — | A data source, not associated with any file, that does not contain any data. |
In-Memory | — | A data source, not associated with any file, that stores cases in memory for the duration of the running application. |
Data Source | Default Extension | Description |
---|---|---|
Comma Delimited (CSV) | .csv | Cases from a single record are written to a comma-separated values file. |
Semicolon Delimited | .skv | Cases from a single record are written to a semicolon-separated values file. |
Tab Delimited | .tsv | Cases from a single record are written to a tab-separated values file. |
Excel | .xlsx | Cases are written to a Microsoft Excel file. |
R | .RData / .rda | Cases are written to a R Data file that can be read in R. |
SAS | .xpt | Cases are written to a SAS Transport file that can be read in SAS. |
SPSS | .sav | Cases from a single record are written to a SPSS Statistics Data file that can be read in SPSS. |
Stata | .dta | Cases from a single record are written to a Stata Data file that can be read in Stata. |
CSPro Export | — | A data source that wraps another data source, allowing you to restrict what records are written. |
Feature | CSPro DB | Encrypted CSPro DB | Text | JSON | None | In-Memory | Comma Delimited | Semicolon Delimited | Tab Delimited | Excel | R | SAS | SPSS | Stata |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Reading cases | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Writing cases | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
Notes, case labels, and case statuses | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Storage of more than one kind of record | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✔ | ✔ | ✔ | ✘ | ✘ |
Binary data items | ✔ | ✔ | ✘ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Deleting cases | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Undeleting cases | ✔ | ✔ | ✘ | ✔ | ✘ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Syncing data | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Cases with duplicate keys | ✔ | ✔ | ✘ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Case identification via UUID | ✔ | ✔ | ✘ | ✔ | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Contains an embedded dictionary | ✔ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |
Allows record sorts | ✘ | ✘ | ✔ | ✘ | ✔ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ | ✘ |