MiCollab 7.2 - no more UBAT?

[bribob]

thread1329-1755719

It would appear that the UBAT scripts from the above thread are no longer functional in MiCollab 7.2

[root@MICOLLAB ~]# ubat -e UBAT-2016-08-29.csv
Exporting data to file /var/tmp/UBAT-2016-08-29.csv ... Done.

Licensing summary:

psql:<stdin>:16: NOTICE: table "tmp_huy_license_summary" does not exist, skipping
psql:<stdin>:29: ERROR: relation "tmp_huy_output_tbl" does not exist
LINE 10: ...n (select bundle, count(bundle) as allocated from tmp_huy_ou...
^
ERROR: relation "macschema.tmp_huy_license_summary" does not exist
LINE 1: select * from macschema.tmp_huy_license_summary
^

Please download file /var/tmp/UBAT-2016-08-29.csv to your PC and open it using a spreadsheet program.
[root@MICOLLAB ~]# locate UBAT-2016-08-29.csv
[root@MICOLLAB ~]# ls /var/tmp
00071853.11564 00071c8d.19032 00071d29.18870 00071d3b.19149 00071daf.21251 00071e02.7980 00071e8b.21398 00071ea6.10621 00071ec0.18451 logcollector.lockfile ths_poolload.log
00071c0f.11453 00071d29.18654 00071d3b.15870 00071d43.19332 00071dd8.21307 00071e40.15779 00071e9d.17276 00071ebc.31234 20160828042201_cube.log queue_tns_tpdvr.log ths_userload.log
[root@MICOLLAB ~]#

Has anyone worked with this tool recently?



-b

 

[Billz66]

it was broken by an updated version of postgresql

mitel sent us a replacement file which is supposed to be in the later releases

If I never did anything I'd never done before , I'd never do anything.....

 

[bribob]

Was the replacement file a new version of ubat.sh ?

I upgraded to MiCollab 7.2.0.26 on Aug 25 because the Sys Admin deployed the OVA on Aug 24, which is the version that my initial post was generated from.

MiCollab 7.2.1.12 was released on Aug 26

The export functionality is now built into the MiCollab USP GUI (Users and Services > Users > Reports > User Summary Report). I hope that the import functionality comes into the GUI in the near future too, as I now have 132 UCC Entry V3.0 bundles to change to V4.0 by hand.

At least I know exactly which users need to be changed.

The same GUI access to the UBAT export does NOT exist (or I can't find it) in MiVoice Business Express 7.1.0.55


-b

 

[Billz66]

Yep it was a new version of ubat.sh

I also upgraded our system to the latest , didint notice that reports button - looks like it does something similar

If I never did anything I'd never done before , I'd never do anything.....