Using python to runother programs

[adityabhambri]

HI guys,
I am trying to automate some project work which the accounting dept
of the company uses. They have to go through multiple steps to achieve
the final goal. Is there some way that I can use python to automate
these manual steps. I can give you an example.

1. run the crystal report using some ***.excel file

2. Store the output as *.txt file.

3. use accounting software and use the *.txt file (this step can be
excluded)

I don't know how to use python to run the crystal report and save the
output as an txt file using python scripts. Is this even possible?
Thanks.
Sincerely,
Aditya.

 

[Terry Reedy]

HI guys,
I am trying to automate some project work which the accounting dept
of the company uses. They have to go through multiple steps to achieve
the final goal. Is there some way that I can use python to automate
these manual steps. I can give you an example.

1. run the crystal report using some ***.excel file

2. Store the output as *.txt file.

3. use accounting software and use the *.txt file (this step can be
excluded)

I don't know how to use python to run the crystal report and save the
output as an txt file using python scripts. Is this even possible?

Maybe. Details depend on your OS, which you neglected to mention ;-)
Lookup os.system. There may also be a new module in 2.4 that is relevant
(I forget name). If you are on Windows, PyWin gives you more options.

tjr

 

[gene tani]

this isn't really enough data to go on. What operating system (sounds
like win2k/XP), does Crystal reports and unnamed accounting software
have COM hooks?

Look at Simon Brunning posts:

http://www.brunningonline.net/simon/blog/archives/000652.html
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/279003