Claravine can automatically generate a Box file with the data from every submission. Administrators can design the file, what data to include in the file, and where to send the data per template.
To add Box Outbound to a template:
- Open the correct Template in the Templates Sub-Navigation menu.
- Click Step 3 - Connect.
- Click to add a new Outbound integration.
- Click Box.
The Box Outbound configuration section displays. - Enter the Integration Name. If no value is entered, Claravine will default the Integration Name to the Template name.
- Select the connected Box Account.
An Administrator must first connect the Box Account in the Accounts Sub-Navigation menu of Integrations. - Select the Folder Path.
- Define the Filename. Add text or click the blue Insert button to add, Template, Submitted at, or Submitted By to add those dynamic values in the generated Filename. (Submitted at will return YYYY-MM-DD_HH-MM-SS in UTC).
- Select the File Type. Options are CSV, XLSX, JSON.
- Select the Delimiter. Options are comma (,), semicolon (;), tab, and space.
- Check the box to Include Summary Header in the file output, or exclude it to being the file with the field headers. The Summary Header includes:
- Date
- User Name
- Targets
- Template
- File configuration options are Custom or Default Summary.
- Default Summary matches the schema in Step 2 Define and Govern schema.
If the visible box is unchecked in the schema, it will not be included in the file. - Custom allows field-specific changes:
- Include or exclude the field from the file
- Change the Output Label/column header
- Manually drag the tile to change the order
- Transform menu: Update all Output Labels to:
- Replace spaces with underscores
- Replace underscores with spaces
- Lowercase
- Uppercase
- Meta Field menu: Add a new meta field to match file output requirements:
- Template Name
- Submitter Name
- Submitter Email
- Created Date
- Updated Date
- Empty
- Default Summary matches the schema in Step 2 Define and Govern schema.
- Click Save to save the template.
Comments
0 comments
Article is closed for comments.