« previous next »
Pages: [1] 2   Go Down

Author Topic: NuPoint Call Directory Call Flow Reports - Automated  (Read 4633 times)

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
NuPoint Call Directory Call Flow Reports - Automated
« on: January 08, 2024, 12:58:56 PM »
There's a very useful report in the NuPoint under Call Directory -->Reports-->View Call Flow Reports

My boss would like to see these reports daily.
The problem is, I have to reset the report the Call Flow Report daily in order to see the details for a single day.

Does anyone know of a way to automatically run the report daily, email it and then reset it?

Ralph
Logged

Offline ZuluAlpha

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 693
  • Country: us
  • Karma: +17/-0
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #1 on: January 09, 2024, 08:20:08 AM »
That would be really nice. I have some contact centers that get hit after the Call Directors so MiCC doesn't report on anything before the calls get there.
Logged

Offline BoiseBorn

  • Jr. Member
  • **
  • Posts: 32
  • Country: us
  • Karma: +2/-0
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #2 on: January 09, 2024, 04:05:08 PM »
Enjoy this ability to while you can. Mitel has moved the Nupoint call tree into the latest version of MiVB and renamed it VM Call Flow Administration (This form is available only for cMIVB, EX Controller, MiVoice Business Virtual, and MiVoice Business for ISS).

There is no option that I've found to produce the same report from the MiVB. On the plus side if they do add the ability you could probably figure out a way to use the scheduler to produce the report...maybe.
Logged

Offline lundah

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1216
  • Country: us
  • Karma: +66/-0
  • Senior Chief Grunt
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #3 on: January 10, 2024, 10:00:08 AM »
I don't know of any way to do this. Call Flow reporting has always been limited at best, not sure why Mitel never made any improvements to it. My current gig uses the OpenText/AVST CX-E platform which is also sold as MiCollab Advanced Messaging, and the reporting capabilities of that is light years ahead.
Logged

Offline johnp

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2202
  • Country: us
  • Karma: +66/-0
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #4 on: January 10, 2024, 05:37:40 PM »
Not sure about getting the report emailed, but in theory you could use chown to run a delete file for the stats at midnight and when another call comes in, the file I believe is recreated. These are in /usr/vm/val5/CallFlows/xxxx_yyyy_stats.xml where xxxx... represents the flow desired. It might also make sense to use this file instead of the report. One could at 11:59 have an automated download of it via a sftp client, just prior to reset.
Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #5 on: January 11, 2024, 06:34:08 AM »
Oooo....   I like that.
Perhaps a crontab to copy the file to another directory, change the file name to the current date and then email.

I'll have to play with that a bit.

Thank you, John!

Ralph
Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #6 on: January 11, 2024, 09:44:23 AM »
I'm playing with it now.
I deleted the file to see if it resets overnight.

JohnP, after some internal discussions we another question though, would it be possible to connect to the database directly?
Do we know what database it's using?  i.e. Postgres, MySQL, etc?

Ralph
Logged

Offline lundah

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1216
  • Country: us
  • Karma: +66/-0
  • Senior Chief Grunt
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #7 on: January 11, 2024, 10:07:26 AM »
Quote from: johnp on January 10, 2024, 05:37:40 PM
Not sure about getting the report emailed, but in theory you could use chown to run a delete file for the stats at midnight and when another call comes in, the file I believe is recreated. These are in /usr/vm/val5/CallFlows/xxxx_yyyy_stats.xml where xxxx... represents the flow desired. It might also make sense to use this file instead of the report. One could at 11:59 have an automated download of it via a sftp client, just prior to reset.

I was trying to find my copy of an old doc with all the batch commands, wondering if there was something in there, but this is good. Once you have your commands worked out you could add it to the daily cron tab that already runs.
Logged

Offline johnp

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2202
  • Country: us
  • Karma: +66/-0
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #8 on: January 11, 2024, 06:42:38 PM »
From what I know this file will be recreated upon the next call, so deleting should not be an issue IMHO
Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #9 on: January 12, 2024, 11:10:06 AM »
I was able to write a bash script to copy the file and email it.
The script works as I hoped.

But...

I added it to the root crontab.  It worked.  Until it didn't.
It stopped working so I checked the crontab again and the entry for it was missing.
It appear that something overwrites the crontab. 

Any suggestions?

Ralph
Logged

Offline lundah

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1216
  • Country: us
  • Karma: +66/-0
  • Senior Chief Grunt
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #10 on: January 12, 2024, 01:24:22 PM »
Quote from: ralph on January 12, 2024, 11:10:06 AM
I was able to write a bash script to copy the file and email it.
The script works as I hoped.

But...

I added it to the root crontab.  It worked.  Until it didn't.
It stopped working so I checked the crontab again and the entry for it was missing.
It appear that something overwrites the crontab. 

Any suggestions?

Ralph

Which cron file did you add it to? There's a few. Try /usr/vm/bin/cron.daily or /etc/cron.daily/89NPMdaily
Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #11 on: January 14, 2024, 01:30:25 PM »
Quote
Which cron file did you add it to? There's a few. Try /usr/vm/bin/cron.daily or /etc/cron.daily/89NPMdaily

Thanks for the tip.
I'll take a look at that.  I've never edited a crontab other than using the crontab -e command.

Ralph

Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #12 on: January 15, 2024, 03:55:14 PM »
lunduh,
How do I edit those crontab? It looks like I need to know what the user is before i can edit it.
What would the user be?

Ralph
Logged

Offline lundah

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1216
  • Country: us
  • Karma: +66/-0
  • Senior Chief Grunt
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #13 on: January 15, 2024, 04:52:03 PM »
Quote from: ralph on January 15, 2024, 03:55:14 PM
lunduh,
How do I edit those crontab? It looks like I need to know what the user is before i can edit it.
What would the user be?

Ralph

I
Logged

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: NuPoint Call Directory Call Flow Reports - Automated
« Reply #14 on: January 15, 2024, 05:55:00 PM »
lunduh, I don't understand your post?

Ralph
Logged

Pages: [1] 2   Go Up
« previous next »
 

Sitemap 1 2 3 4 5 6 7 8 9 10