Asset Exporter

For the most up-to-date documentation, please visit docs.brix.ch

Exports assets in regular intervals to a defined folder. If also metadata has to be exported (as CSV or Excel file) you can use the "Extended Asset Exporter". Now also supports public URLs.

Properties

To be configured in {home}/appserver/conf/custom.properties

General properties

documentExport.license

type: String, required: yes, default: -

license key (delivered by brix IT Solutions)

documentExport.changeDetectionNode

type: long, required: yes, default: -

Defines the ID of the root-node under which for each job a node will be created to collect the changed assets of the job.

documentExport.internalUrl

type: String, required: no, default: -

Rewrites the URLs received from the download request, so that the file can be retrieved directly through the intranet.

documentExport.visibleForGroup

type: long, required: no, default: -

restrict the use of the plugin to this user group ID (superadmins always see it in any case)

documentExport.jobInterruptGraceTimeInMillis

type: int, required: no, default: 3000

grace time before a job thread is killed

documentExport.metadataExportEnabled

type: boolean, required: no, default: yes

Enable or disable the possibility to export metadata of the exported assets (as CSV or Excel file).

documentExport.simulateFileNameResolverAsAssetName

type: String, required: no, default: 1:

shortcut to speed up full exports -> simulate the asset filename resolver format: :,..., e.g. 1:jpg,2:png will assume .jpg when using dlf 1. you can leave empty to use the files original file extension (e.g. for original format

documentExport.customNameResolverFactories

type: String, required: no, default: -

Whitelist for custom name resolvers (inherit by CustomNameResolverFactory), default resolver factories are always available

documentExport.customPathResolverFactories

type: String, required: no, default: -

Whitelist for custom path resolvers (inherit by CustomPathResolverFactory), default resolver factories are always available

documentExport.exportBasePaths

type: String, required: no, default: -

Defines the base baths for the local export locations (comma-separated). If defined, the plugin only allows to export to subfolders of one of the predefines base paths. If not defined, every export location is allowed.

documentExport.sendMail

type: Boolean, required: no, default: true

If true, error mails will be sended when a job fails

documentExport.errorMail

type: String, required: no, default: -

email address for sending error mails

documentExport.publicUrlSetInstance

type: Boolean, required: no, default: true

Set this to false for Celum 5.13.x and older versions, then the instance will always be "1", because instance can only be a positive integer ("1"). Otherwise the instance will be set to the export name.

documentExport.publicUrlProviderName

type: String, required: no, default: Asset Exporter

The public URL provider name.

CSV properties

documentExport.metadataExport.csv.separator

type: char, required: no, default: ,

CSV separator for the metadata csv export

documentExport.metadataExport.csv.quotechar

type: char, required: no, default: "

CSV quote char for the metadata csv export

documentExport.metadataExport.csv.quoteAll

type: booelan, required: no, default: true

Define if all csv values are quoted

documentExport.metadataExport.csv.encoding

type: String, required: no, default: UTF-8

Encoding for the metadata csv export

documentExport.metadataExport.csv.lineend

type: String, required: no, default: \r\n

End of line for the metadata csv export

documentExport.metadataExport.csv.dateFormat

type: String, required: no, default: yyyy-MM-dd

date format for csv exports

documentExport.exportOnChange

type: boolean, required: no, default: false

If true, an asset change will trigger its delta export jobs

documentExport.exportOnChangeRetainSeconds

type: long, required: no, default: 60

Time between asset change and automatically start of the export, if exportOnChange is true (in seconds)

Amazon S3 Export

  1. Create an IAM-User with AmazonS3FullAccess to get the Access Key ID and the Secret Access Key.
  2. Create a bucket to get Bucket and Region.
  3. Choose Amazon S3 as Export type and enter the values from above.

Attention

  • We need the region and not the region name which is specified when creating the bucket. See here for a list of all values. For digitalocean you can see the region in the URL, e.g. brix.fra1.digitaloceanspaces.com.
  • The base path is required and cannot be "/" (unless you make a node export and have no assets directly in that node). This is because uploading assets directly into the bucket without subfolder fails from CELUM and libraries cannot be shaded because awssdk loads some classes by name.
  • Make sure that all the file names adhere the naming conventions. When in doubt use the ID structure path resolver and the download format ID name resolver.

Note (28.10.2019): digitalocean is not fully S3 compatible, that's why leftover deletion is not supported there (will lead to an error).

Microsoft Azure Blob Storage Export

  1. Right-click on the container > Get Shared Access Signature
  2. Check all permissions
  3. Set expiry date far into the future
  4. Generate

CRON properties

documentExport.cronExpression.hourly

type: String, required: no, default: 0 0 0/1 1/1 ?

Cron expression for hourly execution

documentExport.cronExpression.daily

type: String, required: no, default: 0 0 0 1/1 ?

Cron expression for daily execution

documentExport.cronExpression.weekly

type: String, required: no, default: 0 0 0 ? SUN

Cron expression for weekly execution

documentExport.cronExpression.manually

type: String, required: no, default: 59 59 23 31 12 ? 2099

Never executing cron expression

Screenshots

Asset Exporter Adminmenu

Asset Exporter Create Export

Asset Exporter Overview

Compatibility Matrix

documentExport CELUM
1.0 5.11.4
1.1 5.12.2
1.2 - 2.3 5.12.4
2.3.1 - 2.5 5.13.1
2.5.1 - 2.8.3 5.12.4
2.8.3 - 2.8.11 5.13.3
2.9.28 5.13.4
2.15.6 5.13.4 (tested with 6.4)

Release Notes

1.0

Released 2016-07-18

  • Initial Version

1.1

Released 2016-12-15

  • Extension for logging (the report can either be exported together with the assets or stored locally on the server)

1.2

Released 2017-02-16

  • The export destination can be either a share available on the server or an FTP server

1.9

Released 2017-09-26

  • Export configuration, adapt node IDs and mode

2.0

Released 2017-09-28

  • Search export jobs possible

2.3

Released 2018-03-28

  • Combination of different search criteria for a search export job possible

2.5

Released 2018-12-11

  • Public URLs

2.5.9

Released 2019-01-17

  • DefaultNameResolverFactories and CustomNameResolverFactories. Default are always available, custom have to be enabled by the customNameResolverFactories property.

2.6.0

Released 2019-01-22

  • Base paths for export configurable

2.7.0

Released 2019-01-22

  • SearchJob: Cron-Expression customizable, empty and not-empty searches

2.8.2

Released 2019-03-04

  • Custom path resolvers, Amazon S3 Export

2.8.4

Released 2019-03-19

  • Execute-As setting for superadmin to define as which user a job should be executed, for non-supperadmin jobs will be executed as creator user.
  • Only show own export-tasks (except superuser)
  • Button to manually schedule assets to its jobs

2.8.6

Released 2019-03-27

  • job setting to set export status on exported assets (infofield an value configurable)

2.8.12

Released 2019-05-08

  • if export status value is empty, infofield value will be cleared in return option "none" for export status infofield

2.9.0

Released 2019-05-15

  • export status value for failed and for succeeded exports
  • toast notification when asses are rescheduled

2.9.22

Released 2019-07-30

  • Microsoft SharePoint export
  • Microsoft Azure Blob Storage export
  • Internal URLs

2.9.26

Released 2019-08-22

  • new properties: publicUrlSetInstance, publicUrlProviderName
  • moved public URLs to the export set

2.9.26

Released 2019-08-22

  • new properties: publicUrlSetInstance, publicUrlProviderName
  • moved public URLs to the export set

2.10.0

Released 2019-09-05

  • Search by CreateDate possible (format: dd/MM/yyyy-dd/MM/yyy)

2.10.1

Released 2019-09-09

  • cron expression validation and parse to human readable string

2.11.0

Released 2019-09-11

2.11.4

Released 2019-10-17

  • Better GUI design
  • Custom end point URI for S3 export, to support other S3-compatible destinations apart from Amazon

2.11.10

Released 2019-11-04

  • CSV export: option for csv with timestamp in filename
  • Option to clean filename (only alphanumerics)
  • Runtime configurable properties
  • Option to export on change for delta jobs

2.14.0

Released 2020-01-17

  • Added new "Skip file upload" feature (e.g. to modify public URLs without uploading the file again)
  • Minor improvements

2.15.5

Released 2020-02-17

  • Search Preview function for all search jobs (paged)
  • Refactoring, Bugfixes (Typos)
  • SFTP Transport Library

2.15.6

Released 2020-02-18

  • CELUM 6.4 (19.10) compatible