Difference between revisions of "Addon:SQLite Export Import"
| Line 1: | Line 1: | ||
{{Third-party plugin}} | {{Third-party plugin}} | ||
{{out of date|can not find in gramps trunk, because it was a plugin}} | {{out of date|can not find in gramps trunk, because it was a plugin}} | ||
| − | |||
| − | SQL stands for "Structured Query Language" and is pronounced "sequel" (it is a joke: as it came after QUEL, it is its sequel). After you export your Gramps data into a file such as ''Untitled_1.sql'' | + | A Gramps exporter and importer has been developed in [https://github.com/gramps-project/addons-source/blob/master/Sqlite/ master/Sqlite]. |
| + | |||
| + | 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. | ||
| + | |||
| + | You can also import via SQL import. | ||
| + | |||
| + | |||
| + | SQL stands for "Structured Query Language" and is pronounced "sequel" (it is a joke: as it came after QUEL, it is its sequel). | ||
| + | |||
| + | ==Using export with external programs== | ||
| + | After you use the SQL Exporter to export your Gramps data into a file such as <code>''Untitled_1.sql''</code>, you can then use SQL queries like: | ||
<pre> | <pre> | ||
Revision as of 22:11, 2 January 2016
|
This is a Third-party Addon. The Addon/Plugin system is controlled by the Plugin Manager. Please use carefully on data that is backed up, and help make it better by reporting any issues to the bug tracker. |
|
|
This page's factual accuracy may be compromised due to out-of-date information. Please help improve the Gramps Wiki as a useful resource by updating it. |
A Gramps exporter and importer has been developed in master/Sqlite.
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.
You can also import via SQL import.
SQL stands for "Structured Query Language" and is pronounced "sequel" (it is a joke: as it came after QUEL, it is its sequel).
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 $
