Importation et exportation des données

Although Ghini can be extended through plugins to support alternate import and export formats, by default it can only import and export comma separated values files or CSV.

Il y a un support pour exporter vers l’accès pour les données de Collections biologiques, il est limité.

Il y a également une prise en charge limitée pour l’exportation vers un format XML qui reflète plus ou moins exactement les tables et la ligne de la base de données.

Les renouvellements ne sont pas couverts.

Avertissement

Importation de fichiers va très probablement détruire toute donnée que vous avez dans la base de données afin de s’assurer que vous avez sauvegardé vos données.

Importation de CSV

En général, il est préférable d’importer les fichiers CSV dans Ghini précédemment exportés de Ghini. Il est possible d’importer un fichier CSV, mais qui est plus avancé que ce doc couvrira.

To import CSV files into Ghini select Tools‣Export‣Comma Separated Values from the menu.

Une fois cliqué sur OK dans la boîte de dialogue, qui demande si vous êtes sûr que vous savez ce que vous faites, un sélecteur de fichier s’ouvre. Dans le sélecteur de fichier, sélectionnez les fichiers à importer.

Chargement en cours

To export the Ghini data to CSV select Tools‣Export‣Comma Separated Values from the menu.

This tool will ask you to select a directory to export the CSV data. All of the tables in Ghini will be exported to files in the format tablename.txt where tablename is the name of the table where the data was exported from.

Importation de CD

This is the way to import data into an existing database, without destroying previous content. A typical example of this functionality would be importing your digital collection into a fresh, just initialized Ghini database. Converting a database into bauble json interchange format is beyond the scope of this manual, please contact one of the authors if you need any further help.

À l’aide du format d’échange de Ghini json, vous pouvez importer des données que vous avez exporté à partir d’une installation de Ghini différente.

Exporting to JSON

This feature is still under development.

_images/export-to-json.png

when you activate this export tool, you are given the choice to specify what to export. You can use the current selection to limit the span of the export, or you can start at the complete content of a domain, to be chosen among Species, Accession, Plant.

Exporting Species will only export the complete taxonomic information in your database. Accession will export all your accessions plus all the taxonomic information it refers to: unreferred to taxa will not be exported. Plant will export all living plants (some accession might not be included), all referred to locations and taxa.

Importing from a Generic Database

This functionality is the object of issue #127, for which we have no generic solution yet.

If you’re interested in importing data from some flat file (e.g.: Excel spreadsheet) or from any database, contact the developers.

Importing a Pictures Collection

We can consider a collection of plant pictures as a particular form of botanical database, in which each picture is clearly associated with one specific plant.

Even without using a photo collection software, you can associate pictures to accessions by following one and the same clear rule when naming picture files.

For example, 2018.0020.1 (4) Epidendrum.jpg would be the name of the fourth picture for plant number 1 within accession 2018.0020, identified to rank genus as an Epidendrum.

The Tools‣Import‣Pictures functionality here described is meant for importing an ordered collection of plant pictures either to initialize a ghini database, or for periodically adding to it.

Use Tools‣Import‣Pictures to activate this import tool. Import goes in several steps: parameter definition; data revision and confirmation; the import step proper; finally review the import log. At the first two steps you can confirm the data and go to the next step by clicking on the next button, or you can go back to the previous step by clicking on the prev button. Once the import is done and you’re reviewing the log, you can only either confirm —or abort— the whole transaction.

In the « parameter definition » pane you: select the directory from which you intend to import pictures; indicate whether to import pictures recursively; select or create a location which will be used as default location for new plants; inform the tool about the rule you’ve been following when naming picture files.

_images/import-picture-define.png

In the « data revision » pane you are shown a table with as many rows as the pictures you are importing. Each row holds as much information as the tool managed to extract from the picture name. You can review the information, correct or confirm, and indicate whether or not the row should be imported.

_images/import-picture-review.png

In the final « commit or rollback » pane you read the logs relative to your data import, and decide whether to keep them (commit them to the database), or undo them (rollback the transaction).

_images/import-picture-log.png

When the Picture Collection importer creates or updates objects, it also sets a Note that you can use for selecting the objects involved in the import, and for reviewing if needed.