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]]
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:
{{-}}
[[File:ExportViewAsSpreadsheet-exampleODSODS-Displayed-in-LibreOfficeCalc-50example-60.png|right|thumb|400px450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Example ODS Spreadsheet - Displayed in LibreOffice Calc]]<!-- from "Events" category "Export View" as "OpenDocument Spreadsheet" named "Export View as Spreadsheet example.ods" then open in libreoffice -->
The example screenshot shows an export to the '''OpenDocument Spreadsheet''' (ODS format) displayed as a Spreadsheet in Libreoffice LibreOffice Calc.
{{-}}
*{{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.
====Style editor dialog====
[[File:StyleEditor-dialog-Description-tab-example-50.png|thumb|right|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Description options tab - Document Styles - dialog - default styles for Ahnentafel Report]]
The {{man label|Style editor}} dialog allow you to customize the document style specific to each report.
Once changes for your custom style have been finalized select the {{man button|OK}} button to save the changes or {{man button|Cancel}} to exit.
=====Style editor dialog tabs=====
On the left hand side you will see the {{man label|Style}} column that list the paragraph options specific to that report that you may modify. For example the {{man label|[[Gramps_6.0_Wiki_Manual_-_Reports_-_part_6#Ahnentafel_Report|Ahnentafel Report]]}} shows the style options for <code>AHN-Entry</code>, <code>AHN-Generation</code> and <code>AHN-Title</code>.
[[File:StyleEditor-dialog-Description-tab-example-50.png|thumb|right|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Description options tab - Document Styles - dialog - default styles for Ahnentafel Report]]
*{{man label|Description}} : The description tab describes what each paragraph is all about. For example shown here is the style used for the Ahnentafel Report ( <code>AHN-Entry</code> ) with the description: ''The basic style used for the text display.''
{{-}}
[[File:StyleEditor-dialog-FontOptions-tab-example-50.png|thumb|right|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} "Font options" tab - "Style Editor" dialog for "Document Styles" (default styles for Ahnentafel Report)]]
*{{man label|Font options}} : Here tab allows you can to set the {{man label|Type face}} ''Roman'' or ''Swiss'', the {{man label|Size}} of the font in pt.(point), the {{man label|Color}} of the font and some {{man label|Options}} like ''Bold'', ''Italic'' or ''Underline''.
{{-}}
[[File:StyleEditor-dialog-ParagraphOptions-tab-example-50.png|thumb|right|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} "Paragraph options" tab - "Style Editor" dialog for "Document Styles" (default styles for Ahnentafel Report)]]
*{{man label|Paragraph options}} : Here tab allows you to set the {{man label|Alignment}}, the {{man label|Background color}}, {{man label|Indentation}}, {{man label|Spacing}} and {{man label|Borders}} of your style.
{{-}}
A selector dialog is one in which a list is provided with some buttons and a filter search box at the top. Typically, the list is related to category objects? -->
Selector dialogs are ??? a combo interface box and you generally use then to ??? and select an object (Person/Family/Events etc). Also various {{man label|Selectors}} also have search bars:<!-- 14 entries in user manual index -->
* [[Gramps_6.0_Wiki_Manual_-_Categories#Select_Family_selector|Select Family selector]]
* [[Gramps_6.0_Wiki_Manual_-_Entering_and_editing_data:_detailed_-_part_1#Select_Event_selector|Select Event selector]]
The name format, grouping and sorting can be overridden for selected individuals and surnames. The Edit Person dialogs have two Edit buttons to access this feature. The button for Preferred name is to the right of the Suffix field. However, for any selected Name (Preferred or Alternative) in the Names tab which opens the Name Editor. The built-in and custom Display Name formats can be selected exceptions to "Group as:" and "Sort as:" options that default to the Name format selected in Preferences.
=== Pick a Color selector ===<!-- rename as https://en.wikipedia.org/wiki/Color_picker mentions "A color picker (also color chooser or color tool)" but no search shows "selector" -->
The [[Gramps_6.0_Wiki_Manual_-_Settings#Colors|Colors]] tab of the Preferences allows customizing of the color of various elements of diagrams in the Charts category's graphical views.
** [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-->
|-