My PC sync was working (maybe not perfectly but adequately) until today. I too have been trying to import into the Communication Centre via the File>Import feature with very little luck. I even tried creating a Bilbo textfile (see above) and it was rejected.
However a gilmer of hope...
Apparently a text file format that the Communications Centre will accept (today at least) requires the following common field:value mapping:
First name: Jim
Last name: Smith
Job title: Operations Manager
Notes: Notes about Jim
General mobile: 040404040404
General email: firstname.lastname@example.org
General fax: 031000000
General P.O.Box: Box 30
General extension: 30595
General street: 100 Queen Street
General postal/ZIP code: 300
General city: Melbourne
General state/province: VIC
General country/region: Australia
Home phone: 0394949494
Home email: email@example.com
Home street: 10 Rock Place
Home postal/ZIP code 3001
Home city: Hawker
Home state/province: WA
Home country/region: Australia
Business phone: 0392730392
Business extension: 30392
Business street: Level 100
100 King Street
Business postal/ZIP code: 3000
Business city: Melbourne
Business state/province: VIC
Business country/region: Australia
Further, the deliminator is a tab following the ":" and the commencement of the actual data value e.g., the first entry above is actually First name: <tab>Jim
The break between contacts (e.g., Jim and a second contact call Don) is apparently a paragraph.
Presently I'm working on a mail merge which I will save as a single .txt file using an Outlook generated CSV file. It seems to be working consistently except for the interpretation of name strings... it appears to get mixed up with First, Middle and Combined names.
I´d Like to thank everybody specially cdl_1 for the help around this issue.
A really tricky way to contour the communication centre stiffness, but it works really well.
My tip: the titles of each category (First name, Middle name, Business mobile, etc), ARE case sensitive.
So if you´re importing and the names doesn´t come up, that´s because in the title you may have mistyped it, like First Name (with the 2 capitals).
First name and First Name aren´t the same.
Thanks again, saved me a lot of work.
Flávio from Brazil.
08-04-2009 10:55 - edited 08-04-2009 10:55
Other way without using Outlook...
Have a look at this:
Maybe it helps
my oh my indeed - this should not be this hard!
I found the best way was to first export a single contact from Pc suite, open that file with the text editor, and then copy and paste the correctly formatted records into the text editor, making sure that the headings don't change and that all emplty fields in a record is represented as "", then save it before importing it back into PC Suite. The only acceptable format is CSV, nothing else seems to work.
Thanx Guys. Putting all your ideas together and an hour later this is what I found.
* Basic comma delimitted format is required. "field1","filed2", "filed3" etc etc.
* first line in file must have field names, with correct case - use export from PC Suite to see correct.
* don't need all fields. I used "Last name" and " General mobile".
* can use Excel CSV format to generate file, with Notepad doing the find & replace trick somebody mentioned before.
* used drag & drop from Windows Explorer into Contacts of Nokia Suite, not import.
02-05-2009 21:37 - edited 02-05-2009 21:47
... days trying to get 500 contacts imported into my new E71. Surely a basic task like this oughht to be simple? This sort of issue is enough to make me want to return the phone and go use another brand with software that supports obvious functions.
Exactly my experience, exactly my reaction!
Nokia, shame on you! What happened with Nokia the last 10 years, that brougt the quality down below zero?
I really loved my 6210 and 6310i, but it could not hold>500 contacts.
I am very sorry I did buy the E71, I wish I had chosen a Palm !
Hi all Having stood on the shoulders of the giants above, this piece of excel work may be useful in Excel (I only used first name
(Cell A,) last name (cell B), phone (Cell C) and email (Cell C) headings, but use as many/few as you want
In cell E1, type "First name","Last name","General phone","General email"
in cell E2 type =CONCATENATE("""",A3,""",""",B3,""",""",C3,""","""
This will join the cells together, put "" marks and commas as necessary.
Select whole of column E and then open notepad and paste and then save as ????.csv This will import straight away into nokia comms manager.
I spent 2 days trying different things and this worked first time on new E51 with 117 contacts
OK - so here's some further info that hopefully is useful. Have been trying to get 198 contacts from a spreadsheet into Nokia 6233 all afternoon. Then followed the |/" find and replace trick found here but still didn't work.
Then cut the csv file into 2 halves, each with less than 100 contacts and it worked. A bit fiiddly but got there in the end.
Feels like Nokia actually don't want you to get your contacts into your phone - not sure why as when you do you tend to make more calls and they get more revenue!
Hey thanks a lot Niel.
I did a lot of experiments in file formats but could not succeed. The way suggested by you really worked.
This is best for people who use Microsoft Office Home and Student 2007 which does not come with an Outlook or outlook express.
I think Nokia Communications works perfectly on common sense rather than the complicated file formats of MS Office.
A suggestion to everybody:
In the method suggested by neil_b, just make double sure that the column headings correspond to those used by the language set up made in your phone to make the method work properly.
23-06-2009 11:54 - edited 23-06-2009 11:56
I also use Excel sheet to generate an import list with proper format. I use only one sheet and Excel function CONCATENATE. For PC Suite English US it looks like below:
Row 1 contains headers:
- in C1 write First name
- in D1 write Last name
- in E1 write General mobile
- in F1 write General phone
- in G1 write General e-mail
Rows below row 1 contain data.
Additionally in row 1st:
A1 contain quotation marks "
B1 contain semicolon ;
Now I use simple Excel function in cell H1 to merge everything into one column:
Please copy the function down in column H, then mark column H and copy everything to empty txt file. Save this txt file and change the extension to csv. Use PC Suite to import it. Works fine on my computer.
I am totally disapointed with this CSV export/import feature in Nokia Communication Center. I tried every technique described by users in different threads in Nokia Discussions Forums and I am unable to successfully import a CSV file in my Nokia Phone...
I use the french version 18.104.22.168 of the Nokia PC Suite software. This software is unable to import back in what it exported to CSV... I checked the columns names, I tried saving the CSV file to Unicode, I tried to Drag&Drop the file on the phone or use the Import menu option, nothing will work. Everytime I get the message that I need to check the file format...
Is there something special with the french version of the software that I need to do to make it work properly?
It's depressing. I feel I'm going to switch to Apple iPhone and get myself a Macintosh...
Thanks in advance for any help.