Export/Import

Export

The user can select any table from the database to export by clicking on the top-left dropdown of FRACAS > FRACAS > Export.

../_images/fracas_export.PNG

As it can be seen in the image above, the user can select the columns/fields to export by clicking on the corresponding checkboxes. The chosen options are then saved for a user so that, on the next export, the fields are directly checked. Finally, it is important to highlight that the user can also select all the fields of a given group of fields, such as a part or an aircraft.

The available formats to export are:

  • CSV, for simple comma-delimited file

  • Excel (.xlsx), in which some formatting is preserved

Import

Similarily to the export, the user can import data to nearly any table of the database. To do so, select the proper project in FRACAS > FRACAS > Import, select the file via a Windows’ file dialog and specify how the CSV is delimited (comma or semicolon).

Then, the user can select the table to import and link each column of the CSV file to a column of the database table. There is also an option to do so automatically (“Autocomplete”) based on the matching of the words. To facilitate the task, the user can also show the first rows of the file to import. Finally, it is possible to only import a specific range of rows.

../_images/fracas_import.PNG

Warning

For tables which depend on entries from other tables (e.g. the defect table which depends on part entries), Robin tries to get that depending entry from the database with the unique combination of fields. If that entry does not exist, Robin creates the entry on the depending table.