000031224 - Subform import does not import all rows of file in RSA Archer 5.x

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 24, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000031224
Applies ToRSA Product Set:  Archer
RSA Version/Condition:  5.x, 6.1
IssueWhen performing data import to a subform, if the first column of the subform data is blank in any row, that row will not be imported. Thus, some rows are not imported.

Steps to reproduce the problem

Create a CSV file for importing records into a subform, as follows:

  • Column A is a unique field named "Parent Record" from the parent application used to identify the parent application record.

  • Column B is a field "Number" from the subform

  • Column C is field "Values List" from the subform

Create two rows of data as below:

Parent Record, Number, Values List

The first subform record above will be imported but the second will not.

CauseIf the first column of subform data in the import file is blank in any row, that row will not be imported.

This defect has been fixed in Archer version 6.2


If you switch the order of the columns so that the import file is:

Parent Record, Values List, Number

Then both subform records will be imported.