1 Reply Latest reply: Oct 1, 2010 9:33 AM by Nicholas Stokes
grdore Level 1 Level 1 (0 points)
We have mistakenly loaded up a lot of files in Final Cut Server 1.5 with filenames that have illegal or not recommended characters in them i.e.

10/10/08-Clip1.mov

FCSvr has created proxys etc but then given the asset a name with colons instead of slashes and can't connect to the original clip. i.e.

10:10:08-Clip1.mov

To compound matters, the clip has been saved using ascii representations for colons (%3A) i.e.

10%3A10%3A08-Clip1.mov

I've managed to access the database backup using pgAdmin and it looks like these entries are set in the tables pxentity and pxdmvaluestringother.

I'm quite familiar with SQL etc so can update the values to legal ones and then rename the files the same. Is there anything I should be aware of in doing this?

Obviously I'll make backups etc before doing it.

Many Thanks

Mac Pro