Jkuehlthau at 19:09, 10 September 2015

2015-09-10T19:09:53Z

← Older revision		Revision as of 19:09, 10 September 2015
Line 1:		Line 1:
	I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the same xref list, thanks to the use of the newer SQLite xref list functionality, http://wiki.starfishetl.com/index.php/Cross-reference_(Xref)#SQLite_Xref. In this code, I check to see if the record I'm reading already exists in the XREF. If it exists, then I know it is a duplicate and can proceed to the Delete Stage. If it is not a duplicate~~, then~~ I write the data to the XREF and skip the Delete Stage.		I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the same xref list, thanks to the use of the newer SQLite xref list functionality, http://wiki.starfishetl.com/index.php/Cross-reference_(Xref)#SQLite_Xref. In this code, I check to see if the record I'm reading already exists in the XREF. If it exists, then I know it is a duplicate and can proceed to the Delete Stage. If it does not exist, then it is not a duplicate and I write the data to the XREF and skip the Delete Stage.
	<source lang="vb">		<source lang="vb">
	Sub VBScriptProcedure		Sub VBScriptProcedure

Jkuehlthau: Created page with "I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the A..."

2015-09-10T19:09:01Z

Created page with "I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the A..."

New page

I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the same xref list, thanks to the use of the newer SQLite xref list functionality, http://wiki.starfishetl.com/index.php/Cross-reference_(Xref)#SQLite_Xref. In this code, I check to see if the record I'm reading already exists in the XREF. If it exists, then I know it is a duplicate and can proceed to the Delete Stage. If it is not a duplicate, then I write the data to the XREF and skip the Delete Stage.
<source lang="vb">
Sub VBScriptProcedure
dim strExists
strExists = xrefread("sf-attachments","@@ORG:ParentId@@@@ORG:NAME@@")
If strExists = "Exists" Then
LogMessage "Duplicate of: @@ORG:NAME@@"
Else
XrefWrite "sf-attachments","@@ORG:ParentId@@@@ORG:NAME@@","Exists"
GoToNextRow
End if
End Sub
</source>

Check for duplicates using xref - Revision history

Jkuehlthau at 19:09, 10 September 2015

Jkuehlthau: Created page with "I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the A..."