Header(array('settings' => 'Settings', 'help' => 'Help'), 'xls_export_config_{n}'); ?>
tabStart('settings'); ?>
input('action_xls_export_{n}_data_path_config', array('type' => 'text', 'label' => 'Data Path', 'class' => 'medium_input', 'smalldesc' => 'The path to the Data list in the $form->data array, e.g: MODEL_ID')); ?>
input('action_xls_export_{n}_list_fields_config', array('type' => 'text', 'label' => 'Fields list', 'class' => 'big_input', 'smalldesc' => 'Comma separated list of fields to be included, no spaces, leave empty and all fields will be added.')); ?>
input('action_xls_export_{n}_list_headers_config', array('type' => 'text', 'label' => 'Headers list', 'class' => 'big_input', 'smalldesc' => 'Comma separated list of headers labels to be included, no spaces, leave empty and data list keys will be used.')); ?>
input('action_xls_export_{n}_add_bom_config', array('type' => 'select', 'label' => 'Add BOM', 'options' => array(0 => 'No', 1 => 'Yes'), 'smalldesc' => 'Add the UTF-8 BOM characters to the output ? this helps MS Excel detect the file as UTF-8 if you have any special characters inside.')); ?>
input('action_xls_export_{n}_file_name_config', array('type' => 'text', 'label' => 'File Name', 'class' => 'medium_input', 'smalldesc' => 'The export file name.')); ?>
input('action_xls_export_{n}_save_file_config', array('type' => 'select', 'label' => 'Save File', 'options' => array(0 => 'No', 1 => 'Yes'), 'smalldesc' => 'Should we save the file instead of sending it for download ?')); ?>
input('action_xls_export_{n}_post_file_name_config', array('type' => 'text', 'label' => 'Post field Name', 'class' => 'medium_input', 'smalldesc' => 'The saved file field name which can be used in the email attachments.')); ?>
tabEnd(); ?>
tabStart('help'); ?>
- The action will generate XLS file contains HTML table which is importable by MS Excel (tested on Excel 2003,2007 and 2010).
- The records list array should be in your $form->data array, using a DB Multi record loader for example.
tabEnd(); ?>