Topic "Required Shell script for Automation"

Author Message
g.ganiraju
[View user's profile]

Joined: 2010-08-16
Posts: 4
Location: Pune
Hi ,

I need a automatio shell script for the following requiremnt.can any one please help me for this.

Requirement:

1. Connect to stage server and use WinSCP to retrive the file "xyz.dat" from the above mentioned server and path. This is the inventory file.
2. Open the inv.txt file present in E:\ABC. NOTE: inv.txt is used to process the data in Flx.mdb file.
3. Place the records in inv.txt and just validate for the number of records with the source file.
4. Delete the a.xls present in E:\ABC\
5. Once the latest inv.txt is ready, open the E:\ABC\Flx.mdb access file.
6. Click on Open, then on "Daily Sales Vs. buy Report".
7. Click on "Import Data" tab. "ALL EXISTING DATA WILL BE LOST !!!" msg will pop up. Just click on "OK" tab.
8. Flx.mdb will prompt for ODBC connection password. Supply the same to connect to GHI.WORLD. Username: DWH_ABC pwd : abcde
9. Once data gets imported, "Import Completed" pop-up window appears.
10. Click "OK". Then click on "Output to Excel" tab to export the data to excel sheet.
11. Pop-up window "Export Complete" appears. Click on "OK".
12. This export will generate an ijk.xls file in E:\ABC\ path. Open the .xls and run the below macros.
13. Goto Tools --> Macros --> Macros, to run the Macros from Excel sheet.
14. Run the macro - "PERSONAL.XLS!macNewIJK".
15. Click on the 'Sales vs buy' sheet below. Then go to Window->unfreeze pane.
16. Once done, save the ijk.xls as Sales vs. buy Report - <Month 'YY>.xls in E:\ABC folder.

Thanks.
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
Please read documentation. If that does not help, come back.
_________________
Martin Prikryl
g.ganiraju
[View user's profile]

Joined: 2010-08-16
Posts: 4
Location: Pune
Hi,

I am very new to scripting.So can you please help me to write the script for the above requirement.Hope it helps me to learn to write ther scripts.


Thanks.
g.ganiraju
[View user's profile]

Joined: 2010-08-16
Posts: 4
Location: Pune
hi

Can you please help me out in this.

thanks.
g.ganiraju
[View user's profile]

Joined: 2010-08-16
Posts: 4
Location: Pune
Hi Prikryl,

I am waitig for your reply.so can you please help me out to write the script.

Thanks
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
No. I won't write the script for you.
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License