simpsop
asked on
Lotus Notes Scheduled Agent Export View to Tabular Text?
I feel stupid asking this one...
Does anyone know how I can automate exporting a Notes View into Tabular text format to C:\ using a scheduled agent?
I have an Agent setup as:
Run Once(@Commands may be used)
Formula
@Command([OpenView] ; "ACCESS EXPORT");
@Command([FileExport] ; "Tabular Text" ; "C:\\tabulartext.txt")
This opens the view fine & launches the export, but I have to manually check the All Documents & Include View Titles. I want to set the "All Documents" and "Include View Titles" flags, so that the entire operation is handled automatically.
Does anyone know how I can automate exporting a Notes View into Tabular text format to C:\ using a scheduled agent?
I have an Agent setup as:
Run Once(@Commands may be used)
Formula
@Command([OpenView] ; "ACCESS EXPORT");
@Command([FileExport] ; "Tabular Text" ; "C:\\tabulartext.txt")
This opens the view fine & launches the export, but I have to manually check the All Documents & Include View Titles. I want to set the "All Documents" and "Include View Titles" flags, so that the entire operation is handled automatically.
If done in lotus script, as there are multiple entries out here about exporting to excel, you can put the export logic in an agent an execute the agent from a button. Then just include the export script in the agent. Some of the export scripts are very slick and select all documents, format the titles, etc. I have some export logic that I use if interested.
Good Luck !!
Paul
Hello Arun.:-)
Good Luck !!
Paul
Hello Arun.:-)
ASKER
Pratigan,
I'd definetly be interested in your export logic if you don't mind sharing.
Paul
I'd definetly be interested in your export logic if you don't mind sharing.
Paul
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
pratigan,
Sorry, I didn't catch the "Button" part. I need this to run automatically, on a scheduled basis, with absolutely NO user intervention. The plan is to export a tabular text file to a shared drive at say midnight, asving it as either a .txt ot .csv file, so that an MSAccess database can retrieve it & load it to it's files at 1am.
Nice code for an export button though.
Thanks,
Paul
Sorry, I didn't catch the "Button" part. I need this to run automatically, on a scheduled basis, with absolutely NO user intervention. The plan is to export a tabular text file to a shared drive at say midnight, asving it as either a .txt ot .csv file, so that an MSAccess database can retrieve it & load it to it's files at 1am.
Nice code for an export button though.
Thanks,
Paul
Hello Paul,
You can set this code up to run anywhere. set it in an agent and schedule your agent however you wish. YOu will see in the logic that it currently exports to excel, but it is modifiable to export to txt as well.
I choose to have it run from a button, but it can be modified to run anytime...
It give you a good solid base starting point.
You can set this code up to run anywhere. set it in an agent and schedule your agent however you wish. YOu will see in the logic that it currently exports to excel, but it is modifiable to export to txt as well.
I choose to have it run from a button, but it can be modified to run anytime...
It give you a good solid base starting point.
ASKER
Hi pratigan,
Thanks for clearing that up. Answer accepted.
Thanks again,
Paul
Thanks for clearing that up. Answer accepted.
Thanks again,
Paul
Your Welcome !!
Thank You !
Thank You !
And as far as checking the box to include view titles, you might have to look into some API stuff or SendKeys options.