Changes

Check Attachments

403 bytes added, 13:18, 9 November 2016

no edit summary

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''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 :If needed delete the output file are not included in row with ''myfile.txt'' from the table ''test i''.e<li> Add field ''guid'' to table test (varchar 38). myfile[[Image:Check attachment1.txtpng|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}}

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits