BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 03-02-2008, 08:21 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: May 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question Importing information(excel) into your blackberry

Please Login to Remove!

I have some contact information in an excel sheet that I would like to import into my blackberry address book. Does anyone know how I can do this? I know you can do it by choosing asci, but I am not sure how the rows or columns should be layed out in order to do it properly. Thanks.
Offline  
Old 03-02-2008, 08:28 AM   #2 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

First you will need to import that information into a PIM type application like Outlook. Then you can use Desktop Manager to sync the information with your BB.

Do you have Outlook and Desktop Manager?
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 03-02-2008, 09:02 AM   #3 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Wirelessly posted (8130, Bell Mobility: BlackBerry8130/4.3.0 Profile/MIDP-2.0 Configuration/CLDC-1.1 VendorID/109)

The Desktop Manager will allow you to import directly from an ASCII file as well. If you run a quick export you will get a file with the default field mappings and then you can use that layout to format your existing data.
Offline  
Old 03-02-2008, 09:11 AM   #4 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Here are the default mappings for ASCII import/export in DM:

Address Book
-------------------
"First Name"
"Middle Name"
"Last Name"
"Title"
"Company Name"
"Work Phone"
"Home Phone"
"Fax"
"Mobile Phone"
"PIN"
"Pager"
"Email 1"
"Email 2"
"Email 3"
"Address1"
"Address2"
"City"
"State/Prov"
"Zip/Postal Code"
"Country"
"Notes"
"Interactive device"
"1-way Pager"
"User Defined 1"
"User Defined 2"
"User Defined 3"
"User Defined 4"

Calendar
-------------------
"Description Title"
"Notes"
"Location"
"Alarm Date"
"Alarm Time"
"Start Date"
"Start Time"
"End Date"
"End Time"
"Alarm Flag"

MemoPad
-------------------
"Note Title"
"Note Body"

Tasks
-------------------
"Title"
"Notes"
"Due Date"
"Priority"
"Completed Flag"
"Status"
Offline  
Old 03-02-2008, 09:22 AM   #5 (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

Wirelessly posted (BlackBerry8310/4.5.0.6 Profile/MIDP-2.0 Configuration/CLDC-1.1 VendorID/107)

And in my experience, outlook likes either the native xls format or csv (comma seperated values) files for import. Ascii will work, but for me Outlook tends to botch the info on an import. Ask was posted above, DM will import ascii directly with no PIM app

Last edited by Sith_Apprentice : 03-02-2008 at 09:24 AM.
Offline  
Old 03-02-2008, 09:34 AM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by Sith_Apprentice View Post
...outlook likes ... csv (comma seperated values) files for import. Ascii will work, but for me Outlook tends to botch the info on an import. ...
CSV is an ASCII filetype ... ?
Offline  
Old 03-02-2008, 09:47 AM   #7 (permalink)
BlackBerry God
 
aiharkness's Avatar
 
Join Date: Jul 2005
Location: Florida Panhandle
Model: Z10
OS: 10.2.1
Carrier: T-Mobile USA
Posts: 13,697
Post Thanks: 15
Thanked 498 Times in 485 Posts
Default

Quote:
Originally Posted by markhutchison View Post
CSV is an ASCII filetype ... ?
The c in CSV refers to the type of delimiter, in this case a comma. The columns in ascii file could have space or tab boundary, for example.
__________________
- Ira
Online  
Old 03-02-2008, 09:53 AM   #8 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by aiharkness View Post
The c in CSV refers to the type of delimiter, in this case a comma. The columns in ascii file could have space or tab boundary, for example.
Gotcha ... yes, I'm aware that CSV is a comma delimited file. I just think that saying "ASCII" imports don't work well is unclear.

