| ... |
... |
@@ -148,61
+148,6 @@ |
| 148 |
148 |
|
| 149 |
149 |
Selects all form records based on the currently [[set filters>>||anchor="filter_menu"]]. {{info}}This may take a while if there is a large number of form records within the list.{{/info}} This checkbox is always available. |
| 150 |
150 |
|
| 151 |
|
-==== {{icon name="download"/}} Export ==== |
| 152 |
|
- |
| 153 |
|
-Exports all selected form records or all form records based on the currently [[set filters>>||anchor="filter_menu"]] if there are no form records selected. |
| 154 |
|
- |
| 155 |
|
-Example: |
| 156 |
|
- |
| 157 |
|
-No form records are selected and filter is set to the inbox "Default inbox". Performing an export action will export all form records that are stored in the inbox "Default inbox". For exporting the form records of all inboxes the filter on "Default inbox" needs to be removed. |
| 158 |
|
- |
| 159 |
|
-There are three different types of exporting form records: |
| 160 |
|
- |
| 161 |
|
-__{{icon name="file-code-o"/}} XML__ |
| 162 |
|
-{{figure image="inbox_export_xml_en.png"}}{{id name="fig_inbox_export_xml" /}} |
| 163 |
|
-XML-Export of selected form records: Optionally an XSL-Template may be selected for transforming the resulting XML file into the desired format (XSL-Templates can be defined under [[XSL transformation>>Formcycle.UserInterface.FilesAndTemplates.XSLTransformation.WebHome]]).{{/figure}} |
| 164 |
|
- |
| 165 |
|
-Form record data of all form elements will be exported flat in an XML structure. |
| 166 |
|
- |
| 167 |
|
-{{code language="xml"}} |
| 168 |
|
-<xfc-data xfc-version="3.x.x" generation-date="yyyy-mm-dd HH:mm:ss.ms TZ"> |
| 169 |
|
- <processes> |
| 170 |
|
- <process process-uid="xxx" creation-date="yyyy-mm-dd HH:mm:ss.ms TZ" project-name="yyy" status="zzz"> |
| 171 |
|
- <form version="1"> |
| 172 |
|
- <field name="elName"> |
| 173 |
|
- <plainValue><![CDATA[Wert]]></plainValue> |
| 174 |
|
- <values count="1"> |
| 175 |
|
- <value index="0"><![CDATA[]]></value> |
| 176 |
|
- </values> |
| 177 |
|
- <label><![CDATA[]]></label> |
| 178 |
|
- </field> |
| 179 |
|
- ... |
| 180 |
|
- </form> |
| 181 |
|
- <process ...> |
| 182 |
|
- </processes> |
| 183 |
|
-</xfc-data> |
| 184 |
|
-{{/code}} |
| 185 |
|
- |
| 186 |
|
-Using an optional XSL template (see [[figure>>||anchor="fig_inbox_export_xml"]]) the exported XML can be transformed into the desired format. The appropriate template can be selected using the combobox. For further information on XSL templates look [[here>>doc:Formcycle.UserInterface.FilesAndTemplates.XSLTransformation]]. |
| 187 |
|
- |
| 188 |
|
-__{{icon name="file-excel-o"/}} Excel__ |
| 189 |
|
-{{figure image="inbox_export_excel_en.png"}}{{id name="fig_inbox_export_excel" /}} |
| 190 |
|
-Excel export of the selected form records: Column names can be configured for every export.{{/figure}} |
| 191 |
|
- |
| 192 |
|
-All data will be exported to an Excel file. If form records of multiple forms have been selected than a new worksheet will be created for every form within the Excel file. All values of [[repeated form elements>>Formcycle.FormDesigner.ElementProperties.BaseProperties]] will be put into the same cell, separated by commas. If this is not desired the export option //Excel (multiline)// is recommended. |
| 193 |
|
-The column names of the resulting Excel file may configured using the following options: |
| 194 |
|
- |
| 195 |
|
-* **Name of the form element** |
| 196 |
|
-The element names that are used in the [[{{designer/}}>>doc:Formcycle.FormDesigner.ElementProperties.BaseProperties.WebHome]] will be used for the Excel columns (e.g.: tf1, sel1, ...). |
| 197 |
|
-* **Alias of the form element** |
| 198 |
|
-The element alias that is used in the [[{{designer/}}>>doc:Formcycle.FormDesigner.ElementProperties.BaseProperties.WebHome]] will be used for the Excel columns. |
| 199 |
|
-* **Column name of the data table** |
| 200 |
|
-The column names that have been set in the [[inbox configuration>>doc:Formcycle.UserInterface.MyForms.Inbox.WebHome]] will be used for the Excel columns. This selection is only available in the [[project views>>||anchor="inbox_list_project"]]. |
| 201 |
|
- |
| 202 |
|
-__{{icon name="file-excel-o"/}} Excel (multiline)__ |
| 203 |
|
-{{info}}This Option is not available in [[project views>>||anchor="inbox_list_project"]].{{/info}} |
| 204 |
|
-The export works the exact same way as the simple Excel export, except that the values of [[repeated form elements>>Formcycle.FormDesigner.ElementProperties.BaseProperties]] will be put into separate rows. |
| 205 |
|
- |
| 206 |
206 |
==== {{ficon name="action-move-inbox"/}} Move ==== |
| 207 |
207 |
|
| 208 |
208 |
{{figure image="inbox_move_en.png"}} |