Q
Problem solve Get help with specific problems with your technologies, process and projects.

Automating the data extracting process

I have custom processes that run in a robot environment extracting data that is used to update a spreadsheet. I'm updating the spreadsheet manually using a macro within the Excel file. How can I automate this process and have it completed when the night robot jobs are completed? The data is on the iSeries and the spreadsheet is on our Novell Server.
You can do the following to automate the process:

* In your CL -- after the file is prepared -- use command CPYTOIMPF and your file will be copied to a stream file.

 
CPYTOIMPF FROMFILE(MYFILE)
          TOSTMF('/tmp/streamf.csv')
          MBROPT(*REPLACE)
          RCDDLM(*CRLF)
          DTAFMT(*DLM)
Note that the CSV extension is important.

* Ftp the resulting stream file to the network drive. (Novell has a built in FTP server.)

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.


Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close