To convert all the existing [.docx] files into [.doc] files.
Would it be possible to do a mass update in AGILE to convert all the existing [.docx] files into [.doc] files.
You could do this directly in the tables BUT PLEASE PLEASE PLEASE thoroughly before doing any of this in production…. just need to say that just cause I have seen so many issues…. best of luck.
Are you talking about just changing the file extension in Agile, or actually converting the files from .docx (Office 2007 onward) to .doc (Office 2003)???
But probably both, so here goes. Converting the file formats would have to be done in the file vault, and probably best done via a script that called MSWord to open each file and and do a save-as using the .doc format. Changing the file extension in Agile, you would want to modify FILES.FILETYPE, which is where just the file extension is stored. The actual file name (FILES.FILENAME) also contains the file extension, so that value would have to be changed as well. And of course, you would then need to eliminate all of the “old” .docx files from your file vault (unless you have lots of disk space) once the “new” files had been created.
And as Patrick said, *TEST* your process/procedure to do this in your DEV/TEST environment first. And even then, make a full backup of the database *and* file vault before doing this in your production environment. It is far too easy to get yourself where things are so screwed up you may not be able to recover, if you do not plan to fail and take precautions thereof.