Advertisement

11.08.2007 at 04:33AM PST, ID: 22947100
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

FTP a file to a directory and then remove the local file

Tags: ftp, local, file
I need to be able to do the following:
- Set up a scheduled taks to open an FTP conenction
- Move a file from a local directory
- Delete or move the file locally if it's been successful
- When complete close the connection until the next scheduled task

I cannot delete the contents of the dirtectory (e.g. *.txt) because new items are added all the time
Start your free trial to view this solution
Question Stats
Zone: Networking
Question Asked By: ghutchins
Solution Provided By: ReconIT
Participating Experts: 2
Solution Grade: B
Views: 45
Translate:
Loading Advertisement...
11.08.2007 at 05:36AM PST, ID: 20240973

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.08.2007 at 05:43AM PST, ID: 20241037

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.09.2007 at 06:00AM PST, ID: 20249389

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.12.2007 at 08:26AM PST, ID: 20265089

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • Automotive
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Displays / Monitors
  • Handhelds / PDAs
  • Components
  • Peripherals
  • Laptops/Notebooks
  • Servers
  • Misc
  • Apple
  • Embedded Hardware
  • Networking Hardware
  • Storage
  • Desktops
  • New Users
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMware
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Virtualization
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • Web Computing
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Consulting
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMware
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Automation
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Web Services
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Web Computing
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Lounge
  • Business Travel
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
  • Automotive
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
11.08.2007 at 05:36AM PST, ID: 20240973
write one batch file that executes an FTP script (Create a text file for this) then have the batch file delete the local file Example:


cd\mydir
ftp -s:ftpscript.txt
delete myfile
exit

FTPscript.txt

open address here
ANONYMOUS
password
put myfile
bye
 
11.08.2007 at 05:43AM PST, ID: 20241037
Thanks for that.

The problem I have is the file name is a reference (e.g.):
1111.txt
1112.txt
1113.txt
1114.txt

I need to move files from my directory to the FTP site, so I need a way to move 1111.txt, once successfully moved delete it and then move onto the next file.  As this process is happening new files are being placed into the directory (1115.txt)
 
11.09.2007 at 06:00AM PST, ID: 20249389
Sounds difficult....

if exist c:\1111.txt goto continue
exit
continue:
cd\mydir
ftp -s:ftpscript.txt
delete myfile
exit

Of course you would have to throw a loop in there to cycle through until it finds a file that still exists... Probably still Not the best way to do it.....I'm sure you can do this with a batch file but perhaps something like vbscript would be more useful.

Unfortunately, most of my programming experience is with using VBA and some Visual Basic.net
I'll take a look over some batch file programming and some vbscripts and see if I can figure something out for you.

 
11.12.2007 at 08:26AM PST, ID: 20265089
You might find this helpful. We use the CUTEFTP client (around $60) on our servers (installed as a service running under an account that has permissions on the needed directories) and call vb scripts from scheduled tasks. This exact script is pulling files from the remote host over ftps but it could easily be modified to push files over standard FTP (assuming you purchase and install CUTEFTP). We have the same issue where files are always being added. The nice thing about this is when the task runs you get a snap shot of what is currently there and only work with those files.  

Dim MySite
  Dim Local
  Dim Remote
  Dim TextFile
   
dim f1,ts

  Dim fso
  set fso = CreateObject("Scripting.FileSystemObject")
 
'Create a connection object and assign it to the variable

  Set MySite = CreateObject("CuteFTPPro.TEConnection")
  Local = "[Local Directory Path]"
  Remote = "[Remote Directory Path]"
  TextFile = "[File Path]"
  LogFile = "[File Path]"
   
  MySite.Protocol = "FTPS"
  MySite.Host = "[Host Address]"
  MySite.Port = 21

  MySite.Login = "[Login]"
  MySite.Password = "[Password]"
  MySite.SocksInfo = ""
  MySite.ProxyInfo = ""


on error resume next


  MySite.Connect
   
  if  err.number <> 0 then

   set ts = fso.OpenTextFile (Logfile,8)
   ts.WriteBlankLines (1)
   ts.WriteLine (err.description  & Date & " " & Time )
   ts.close
   set ts = nothing
   set f1 = nothing
   on error goto 0

   wscript.quit 1
  end if

   MySite.LocalFolder = Local

   'Creating a List of Remote Files

   MySite.GetList Remote, TextFile,"%NAME"

   set textStreamObject = fso.OpenTextFile(TextFile,1)

   'Opening Text File and Reading Filenames for Download and Delete
   Do While Not textStreamObject.AtEndOfStream
       Line = textStreamObject.ReadLine
         'Now download data file
         MySite.Download Remote & "/" & Line
       if MySite.Status = "FINISHED" then

'        If (MySite.LocalExists(Local & "\" & Line)) Then
           'Delete Remote File
           MySite.RemoteRemove(Remote & "/" & Line)
       End If

   Loop

'Clear
MySite.Disconnect
Set fso = Nothing
Set textStreamObject = Nothing
On Error Goto 0
Accepted Solution
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628