Check Attachments

In this example there are 4765 rows in the attachment table and there are 8660 files in the C:\IMSMAng\server\attachments folder.

1. Open the Command window and navigate to C:\IMSMAng\server\attachments folder.

   

2. List the file names with the command dir /b > myfile.txt
3. Use Navicat and import the file myfile.txt to table test

   If needed delete the row with myfile.txt from the table test.

4. Add field guid to table test (varchar 38).

   

5. Now the field guid table test should be populated. The value is part of the file name and therefore the UPDATE query has to be run for each case.

Template:NavBox Hub