BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-21-2006, 11:14 AM   #1 (permalink)
New Member
 
Join Date: Feb 2006
Model: 7520
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question Import CAL's into BES

Please Login to Remove!

Is there a way to import the CAL's from a file (txt, CSV, etc.)?
We've just implemented a BES system (4.0) and the managment decision was that each department we support would purchase they're own CAL's from the cell provider. The result is that as the BES admin, I'm receiving a steady stream of CAL's, usually 1 or 5 packs. They're already being entered into a spreadsheet, but since the server entry requires the 6 character groups, doing a cut and paste 5 times for each CAL is a pain. I'd like to be able to just get them out of the spreadsheet and import them all at once.

I apologize if this is a simple question that's been asked before, but unfortunately I've been tasked with the BES implementation/admin with no training; I'm figuring it out as I go along.. Sort of the "ready, fire, aim" management style..

- Mike O'Donnell
Offline  
Old 02-21-2006, 11:22 AM   #2 (permalink)
Knows Where the Search Button Is
 
Slippery's Avatar
 
Join Date: Feb 2006
Location: New York
Model: 8830
OS: 4.2.2.123
Carrier: Sprint
Posts: 23
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is a great question...I also have been thrown in the deep end to see if I can swim. So far I'm doing ok, and with this place as a floatation device I should be good to go.

Sorry...I just realized you are going to look at this thinking I had the answer for you...

Slip
Offline  
Old 02-21-2006, 12:03 PM   #3 (permalink)
Thumbs Must Hurt
 
Dustbin30's Avatar
 
Join Date: Sep 2005
Location: London
Model: 7230
Posts: 108
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can insert them directly into the database. If you are using MSDE a good GUI would be Teratrax. But be warned, RIM takes this as an unsupported configuration if anything goes wrong...
Offline  
Old 02-21-2006, 01:13 PM   #4 (permalink)
New Member
 
Join Date: Feb 2006
Model: 7520
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks. I'm not ready to try directly accessing the database, I'm not real strong on SQL. I was hoping there was some tool or "official" method of doing this with the BES software-
- Mike
Offline  
Old 02-21-2006, 04:32 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Apr 2005
Location: The Netherlands
Model: 8800
Carrier: Vodafone
Posts: 374
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

How To - Export and import BlackBerry Enterprise Server license keys from the command prompt
Last Updated: 03 October 2005
Article Number: KB-03300
Summary

This article applies to the following:

* BlackBerry Enterprise Server® 3.5 and 3.6
* Microsoft® Exchange

Procedure

You can export and import BlackBerry Enterprise Server license keys from the command prompt if you are

* logged into the computer hosting the BESMgmt database

AND
* logged into the computer as a Local Administrator or you have an account with permissions to read and write to the BESMgmt database.

To export license keys from the BESMgmt database to a file

1. Close the BlackBerry Enterprise Server Management console.
2. Open a command prompt and type

bcp besmgmt..licensekeys out <c:\keys.txt> -c -T

where <c:\keys.txt> is the path and filename of the export file.
3. Press ENTER to export the license keys.

To import license keys from a file to the BESMgmt database

1. Close the BlackBerry Enterprise Server Management console.
2. Open a command prompt and type

bcp besmgmt..licensekeys in <c:\keys.txt> -c -T

where <c:\keys.txt> is the path and filename of the export file.
3. Press ENTER to import the license keys.


Regards,
Bob
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright © 2004-2014 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.