DE EN EN (Google)

Export

Basically, you can export all the data you can search from easydb.

Exports are first created in easydb and then executed. After execution, the data is provided for downloading or copied to another server via a transport path (optionally, for example, RSYNC, FTP). The exports are performed asynchronously on the easydb server, since these processes are Much time.

NOTE: Exports can be scheduled with schedules (see below) and then periodically executed by easydb. Thus, for example, Make regular backups of your easydb or perform scheduled data expansions.

Within an export process, you can calculate files of different sizes, export sections from images, and specify a format for export.

Exports can be created via various ways from the easydb:

Create Export

In the upper part of the dialog you can define which files are exported. In the lower part, you specify which data are exported. Records are exported with data as CSV or XML separately from the actual files. If desired, you can also export links to the files in the data.

After the settings, click Export … to create and start the export.

Before the export starts, a message dialog appears in which a name can be entered. For exports with schedules, you must assign a name. For exports without schedules, the name is optional.

Export...

Then click on Save to start the export final.

Files

Here, you select which files you want to export for each object type and field. The name of the file type is displayed after the field name. These numbers only include the preferred versions of the files.

Data Types

Here you decide for each datatype whether the files of this type are considered for the export or not. In addition, the file type can be used to determine which version of the file is to be exported and whether or not there is a size or format adjustment during the export.

The following settings can be made:

General Settings

Setting Declaration
Original No No original file is exported.
Original Only the original will be exported.
Actual Original This is the preferred visible version of the file. For example, if you rotated or cropped an image, this version is called Current Version, the unaltered image is called Original. For files that have not been rotated or otherwise modified in the easydb, Current Version and Original are the same
Original + Current version It will be Original and Current original
Variant No No further variant of the file to be exported is calculated for the export.
Pre-calculated variant Here you see a list of pre-calculated variants. Which variants appear here is part of the System Administration Configuration. Depending on the data type, these variants are different. You can select from the list, which variant / size should be exported in addition to the original and / or the current original
Metadata profile The profile used for XML / EXIF ​​/ IPTC writing. Available for the file types Image, Audio, Video
Your own variant For some file types, this setting is available. Depending on the type of file, you can customize the export format
Watermark If set, a watermark is added to the file (only for images). The watermark is set at Pool. Only pictures in a pool can be provided with a watermark. Only available for file type Image
- Unchanged - The file gets the metadata of the original version
- Default - The profile of the pool or object type settings is used here
- Remove - The file is exported without metadata.
<Profile> Specify a profile used for export

Format options for images

Setting Declaration
Format Unchanged The format of the selected version is retained.
JPEG JPEG format with indication of quality Low, Medium, High, Maximum
TIFF TIFF
PNG PNG
BMP BMP
Color Space RGB RGB color space
CMYK CMYK
Grayscale Grayscale
Size Default sizes The list of preset sizes is displayed.
Own … Select this setting to set your own size
Measure long side The dimension is long, for example, 400 pixels and a 800 x 600 large image, the image will be 400 x 300 pixels
short side The pixel specification refers to the short page. For example, 400 pixels and a 800 x 600 large image, the image will be 600 x 400 pixels
Width The pixel value refers to the width of the generated image.
Height The pixel value refers to the height of the generated image.
Pixels Number of pixels for the dimension specification. Note that DPI can not specify DPI for the calculation of dimensions / measures during export. In order to calculate DPI, the target print format must be known. This will then inevitably be converted into pixels again

Format options for videos

No format changes are supported for videos. You can access the pre-produced formats and format conversion using an external program.

Format options for audio

No format changes are supported for audios. You can access the pre-produced formats and format conversion using an external program.

Format options for Office & PDF

Setting Declaration
Format PDF Select this setting to create a PDF from Office documents such as Word, Excel, etc.

Format options for other file types

No format changes are supported for other datatype.

Data

Data

Setting Declaration
Create CSV file Creates a CSV with all data.
Create JSON file Exports the data as JSON (to a file).
One JASON file per record Exports JSON to one file per record.
Create XML file Export the data as XML (to a file)
One XML file per record Exports XML to one file per record.
XML profile - Standard - easydb Standard XML Format
- Standard (flat) - easydb Standard XML Format
<Profil> Uses the specified profile to create the XML.
Select your own fields If you can set your own fields (see field selection)

Field Selection

Normally, all fields are available that are available in the form and are also used in the search for the display (detail view). If you do not want this, or if you want to give the fields their own name, use the field selection dialog.

Fields are exported with your database name, not with the visible field identifier from the form.

*Field Selection*

Select the checkbox for the fields that you want to use in the export. Change the identifier for your export.

The order of the fields can not be changed. The order used by the mask is used.

Linked Object Types

Linked object types can basically be exported to a level, i. A link from the first linked record is not tracked.

Multiple Fields

Multiple fields are exported in standard format. Select the check box next to the multi-field name. If you need to export individual fields, use the checkboxes below the multiple field.

Data Fields

For files, a link can be exported in the data. A link will be displayed for each exported version (Original and Current version). You can set what these links show.

Setting Declaration
URL - No - Is the default. No link is exported.
Original Here you can select the link for the original, the current original or for both versions
Small Yes to export the link to a small version.
Preview Select Yes to export the link to a preview version
Large Yes to export the link to a large version.

Advanced

Advanced

