Import and export

Excel export

The current object selection as an Excel workbook, with embedded images. You open the export in the sidebar under Data In- & Export, section Export, Excel Tables.

Excel export in Moliri, Presets tab: the saved presets Leihliste (loan list, 11 fields) and Versicherungsliste mit Bild (insurance list with image, 7 fields), each with Load preset, Add fields and Remove fields; on the right the loaded fields of the loan list such as Inventarnummer, Objekttitel, Urheber, Leihgeber, Leihstatus, Leihbeginn and Leihende, each with group and output form; at the bottom the switches for colours, comments, source and events, and the image size.

Presets tab with the loan list loaded

Field selection

AreaContent
Available fieldsAll fields of the project, ordered by field group and searchable
PresetsSaved field selections, see below
Selected fieldsThe columns in export order. Change the order by dragging

Load view fields sets the selection to the fields of the current view.

For some fields you can choose further columns besides the field value, such as the identifier (id) of a file field instead of the image, or for a geolocation field the Map at a particular zoom level.

Virtual fields go into the spreadsheet with their computed value, formatted text as plain text.

Annotations and events

OptionEffect
Export colorsColour markings as cell colour
Export commentsField comments as cell comments
Export sourceSource references of the fields
Events (separate sheet)The objects’ events on a second sheet, with type, title, participants, role, location, period, description, note and source

Colours and comments have a counterpart in the Excel import .

Images

SettingValues
Image sizeEdge length of the embedded images. Applies to all image columns
MarkingsField · Image · None
CropField · Image · None
RotationField · Image · None

Field uses the editing stored on this object’s image field, Image the editing stored on the file, None the unedited image. The default is Field.

Duplicate adds another column for the same image with its own settings. That way the original and the edited version stand side by side.

Selected fields area in Moliri's Excel export: the title image twice, once with markings and crop from the field, and in the duplicate with markings None and crop Image

Raw or formatted

Fields with a formatting (output formatter) offer a choice of Output per column:

OutputResult
RawThe stored value, for a JSON field for example {"Objekt":{"hoehe":"118,5"}}
Formatted or the name of a formattingThe readable value, for example Objekt: 118,5 × 64 cm

If a field has several formattings, all of them are offered. The header row names the chosen formatting. Together with Duplicate you can output several versions side by side. The choice is saved with the preset.

Citations

An object field that points to literature can be output as a Short citation or Full citation, and so can a link column such as dokumentiert in (documented in). If such a column is in the selection, the dialog shows the Citation style section. Without a choice of your own, the style at the object field or that of the instance applies (As at the field or in the instance). See Citation style .

The citations are computed by the instance’s citation service. If it cannot be reached, the workbook holds only the titles, and the dialog tells you so after the export.

Presets

ActionEffect
Save current selection as presetSaves the chosen fields under a name
Load PresetReplaces the current selection
Add fieldsAdds the preset’s fields to the current selection
Remove fieldsTakes the preset’s fields out of the current selection
Make preset available to all usersShares the preset. The list shows Private or Shared and who created it

Presets can be used in other projects. Fields that do not exist there are left out.

Progress

The file is built on the server in three phases: Fetching data, Building sheet & embedding images, Finalizing. With many images the second phase takes longest; it goes faster with a smaller image size.

An export with image or map columns runs as a job on the server, without a time limit, even with thousands of images in several sizes. Until a background service takes it, it shows Queued; exports go ahead of running uploads. Once the file is ready, the browser downloads it.

You can cancel the export or let it run on with Continue in background; the finished file is then ready for download under Tasks. It is called export.xlsx. Keep Moliri open until the export is done: after reloading the page the file no longer arrives.

Further reading