Home » Infrastructure » Unix » Automation script (Shell scripting)
Automation script [message #471271] Fri, 13 August 2010 02:34 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi All,

I want to write a Pl/sql program for the following requirement.

1. wnat to connect to remote desktop .
2. There we can find one more DB like AS-access. This one contains one file( ltake it as "XYZ" i)n some particular path.
3. want to save this file in share folder.
4. this share folder contains some "abc.txt" file.
5.want to replace the data which XYZ contains.
6. It is already having one ".XLS" file in share folder. want to delete it. ( because while running the exporting data the ".XLS" file created daily)
7. now in share folder we have one ".mdb" file.If we click on that it will ask like "create Report"," Exit".
8. we should click on "Create Report"
9.then one pop up will come like "All the exisiting data will be lost",then press "OK"
10. Again one window will open. It contains 2 buttopns. 1. Import Data 2. Export data.
11.Click on Import data. Then it will ask for "Password"
12.After giving the password it will import the whole data. ( It's taking around Hr time)
13. After that one pop up will come says " Import completed". then press OK and then click on "Export data"
14.After clicking this it will generate ".xls" file in share folder.
15. after that open that ".XLS" file and then Goto Tools --> Macros --> Macros, to run the Macros from Excel sheet.

16. Run the macro - "PERSONAL.XLS!macNewEFG".

17.Once done, save the ".xls" as "Report - <Month 'YY>.xls" in share folder.
18.Send then this generated report to respective mail-ids automatically.

daily manually we are doing this job. But I am planning to do it automatically.

so can any one please give me your suggestions fir this.

Thanks in adv.
Re: Automation script [message #471276 is a reply to message #471271] Fri, 13 August 2010 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I see nothing that is ACTUALLY related to Oracle.
PL/SQL is NOT an OS scruipting language, it is a DATABASE language.

Regards
Michel
Re: Automation script [message #471293 is a reply to message #471276] Fri, 13 August 2010 03:35 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Yes. I do accept.But can you please let me know the process t write a script or procedure(Oracle Prcodeure if possible) for the above requirement.

Thanks.
Re: Automation script [message #471297 is a reply to message #471293] Fri, 13 August 2010 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No Oracle procedure, just script which is out of the scope of this forum and so the topic is closed.

Regards
Michel
Re: Automation script [message #471301 is a reply to message #471297] Fri, 13 August 2010 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hello, user71408! Where were you hiding all the time? I kind of missed you!

Unfortunately, you'll have to face the truth: the fact that you know how to use PL/SQL doesn't mean that you can abuse it. It is, simply said, not enough for all you have to do. It also means that you should learn another language, the one that supports tasks related to file manipulation.
Re: Automation script [message #471376 is a reply to message #471271] Fri, 13 August 2010 13:06 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Welcome back user71408! I have missed the hilarity you bring to the place! Have you tricked someone into hiring you again?
Re: Automation script [message #472244 is a reply to message #471376] Thu, 19 August 2010 06:52 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
A colleague has just pointed out that you're back. Let the hilarity ensue
Previous Topic: Shell Script
Next Topic: otn downloads
Goto Forum:
  


Current Time: Tue Mar 19 04:09:28 CDT 2024