Changes

<ol>

<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments'' folder.

<li> List the file names with the command ''dir /b > myfile.txt''

<li> Use Navicat and import the file ''myfile.txt'' to table ''test''

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

<li> Add field ''guid'' to table test (varchar 38).

<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.

:'''Example query'''

:'''Missing in the table''' (in my example 6625)

<pre>

</pre>

</ol>

[[Category:NoPublic]]

{{NavBox Hub}}