User Bundles Analysis Tool - UBAT 1

[bribob]

A few months ago I found a document explaining how to export a CSV showing the UCC bundle that is assigned to a user. The CSV could then be modified using Excel, uploaded back to the MAS and then imported to effectively bulk modify the UCC bundle assigned in USP. I'm looking for that document.

The command syntax that I found in history is:

#ubat -e <file name.csv>

Going a little further:

# more /usr/mas/bin/ubat.sh
#!/bin/bash
#
# This script has two main action options: -e : Export, -i : Import
# The third action option -c is to remove intermediate tables created
# during export/import. You would only use -c after you have done your
# import; not before.
#
# To export (-e) is to analyze users and their feature sets, makes
# suggestions as to their UCC bundles and export the resulting
# info to a .csv file
#
# To import (-i) is to import a similarly formatted .csv file and
# use the information therein to set the UCC bundles for the
# users in the file.
#
# The typical usage is described in DK122004:
# 1. Export users to .csv file. Example: ./ubat.sh -e myusers.csv
# 2. Use a spreadsheet to analyze the information. Make changes
# to the 'bundle' field if necessary.
# 3. Import the modified .csv file. Example: ./ubat.sh -i myusers.csv
# 4. Cleanup. Example: ./ubat.sh -c
#
# History:
# 24/03/2014 vuh MN00521767 - Suppress unwanted output
# 24/03/2014 vuh MN00521860 - Empty UCA profiles come out as no UCA profile
#

Anyone know the name of this document?



-b

 

[bribob]

For the record, MiCollab 6.0.41.0

I've found that the CSV file for import needs to have 2 columns modified in order for the assigned bundle to change in USP. First is the bundle column which should be: UCC [Basic/Entry/Standard/Premium] User for Enterprise (V3.0) . The second is the allocated column, which should be changed to a value of N.

If the allocated column remains as Y, then that particular user in the CSV will not change in USP. I import command will not fail, but it will tell yo




-b

 

[Billz66]

Fantastic , I had been extracting afile from the backup and working some VBA code to extract who was using what licensing

Where did you find out out about this ? is there more auditing scripts in there hidden away

I would love a method of importing nupoint FCOS.

every site we install i go through and manually create the 4 or 5 FCOS profiles that we use as our standards

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

and due to an endless stream of MiCollab , MiCC issues
Life would be simpler If only they tested products properly before releasing them .....