... |
... |
@@ -141,6
+141,7 @@ |
141 |
141 |
The form record list header consists of two button rows (see [[figure>>||anchor="fig_inbox_list_default_marked"]]). On the left are //form record actions// and on the right are //general actions//. |
142 |
142 |
|
143 |
143 |
{{id name="form_record_actions"/}} |
|
144 |
+ |
144 |
144 |
=== Form record actions === |
145 |
145 |
|
146 |
146 |
Which form record actions will be displayed depends on the currently selected form records. |
... |
... |
@@ -208,20
+208,24 @@ |
208 |
208 |
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. |
209 |
209 |
|
210 |
210 |
{{id name="export"/}} |
|
212 |
+ |
211 |
211 |
== Export == |
212 |
212 |
|
213 |
213 |
Clicking //Export// {{icon name="download"/}} in the header of the form record list 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 (see [[form record actions>>||anchor="form_record_actions"]]). |
214 |
214 |
|
215 |
|
-Example: |
|
217 |
+__Example:__ |
216 |
216 |
|
217 |
217 |
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. |
218 |
218 |
|
219 |
219 |
There are three different types of exporting form records: |
220 |
220 |
|
221 |
|
-__{{icon name="file-code-o"/}} XML__ |
222 |
|
-{{figure image="inbox_export_xml_en.png"}}{{id name="fig_inbox_export_xml" /}} |
223 |
|
-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 |
+=== {{icon name="file-code-o"/}} XML === |
224 |
224 |
|
|
225 |
+{{figure image="inbox_export_xml_en.png"}} |
|
226 |
+{{id name="fig_inbox_export_xml" /}} |
|
227 |
+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]]). Additionally meta data may be exported. |
|
228 |
+{{/figure}} |
|
229 |
+ |
225 |
225 |
Form record data of all form elements will be exported flat in an XML structure. |
226 |
226 |
|
227 |
227 |
{{code language="xml"}} |
... |
... |
@@ -245,10
+245,13 @@ |
245 |
245 |
|
246 |
246 |
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]]. |
247 |
247 |
|
248 |
|
-__{{icon name="file-excel-o"/}} Excel__ |
249 |
|
-{{figure image="inbox_export_excel_en.png"}}{{id name="fig_inbox_export_excel" /}} |
250 |
|
-Excel export of the selected form records: Column names can be configured for every export.{{/figure}} |
|
253 |
+=== {{icon name="file-excel-o"/}} Excel === |
251 |
251 |
|
|
255 |
+{{figure image="inbox_export_excel_en.png"}} |
|
256 |
+{{id name="fig_inbox_export_excel" /}} |
|
257 |
+Excel export of the selected form records: Column names can be configured for every export. Additionally meta data may be exported. |
|
258 |
+{{/figure}} |
|
259 |
+ |
252 |
252 |
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. |
253 |
253 |
The column names of the resulting Excel file may configured using the following options: |
254 |
254 |
|
... |
... |
@@ -259,10
+259,31 @@ |
259 |
259 |
* **Column name of the data table** |
260 |
260 |
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"]]. |
261 |
261 |
|
262 |
|
-__{{icon name="file-excel-o"/}} Excel (multiline)__ |
|
270 |
+=== {{icon name="file-excel-o"/}} Excel (multiline) === |
|
271 |
+ |
263 |
263 |
{{info}}This Option is not available in [[project views>>||anchor="inbox_list_project"]].{{/info}} |
264 |
264 |
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. |
265 |
265 |
|
|
275 |
+=== Export meta data (Optional) === |
|
276 |
+ |
|
277 |
+{{info}}This functionality is available in FORMCYCLE version 6.1.0 and above. In previous versions meta data was exported by default.{{/info}} |
|
278 |
+Meta data may be exported additionally for every export type (see figure [[XML export>>||anchor="fig_inbox_export_xml"]]/[[Excel export>>||anchor="fig_inbox_export_excel"]]). The following fileds are available for export: |
|
279 |
+ |
|
280 |
+* **Process ID** |
|
281 |
+Process ID of the form record. |
|
282 |
+* **Status** |
|
283 |
+Name of the state the form record is in at the time of export. |
|
284 |
+* **Date of receipt** |
|
285 |
+Date the form record was submitted/created. |
|
286 |
+* **Modification date** |
|
287 |
+Date of last change to the form record. |
|
288 |
+* **Form variables** |
|
289 |
+Configured [[Form variables>>doc:Formcycle.FormDesigner.CodingPanel.VariablesTab]] an their values. |
|
290 |
+* **Control fields** |
|
291 |
+Control fields of the form such as //xf-action//, which holds the name of the button used for submitting the form. |
|
292 |
+* **Meta data** |
|
293 |
+Date of export and used FORMCYCLE version. |
|
294 |
+ |
266 |
266 |
== Review area == |
267 |
267 |
|
268 |
268 |
{{id name="review_area"/}} |