Exporting library metadata in .xlsx format is a welcome change.
However, it is not quite compatible with .xlsx standards.
In my case I have exported all my track data using client Mac OS-X 10.15.7 and :
The exported file (“Librarytracks…”) is 4.9Mb
This can be opened by Excel and Numbers but not by a database with .xlsx import filters (see screenshot).
Opening and saving via Excel changes the size to 5.8Mb.
This can then be opened by the database using the .xlsx import filter.
Somehow, something is missing in the export file to make it fully .xlsx compliant.
I like to work with LibreOffice and there, after opening it, I can specify in which format I want to save it again. Is this not possible with Apple and Microsoft products?
Hi @RalphH, what software are you trying to use here? Can you share an example of an .xlsx file that does work with this application? I can’t make any guarantees here, but we can take a look.
Yes it is possible, but only with spreadsheets (Excel, Numbers). My database which has a .xsls import function does not recognise the contents correctly.
It seems that FileMaker is picky about the format. This is also discussed on their forum, sadly without a clear answer as to what the offending/missing part is.
Thanks for the heads up, BlackJack. This is the first time I’ve had this issue with FMP (over about 15+ years)
Anywho, I’m sure I can script around it somehow.
Thanks for the details and for sending those over, Ralph. I’ve passed along this info to the team. I can’t make any guarantees or offer timelines, especially since this seems to be specific to FileMaker, but I’ll update you here if I have news on this.
I believe the issue here is that Roon is exporting the Excel file as an Open XML file posing as an Excel file (by using the xlsx extension). I can open Roon’s exported file using BBEdit (on the Mac) and I see the XML in addition to other folders in the file package.