Addon:SQLite Export Import
This is a Third-party Addon. Please use carefully on data that is backed up, and help make it better by reporting any comments or problems to the author, or issues to the bug tracker |
This a pair of addons that are used together and do not provide generic SQL support for import from an unknown format. See: 11447 |
A Gramps SQLite exporter and SQLite importer that can export most of the Gramps genealogical data.
SQL stands for "Structured Query Language" and is pronounced "sequel" (it is a joke: as it came after QUEL, it is its sequel). SQLite is a common local database format
Contents
Installation
Install both the SQLite Export & Import addons.
Usage
Export SQL
You can export most of the Gramps genealogical data through an SQL Export using the Export Assistant. This does not export other Gramps data, such as bookmarks, researcher information, etc.
- From the menu select: Family Trees > Export...
- From the Saving your data wizard dialog select Next
- From the Choose the output format wizard dialog select the SQLite Export option and then select Next twice
- From the Select save file wizard dialog either name the file and default location or change it and then select Next
- From the Final confirmation wizard dialog select Apply and then Close
Import SQL
You can also import via SQL import.
- It is recommended that you create an new Family Tree before import.
- From the menu select: Family Trees > Import...
- From the Import Family Tree file dialog selector, select your previously created SQL file (eg:
Untitled_1.sql
) and then select the Import button
Using export with external programs
After you use the SQL Exporter to export your Gramps data into a file such as Untitled_1.sql
, you can then use SQL queries like:
$ sqlite3 Untitled_1.sql SQLite version 3.5.9 Enter ".help" for instructions sqlite> .tables dates family names people repository events media notes places sources sqlite> .headers on .headers on sqlite> select * from people; handle|gramps_id|gender|death_ref_index|birth_ref_index|change|marker0|marker1|private b247d7186567ff472ef|I0000|1|-1|-1|1225135132|-1||0 sqlite> select * from names where surname like "%Smith%"; private|first_name|surname|suffix|title|name_type0|name_type1|prefix|patronymic|group_as|sort_as|display_as|call 0|Test|Smith|||2|||||0|0| sqlite> .exit $
See also
- GEPS 010: SQL Backend
- Gramps_SQL_Database#Older_version
- 11447 sqlite3.DatabaseError: file is not a database
- 9148 Sqlite export followed by re-import not idempotent