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.

  1. 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.

  2. 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.

  3. 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

From · SQLITE

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
To · POR

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.

terminal
$ cv convert report.sqlite report/ --to por
$ cv convert report.sqlite report/ --to por

Questions.What people ask about SQLITE to POR.

01OF 04

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.

More conversions.Other ways in and out of SQLITE and POR.