Check Attachments: Difference between revisions

Revision as of 12:18, 9 November 2016

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

Open the Command window and navigate to C:\IMSMAng\server\attachments folder.
List the file names with the command dir /b > myfile.txt
Use Navicat and import the file myfile.txt to table test
If needed delete the row with myfile.txt from the table test.
Add field guid to table test (varchar 38).
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.

@@ Line 1: / Line 1: @@
+In this example there are '''4765''' rows in the ''attachment'' table and there are '''8660''' files in the ''C:\IMSMAng\server\attachments'' folder.
 <ol>
-<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments''.
+<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments'' folder.
 [[Image:DOS cmd list.png|600px|center]]
 <li> List the file names with the command ''dir /b > myfile.txt''
 <li> Use Navicat and import the file ''myfile.txt'' to table ''test''
-Make sure the output file are not included in the table test i.e. myfile.txt
+:If needed delete the row with ''myfile.txt'' from the table ''test''.
-<li>
+<li> Add field ''guid'' to table test (varchar 38).
+[[Image:Check attachment1.png|700px|center]]
+<li> 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.
 </ol>
 [[Category:NoPublic]]
 {{NavBox Hub}}