Auto report send to each user's email

cavagnaro

Re: Auto report send to each user's email

Post by cavagnaro »

The issue is that there only 1 report but you will need I think 1 view per user as Omnivista doesn't know the email for each user...so you have to teach him what to do with the reports (generate) and what to do with the output (email to XX user).
Other way but not using OV would be to export the data to a SQL external DB and from there build a job but still would need to do the extension-mail association somehow...
corwin

Re: Auto report send to each user's email

Post by corwin »

Hello
With some script you can succeed
1st if you have directory option you can add to directory entry the mail field
Check then that mail is inherited in accounting
Organisation for these entries

If no mail inherited use field like misc1

Perform report as report on directory entry
To avoid extract data limitation
You may Perform 1 report per cost center or per level in organisation
Report should ne grouped per user and show user Mail or misc field

The report should be schrduled with txt export

Use Google to find a script that parse the txt file , find mail and send by mail the text section you need

In sheduler module locate the schedule accounting report
Add to it a new dependent jobset and job

For the job (task) define it s parameter to run the script

Mail sending is easy
CAN do it from telnet mailip 25
And there are scripting tools that Perform a full telnet session by reading a txt file with command

For all the setup , you need at
least 2 hours
korin

Re: Auto report send to each user's email

Post by korin »

Thank you guys
I appreciate your cooperation
Post Reply

Return to “OmniVista 4760”