Export Playlist at Excel format : impossible! [Fixed: Avast was blocking files]

Roon Core Machine

i5-8400 WIN10 - LTSC

Hi,
With the latest version (build 831) I tried to export a Roon playlist. In Soundiz (CSV) or Excel format, same issue.
With a playlist of physical files or stream (Qobuz), same issue.
I can export physical files from my server to my Roon remote.
But impossible to create a playlist export.

Screenshot.

From log file :

10/01 20:56:25 Debug: [export/client/soundiiz] playlist export, spinning, remaining count: 1
10/01 20:56:25 Debug: [export/client] attempting to write out file: C:\Users\Stef\Desktop\Mix Johnny Griffin.csv
10/01 20:56:26 Warn: dumping library excel file: System.UnauthorizedAccessException: L'accès au chemin d'accès 'C:\Users\Stef\Desktop\Mix Johnny Griffin.csv' est refusé.
   Ă  System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   Ă  System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   Ă  System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   Ă  System.IO.File.InternalWriteAllBytes(String path, Byte[] bytes, Boolean checkHost)
   Ă  Sooloos.Client.RootDesktop.<>c__DisplayClass23_0.<dumpxls>b__0(Object <p0>)
10/01 20:56:26 Debug: [export/client/soundiiz] playlist export, spinning, remaining count: 0
10/01 20:56:29 Debug: [export/client/soundiiz] playlist export, spinning, remaining count: 1
10/01 20:56:30 Debug: [export/client] attempting to write out file: C:\Users\Stef\Desktop\Mix Johnny Griffin.xlsx
10/01 20:56:30 Warn: dumping library excel file: System.UnauthorizedAccessException: L'accès au chemin d'accès 'C:\Users\Stef\Desktop\Mix Johnny Griffin.xlsx' est refusé.

No idea ??? :roll_eyes:
Why does Roon not have write permission when I am the administrator on my computer (and Roon is logged in with admin rights).

I also discovered in my logs an approximation of my geographical location… not the right city but the 1st occurrence of a list of homonyms.
This one is just 300km from my home ! :laughing:

Because user folders are private and even the administrator account has to respect that. Also running Roon as Administrator instead of the actual user is not the standard IIRC. So run Roon as the user “Stef” or maybe you have more luck if you try to write the file to the all users desktop folder (C:\Users\Public\Desktop) instead. All users should have read/write access rights to that folder but he’s normally hidden.

Thanks BlackJack, maybe I misspoke.
I use my laptop under my user account “Stef” but this account has the same rights as administrator.
I can export files from a playlist and choose where to export them (\Stef\Desktop or any folder).
But for a playlist export in Soundiz or excel format, there is no choice, it’s necessarily the user’s desktop (see screenshot of the 1st post ).
I can’t change the target but Roon can’t write in the folder he chose !

Then maybe something is amiss on your machine. Check the access rights for Stef’s desktop folder. Hint: Also make sure the file you want to write to (Mix Johnny Griffin.[csv|xlsx]) isn’t already/still opened in another program. Do you use any Antivirus or malware protection software?
I can’t reproduce your issue on my machine, the file can be written to my desktop folder and is owned by my user account as expected when I inspect it’s rights.

It is still not clear to me why you insist on pointing to the administrator account or administrator rights assuming you are not doing anything unusual, something that other average users may not do too. If you do something unusual, this may be the cause of your problem, and if you stop doing it, the problem may be resolved.
If you clearly describe if and if so how your setup/usage is different from normal setup and general usage, it can help other people and the Roon support team a lot to understand your case. I know that this is not always easy, especially if English is a foreign language for you (and me too btw., so my answers are probably confusing you as much as your posting confuse me), but please try.

Let’s leave administrator rights aside… just Roon can write files to my user desktop when I ask it to export files + m3u.
So Roon has the necessary rights…


But there is a bug, to export to Soundiz or excel format, that’s all.

And yes, English is not my first language :slight_smile:

It works flawless on my machine but it does not work on your machine. Also Roon, as of my understanding, is just using the provided file access methods (System.IO) and doesn’t meddle around with users and rights on it’s own. The error returned though by your system (not Roon) is of the type System.UnauthorizedAccessException. This all looks to me as if the “bug” exists on your machine and not in Roon. So what is different/unusual in your setup? As long as no one else is able to reproduce your issue, you’re the only source of information.

I tried to help you, tried to get more concrete information from you, asked about third-party software like antivirus or malware protection software that might prevent the creation of potentially “dangerous” Excel files on the desktop (because you wrote that export files and playlist works for you). I’m tired now from trying to get substantial information from you which, from my point of view, didn’t yield any countable result so far. I will therefore leave it to others to try to help you from here on and wish you all the best luck.

1 Like

First of all, thank you !!!
It was a bit more complicated but it was Avast that locked me out of writing this type of file on my desktop ! Without any alerts !
There is nothing unusual on my system… except probably a poorly documented Avast update.
Once again, thank you! And sorry to have put you under strain!

1 Like

I’m happy to hear that the bug on your system could be found and things are now working for you.

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.