Workflow Question

Hello,

I have the following way of working:

I create a new session, for example Florian_Schmitt_14_06_2022_ then I shoot via tethering only the JPEGs in the computer I save the RAW + JPEGs on the camera's memory card.
For example, the files on the Sony card are named DSC1234 but the files in CO 22 are named Florian_Schmitt_14_06_2022_001. My clients rate the images with Capture Pilot with stars. So that I can see the rating directly in Capture One, so far I have simply copied the xmp files from CO Folder to the card and if the files have exactly the same name, Adobe Bridge, for example, also recognizes the ratings and can assign the rating to the file. But if the file doesn't have the same name, it won't work. In Sony cameras you can only store 3 letters for naming the files. The only option I see at the moment is to rename all the files on the card to what the JPEGs are called in CO22. And that after every shoot on multiple cameras.

I can't transfer RAWs because the transfer with Wifi takes too long.

Is there a better solution?

Please help

Thanks