Import wizard problems

Unpredictable results can occur when an existing configuration file is used as a template for creating a new configuration file and the number of columns in the original structure file does not match the number of columns in the new structure file. This may result in the import process failing or it may result in a successful import but the attributes for one or more members may be incorrect.

Mapping problems can occur when the First row has column headers option is selected when specifying structure file formatting within the import process and the structure file does not contain column headers for every column in the structure file. This condition can occur when the structure file is manipulated in Excel and then saved.

This is an example of incorrect structure file when the First row has column headers option is selected:

NAME,DESCRIPTION,PARENT,,
ALL UNITS,ALL UNITS,*,ALL UNITS,
BANK,FIRST NATIONAL BANK,ALL UNITS,ALL UNITS,USD
MAX ,MAXIM COMPANY,ALL UNITS,ALL UNITS,USD
.MID,MIDDLE OF THE ROAD COMPANY,ALL UNITS,ALL UNITS,USD

This is an example of correct structure file when the First row has column headers option is selected:

NAME,DESCRIPTION,PARENT,HIERARCHY,CURRENCY
ALL UNITS,ALL UNITS,*,ALL UNITS,
BANK,FIRST NATIONAL BANK,ALL UNITS,ALL UNITS,USD
MAX ,MAXIM COMPANY,ALL UNITS,ALL UNITS,USD
.MID,MIDDLE OF THE ROAD COMPANY,ALL UNITS,ALL UNITS,USD