Add New Export Group and Type

Q

How to Add New Export Group and Type?

✍: FYIcenter.com

A

If you want to control how form submissions are exported to print or download for reporting purpose, you can add a new export group and a new export type as shown in this tutorial.

1. Click "Module" in the menu and select "Export Manager". You should see a list of export groups.

2. Click "Add Export Group" and name it as "My Export". You should see the export group definition page.

3. Select "Display in popup": Height 600px, Width 800px.

4. Select "HTML" as content type.

5. Enter "{$export_type_smarty_template}" as Smarty Template. This tells Form Tools to display the export type directly, since there is only 1 export type in this group.

6. On the "Export Types" tab, click "Add Export Type".

7. Enter the following smarty template:

<head>
 <title>{$export_group_name}</title>
 {literal}
 <style type="text/css">
 ...
 </style>
 {/literal}
</head>

<body>
<h1>{$form_name} - {$view_name}</h1>

<table cellpadding="2" cellspacing="0" width="100%" class="print_table">
<tr>
 {foreach from=$display_fields item=column}
 <th class="{$column.field_name}">{$column.field_title}</th>
 {/foreach}
</tr>
{strip}
{foreach from=$submissions item=submission}
 {assign var=submission_id value=$submission.submission_id}
 <tr>
 {foreach from=$display_fields item=field_info}
  {assign var=col_name value=$field_info.col_name}
  {assign var=value value=$submission.$col_name}
  <td>
  {smart_display_field form_id=$form_id view_id=$view_id
   submission_id=$submission_id
   field_info=$field_info field_types=$field_types
   settings=$settings value=$value}
  </td>
 {/foreach}
 </tr>
{/foreach}
{/strip}
</table>

</body>
</html>

As you can see, we have full control of how the export page looks like by modify the CSS settings.

For more information on smarty templates, visit smarty Website at smarty.net.

 

Understanding Form Tools Database

What is Export Manager Module

Using Export Manager Module

⇑⇑ Form Tools - Frequently Asked Questions

2019-11-08, 109👍, 0💬