I agree 100% that Outlook (and most applications) work best with comma delimited files. Tab delimited would be a good second ... space delimited is just bad news ...
Offline  
Old 03-02-2008, 10:16 AM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: May 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have a regular excel file with column headings I created and their other corresponding information listed below them in the cells. I also have lotus. I wondered is there a specific layout I need to put the information I currently have in the excel worksheet?
Offline  
Old 03-02-2008, 10:19 AM   #10 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by rllngriver View Post
... is there a specific layout I need to put the information I currently have in the excel worksheet?
In my post above, the order in which I've listed the fields for each application should be the order of your columns in Excel.
Offline  
Old 03-02-2008, 10:19 AM   #11 (permalink)
Thumbs Must Hurt
 
Join Date: May 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Clarification

So does each correponding information I want have to be listed horizontally like this? Right now it is vertical. Do I have to put double quotes around the info like this?


Quote:
Originally Posted by markhutchison View Post
Here are the default mappings for ASCII import/export in DM:

Address Book
-------------------
"First Name"
"Middle Name"
"Last Name"
"Title"
"Company Name"
"Work Phone"
"Home Phone"
"Fax"
"Mobile Phone"
"PIN"
"Pager"
"Email 1"
"Email 2"
"Email 3"
"Address1"
"Address2"
"City"
"State/Prov"
"Zip/Postal Code"
"Country"
"Notes"
"Interactive device"
"1-way Pager"
"User Defined 1"
"User Defined 2"
"User Defined 3"
"User Defined 4"

Calendar
-------------------
"Description Title"
"Notes"
"Location"
"Alarm Date"
"Alarm Time"
"Start Date"
"Start Time"
"End Date"
"End Time"
"Alarm Flag"

MemoPad
-------------------
"Note Title"
"Note Body"

Tasks
-------------------
"Title"
"Notes"
"Due Date"
"Priority"
"Completed Flag"
"Status"
Offline  
Old 03-02-2008, 10:21 AM   #12 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

It's in list format simply because it's tough to enter a chart into a forum post.

Each of the entries in the list would be your Column headers in Excel (so yes, just switch it from vertical to horizontal in Excel). It doesn't really matter if you put in the quotes.

Last edited by markhutchison : 03-02-2008 at 10:22 AM.
Offline  
Old 03-02-2008, 10:24 AM   #13 (permalink)
Thumbs Must Hurt
 
Join Date: May 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 85
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is ascii another way of saying .csv(excel)
Offline  
Old 03-02-2008, 10:30 AM   #14 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by rllngriver View Post
Is ascii another way of saying .csv(excel)
No. CSV (Comma Separated Values) files are saved in ASCII format. ASCII (American Standard Code for Information Interchange) is a plain-text filetype. CSV is a way of representing data records from a table or database in plaintext format. In CSV the fields of an individual record are separated by commas and each record is separated by either a Line Feed or a Carriage Return.
Offline  
Old 03-02-2008, 10:32 AM   #15 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by rllngriver View Post
... .csv(excel)
You should note as well that CSV is not an Excel specific format. CSV is a generic format that can be very useful for importing and exporting data between different applications.
Offline  
Old 03-02-2008, 11:29 AM   #16 (permalink)
BlackBerry Master
 
djm2's Avatar
 
Join Date: Jul 2007
Model: 9780
PIN: N/A
Carrier: T-Mobile
Posts: 4,633
Post Thanks: 28
Thanked 12 Times in 12 Posts
Default

Quote:
Originally Posted by markhutchison View Post
You should note as well that CSV is not an Excel specific format. CSV is a generic format that can be very useful for importing and exporting data between different applications.
But possibly also very hazardous, especially if any of the fields contain legitimate uses of a comma.
Offline  
Old 03-02-2008, 11:36 AM   #17 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by djm2 View Post
But possibly also very hazardous, especially if any of the fields contain legitimate uses of a comma.
That's a good point. The choice of delimiter should be based on the content of your dataset. In general it's best to choose a delimiter that would be considered an illegal character within your dataset; sometimes this is not possible.

This is just one of the reasons why XML is a much better choice for plaintext representation of datasets.
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.