We have tables containing test data attached to our manual test cases in TestDirector. My question is this:
If someone makes a change to a test data table, does the user have to go in and delete the attachment and then add it again in order for the changes to be reflected? I am guessing that you do, since when you open the attachment (Excel) and save it, it doesn't save it to the TD database but to a local or network drive. Is there a way to save changes made to the table in TestDirector?
I think this is explained in Open Test Architecture guide (in the section that explains TD project directory structure).
All file attachments physically persist in Attach folder of the project repository, and have names like [entity]_[id]_[real attachment name] (for example: TEST_123_My Doc.txt).
However I wouldn't advise you to give the users access to this directory. From my experience this causes a lot of problems and project repository becomes a mess: people delete/rename documents directly in file system (which doesn't delete/change document "pointer" from TD, then others cannot understand why the document cannot be opened, or the wrong document is opened, etc.). Or they save files directly to this folder, and then wonder why they don't see them in TD... Of course it's the matter of education, but it's always better to keep project back-end away from users.
Probably, if there's a lot of document editing in your company, and you are an admin, you can create some tool (using TD API), which would allow batch upload of many documents.