Export to Excel not completing on Windows 11 with playlist over 800 songs (ref#LWGCTX)

What’s happening?

· Export feature hangs

How can we help?

· Please see below

Other options

· Other

Describe the issue

Hello. Using Roon 2.0 (build 1490). I received a Roon tip about exporting to Excel. I tried it 3x times last night on a playlist with 800+ songs, even letting the last attempt run overnight and it never completes. I do have Excel installed on my Windows 11 machine.

Any suggestions?

Describe your network setup

AT&T BGW320-505 ONT
Firewalla Gold
Dell PowerConnect 2816 Switch
Cat6 from that switch to my office
TP-Link TL-SG1016D Swtich
Cat 6 to my laptop.

It just sits at this screen

I’d like to weigh in with the same issue. I’ve been using roon for years, and have frequently done excel exports of playlists. Now they just display the “working” icon and hang, similar to the parent message. The playlists vary from about 200 to slightly over 1000 songs, length doesn’t seem to matter. Rebooting the roon server doesn’t help.
My roon server: OS 1.0 build 259. On rock (Intel NUC/10i7FNH, 32GB, 1 TB SSD, this used to be a recommended system by roon for rock). Roon server software: 2.0 build 1490
My roon client: Windows 10, also 2.0 build 1490. (note the initial post was running windows 11)
roon library: Samba mount from raspberry pi 5 server running raspbian.
Network: all machine above on cat 6 ethernet
Likely not relevant, but music system is connected via USB from rock to Benchmark DAC.
Again, used to work, same hardware. I’ve recently had one or two successful exports, but 20 or so other attempts just hang. Have roon server logs mounted on windows, don’t see anything helpful in the logs, but I may not know enough about the roon server to be looking in the right place.

Hey @Jamie_Dewoody1 and @jim_hamilton,

Thanks for sharing your report of the export function not completing successfully! What were the specific names of the playlists you’ve attempted to export? While our team takes a closer look into things, we have a few follow-up questions:

  1. Are you able to successfully export via Folder or Sounddiz?
  2. What type of content are on the failed playlists? Local content, streaming content, or a mixed bag?
  3. Are you able to export a smaller playlist, lets say one under 100 tracks via excel successfully?

We’ll be on standby for your reply, thank you!

I appreciate the prompt customer support.
I have extensive experience with excel export, have not had reason to try the folder or sounddiz exports up to now. Per your questions:

  1. successfully exported a small “demojazz” playlist (9 hi-res tracks) via folder. Same playlist hangs on sounddiz export, similar to excel export attempts
  2. All the playlists are built from local files on my fileserver - local content, no streaming content
  3. the playlists range from 9 to about 1500 tracks. They all used to export fine, now every one I have tried has simply hung…The 9 track “demojazz” playlist that exported via the “folder” option still hangs on attempted excel export.
  4. specific names of playlists: no special characters if thats the concern. Names include: play1, play2, rock, jazz1, jazz2 - simple vanilla ascii text names.

Hi @jim_hamilton, @Jamie_Dewoody1

We’d like to reproduce this issue with a copy of your Roon database(s). At your convenience, please navigate to your Roon Database Location, zip up (compress) the “RoonServer” folder, and upload it here to our Database Uploader.

Thank you!

Benjamin,

Thank you for the reply.

  1. I can export to folder successfully. Export to Soundiiz does not work.
  2. All media is local .flac files.
  3. I tried my smallest playlist, which was 102 files and it did not complete.

I have uploaded the roonserver folder as requested. Since these uploads are pretty big, it would be a good idea to make uploads resumable. With typical home connections, they take hours. My first attempt failed at the 2/3 mark.
I do have one factoid, though its a shot in the dark and probably irrelevant. I had a number of .m3u playlists, some prior to roon. They were in my music directory: roon found them and played them fine. When roon introduced “playlist improvement” (a great feature), I integrated these m3u-derived playlists with roon playlists (by queuing up the playlists and then using roon to append them to existing playlists). A second comment is that, while I have used playlist export extensively, I hadn’t done so for a while until my recent attempts, so I can’t correlate the current problem with a specific roon build.

Hi @jim_hamilton,
You don’t need to upload the entire RoonServer folder. We only need the log folder inside of the RoonServer folder. That should upload fairly quickly.

good to know, but given the original, explicit instruction to upload the roonserver folder, I did so.

I took another look at @connor’s post. I was incorrect about what he was asking for. My apologies.

My exports also never complete.

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