Exporting and opening XLSX container File

[Ralph Schwegler]

Hello

I run into an issue with a a container and the navigation:

we have a documentation of cases, and in that we carry PDFs, pictures, Word and Excel files (plus some others)

There is a button to open the attached file. While it works with all tested format, it doesn't for .xlsx (.xls works)

I tried to rename, which works but then it cannot open correctly.

Any hint how I could bring that to work?

Cheers and stay safe

[comment]

20 minutes ago, Ralph Schwegler said:

There is a button to open the attached file.

And what exactly does this button do?

If it does Export Field Contents, with the option "Automatically open file" selected, and the file does not open, that would indicate that there is no default application set for this type of file. Are you able to open the exported file by double-clicking it?

 

[Ralph Schwegler]

here's the script - some parts are tests:

*****

# open_container in file FFG

 

Set Variable [ $path ; Value: Get ( DesktopPath )& GetContainerAttribute (GetRepetition ( Notizen::Notiz Container ; Notizen::ContainerAuswahl ) ; "filename") ]

If [ Right(Lower($path);4)="xlsx" ]

// Set Variable [ $path ; Value: Left ( $path ; Length ( $path ) - 1 ) ]

Export Field Contents [ Notizen::Notiz Container[Notizen::ContainerAuswahl] ; “$path” ; Create folders: Off ]

Show Custom Dialog [ "Datei auf dem Schreibtisch ers…" ; "Excel Dateien können leider nicht automatisch geöffnet werden, diese wurde auf dem Schreibtisch ab…" ]

Else

Export Field Contents [ Notizen::Notiz Container[Notizen::ContainerAuswahl] ; “$path” ; Automatically open ; Create folders: Off ]

End If

*****

By creating a new Excel file in my sample document, I noticed that actually the container in FM had a corrupted file, and it looks good now...