November 19, 200817 yr Relinking 1000s of pdfs. I'm setting the container field to the path (filename is recordID.) However, some files are missing. How will I know? I don't want to test by using Go to Field (Select), with a looping script, because that'll potentially open the all the valid pdfs. Is there a way to check whether a referenced path is valid without opening the file? Please, comment, tell me the obvious answer, lol.
November 19, 200817 yr There is a parallel thread going on right now: http://www.fmforums.com/forum/showtopic.php?tid/199407/ Looping Go to Field [select], presumably with error capture, actually sounds interesting. If this is a one-time effort, you could do this in "installments", say a couple of hundred records in each batch.
November 19, 200817 yr Why not just use the Moo-plugin to do the check to see if the file exists? http://mooplug.com/docs/functions/moo_fileexists Its free. :o
November 19, 200817 yr Author Thank you all for your quick replies and suggestions. The whole story, (and there's always more to the story, huh?), is that one or more of the embedded pdfs were corrupted. This brought down the file. We were able to export from a backup all the docs, and set their name to the recordID. We also had the original file name. Long story short, it's all back as references and good. One lesson, is when building a system that allows a user to import a pdf from any source (this is a headhunter and these pdfs are mostly resumes), you must be careful that you don't embed corrupted files. Wouldn't it be nice if FM could filter out any bad files before it accepts it into a container?
Create an account or sign in to comment