Setting Declaration
Package Size 100 (default) Creates export packages with 100 records each
Unlimited (all in one folder) All records of this export are packed into a folder
Own value Enter your own number for the size per package
Filename Default Template The current name from the default template is used
Original filenames The name of the original file is used.
File name A separate file name can be entered. For this, substitutions can be used, which are also available for the respective object types (see File names for export and download
Substitutions %medien_ab.text2%
%medien_ab.text1%
%medien_ab.text4%
%medien_ab.text5%
%medien_ab.boolean%
%medien_ab.datum1%
%medien_ab.datum3%
%medien_ab.datum2%
%medien_ab.zahl1%
%medien_ab.zahl2%
%medien_ab.lk_systematik_id._standard.1.text%
%medien_ab.ort._standard.1.text%
%medien_ab.fotograf._standard.1.text%
%medien_ab.url%
%medien_ab.link%
%medien_ab.text3%
%medien_ab.medium%
%medien_ab.medium2%
%medien_ab.email%
%medien_ab.nurregexp%
%medien_ab.regexpundhinweis%
%_export.name%
%_system.easydb.name%
%_global_object_id%
%_system_object_id%
%_asset.original_filename%
%_asset.version%
%_asset.class%
%_asset.extension%
%_asset.technical_metadata.width%
%_asset.technical_metadata.height%
%_asset.technical_metadata.max_dimension%
Scope Checkbox With the setting of the checkbox, only new and changed data sets are taken into account for the export.

List of Exports

Exports from the export module can be called up in the upper right via the export manager and the export list can be displayed.

Export manager

The status of a running export is indicated by a small badge in the export manager.

Status Description
Working Exports are waiting to start or are currently running.
Done Exports are finished.
Failed Exports have been terminated due to errors.

The export list shows all exports and failed downloads. If you press the ALT key while opening the export manager, the successful downloads are also included in the list.

Detailed information on the export history can be viewed via the Export Manager

Further information to exporting

Selection Detail Explanation
Export Displays the name of the export or download. When you create an export, you can assign your own name. Exports without names or downloads are displayed consecutively numbered. Further information can be called up via the pull-down menu.
Event protocol A log entry is stored for each event related to the export. The entries can be viewed here.
Transports If there are configured transports for an export, they are displayed here. Under the respective transport, an event log is available, as well as a list of the packaged and sent files.The files are removed when exports have expired. These can be updated by restarting the export.
Files Displays the files or directories for an export (if included) or a download. The files are removed when exports have expired. Next to each file and directory, there are ways to load and view the file.
Download the file to the desktop.
View the file in the browser. If the browser can not display the format itself, the file is loaded. This feature is not available for files larger than 10MB.
Download the file or directory as ZIP.
Timestamp Time of creation for new exports or last run after updates.
Typ Export Regular export.
Export (incremental) Export for which “Export new or modified records only” has been activated.
Download Download of files. Successfully performed downloads will only appear in the list if the Download Manager button is used together with the ALT key.
Status New New export. Appears, for example, for new exports with a schedule that will run for the first time at a defined time.
Done Export was successful. It may appear with a warning. The warning details can be viewed in the event log.
Processing Export is currently in progress.
Updated Export has been modified or restarted. The timestamp shows the new run.
Error The export failed. Details can be found in the event log.
Expired The export is no longer valid. To make it available again, it needs to be restarted. By default, exports expire after 3 days. The expiry time can be adjusted by the easydb administrator via the Server-Config

Various functions are available for each export.

Function Description
Loads the export as a zip file to the local computer.
The export is transferred to the search bar and the search is started. This allows you to display the records that are currently being found for the export.
To adjust the Export settings (format, data, etc) open the Export Dialog.
To adjust the Time plan, open the Time plan Dialog.
To adjust the Transport, open the Transport Dialog.
Click here, to manually start an export.
Click here, to stop a running export.
Click here, to delete an export.

Schedule

Time schedules ensure that the defined export is carried out regularly. For example, you can define a search, which then regularly causes an export once a week. To do this, click on to view the schedule.

Schedules also work the same as scheduling user. You can choose from the presets a schedule for the schedule or define your own schedule. In the example, the export is executed every 12th of the month, when it is a Monday at 3pm.

NOTE: If no exact times are set for the schedule, the export takes place at a certain point in time. This is then specified by the system and can differ per configuration.

Time plan for Exports

Setting Description
Download the file to the desktop.
View the file in the browser. If the browser can not display the format itself, the file is loaded. This feature is not available for files larger than 10MB.
Download the file or directory as ZIP.

NOTE: Exports are based internally on searches, that is, If you use time schedules, the exported records may differ after each execution, since a current search is carried out before the respective export process.

Transport

Exports require a transport so that the exported files can be externally accessed. Without transport, you can only access the exported files using the Detailed List in * Export List *. For example, a transport can provide a download or copy files to remote servers via RSYNC or FTP.

Click on to access the transport dialog.

Transports for export

Setting Explanation
Type Download This transport provides files for external download. Upon request, an e-mail is sent to configured recipients after export
FTP Transport to a server via FTP.
Wordpress Transport sends files to Wordpress. A timetable can be created for regular transports.
Falcon.io Transport sends files to Falcon.io. A timetable can be created for regular transports.
Options For RSYNC and FTP server, optionally a directory, login and password can be configured
Compression zip - unlimitert The files are packed into a ZIP
zip - 2GB The files are packed in a maximum of 2 GB ZIP. If necessary. Several ZIP archives are created. If a single file is larger than 2GB, the ZIP for this file will also be larger
Zip - 10MB How zip - 2GB but with the size of 10 MB per file.
tar.bz2 The files are packed into a TAR archive that has been compressed with BZ2
The recipient of the e-mail. Use and to customize the list. You can create e-mail users in addition to Users and Groups. How to do this is under folders / share.
message In addition to the easydb standard text, you can also write your own text in an e-mail to the recipients