Importing calculated fields from Microsoft Excel files

Importing calculated fields from Microsoft Excel files

Reported: June 16, 2017.

Version(s) affected: DataSight 3.0 and 3.1.

Issue: During an import routine, if values in nominated fields of a file have been calculated using Microsoft Excel formulae, they appear empty when previewed and do not import. This issue however does not cause exceptions.

Workaround: Copy values out of the calculated fields as raw data and paste into new fields; then import the new fields by mapping them to desired variables in DataSight.

Resolution: Fixed in DataSight 3.2.

Last Updated: June 16, 2017.

    • Related Articles

    • Map Fields

      In Step 2 of the Data Import Routine in the lower panel under Map Fields, you will map your input fields to your DataSight fields. The method of field mapping depends upon whether your data is a pivoted data set or a normalised data set. Mapping ...

    • Records with midnight timestamp sometimes missing when importing from XLS or XLSX data files

      Reported: July 25, 2019 Version(s) affected: DataSight 3.6 onwards Issue: When importing XLS or XLSX data files, records with a midnight timestamp are sometimes missing from the Date Time field in Step 3. This occurs because Excel has previously ...

    • Microsoft SQL views of Pivoted Datasheets

      Reported: January 31, 2017. Version(s) affected: DataSight 3.0 and 3.1. Issue: Microsoft SQL views of pivoted datasheets are not saved in pivoted tables. Linking the views to other software products such as Microsoft Excel, then does not produce the ...

    • Linking Excel to DataSight

      DataSight has been designed to use Microsoft SQL as the fundamental database behind the application. This provides real benefits for DataSight users. The following procedure shows you how to link DataSight with Microsoft Excel. The same procedure can ...

    • Video: Report Designer Flagging Calculated Fields