Regenerate File Meta?

Dear support team,

we migrated an old member directory page onto a new page based on Ultimate Member. We successfully imported our old users and their meta fields. But we are facing one problem we just can’t solve. It’s about the file uploads (audio files). We did save the absolute file paths from our old database into the new user meta fields. In our case for example the meta field is called sk_audio01 and it could have something like https://example.com/wp-content/uploads/2015/05/user-audio.mp3 in it. This works on our frontend listings / profile pages but we ran into troubles if users try to edit their profile because those file upload form fields don’t recognise this and will clear all those fields when saving the profile.

As we already found out, there should be actually only the file name in the meta field instead of the absolute path and furthermore there should be some serialized data in a 2nd meta field called sk_audio01_metadata. But we are missing those.

So my question is, is there any solution to run some code that converts or regenerates these meta fields to have the database entries in a proper way?

Hope to get some feedback on this issue.

Thanks in advance,
Christian