| ... |
... |
@@ -148,6
+148,12 @@ |
| 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 |
+For further information on form record export see [[Export>>||anchor="export"]]. |
|
156 |
+ |
| 151 |
151 |
==== {{ficon name="action-move-inbox"/}} Move ==== |
| 152 |
152 |
|
| 153 |
153 |
{{figure image="inbox_move_en.png"}} |
| ... |
... |
@@ -200,6
+200,62 @@ |
| 200 |
200 |
|
| 201 |
201 |
Project views are data table views which are available as soon as display columns have been configured for the form (see [[Form > Inbox>>doc:Formcycle.UserInterface.MyForms.Inbox.WebHome]]). The values of the configured form elements as well as additional form information will be displayed in the data table. Every column can be filtered and sorted. Form records containing attachments are marked by a paperclip icon {{ficon name="paperclip-45"/}} (see [[figure>>||anchor="fig_inbox_list_item_default"]]). Clicking the icon opens the [[attachment page>>||anchor="review_area_attachments"]] of the form record directly. |
| 202 |
202 |
|
|
209 |
+{{id name="export"}} |
|
210 |
+==== {{icon name="download"/}} Export ==== |
|
211 |
+ |
|
212 |
+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. |
|
213 |
+ |
|
214 |
+Example: |
|
215 |
+ |
|
216 |
+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. |
|
217 |
+ |
|
218 |
+There are three different types of exporting form records: |
|
219 |
+ |
|
220 |
+__{{icon name="file-code-o"/}} XML__ |
|
221 |
+{{figure image="inbox_export_xml_en.png"}}{{id name="fig_inbox_export_xml" /}} |
|
222 |
+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}} |
|
223 |
+ |
|
224 |
+Form record data of all form elements will be exported flat in an XML structure. |
|
225 |
+ |
|
226 |
+{{code language="xml"}} |
|
227 |
+<xfc-data xfc-version="3.x.x" generation-date="yyyy-mm-dd HH:mm:ss.ms TZ"> |
|
228 |
+ <processes> |
|
229 |
+ <process process-uid="xxx" creation-date="yyyy-mm-dd HH:mm:ss.ms TZ" project-name="yyy" status="zzz"> |
|
230 |
+ <form version="1"> |
|
231 |
+ <field name="elName"> |
|
232 |
+ <plainValue><![CDATA[Wert]]></plainValue> |
|
233 |
+ <values count="1"> |
|
234 |
+ <value index="0"><![CDATA[]]></value> |
|
235 |
+ </values> |
|
236 |
+ <label><![CDATA[]]></label> |
|
237 |
+ </field> |
|
238 |
+ ... |
|
239 |
+ </form> |
|
240 |
+ <process ...> |
|
241 |
+ </processes> |
|
242 |
+</xfc-data> |
|
243 |
+{{/code}} |
|
244 |
+ |
|
245 |
+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]]. |
|
246 |
+ |
|
247 |
+__{{icon name="file-excel-o"/}} Excel__ |
|
248 |
+{{figure image="inbox_export_excel_en.png"}}{{id name="fig_inbox_export_excel" /}} |
|
249 |
+Excel export of the selected form records: Column names can be configured for every export.{{/figure}} |
|
250 |
+ |
|
251 |
+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. |
|
252 |
+The column names of the resulting Excel file may configured using the following options: |
|
253 |
+ |
|
254 |
+* **Name of the form element** |
|
255 |
+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, ...). |
|
256 |
+* **Alias of the form element** |
|
257 |
+The element alias that is used in the [[{{designer/}}>>doc:Formcycle.FormDesigner.ElementProperties.BaseProperties.WebHome]] will be used for the Excel columns. |
|
258 |
+* **Column name of the data table** |
|
259 |
+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"]]. |
|
260 |
+ |
|
261 |
+__{{icon name="file-excel-o"/}} Excel (multiline)__ |
|
262 |
+{{info}}This Option is not available in [[project views>>||anchor="inbox_list_project"]].{{/info}} |
|
263 |
+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. |
|
264 |
+ |
| 203 |
203 |
== Review area == |
| 204 |
204 |
|
| 205 |
205 |
{{id name="review_area"/}} |