BlackBerry Forums Support Community               

Reply
 
LinkBack Thread Tools
Old 05-13-2008, 07:21 PM   #21 (permalink)
BlackBerry Extraordinaire
 
Nextel User's Avatar
 
Join Date: May 2005
Model: 8220
Carrier: AT&T
Posts: 1,146
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default

Please Login to Remove!

so now you can track your wife's gps enabled bb all day?


kidding.....

this is fantastic. you are making the unite software do more than rim allowed(wanted) it to.

keep up the good work
Offline   Reply With Quote
Old 05-13-2008, 07:43 PM   #22 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by Dawg View Post
was it alot of steps grim.
Not since I made the export file. I'll post it with a do at your own risk kinda thing. Working on it now.
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-13-2008, 08:06 PM   #23 (permalink)
Thumbs Must Hurt
 
matthiasj's Avatar
 
Join Date: Jul 2007
Location: KY
Model: 9700
OS: 5.0.0.566
PIN: 2164B714
Carrier: AT&T
Posts: 171
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

that sounds good makes me wanna try it again hah!
Offline   Reply With Quote
Old 05-13-2008, 08:11 PM   #24 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

OK, top post is updated. I made the instructions in a hurry, so they are pretty un-user-friendly. Are they understandable?
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950

Last edited by Grimlin : 05-13-2008 at 08:22 PM.
Offline   Reply With Quote
Old 05-13-2008, 08:52 PM   #25 (permalink)
No longer Registered.
 
Dawg's Avatar
 
Join Date: Mar 2005
Location: Atlanta
Model: 8330
OS: 4.5.0.138
PIN: 31a6c9c9
Carrier: Verizon BIS
Posts: 13,963
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

too much for me to do tonight I will play with it tomorrow.
Offline   Reply With Quote
Old 05-13-2008, 08:53 PM   #26 (permalink)
Retired BBF Moderator
 
Sith_Apprentice's Avatar
 
Join Date: Aug 2005
Model: 9000
OS: 4.6.0.xxx
Carrier: AT&T
Posts: 10,149
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

thread stuck
Offline   Reply With Quote
Old 05-14-2008, 08:48 AM   #27 (permalink)
Talking BlackBerry Encyclopedia
 
RobM's Avatar
 
Join Date: Oct 2006
Location: Tampa Florida
Model: 8800
PIN: 240721B8
Carrier: Cingular/ATT
Posts: 342
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I guess I will play a wait and see how others use it and like it now...I have already done the wipe to remove unite but this looks interesting now..but I aint jumpin till I see some others
__________________
Looking to Buy or Sell Property in the Tampa Bay Area
Tampa Real Estate|Tampa Foreclosures|Tampa Real Estate Blog
Offline   Reply With Quote
Old 05-15-2008, 09:05 AM   #28 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Anyone else tried it yet? Success? Failure? Don't Care?
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-15-2008, 09:56 AM   #29 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Quote:
Originally Posted by Grimlin View Post
THIS THREAD IS NOT ABOUT GETTING RID OF THE ITPOLICY OR WHINING ABOUT IT MESSING UP YOUR BROWSER
..snip..
This did exactly what you said it would do, which is exactly what I wanted.

I wonder why RIM didn't include the ability to fine tune the ITPolicy in the first place. Anyway thanks! Your the man!
Offline   Reply With Quote
Old 05-15-2008, 10:06 AM   #30 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by hrbuckley View Post
I wonder why RIM didn't include the ability to fine tune the ITPolicy in the first place. Anyway thanks! Your the man!
Probably because they would have to call it a BES. The backend is a BES with most of the functionality loss being tied to the lack of a proper console to configure things. I need to try and install the BES Console and see if you can point it to the Unite instance.
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-15-2008, 10:27 AM   #31 (permalink)
New Member
 
Join Date: May 2008
Model: 8130
PIN: N/A
Carrier: Telus
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Worked like a charm.

Out of curiosity - do you know where the tracking data gets stored in the DB?

Thanks for this.
Offline   Reply With Quote
Old 05-15-2008, 12:19 PM   #32 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by ebj75 View Post
Worked like a charm.

Out of curiosity - do you know where the tracking data gets stored in the DB?

Thanks for this.
GPS Reporting in IT Policy - where does it log to?
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-16-2008, 08:53 AM   #33 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Grim,

OK, I read the bes-admin-corner thread. The last post seemed to indicate that tracking is not enabled. Is this still true, or are you able to get it to work on yours? I've got your ITPolicy2 installed, and have the SyncLBS table but there is no data in it.

Never mind. Though one ref said 4.2.2 HH OS was required for this, other (more correct) source says 4.3 required. Which I don't have.

Last edited by hrbuckley : 05-16-2008 at 09:13 AM. Reason: More reading.
Offline   Reply With Quote
Old 05-16-2008, 09:13 AM   #34 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by hrbuckley View Post
Grim,

OK, I read the bes-admin-corner thread. The last post seemed to indicate that tracking is not enabled. Is this still true, or are you able to get it to work on yours? I've got your ITPolicy2 installed, and have the SyncLBS table but there is no data in it.
Tracking is not enabled by default. Thus the policy change. You will know it is working when the device gets a prompt that tracking is now enabled. Which policy have you put your users on? Do they have OS 4.2.2 or above? Do they have a device with GPS?
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-16-2008, 12:04 PM   #35 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Thanks for the reply. I have only one unit so far (mine) which is an Unlocked AT&T 8820 with 4.2.2. I only see two policies default and Unite, which now I wonder if that means I had a problem...

Going through the steps again I notice:
Code:
                                
bcp Unite.dbo.ITPolicy2 in ITPolicy2.sql -T
accept all defaults except save tofile
Do you want to save this format information in a file? [Y/n] n                  
                                                                                
Starting copy...                                                                
SQLState = S1000, NativeError = 0                                               
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file                                                                          
                                                                                
0 rows copied.                                                                  
Network packet size (bytes): 4096                                               
Clock Time (ms.): total        1
I wonder if I got a corrupt ITPolicy2.sql file. Uncompressed it is 234 bytes.

Anyway I did get the default policy pushed to the BB and got my old browsers back. I played with Device Management (restricting phone use etc) but opened everything back up. Now I have the Unite policy and can't seem to change it. But since there was an error with BCP that is probably something to worry about later.
Offline   Reply With Quote
Old 05-16-2008, 12:27 PM   #36 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Wirelessly posted

Did you open the file and save it before you ran bcp?
It could have scrambled the formatting. What does the itpolicy2 table look like?
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-16-2008, 12:40 PM   #37 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Might have, curiosity killed the cat. I will re-extract from the zip and try again. The table looks ok, just the two policies in it.
Offline   Reply With Quote
Old 05-16-2008, 12:59 PM   #38 (permalink)
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by hrbuckley View Post
The table looks ok, just the two policies in it.
Then it most definitely did not import. Those policies are the default ones that come with Unite.
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote
Old 05-16-2008, 01:01 PM   #39 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Tried downloading the zip and extracting again. Still get the same error.
Offline   Reply With Quote
Old 05-16-2008, 01:31 PM   #40 (permalink)
New Member
 
Join Date: May 2008
Model: 8130
PIN: N/A
Carrier: Telus
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I had the same error message. Which I attributed to opening and probably saving the file prior to running bcp.

I re-downloaded and unziped. Re-ran the bcp command and it worked fine. Make sure the datestamp matches - 2008-05-13 9:28AM (which is the date stamp of ITPolicy2.sql in the zip file)
Offline   Reply With Quote
Reply


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.