15,534
edits
Changes
m
{{grampsmanualcopyright/fr}} {{man index/fr|Gramps_3Gramps_5.4_Wiki_Manual_0_Wiki_Manual_-_Manage_Family_Trees#Importing_Data/fr#Importation_des_donn.C3.A9es|Gramps_3Gramps_5.4_Wiki_Manual_0_Wiki_Manual_-_Manage_Family_Trees#Exporting_Data_Probably_Alive/fr|35.40}}
This {{man warn|Note|'''Ce format allows you to import/de table ne permet pas d'exporter 100% export a spreadsheet of data all at oncedes données Gramps. The spreadsheet must be in the Comma Separated Value ''' Il ne fait qu'exporter (et importer) un ensemble de données, type : individus (nom et genre), naissance, baptême , décès, et inhumation dates/lieux/sources, mariages (dates/lieux/sources) et relations (CSVparents et enfants) format. Most spreadsheet programs can read and write this format. It is also easy to write by hand. This is the only GRAMPS import format which allows for merging with existing dataLes notes ne sont pas exportées, mais de nouvelles notes peuvent être ajoutées à la fin de notes existantes.}}
NOTE: '''This spreadsheet format does not allow for 100% export of GRAMPS dataLes sources sont référencées par leur texte du titre.Vous pouvez ajouter des détails supplémentaires à une nouvelle source après l''' It only exports (and imports) a subset of data, namely: people (names and gender), birth, baptism, death, and burial dates/places/sources, marriages (dates/places/sources) and relationships (parents and children). Notes are not exported, but new notes are appended onto the end of existing notesimportation.
'''New for Gramps 3.4'''Il y a trois utilisations principales pour ce format : Previously, sources were not exported, but now they are. Sources are referred to by their title text. You can add further details to a source after importing.
There # Vous pouvez exporter vos principales données Gramps dans un format type tableur, éditer le texte ou utiliser une programme type tableur, et importer les changements et ajouts dans Gramps. This is handy for sending to others to fill in, or for taking on the road when you don't have your full gramps application.# Vous pouvez importer de nouvelles données dans une base de données Gramps. Par exemple, if you have a set of new people to add to your database, but don't want to hunt and peck your way to finding where they go, you might find it easier to type them into a spreadsheet, and then quickly suck all of them in at once. This is handy if you have a large amount of data that you are cutting and pasting from another application or the web. Un exemple étant l'action de [[Narrative_Website_Import|restaurer votre base de données]] en chargeant votre site internet Saga dans une table.# Vous pouvez également importer un ensemble de corrections et d'ajouts. Say that you have printed out a report, and you are three main uses for this format:going through it marking corrections. If you make each correction a section of a spreadsheet, you can "script the edits" and then execute them all at once.
# You can export your core gramps data into a spreadsheet format, edit it with a text or spreadsheet program, and import the changes and additions back into gramps. This is handy for sending to others to fill in, or for taking on the road when you don't have your full gramps application.# You can import new data into your gramps database. For example, if you have a set of new people to add to your database, but don't want to hunt and peck your way to finding where they go, you might find it easier to type them into a spreadsheet, and then quickly suck all of them in at once. This is handy if you have a large amount of data that you are cutting and pasting from another application or the web. An example of this is [[Narrative_Website_Import|restoring your GRAMPS database]] by loading the Narrative Website into a spreadsheet.# You can also import a set of corrections and additions. Say that you have printed out a report, and you are going through it marking corrections. If you make each correction a section of a spreadsheet, you can "script the edits" and then execute them all at once.== Exportation ==
== Export ==Pour exporter votre base de données :
To export your database:# Démarrez Gramps# Sélectionnez "Exporter" depuis le menu 'Arbres Familiaux'# Sélectionnez le format "Tableur séparé par des virgules (CSV)"
# Start gramps# Select "Export" from the File menu# Select "Comma Separated Values Spreadsheet (CSV)"{{stub|fr}}
'''New for Gramps 3.4:''' baptism and burial data is now added to import and export:
;HINT: {{man note|Open/Libre Office allows you to turn off autoformatting when you open the vous permettent de désactiver le formatage automatique quand vous ouvrez un fichier CSV file. If you don't do this|Si vous ne le faites pas, alors Open/Libre Office may interpret the peuvent mal interpréter ces dates incorrectly. Change the Changez le type of the column to Text rather than de colonne pour Texte plutôt que Standard. If your spreadsheet program doesn't allow you to format the fields before you get it into columns Si votre programme de tableur ne permet pas cela (egpar exemple, Excel) you need to change the display , alors vous devrez changer l'affichage du format of des dates in GRAMPS before you exportdans Gramps avant d'exporter vos données. You can do this under Edit Vous pouvez le faire depuis le menu {{man menu|Éditer -> Preferences Préférences -> Display Affichage -> Date Formatde date.}}}}
'''New for Gramps 3.4:''' baptism and burial data is now added to import and export:
Protected "Fr:Manuel wiki pour Gramps 5.0 - Importation et Exportion CSV": manual rolled over for Gramps 5.1.x ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))
{{languages|Gramps_3Gramps_5.4_Wiki_Manual_0_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export}}
{{stub|fr}}
== Importation/Exportation du tableur Gramps Spreadsheet Import/Export ==Ce format vous permet d'importer et d'exporter une table avec des données en une seule fois. La table doit être dans un format séparé par des virgules (CSV). La plupart des programmes type tableur peuvent lire et écrire ce format. Il est également simple de l'éditer à la main. C'est le seul format d'importation Gramps qui permet la fusion des données existantes.
A selected set of fields of your genealogy data will be saved to a .csv file in the format described below. In addition, the people and familes are referenced so that the data can be edited and read back in, thereby updating the database.
There are some columns that will be blank, specifically note and source columns. These are listed in the spreadsheet so that you can make notes for the import, but notes are never exported with this tool. '''Gramps 3.4 3 now exports source titles; previously no source data was exported.'''
Your data is broken up into three sections representing individuals, marriages, and children. The exported fields and column names are:
;Families: Family, Child
;Individuals: Person, Lastname, Firstname, Callname, Suffix, Prefix, Title, Gender, Birthdate, Birthplace, Birthsource, Baptismdate, Baptismplace, Baptismsource, Deathdate, Deathplace, Deathsource, Burialdate, Burialplace, Burialsource, Note
The first column in each area is the gramps ID. That is what will tie your edits back to the correct data, so don't alter those data. Load this file into your favorite spreadsheet using comma separated, double-quote text delimited, and Text format (any encoding for now). Then you can add or correct data, and save it back out, keeping the same format. You can then import the data back ontop of your old data and it will be corrected.
== Import Importation ==
To import your data:
The merge part of this code will only add or update information to your database, and it always assume that the spreadsheet data is the correct version.
If you load this spreadsheet into Open/Libre Office, make sure you select each column as type '''Text''' rather than '''Standard'''. Standard will reformat your dates and numbers. Also, if you use Excel, you will probably want to select all cells once opened, and change the format of the cells to '''Text'''.
The spreadsheet is data made up of columns. Each column should have at the top of it the name of what type of data is in the column. You must use special names for the columns. Currently they are:
=== People Individus ===
<pre>
person - a reference to be used for families une référence à utiliser pour les familles (marriagesmariages, and childrenet enfants) grampsid - to assign a gramps pour assigner un identifiant id to the personGramps à l'individufirstname - a personle prénom de l's first nameindividusurname/lastname - a personle nom de famille de l's last nameindividucallname - a common name un nom commun, usuel (nicknameou surnom) for the personpour l'individuprefix - surname prefix le préfixe du nom de famille (von, de, etc)suffix - a suffex of a person's name le suffixe (Jr., Sr.)title - a personle titre de l's title individu (Dr., Mr.)gender - male or female masculin ou féminin (you should use the translation for your languagevous devez utiliser votre traduction)note - a une note for the personpour l's recordenregistrement de cet individu
birthdate - date of birth
birthplace - place of birth
deathcause - cause of death
</pre>
<pre>
</pre>
=== Marriage Mariage ===
<pre>
</pre>
=== Family Famille ===
<pre>
</pre>
== Details Détails ==
Case doesn't matter. Notice that the names don't use underscores in them. You may use any combination of these, in any order. (Actually, you have to at least have a surname and a given name when defining a person, and you have to have a marriage and child columns when defining children, but that is it.) The column names are the English names given (for now) but the data should be in your language (including the words "male" and "female").
Here is an example spreadsheet in Open/Libre Office, but any spreadsheet program should work.
[[ImageFile:Test.csv-csvLibreOffice-Calc-50.jpgpng]]
Notice that the data need not begin in the first column, nor in the first row.
And here is the resulting data in gramps:
[[ImageFile:ScreenshotFamilyTree-1example-imported-test.csv-50.jpgpng]]
Here is an example of a CSV text spreadsheet with multiple areas:
Finally, this also creates a person named Timothy Jones who is not related to anyone.
=== Real world example Exemple du monde réel ===
In this example, I had an entire generation to enter, 16 names with marriage dates. The children I already had in the database. I entered them into Open/Libre Office:
[[ImageFile:Gen5Gen4-spreadsheettest.jpgcsv-LibreOfficeCalc.png]]
Notice that you can use numbers or strings as the reference names between areas. In the person area, I used the numbers 1 through 16. That made it easy to refer to them in the second area of marriages. The marriages are labeled with the letters A through H.
==== HINT ATTENTION ====
Open/Libre Office allows you to turn off autoformatting when you open the CSV file. If you don't do this, Open/Libre Office may interpret the dates incorrectly. Change the type of the column to '''Text''' rather than '''Standard.''' If your spreadsheet program doesn't allow you to format the fields before you get it into columns (eg, Excel) you need to change the display format of dates in gramps before you export. You can do this under Edit -> Preferences -> Display -> Date Format.
Saving as CSV and importing into gramps produces the far right-hand column in the tree:
[[ImageFile:Gen5Gen4-csv-import-gramps-50.jpgpng]]
{{man index/fr|Gramps_3Gramps_5.4_Wiki_Manual_0_Wiki_Manual_-_Manage_Family_Trees#Importing_Data/fr#Importation_des_donn.C3.A9es|Gramps_3Gramps_5.4_Wiki_Manual_0_Wiki_Manual_-_Manage_Family_Trees#Exporting_Data_Probably_Alive/fr|35.40}}
{{grampsmanualcopyright/fr}}
[[Category:Fr:Documentation|MC]]
