| |
|
|
Why are some fields not exported to Excel Columns
When exporting data from a Lotus Notes databse to Excel, some fields are exported into columns in Excel but others are not. There are a number of circumstances that can lead to data not being exported and this document explores these circumstances. This document is designed as a trouble-shooting guide to ensure that the Integra profile is set to export all the data as required and identifies potential causes of such a problem:
Incorrect or Missing Tags in Excel Template - By default, an Integra profile exports fields listed in the Selected Field List of the Integra profile to the Excel spreadsheet using Excel Tags. If the Use Tags field in the Excel Tab of an Integra profile is set to Yes (as is the default), the Excel template is required to have a Tag for each of the listed Field Names. In the event that there is a mismatch in the number of fields in the profile compared to the tags in the Excel spreadsheet, the field listed in the profile which does not have a corresponding tag will be omitted from the export.
In the event that there is an error in the tag name, this will also result in an error indicating that the named field does not have a corresponding tag.
Adding Fields into Integra
When creating an Integra profile for the first time, Integra suggests you allow it to automatically create a default Excel template which will have each column starting from the offset column tagged with the name of each of the fields in the available field list. This reduces the errors of missing or incorrectly named tags.
However in the event that, after having initially created the template, you add fields into the selected field list of the profile, the added fields need to be added to the Excel template as tags. Follow the instructions in the user manually for adding these tags. In addition, Integra pushes the data into the Excel template into a tagged area referred to as the _datablock. If initially 6 fields were being exported, the range A4 : F6 will be tagged as the _Datablock area. In the event, you subsequently add an additional 2 fields into the selected field list and even assuming you tag column G and H with the names of the new fields, you still need to extend the _Datablock range to be from A4 to H6.
Using Reserved Tag Names
Integra prohibits cell references being used as Tags for the Excel spreadsheet. In the event that you have a field called T1, K27 or any other field which is the same as a cell name in Excel, the data from this field will not be exported and neither Integra nor Excel will present an error to the user.
|
. |
|
FAQ# 0127
|
|
|
| |