comes with a built-in submissions repository. The repository can run on top of most SQL databases. By default, your form data is stored in the repository and can be viewed from the Submissions page. Fields in your form/workflow, set up as Searchable fields by the designer, can be used as criteria when searching submissions. You can also filter by default fields such as error, error description, submitter id, lock user id, started date, etc. The Insight Server and the Insight service must be running for the Submission view to work.
...
The Submissions table will show submissions in the following states: SUBMITTEDSAVED, SAVED PENDING, SUBMITTED, ABORTED, ERROR and WAITING. Simply check the appropriate check box in the State section. For example, It would be easy for a manager to check the current status of Expense Report approvals by checking one or all the submission types in the State box. The Submission Table dynamically changes as the submission state choices are checked/unchecked.
Here is an explanation of the available states:
...
- SAVED: This will return only those tasks which were created when users clicked the Save button on the form/workflow to save their partially filled forms
- PENDING: This will return all tasks which are pending, meaning someone else put these tasks in the users task list
- SUBMITTED: This will return all tasks which are completed, i.e. the form/workflow for which this task was created has been submitted
- ABORTED: This will return all the tasks that were deleted/aborted so the form/workflow never got submitted
- WAITING: The WAITING status can be used to find workflow tasks that have an Email or HTTP activity. A submission will show a state of WAITING when a workflow is routed to an anonymous user and the workflow is suspended until the this step is completed.
...
This happens because Excel makes assumptions about the way imported data should be formatted; usually leading zeros are mathematically insignificant, so they are removed. You can keep the leading zeros in CSV files by using Excel's Text Import Wizard. (These instructions may vary based on your Excel version.)
- Launch Excel Spreadsheet. Click the Data tab.
Click the From Text/CSV icon. Use the file manager to locate the CSV file you want import.
Click Import.
- Select Comma from the Delimiter dropdown.
Click Transform Data.
Select the column(s) that contains the data with leading zeros. Change the Data Type to "Text". The preview will refresh to show your data with leading zeros.
Click Close & Load.
...