Re: Searching for a solution with Batch programming

On Feb 26, 9:39 pm, "Mr. Arnold" <MR. Arn...@xxxxxxxxxx> wrote:
<Riva...@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.

It's more of a question what am I not? Heh, I am basicly a System/
Network Admin, PC support, and programmer wrapped into one. Our IT
group is very small for a rather large company. I would love to sit
down and hack out some code for this. As far as the rather rude
response for Excel, Excel costs money, and with a very tightly run
company, I could use the money from a office package elsewhere. .Net
might be the best way to go, I figured there was a simple enter
command or exit dialog command I could throw up, solving the problem
quickly, but I guess not. The space didn't work either, thanks for
the suggestion though. I've tried echoing as well with no luck.
.

Relevant Pages

  • Re: finding a fax in the fax console?
    ... The command line is for the Open command for TIF files. ... > I am still unable to view any faxes from the console. ... >>>>Inbox to the Outlook Inbox. ...
    (microsoft.public.outlook.fax)
  • RE: DLL error prevents me from using Windows...please help...
    ... I tried to open Rcovery Console through SAFE MODE W/ COMMAND ... I'm attempting the Recovery Console EXPAND feature, ... >> I don't have video on my motherboard. ...
    (microsoft.public.windowsxp.general)
  • Re: Which distro for a server?
    ... > everything that I need with only a text console. ... > that doesn't exactly help me in learning linux on my own. ... command line commands or names of configuration files - field-based editing ... me a virtually seamless full screen linux GUI. ...
    (comp.os.linux)
  • Re: Why isnt OMVS command integrated with ISPF?
    ... the operator never needs to press ATTN before entering a command. ... you can now run a true z/OS console on a VTAM ... z/OS Unix session, if only to see how externalsbehaves under Unix. ...
    (bit.listserv.ibm-main)
  • Re: cmdEX.exe - augmenting the existing CMD.EXE
    ... interfaces to get to the edit buffer. ... the console could be redirected to a Unicode graphical shell. ... provide extended command line completion for the current context. ... given the current context, and a way of returning the appropriate options.. ...
    (microsoft.public.win2000.cmdprompt.admin)