Group File Exchange; Bb8 -> Bb9 missing link name

Just ran into an issue with trying to restore Group File Exchange files from a Bb8 archive. After the restore the file was there, but filename was not being displayed in the Bb9 Group File Exchange UI. There's no link to "click" on.

In Bb8.0SP5 Hotfix2, Group File Exchange:

In Bb9.1SP5, after restoring the Bb8 archive:

I tracked it down to a difference between how Bb8 and Bb9 added files.

In Bb8 (8.0SP5 Hotfix 2), when you add the file to the Group File Exchange, the name was optional. So link name could be blank.

In Bb9 (9.1SP5), when you add the file to the Group File Exchange, the name is required. So link name can never be blank.

The Bb9 Group File Exchange UI expects a link name, so when it is blank it displays nothing there.

The fix I did was to update the bb_bb60.dbo.files table

update [bb_bb60].[dbo].[files]
set link_name = file_name
where link_name = '' and file_name != '' and file_action='LINK'

Once I did that, I could see the links in the Group File Exchange UI.