Heading Present which does not exist in the dictionary message when exporting from Excel


 Product(s):Keynetix
 Version(s):1.0
 Area:Assist

Heading Present which does not exist in the dictionary message when exporting from Excel

Issue Summary

When KeyAGS reads an Excel template it looks for column headers which are defined within the AGS dictionary. These headers reflect the AGS version which has been specified by the version toggle button:

However, there are occasions where field headers are defined in the spreadsheet which are not defined within the AGS format. Such fields are permissible in the format - being described as user defined fields (UDFs) - but need to be correctly defined in the DICT table of an outgoing AGS file. KeyAGS will return an error similar to that illustrated above when a UDF header is found in the sheet but the necessary dictionary definition is not in place:

Resolution

Therefore, to address the issue the definition needs to be recorded in a manner KeyAGS can read. This can be done using one of two methods, the first being the more common and particularly explicable for templates designed for routine use.

Add the definition to the KeyAGS dictionary

1. Select KeyAGS | KeyAGS Designer | Administrator.

2. From the new screen ensure the 'AGS Version' is set to the relevant version.

3. From the Dictionary tab set the 'Group' to the required table.

4. At the bottom of the page click 'Add New Field' and add the definition for the new field as required:

5. Apply the changes but ensure that they are saved (File | Save) before the dictionary is closed.

6. Create the file as before and now the definition will be in place to allow the conversion of the data the relevant definition to be added to the DICT table.

Other Workarounds

Add the definition to an additional sheet

This is a good option for UDFs which relate to a specific project, rather than being used routinely. Such techniques are generally used by those with a solid understanding of the AGS format as they reflect those conventions quite directly.

1. Select KeyAGS | KeyAGS Designer | Default Sheet | DICT.

2. A new sheet will be added to the workbook which includes the columns an AGS file would require.

3. Populate these columns with the required definitions.

4. Create the file as before and now the definition will be in place to allow the conversion of the data the relevant definition to be added to the DICT table.

The two techniques can be used in conjunction with one another. Note that each UDF will need to be defined in this manner.