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.

Properties

Name	Description	Mandatory
SolutionDataLibrary (old name – list)	The name of the Solution Data Library to which you export the repeating group data. It includes a list of all the Solution Data Libraries defined at the global or at the current app level.	Yes
repeatingelement	The name of the repeating element. This field includes all the repeating elements of the form in a drop-down.	Yes
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. This option can be used, for example, 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
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
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, then that existing row will be updated rather than a new row being added to the export list. The KeyColumn value should only be a column name. Example: Direct Value: MyKeyColumnName Value from form field: [/my:myFields/my:field2] Value from solution field: [field1]	No

Export Repeating Group plug-in usage 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.

Export Repeating Group plug-in 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