Check Attachments - Revision history

Alnaucler at 13:15, 9 November 2016

2016-11-09T13:15:31Z

← Older revision		Revision as of 15:15, 9 November 2016
Line 2:		Line 2:
	<ol>		<ol>
	<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments'' folder.		<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments'' folder.
	[[Image:DOS cmd list.png\|600px\|center]]		[[Image:DOS cmd list.png\|600px\|center]]<br/>
	<li> List the file names with the command ''dir /b > myfile.txt''		<li> List the file names with the command ''dir /b > myfile.txt''
	<li> Use Navicat and import the file ''myfile.txt'' to table ''test''		<li> Use Navicat and import the file ''myfile.txt'' to table ''test''
	:If needed delete the row with ''myfile.txt'' from the table ''test''.		:If needed delete the row with ''myfile.txt'' from the table ''test''.
	<li> Add field ''guid'' to table test (varchar 38).		<li> Add field ''guid'' to table test (varchar 38).
	[[Image:Check attachment1.png\|700px\|center]]		[[Image:Check attachment1.png\|700px\|center]]<br/>
	<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.		<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'''		:'''Example query'''
Line 44:		Line 44:
	:'''Missing in the table''' (in my example 6625)		:'''Missing in the table''' (in my example 6625)
	<pre>		<pre>
	~~6625~~		SELECT
			"public".attachment.filename,
			"public".test.f1
			FROM
			"public".attachment
			RIGHT JOIN "public".test ON "public".attachment.attachment_guid = "public".test.guid
			WHERE
			"public".attachment.attachment_guid IS NULL
	</pre>		</pre>
	</ol>		</ol>
			[[Category:SQL Queries]]
	[[Category:NoPublic]]		[[Category:NoPublic]]
	{{NavBox Hub}}		{{NavBox Hub}}

Alnaucler at 13:12, 9 November 2016

2016-11-09T13:12:39Z

@@ Line 9: / Line 9: @@
 [[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}}

Alnaucler at 11:18, 9 November 2016

2016-11-09T11:18:30Z

← Older revision		Revision as of 13:18, 9 November 2016
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>		<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]]		[[Image:DOS cmd list.png\|600px\|center]]
	<li> List the file names with the command ''dir /b > myfile.txt''		<li> List the file names with the command ''dir /b > myfile.txt''
	<li> Use Navicat and import the file ''myfile.txt'' to table ''test''		<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>		</ol>
	[[Category:NoPublic]]		[[Category:NoPublic]]
	{{NavBox Hub}}		{{NavBox Hub}}

Alnaucler: Created page with "

Open the Command window and navigate to ''C:\IMSMAng\server\attachments''. center
List the file names with the command ''dir /b..."

2016-11-09T10:03:13Z

Created page with "<ol> <li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments''. 600px|center <li> List the file names with the command ''dir /b..."

New page

<ol>
<li> Open the Command window and navigate to ''C:\IMSMAng\server\attachments''.
[[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
<li>
</ol>
[[Category:NoPublic]]
{{NavBox Hub}}

Check Attachments - Revision history

Alnaucler at 13:15, 9 November 2016

Alnaucler at 13:12, 9 November 2016

Alnaucler at 11:18, 9 November 2016

Alnaucler: Created page with " Open the Command window and navigate to ''C:\IMSMAng\server\attachments''. center List the file names with the command ''dir /b..."

Alnaucler: Created page with "

Open the Command window and navigate to ''C:\IMSMAng\server\attachments''. center
List the file names with the command ''dir /b..."