Solved

What programming language to use

Posted on 2013-01-17
4
352 Views
Last Modified: 2013-01-28
Windows 2003

I need to write a program that will, at a scheduled time, do the following:

-Download a file from an SFTP site
-Unzip and decrypt the files
-Copy one of the files to a new location
-Run an external program
-Read a text file for a specific value
-Send an email if value 1 is found; copy all the files to a new location if value 0 is found

What would be the best/easiest programming language to use?
0
Comment
Question by:Whah
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 38788660
Assuming that you don't need to code the algorithm for decrypting and you just need to call into WinZip or something, I would use AutoIT or vbscript and use Windows Task Scheduler for the scheduling.
0
 
LVL 1

Accepted Solution

by:
dionis earned 500 total points
ID: 38788733
I recently did most of this for a project.  When presented with a project like this,  I typically ask myself which platform will I work from based on the functions I need to perform and the tools I have.  I used scheduled tasks and bat files to wget/move/rename files.  And then I used coldfusion and it's task scheduler to process the files because of the XML functionality.

I suppose you already know what platform you want since you have an external program to run.  Are you working from Windows?  Most of the above can be done from a bat script.  Now you need to determine what to use for processing your data and sending the email.
Coldfusion is pretty easy if you have a server set up.  Otherwise, I would look to VBScript.
0
 
LVL 16

Expert Comment

by:AlexPace
ID: 38802057
You can use Robo-FTP to do all of this.

-Download a file from an SFTP site.
   FTPLOGON with /servertype=SFTP to connect
   RCVFILE to download

-Unzip and decrypt the files
  The UNZIP command unzips and can remove AES encryption
  Use the PGPDECRYPT command if the encryption is with PGP

-Copy one of the files to a new location
  The COPY command copies a file or use MOVE to move it



-Run an external program
  The EXEC command launches an external program or use DOSCMD to run OS  commands

-Read a text file for a specific value
  The READFILE command will help you do this

-Send an email if value 1 is found; copy all the files to a new location if value 0 is found
  Use the CREATEMAIL and SENDMAIL commands to do this.
0
 

Author Closing Comment

by:Whah
ID: 38827735
I ended up using a batch script.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Simple Linear Regression
Six Sigma Control Plans

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question