12.2.2 : Import From Excel To Worksheet Error: Import file format is incompatible with Worksheet (Doc ID 1629546.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Demantra Demand Management - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

Customer has upgraded from 731 to 12.2.2

The export and import functionality is not working

Customer has Windows 7 and when he tries to export a worksheet he gets the message

The file you are trying to open, 'Export.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

Customer clicks Yes

The customer is able to open the excel file, make updates/overrides to some series, save the file. They get the following message when they try to save it

Export.xls may contain features that are not compatible with Unicode text. Do you want to keep the workbook in this format?
To keep this format, which leaves out any compatible features, click yes
To preserve the features, click no. The save a copy in the latest excel format
To see what might be lost, click Help


Click Yes to save the file

Then Go to worksheet and try to import the file

Get the following

The import file format is compatible with the worksheet. Please review the file headers to ensure they map the worksheet structure (Levels, Time and Series) and reload



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms