Solved

What programming language to use

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This is an explanation of a simple data model to help parse a JSON feed
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 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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

749 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