BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-10-2008, 03:46 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Export to Excel

Please Login to Remove!

I believe ive made a similar post before but i cannot find it. I would like to export all the information from BES 4.1 to excell and have a the correct format to view the file. can someone assist me with this. Thanks
Offline  
Old 06-10-2008, 03:48 PM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

What do you mean by "all the information"?
Can you please be more specific as to what you're looking for?
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 06-10-2008, 03:49 PM   #3 (permalink)
BlackBerry Extraordinaire
 
CO_BBTechie's Avatar
 
Join Date: Jul 2007
Location: Denver
Model: 8310
Carrier: AT&T
Posts: 2,044
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I found it easily;

Quote:
Originally Posted by Duster View Post
I just tried excel also a little better but not exactly what i was looking for.
Why do you want someone to give you instructions again if it wasn't exactly what you were looking for?
Offline  
Old 06-10-2008, 03:50 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by CO_BBTechie View Post
I found it easily;



Why do you want someone to give you instructions again if it wasn't exactly what you were looking for?
I want to get all the info such as carrier, phonenumber, names, exported from bes to a excel file.
Offline  
Old 06-10-2008, 03:52 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by CO_BBTechie View Post
I found it easily;



Why do you want someone to give you instructions again if it wasn't exactly what you were looking for?
can you send me the link to that post i did a search i cant find it. its been a long day ive been up since 2 am
Offline  
Old 06-10-2008, 03:53 PM   #6 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

You want someone to give you a link to one of your own posts?
I'm way beyond confused now.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 06-10-2008, 03:57 PM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by penguin3107 View Post
You want someone to give you a link to one of your own posts?
I'm way beyond confused now.
I search by my username and by keyword that post doesnt appear for me. I have made a posting regarding this issue in the past and got an answer but i forgot how to do.
Offline  
Old 06-10-2008, 04:03 PM   #8 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

<<<<------- Click your name over to left.
Choose 'Find more posts by Duster'.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 06-10-2008, 04:13 PM   #9 (permalink)
BlackBerry Extraordinaire
 
CO_BBTechie's Avatar
 
Join Date: Jul 2007
Location: Denver
Model: 8310
Carrier: AT&T
Posts: 2,044
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok try to keep up....

From within BlackBerry Manager, highlight "handhelds" under "Handheld Management" in the left frame

Highlight all entries in the top frame, then click "export asset summary data" in the bottom frame

That will give you output in this format;

# BlackBerry Server handheld list. Number of handhelds: xx
# User Name,PIN,Handheld Model,Memory,BlackBerry Version,Phone Number,Configuration Name
Last name; First name,PIN,model,memory(Mb),OS,phone #,
Offline  
Old 06-11-2008, 09:30 AM   #10 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by CO_BBTechie View Post
Ok try to keep up....

From within BlackBerry Manager, highlight "handhelds" under "Handheld Management" in the left frame

Highlight all entries in the top frame, then click "export asset summary data" in the bottom frame

That will give you output in this format;

# BlackBerry Server handheld list. Number of handhelds: xx
# User Name,PIN,Handheld Model,Memory,BlackBerry Version,Phone Number,Configuration Name
Last name; First name,PIN,model,memory(Mb),OS,phone #,
Ok i got the list now how do i use excel to format the view so i can see the entries clearly its all jumbled up.
Offline  
Old 06-26-2008, 01:55 PM   #11 (permalink)
BlackBerry Extraordinaire
 
CO_BBTechie's Avatar
 
Join Date: Jul 2007
Location: Denver
Model: 8310
Carrier: AT&T
Posts: 2,044
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry, lost track of this thread. If you haven't yet figured this out though;

Rather than simply opening the exported file with Excel, try importing the file once in Excel.

That should give you some options to separate the fields, as this export produces a CSV.
Offline  
Old 06-26-2008, 01:57 PM   #12 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 7100t
Carrier: cingular
Posts: 179
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by CO_BBTechie View Post
Sorry, lost track of this thread. If you haven't yet figured this out though;

Rather than simply opening the exported file with Excel, try importing the file once in Excel.

That should give you some options to separate the fields, as this export produces a CSV.
yeah thanks alot i figured it out
Offline  
Old 06-27-2008, 11:06 AM   #13 (permalink)
Knows Where the Search Button Is
 
EDDYBLUELEX's Avatar
 
Join Date: Mar 2006
Location: NJ
Model: 7290
Carrier: tmobile
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

How about exporting fields to excel such as the customs ones created. Name Pending Last Contact. Seems it always defaults to Name pin etc.... but not custom fields I assigned.

Need a way to see who is no longer using the bes to delete them. So need report of Pending and last contact time. Exporting to excel with this info was perfect and customizable in 4.0 but in 4.1 it got messed up.
__________________
EDDY EL REY DEL LO REYES
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.