Loading an XLSX document

[DDP021]

Hi,  we have successfully been able to have our users load an XLS document using the generic indexer and setting the File Extension set to XLS on the application....The issue we are having now is the user is attempting to send a XLSX formatted document to OnDemand and is receiving an error when attempting to open it (see attachment)...We tried changing toe File Extension on the application definition to XLSX without any success....Is anyone aware of any issue loading this format of excel into OnDemand?...

[pankaj.puranik]

Hi

First, I presume that you were able to successfully load the xlsx file.
Second, the error message you attached complains about being unable to open a .xls file and not .xlsx file.

If you edited the same application group that you used for storing xls files for storing xlsx, then this miy happen.
Try cloning the application group and load the xlsx into it and then try retrieving it.

Thanks
Pankaj.

[Alessandro Perucchi]

Strange,

Did you try to have 2 applications in your application group? One for XLS, and one for XLSX?
I mean, you don't need to have several application group, just an entry per type of file (Application)

What you could do, is delete the application and recreate it with the xlsx extension, without modifying the application group (that's what I do when I've messed up completely an application :-)

Sincerely yours and happy new year!

Alessandro

[DDP021]

After testing again with the file from the user, we were able to open the XLSX file via the webi client successfully...However, using the thick client we were still receiving the error...It maybe because we are running an older version (8.4.0.1) of thick...We are in the process of upgrading the thick client....As of now, the users are all using webi....We are having the client send another xlsx file to the server...We had them do that last week after modifying the application definition to set the file extension on the view information tab to xlsx but still received the error...We tested the same file and didn't receive the error so we want to verify what happens this week what happens when they send it themselves...For these types of files they send 3 files..Examples of names below:

application.applicationgroup.ard.ind (index file)
application.applicationgroup.ard.out (actual xlsx data file)
application.applicationgroup.ard (trigger file) which is empty....

[DDP021]

To clarify, all we did was modify the Application, not the Application Group by changing the File Extention from XLS to XLSX on the View Informaion tab...After doing that and then loading the XLSX file from the user, we were able to open up the file via the Webi without any error message...

[DDP021]

We had  the user retry a new file....We now receive this error (see attachment)...