11,036
edits
Changes
m
→Database Settings
{{-}}
======Help Reference======
<!-- [[File:xxx.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} xxx]]-->
Display Name Help Reference:
======Display Name list======
<!-- [[File:xxx.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} xxx]]-->
In this section you can add, remove or edit existing name formats as well as see an example of the formatted name.
See:
* [https://gramps-project.org/bugs/view.php?id=1715 feature request to support other local variations for surname guessing]
* [https://wikipedia.org/wiki/Category:Names_by_culture Names_by_country Category:Names by culturecountry], From Wikipedia, the free encyclopedia* [https://wikipedia.org/wiki/Category:Names_by_language Category:Names by language], From Wikipedia, the free encyclopedia}}
*{{man label|Default family relationship:}} - used by the {{man label|[[Gramps_6.0_Wiki_Manual_-_Entering_and_editing_data:_detailed_-_part_1#Family_Editor_dialog|Family Editor]]}} dialog.
*{{man button|Close}} - exit for this session until the Gramps program is restarted.
[[Category:Tips]]
<!-- 20232025/0912/08 28 List of 73 Tips are stored here https://github.com/gramps-project/gramps/blob/maintenance/gramps52master/data/tips.xml -->
{{-}}
*{{man label|Database backend:}} -
** '''[[Gramps_Glossary#sqlite|SQLite]]''' (''default'') - the [[DB-API Database Backend]]
** ... If other When multiple database backends addons are installed, they will be added to the included in this list . <br /><abbr title="exempli gratia - Latin phrase meaning 'for example'">e.g.</abbr>backends: [[Addon:PostgreSQL|PostgreSQL]] , SharedPostgreSQL, MongoDB. This menu can be trimmed by 'hiding' the unwanted database backends in the Plugin Manager. {{man tip|Converting Trees from the retired BSDDB backend|The BSDDB backend developed incompatibilities as Python libraries evolved. That backend choice (as ''default'') was supseded with SQLite in Gramps 5.2 and has been retired (to read-only status) as of the Gramps 6.0 release. <br /><br />Although BSDDB '''''was''''' the default backend default in Gramps 2.0 through Gramp 5.1, all Gramps Trees should be converted another database backend at the earliest opportunity.<br /><br />'''[[Gramps_6.0_Wiki_Manual_-_Manage_Family_Trees#Backing_up_a_Family_Tree|Make a backup]] before any critical change.'''<br /><br />To convert a Tree, first select the target database backendin Preferences, then use the '''Convert''' button for the selected tree in the '''Family Tree ‐> Manage Family Trees''' dialog.}}
See also:
* Addon [[Addon:PostgreSQL|PostgreSQL]] - this adds experimental support for PostgreSQL databases. Recommended for Experts only!
<!--{{man warn|The ''[[Gramps_Glossary#bsddb|BSDDB]]'' - Legacy Database backend was superseded in the Gramps 5.1 version.|Note that BSDDB can be converted only. BSDDB 3 (Read-only for upgrades) <!-- }}find link that mention Gramps 6 does read only conversion of BSDDB databases-->}}
{{-}}
{{-}}
=====Select media directory dialog=====
<!-- [[File:xxx.png|right|450px|thumb|Fig. {{#var:chapter}}. {{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} xxx]]-->
{{stub}}<!--from the directory button above -->
=====Missing Media Objects 'broken link' icon of a box with a red 'x'=====
[[File:BrokenMediaPath-example-60.png|right|450px|thumb|Fig. {{#var:chapter}}. {{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Media object with a broken filepath]]<!-- how was this created ? can the section be renamed to something like "Missing Media Objects" ? with a subheading for the missing red x? -->
If the Preview thumbnails displays 'broken link' icon of a box with a red 'x' you will need to correct {{man label|Base media path:}} for your family tree in the {{man label|[[Gramps_6.0_Wiki_Manual_-_Settings#Family_Tree.27s_Media_path|Family Tree's Media path]]}} section.
=== Sorting columns ===
[[File:PersonView-PeopleListView-example-with-context-menu-60.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} '''Before''' - default sort by "Name" column "People" Category - "Person" (List) View]] [[File:PeopleCategory-PeopleListView-SortedByBirthDateColumn-example-5060.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} '''After''' - Sorted by "Birth Date" column in the list mode of the People Category View - example]]<!-- split into a before and after screenshot of a close up of the column? annotation to remove -->
By default, each Category View presenting data in a columnated table layout will sort the rows in ascending order based on the data in the first (left-most) column. If the table has grouped rows, the grouped data will be sub-sorted. ''(Tables in tabbed subsets of data, Editors and Selectors will work similarly.)''
====Export View as Spreadsheet dialog====
[[File:ExportViewAsSpreadsheet-CSV-file-dialog-example-5060.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} "Export View as Spreadsheet" CSV(default) filefiletype -dialog - example]]<!-- stage screenshot by pasting this filename into field beforehand "enter_export-view-filename-here.csv"-->
Gramps will then display the {{man label|Export View as Spreadsheet}} dialog where after choosing a file location to save to and a name for your file; export data on from the Category List View in one of two spreadsheet formats:
*{{man label|Custom}}
**{{man label|Delimiter:}}
*** '.,' ''comma'' (default)*** ';' ''semicolon''*** ':' ''colon''*** '|' ''bar''
*** 'tab'
===Customize report output formats===
[[File:TextReports-DocumentOptions-section-PlainText-output-settings-50example-60.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Document Options - tab defaults for Text Reports (Plain Text - output selected) example]]
What kind of output customization is available? This dialog allows you to change the fonts, font sizes, font color, background color of the text and alignment of paragraphs on the report.
** [https://gramps.discourse.group/t/macos-and-windows-gtk-file-chooser-dialog-capture-request/3364 Illustrating the File Chooser in the Wiki]
** [https://gramps.discourse.group/t/can-i-cause-folders-to-sort-to-the-top-of-the-list-when-presented-with-the-folder-contents/1708/14 File Chooser: Sorting files and folders]
* [https://discourse.gnome.org/t/where-is-the-filechooser-feature-list/9101/1 Where is the FileChooser feature list?]
=== Language ===
In Windows, use the SET command to change the LANG environment variable to "en_GB.UTF-8" for British English. You can do this from the command line interface or [https://gramps-project.org/bugs/view.php?id=11009 create a startup shortcut with the following Target]:
<code>C:\Windows\System32\cmd.exe /c "SET LANG=en_GB.UTF-8 && START /D ^"C:\Program Files\GrampsAIO64-6.0.35^" gramps.exe"</code>
{{stub}} '''{{man warn|tbd|Describe for each main platform how the normal language is determined and how the user can [[Howto:Change_the_language_of_reports#Run_Gramps_in_a_different_language|choose a different language]].'''}}
{{-}}
{{man tip|You can download a zip file attached to feature request:{{bug|13204}} Gramps AIO64 5X.2 x.x Language icons Shortcuts Pack ( for the 18 languages shown in the [[#Language_codes|Language codes]] table below)}}
{{-}}
|<!--Notes-->
|-
|<!--Language--> Japanese|<!--ISO code--> ja_JP.UTF-8|<!--Example-->%comspec% /c set LANG=ja_JP.UTF-8 && start grampsw.exe"
|<!--Notes-->
|-
|<!--Language--> Arabic (Saudi Arabia)|<!--ISO code--> ar_SA.UTF-8|<!--Example-->%comspec% /c set LANG=ar_SA.UTF-8 && start grampsw.exe"
|<!--Notes-->
|-