Solved

What programming language to use

Posted on 2013-01-17
4
347 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
factorial example challenge 10 92
autoit - check if option is checked in another program 2 109
Eclipse Neon start with Admin account only 6 92
Apps blocked by Java 9 63
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now