Export Repeating Group Plug-in
The Export Repeating Group plug-in exports the values from a repeating table or a repeating section to a Solution Data Library.
Solution field values
If the value for a solution field (apart from the string type field) is not provided by the user or is empty for other reasons, a null value is saved by default for these fields. These fields can be queried using “null” value. See the table below for default values for each data type.
| Data Type | Default values (Evolve 20.0) | Default Values (Evolve 20.1 and later) |
|---|---|---|
| Int | 0 |
null |
| Decimal | 0.0 | null |
| Date | 1900/01/01 | null |
| Boolean | False | null |
| Text/String | Blank string | Blank string |
If a solution field is mapped to a calculated field in the Solution Data Library, Solution Developers receive a warning message and the value for that field is not pulled from the form (is not saved). The solution field value is ignored and the calculated column uses the value from the formula. This also applies when a calculated field is mapped to a property promoted solution field.
Properties
|
Name |
Description |
Mandatory |
Group Name | Modes |
|---|---|---|---|---|
|
SolutionDataLibrary(former name: list) |
The name of the Solution Data Library to which you export the repeating group data. This parameter includes a list of solution data libraries defined at the global and current app levels. |
Yes |
Solution Data |
NA
|
|
repeatingelement |
The name of the repeating element. This field includes a drop-down list of all repeating elements of the form. |
Yes |
Repeating Data Details | NA |
|
merge |
Comma-separated names of elements whose values you want to merge. This option is used to merge values from outside of the repeating group to each row of the export list. For example, the option can be used to export the unique title of the form for each row in the export list. This allows you to easily identify the form associated with a given item in the export list. Example: Direct value: [Title]=[//my:myFields/my:Title] |
No |
Repeating Data Details | NA |
|
columnmap |
The column name in the target Solution Data Library that corresponds to the field in the repeating element. If this option is not specified, all child elements of the repeating element will be exported to the target export list, subject to the XML field names and Solution Data Library column names matching. Example: Direct value: [Quantity]=[//my:myFields/my:quantity],[Price]=[//my:myFields/my: unitPrice],[Total]=[//my:myFields/my:total] |
No |
Repeating Data Details | NA |
|
keycolumn |
If specified, this column is used as the unique key in the export list that identifies each row. If the key column is specified, and a row with the given value already exists, that existing row will be updated rather than a new row being added to the export list. The key column parameter can be a combination of multiple columns from the Solution Data Library. For example, if a key column is specified as ID,Name, both of these fields are matched as a combination for an upsert operation. (Column names are comma-separated.) Example: Direct Value: MyKeyColumnName Value from form field: [/my:myFields/my:field2] Value from solution field: [field1] Calculated columns cannot be used in the key column parameter. |
No |
Repeating Data Details | NA |
Example
Use the Export Repeating Table plug-in if you want to take data from a form and store it on an external source, such as a Solution Data Library, where it can be accessed by other forms or processes.
Tips and best practices
Column names and form field names are case-sensitive and must match exactly. For example, a field name in the form unitPrice must match the column name unitPrice in the target list.
- If you need to map differently-named fields to column names, use the columnmap option.
Exception errors
The following lists "Exceptions" (errors) that can occur with this plug-in if certain conditions are not met. These errors can be found in the logs.
- Plug-in.ExportRepeatingGroup.InvalidColumnList
- Plug-in.ExportRepeatingGroup.XPathNotFound
- Plug-in.ExportRepeatingGroup.MissingExportSite
- Plug-in.ExportRepeatingGroup.ListDoesNotExist
- Plug-in.ExportRepeatingGroup.MissingRepeatingElement