Interact with the local file system

From Starfish ETL
Revision as of 17:58, 8 September 2015 by Jkuehlthau (talk | contribs)
Jump to navigation Jump to search

Check if a file exists

Sub VBScriptProcedure
	If Not FileExists(AttachmentPath & "@@ORG:FILENAME@@") Then 
		GotoNextRow
	End If
End Sub

Move and rename a file

I imported files directly into a Sugar instance's database. The file had to be named the Knowledge Base Article's ID. I moved and renamed the file as the KB article was create:

Sub VBScriptProcedure
	MoveFile "@@ORG:FullName@@","C:\uploads\@@STG:1,id@@"
End Sub