Convert POR to SQLITE
Turn POR files into SQLITE. A SQLite database with one table named data and one column per variable.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop POR files on the dialor turn it to pick what to do
Your SPSS data as a SQLite table.One table named data, one column per variable.
What you get
A SQLite database in one file. It holds a single table named data, and each variable in the POR file becomes a column. Variable names, numbers and text are kept as stored.
Numeric variables shown without decimals become integer columns when every value is whole. Other numbers become doubles, and text variables become text columns. Missing numbers are left NULL.
Dates and times
SPSS date, time and date-time formats become dates and times in the table. They are stored as text, such as 2024-02-03 for a date and 2024-02-03 09:15:00 for a date-time.
What it leaves behind
Variable labels, value labels and missing-value definitions are dropped. A code such as 9 for no answer stays an ordinary value in its column, so you need to handle it yourself in your queries.
Only the data comes across. The descriptive text that SPSS attaches to variables and values is not in the database.
POR and SQLITE.What each format is.
The formats
SPSS Portable
SPSS portable files, the plain-text exchange format of older SPSS versions and PSPP.
- Extensions
- .por
- MIME type
- application
/x -spss -por - Kind
- Text and data
SQLite Database
A whole relational database in one file. Tables, indexes and views.
- Extensions
- .sqlite .sqlite3 .db
- MIME type
- application
/vnd .sqlite3 - Kind
- Text and data
In your code.The same POR to SQLITE conversion through the API, for your app or your agent.
$ cv convert report.por report.sqlite$ cv convert report.por report.sqliteQuestions.What people ask about POR to SQLITE.
The table is named data. It is the only table in the file.
One file. The whole database is a single SQLite file.
No. Value labels are dropped, so a coded answer stays as its stored number or text.
As text. A date looks like 2024-02-03, and a date with a time looks like 2024-02-03 09:15:00.