Scheduled Data Exports

Data can be exported to a CSV file on a periodic basis. This is controlled via data export events in the EnterMedia scheduler.

There are several settings that can be used to configure how the export works.

This is a typical export event for the assets table in the system:

<page>
    <path-action name="PageValue.loadPageVariable"  bean="searcherManager" alltypes="true"/>
    <page-action bean="replacer" name="PageValue.loadPageVariable" class="com.openedit.util.Replacer" alltypes="true" allowduplicates="true"/>
    <property name="eventname">Export Asset CSV</property>    
    
    <path-action name="Script.run" alltypes="true" >
       <script>/${catalogid}/events/scripts/data/generatecsv.groovy</script>
    </path-action>
    <property name="searchtype">asset</property>
    <property name="friendly">true</property>
    <property name="exportpath">/WEB-INF/data/${catalogid}/exports/assetexport-${date}.csv</property>
    <property name="view">asset/export</property>
    <property name="sendnotifications">true</property>
    <property name="to">ian@netevolved.com</property>
</page>

The following settings can be adjusted:

searchtype – change this to match the table (found in the data manager) that you wish to export.

friendly – When set to true, List values will be resolved to their “friendly” english names rather than their IDs.

sendnotifications – this will turn on and off email notifications on completion or error

to – a comma seperated list of recipients for the emails

exportpath – this controls the file name that is used. The ${date} variable will be replaced by todays date

views – This allows you to control which columns are exported. If the view exists for the given data type, the columns in this view will be the only ones included in the export.

You can add additional exports to the system by creating new events in your catalogs event folder. Events can be scheduled using the standard administrative tools.