如何自动化 - 在UNIX环境中加载数据文件的例行手动步骤 [英] How to automate -- routine manual steps to load the data file in UNIX environment

问题描述

嗨伙计们，

目前我正在研究一个有以下问题的项目，我想自动化这个问题

1）我们曾经发过一个平面文件数据进入某个FTP位置。
2）我们将平面数据文件移动到客户端的FTP位置后3）我们必须手动登录到他们的系统，我们必须提供上传的文件名（预定义文件名与当前日期）
在他们系统的导入文件部分。
3.1）他们为我们提供了一个用于远程终端登录的可执行文件.3.2）我们运行一个.exe它会询问用户名称和密码，一旦我们提供此信息
3.3）它将显示屏幕，如主机屏幕
1）生产
2）测试
3）演示
4）退出

输入您的选项.___

3.4）接下来它将显示菜单... ... 1）查看数据
2）维护
3）报告
4）注销
输入你的选择_____
同样我们必须遵循几个预定步骤，最后我们将提供我们想要的文件名导入到他们的数据库中

4）一旦我们提供文件名，它就会自动将文件数据导入他们的系统。

我想自动化步骤3和所有子步骤（3.1,3.2 ...）
他们有Unix终端，我曾经登录过。我可以编写一些脚本来自动执行这一步吗？

Highly感谢你的建议。

谢谢，
prashant

---

pbrathod

解决方案

< blockquote>您是在Windows环境中执行这些步骤还是在通过telnet连接到unix框时执行这些步骤？听起来好像您正在运行他们提供的处理用户I / O的可执行文件。除了交互模式之外，该程序是否还有其他选项？

如果程序使用标准I / O，那么您应该能够通过I / O重定向启动它并将其输入与手动输入相同的输入。如果他们只是为您提供运行程序的非交互式方法（例如提供响应文件），那将更可靠。

Hi guys,

Currently I am working on one project that has following issue, I want to automate this problem

1) We used to send a flat file data into some FTP location.
2) Once we moved our flat data file to client's FTP location
3) We have to manually log-in to their system and we have to provide uploaded file name (predefine file name with current date) 
    Under the import file section of their system.
        3.1) they provide us one executable for remote terminal login
        3.2) one we run this .exe it will ask user name and password, once we supply this information
        3.3) it will display the screen like mainframe screen
                  1) Production
                  2) Test
                  3) Demo
                  4) Logout
  
               enter your option.___
        
       3.4) next it will show menu like…
               1) View data
              2) Maintenance
              3) Reporting
              4) Sign off
              Enter your option____
 
 Similarly we have to follow couple of predefine steps and finally we will provide our file name that we want to import into their database

4) Once we provide file name it will automatically import the file data into their system.

I wanted to automate step 3 and all sub steps (3.1,3.2...)
They have Unix terminal where I used to logged in. Can I write some script to automate this step?

Highly appreciate your suggestions.

thanks,
prashant

---

pbrathod

解决方案

Are you performing those steps in a Windows environment or doing them while connected via telnet to the unix box?  It sounds as though you are running an executable that they supplied which processes the user I/O.  Does that program have any other options besides interactive mode?

If the program uses standard I/O then you should be able to launch it with I/O redirection and feed it the same inputs that you do manually.  It would be more reliable if they simply provide you with a non-interactive method of running the program (such a supply a response file).

这篇关于如何自动化 - 在UNIX环境中加载数据文件的例行手动步骤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！