See hidden file extensions in VBScript

<package>
<job id="ftp">
<script language="VBScript">
Dim user, pass, server, local_path, remote_path
user="Admin"
pass="*******"
server="ftp_server"
local_path="file_path"
remote_path="remote_path"
 
' Create a temp file to hold the script
Dim fso, ofile, fname
Set fso=CreateObject("Scripting.FileSystemObject")
fname=fso.GetTempName()
Set ofile=fso.CreateTextFile("C:\temp\" & fname)
 
' Output login credentials to the script
ofile.WriteLine("open " & server)
ofile.WriteLine(user)
ofile.WriteLine(pass)
ofile.WriteLine("cd """ & remote_path & """")
 
 
Dim app, objFolder, colItems, i
Set app = CreateObject("Shell.Application")
Set objFolder = app.Namespace(local_path)
Set colItems = objFolder.Items
 
' This section finds the most recently-created replication directory.  
' They're named according to date and time, so it suffices to just find the one with the greatest name, lexicographically speaking
Dim latest
latest=""
 
For i = 0 to colItems.Count - 1
	If ((colItems.Item(i).Name > latest) And (colItems.Item(i).IsFolder)) Then
		latest = colItems.Item(i).Name
	End If
Next
 
 
Set colItems = Nothing
Set objFolder = Nothing
 
' set script to create this directory on the FTP server, and change to it
ofile.WriteLine("mkdir " & latest)
ofile.WriteLine("cd """ & latest & """")
 
' now enumerate the files in the local directory of interest, and dump them to the output file
local_path = local_path & "\" & latest
Set objFolder=app.Namespace(local_path)
Set colItems = objFolder.Items
For i = 0 To colItems.Count - 1
	If (Not colItems.Item(i).IsFolder) Then
' Here's where the problem is.  Neither of the following two approaches works.  Maybe something using WMI?
		'ofile.WriteLine("put """ & local_path & "\" & colItems.Item(i).Name & """")
		ofile.WriteLine("put """ & local_path & "\" & objFolder.GetDetailsOf(colItems.Item(i), 0) & """")
	End If
Next
 
ofile.WriteLine("quit")
ofile.Close()
Set ofile=Nothing
Set fso=Nothing
Set colItems = Nothing
Set objFolder = Nothing
Set app = Nothing
 
Dim objShell
Set objShell = CreateObject("WScript.Shell")
objShell.Run "c:\windows\system32\ftp.exe -v -s:" & fname, , True
Set objShell = Nothing
Set fname = Nothing
</script>
</job>
</package>

Select allOpen in new window