OraFAQ Forum: Unix » Automation script

Home » Infrastructure » Unix » Automation script (Shell scripting)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Automation script [message #471271]

Fri, 13 August 2010 02:34

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.

Report message to a moderator

Re: Automation script [message #471276 is a reply to message #471271]

Fri, 13 August 2010 02:57

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: Automation script [message #471293 is a reply to message #471276]

Fri, 13 August 2010 03:35

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.

Report message to a moderator

Re: Automation script [message #471297 is a reply to message #471293]

Fri, 13 August 2010 04:04

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: Automation script [message #471301 is a reply to message #471297]

Fri, 13 August 2010 04:20

Littlefoot
Messages: 21647
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.

Report message to a moderator