Convert SQLITE to POR
Turn SQLITE files into POR files. An SPSS portable file in ASCII.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SQLITE files on the dialor turn it to pick what to do
One SPSS file for each table in the database.Each table becomes its own POR file, with numbers, dates and text typed to match.
What you get
An SPSS Portable file in ASCII for every table in the SQLite database. Each file is named after its table, and the files are written in table name order. Views are skipped.
Integers and reals become numbers. Columns declared DATE or TIMESTAMP become dates and date-times. NULL becomes system-missing.
How values change
Text columns stay text, even when they hold dates. Blobs become escaped text. A table with text stored in a number column is written as text.
Column names become SPSS names of up to 8 capital letters, digits and underscores. When a name changes, the original is kept as its variable label.
Dates are written as DATE11, date-times as DATETIME20 and times as TIME8.
What gets lost
Characters outside ASCII become ?. Text longer than 255 characters is cut.
To combine several databases before converting, you can merge SQLITE first.
SQLITE and POR.What each format is.
The formats
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
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
In your code.The same SQLITE to POR conversion through the API, for your app or your agent.
$ cv convert report.sqlite report/ --to por$ cv convert report.sqlite report/ --to porQuestions.What people ask about SQLITE to POR.
One file for each table, named after the table. Views are skipped.
They become SPSS names of up to 8 capital letters, digits and underscores. If a name changes, the original is kept as the variable label.
Columns declared DATE or TIMESTAMP become dates and date-times. Text columns stay text, even when they hold dates.
Characters outside ASCII become ?. Text longer than 255 characters is cut.