Q: How to create imported files with illegal character filenames
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?
I would say an easier approach would be to just rename the files at the file system and then re catalog them into FCSvr. I'd stay away from the database if you want to just make this change.
