PdcAttachmentList.ReadFromTableName - Revision history

TC at 12:26, 5 January 2024

2024-01-05T12:26:56Z

← Older revision		Revision as of 12:26, 5 January 2024
Line 3:		Line 3:

	== Description ==		== Description ==
	This function will read the attachments based on the TableName and Id string. <br>		This function will read the attachments based on the TableName and Id string. All available properties will be filled in from the database/docrepo/sharepoint. The file will also be downloaded to a temp directory, and the location of this file will be available in the [[PdcAttachment.TempFilePath]] property. In the case of Sharepoint it will not copy the file if a local sharepoint folder is available, it will then put the local path in this property. So the file will always be available at the path stored in the [[PdcAttachment.TempFilePath]] property.<br>
	<br>		<br>
	When reading attachments from Sharepoint, it will include a full path towards the file. ~~If the user has a local sharepoint folder, it will return the path to the file inside this local folder. <br>~~		When reading attachments from Sharepoint, the [[PdcAttachment.FileName]] will include a full path towards the file. otherwise it will only include the filename without the full path.
	~~If there is no local sharepoint folder, it will download a copy of the attachment to the Bemet temp directory, and include the full path towards this file.<br>~~
	~~<br>~~
	~~If sharepoint is not used,~~ it will ~~always copy the attachment to the Bemet temp directory, and~~ only include the filename without the full path.

	== Notes ==		== Notes ==
Line 23:		Line 20:
	end if		end if
	end if		end if
			</source>

			Copying all attachments of a calculation to a sales invoice
			<br>
			<source lang="vb.Net">
			Dim calcAttachList As PDCEXT.IPdcAttachmentList = PDC.App.AttachmentList
			calcAttachList.ReadFromTableName("DO_CALC", tbCalcNr.Text)

			Dim invAttachList As PDCEXT.IPdcAttachmentList = PDC.App.AttachmentList
			invAttachList.ReadFromTableName("FACTUUR", tbInvNr.Text)

			For attachIndex As Integer = 0 To calcAttachList.Count - 1
			Dim attachment = calcAttachList.Items(attachIndex)

			Dim copyAttachment As PDCEXT.IPdcAttachment = invAttachList.Add
			copyAttachment.FileName = attachment.FileName
			copyAttachment.TempFilePath = attachment.TempFilePath
			copyAttachment.Save("")
			Next
	</source>		</source>

	== Availability ==		== Availability ==
	Changed in 2022 R3		Changed in 2022 R3

TC at 11:11, 29 November 2023

2023-11-29T11:11:55Z

← Older revision		Revision as of 11:11, 29 November 2023
Line 3:		Line 3:

	== Description ==		== Description ==
	This function will read the attachments based on the TableName and Id string.		This function will read the attachments based on the TableName and Id string. <br>
			<br>
			When reading attachments from Sharepoint, it will include a full path towards the file. If the user has a local sharepoint folder, it will return the path to the file inside this local folder. <br>
			If there is no local sharepoint folder, it will download a copy of the attachment to the Bemet temp directory, and include the full path towards this file.<br>
			<br>
			If sharepoint is not used, it will always copy the attachment to the Bemet temp directory, and only include the filename without the full path.

	== Notes ==		== Notes ==

TC: Created page with "== Declaration == ReadFromTableName(tableName as String, Id as string) as Boolean == Description == This function will read the attachments based on the TableName and Id stri..."

2023-07-28T14:48:49Z

Created page with "== Declaration == ReadFromTableName(tableName as String, Id as string) as Boolean == Description == This function will read the attachments based on the TableName and Id stri..."

New page

== Declaration ==
ReadFromTableName(tableName as String, Id as string) as Boolean

== Description ==
This function will read the attachments based on the TableName and Id string.

== Notes ==

== Code example ==
This example loads all attachments related to calculationnumber 12345
<source lang="vb.Net">
Dim attachmentlist As PDCEXT.PdcAttachmentList = PDC.App.AttachmentList
if attachmentlist.ReadFromTableName("DO_CALC", "12345") then
if attachmentlist.Count > 0 then
For index = 0 to attachmentlist.count - 1
Dim attachment as PDCEXT.PDCAttachment = attachmentlist.Items(index)
Next
end if
end if
</source>

== Availability ==
Changed in 2022 R3