Re: Searching for a solution with Batch programming


<RivaCom@xxxxxxxxx> wrote in message news:acd0125b-5118-46b9-a5a7-d0eea19a8c60@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I was tasked with a job to write a batch program to download a excel
file from a FTP and convert it to CSV, getting the file was a 2 second
job. But finding a free program to convert xls 2 csv or txt was a
nightmare. I finally found a standalone app, which i can run from
command line. My problem being after it converts a dialog pops up
saying "Conversion Complete", and I can't figure out how I would go
about exiting the program. The last few lines of commands go:

ftp -s:download.bat
open ftphyperlink
username
password
get test.xls
bye
xls2csv.exe test.xls
exit

Anyone have any suggestions or better solutions? This will be running
on windows server 2003, with no office applications on it.

Are you a programmer? If you are one, then just use a .Net Console application. I used a client Web service Console application that was on a NT Scheduler, pull XML transactions from the 3rd party Web service and ended the Console application when done. It is setting out on a Win 2k3 server.


.

Relevant Pages

  • Re: Time Differences
    ... console but UTC on the FTP session. ... window than they are in the PuTTy window. ... print server, that shows all times an hour different from the console ...
    (RedHat)
  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... command line. ...
    (comp.programming)
  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... command line. ...
    (comp.programming)
  • Searching for a solution with Batch programming
    ... I was tasked with a job to write a batch program to download a excel ... file from a FTP and convert it to CSV, getting the file was a 2 second ... command line. ...
    (comp.programming)
  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... Excel is good at converting Excel worksheets to CSV. ...
    (comp.programming)