Defining Material Exports and Filters

It is important to take a step back from the Document Export query to determine the materials required for export, and how external systems need to consume the data associated with each material.  

Defining Documents

The Document Export query template is configured to return materials with an Export Value 1.

  • Exports - The Material Export 1 column in the index file contains the material's Export Value 1.
  • Filters - The Material Export 1 Exists filter restricts the query to only return materials configured with an Export Value 1.

Adjust the Exports and Filters to return a different export value. This is helpful when setting up multiple document exports to different systems. See the Multiple External Systems section below.

  • Exports - The Material Export 2 column in the index file contains the material's Export Value 2.
  • Filters - The Material Export 2 Exists filter restricts the query to only return materials configured with an Export Value 2.

 

  Best Practice

Make it Match! If an index file exists, the Material Export export column must match with the Material Export filter (for example, Materials Export 1 always goes with Materials Export 1 Exists).

Multiple External Systems

If a material needs to be sent to additional external systems, use Export Values 2 - 5 for those document exports. For example:

  • Export Value: This value can be used for a document export to one external system.
  • Export Value 2: This value can be used for another document export to a second external system.
  • Export Value 3: This value can be used for another document export to a third external system.

When exporting multiple material types to the same system, the external system export values must use the same configuration across material types.

Exports for Document Generation

Remember that this is a document export, not a data export. Therefore, adding exports beyond the required items outlined on this page and those required by a document management system for the index file is not necessary. The pdf:file and pdf:xml exports are required, and are used to generate the documents in a document export. Do not change or remove these exports.

If a .tiff or .jpg file is required, replace the pdf:file export with a formula export.  Name the formula export "pdf:file" and add the following snippet to match the schedule export document type: 

'.' + (select q.[config].value('(p[k = "export_archive_type"]/v)[1]', 
'varchar(16)') from [query] q where ([id] = @query))

Important

These exports are required to generate the documents export file. Do not remove these exports. If you are not using an index file, these are the only necessary exports.  If a custom pdf:file export name is required, refer to the Customizing Document Export File Names article for additional information.
Exports for the Index File

If an export is configured to generate an index file, all other exports will appear in that file.

If generating an index file, make sure that the query includes an export that can be used for matching criteria in the external system. 

  • The Material Export 1 column in the index file contains the material's Export Value.
  • The File name export is the row name in the material index file.
  • The pdf:file and pdf:xml exports are required. The pdf:file export is the file name of the pdf. 
  • Add any additional exports needed for the index file.

Include an export that contains a unique ID that exists in both the external system and Slate so the documents match the existing record. If the document export is the initial file entering the external systems, include the Application Slate GUID export to ensure that documents included in subsequent exports match the same record.

Adding Filters to Restrict Results

Like a Data Export, filters restrict the population of the results.

  • Use filters associated with the Applications and Prospects query bases to define the application records that are included in the document export.
  • Use filters associated with the Document Export (Application) query base to further restrict the materials that should be exported.

  • Application Period ActiveRound Key - These filters restrict the application records.
  • Materials for Document Export - This filter restricts the document types.

This filter configuration restricts the results of the query to only include materials with an export value 1 configured that are associated with applications in the active application period in an application round with the TR round key.

Was this article helpful?
2 out of 5 found this helpful