[amitjadhav]

Dear all

First name: Name
Company:  ABACA

General mobile: 12345678

General phone: 123456
General street: India

Plz make similer format l ( Above ) in txt.

 Above format can be coverted from xls but it should be in the form of the below Format.

Remember that the space Provided will be required when converted into txt.

First Name Name

Last Name Last Name

Company Name

General mobile 123456789

General phone 91123456789

General street Adress  

First Name Name

Last Name Last Name

Company Name

General mobile 123456789

General phone 91123456789

General street Adress

When the file is ready, upload it through PC suite.

Go to Contact-->Nokia Communication Center will open.

Go to Contact Icon & Click----your Contact will replicate & displayed.

Then go to File , Select Import -----Another window will Open---Select the Path where you have saved the File.

Select file format *.Text in the Bottom of Window in "File type".

Select the Text file --Newlist.txt---Upload this file ---your contacts will update in your Mobile in terms of Name, dept, Landline No., & Site also.

Plz do not do any addition or deletion in this file otherwise it may not upload correctly----letters are case Sensitive.

[fastmax]

Hi all 

Some suggestions to create a correct CSV file for Nokia PC Suite:

1. Export your contacts from your old system (e.g. Motorola PC Tools) a file in CSV format
2. Create a contact in Nokia PC Suite
3. File > Export that contact in CSV format
4. Open that file with CVS editor like UltraEdit (www.ultraedit.com FreeTrial) no Excel because it have some problems and open also  your file with your real contacts
5. Compare to syntax of first line because the column labels MUST are the same, if you notice difference like "Business phone" (Nokia PC Suite) and "Business ph" (your contact file) you must update the label with the same words of Nokia PC Suite file. IMPORTANT: save the same original file (do not change the name!) and close editor
6. Import the file in Nokia PC Suite
7. If you do not mistake will be all ok in another way ... check again!

 Get to work!

[drkwiat]

After spending untold hours trying, unsuccessfully, to import various CSV formats, etc. into my Nokia E51 via the Nokia PC Suite software, I discovered the following solution:

1. Export your contact list from Yahoo, Outlook, or Thunderbird, into individual card files *.vcf.

2. Open up the "Nokia Communication Center" in the 'Contacts' mode

3. Select all of the individual .vcf files that you wish to import and drag and drop them onto the page. 

In my case, I added 311 contacts that were perfectly formatted and maintained the correct phone numbers, email addresses, etc. Total time: about two minutes!

[yarikoslav]

Hi guys!

If you still have some problems with *.csv files importing, I can help you. I've just finished uploading contacts from a csv file to my Nokia 6233.

If you've got some problems with it, connect with me either via ICQ (388577882) or via E-Mail: yarsay@mail.ru

Best regards,

Dzyuba Yaroslav,

P.S> Hi from Ukraine=)

[meowmoo]

Hi all,

For those who are having problem converting because they are included the "Notes" columns, this might help.

 

1.  create a template using Nokia PC suite

from Nokia PC suite's contact page export a csv file with one entry.  this will give us a template (template.csv) to fill up with our contacts.

2. from outlook (palm etc) export your contacts to csv (contact.csv)

3. open up both file in Excel (I use openoffice)

4. copy and paste the columns you want from your  contact.csv to template.csv

5. If you have copied the column "Notes", then you will need to do some extra work.

In this column, instead of "carriage return" ("0D00 0A00" in hex) it has to be convert to "2920 2920" (in hex).  Nokia is using this special code to represent carriage return for the Notes column.

You wil need a hexeditor to do this, I used HxD.

Note that you can't convert all the "0D00 0A00" to "2920 2920", because at the end of each contact record, there is a  "0D00 0A00" to denote end of record.

Here are the two steps you need to perform:

a.  use hexeditor HxD to do a search and replace for  "0d000a00" with "29202920" (set to hex instead of text)

b. then replace  "2200292029202200" with "22000d000a002200" (set to hex instead of text)

    this step place "0D00 0A00" back to the end of the record.

7. save the converted file above and then use Nokia PC suite to import this file.

Very happy that I don't have to retype a thousand plus records.  Hope this help, good luck!

[srikanthkamath]

The Issue is still not corrected, debugged by nokia. After a few hrs of breaking the head on a non solvable problem within the scope of Nokia Contact Manager and reading the Forum, the solution is consolidated as follows, works with most phones

1. Make a New Contact in Nokia Contact Manager

2. Export it to template.csv format.

3. Double click to open the template.csv

4. Note the file format required ( My case a 6600 fold  is at the end of the Email) and close the file

you are now ready to import because we now know the format & fields required by Nokia Contact Manager to import..

5. One a new work book and import the data from the csv file.

6. Fill in the Names, mobil & tele nos ( I have used a macro to clean the data by using "Clean", "Trim", & "Proper" )

7. At the first unused col enter the following formula at the first row with the header

=CONCATENATE(A1,",","""",B1,""",""",C1,""",""",D1,""",""",E1,""",""",F1,""",""",G1,""",""",H1,""",""",I1,""",""",J1,""",""",K1,""",""",L1,""",""",M1,""",""",N1,""",""",O1,""",""",P1,""",""",Q1,""",""",R1,""",""",S1,""",""",T1,""",""",U1,""",""",V1,""",""",W1,""",""",X1,""",""",Y1,""",""",Z1,""",""",AA1,""",""",AB1,""",""",AC1,""",""",AD1,""",""",AE1,""",""",AF1,""",""",AG1,""",""",AH1,""",""",AI1,""",""",AJ1,""",""",AK1,""",""",AL1,""",""",AM1,""",""",AN1,""",""",AO1,""",""",AP1,""",""",AQ1,""",""",AR1,""",""",AS1,""",""",AT1,""",""",AU1,""",""",AV1,""",""",AW1,""",""",AX1,""",""",AY1,""",""",AZ1,""",""",BA1,""",""",BB1,""",""",BC1,"""",",",""""""

8. Drag to all the rows used

9. Select from row 1 ( with header ) to rows required and copy

10. Open a new file in Notepad

11. Paste the data

12. Save as phoneList.csv ( note change to All Files and Unicode)

Your data is ready ... Import this phoneList.csv file into your contact manager and there you have the data

I have no idea why Nokia does have a simple maping of the field, must be too busy working on the high end application and they do not have time for such basic requirments, ( its same with BB, they do not have a simple contact manager??)

I am sure now that the Mobil OEM have undisclosed agreement with Contact Manager Software Industries and they will not develop any simple contact managment in their phone managment softwares..

---- data in temple exported from Contact Manager ---

Title,"First name","Middle name","Last name","Suffix","Job title","Company","Birthday","SIP address","Push-to-talk","Share view","User ID","Notes","General mobile","General phone","General email","General fax","General video call","General web address","General VOIP address","General P.O.Box","General extension","General street","General postal/ZIP code","General city","General state/province","General country/region","Home mobile","Home phone","Home email","Home fax","Home video call","Home web address","Home VOIP address","Home P.O.Box","Home extension","Home street","Home postal/ZIP code","Home city","Home state/province","Home country/region","Business mobile","Business phone","Business email","Business fax","Business video call","Business web address","Business VOIP address","Business P.O.Box","Business extension","Business street","Business postal/ZIP code","Business city","Business state/province","Business country/region",""

,"This","","Test","","","","","","","","","","","1234567890","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""

Pls note the start and close at each line..

[KausaliKoala]

I have some notes (as much for myself as others) from a few attempts loading data onto my phone via CSV.

Nokia PC Suite  7.1.40.1 (downloaded Dec 2009)

Windows XP; Regional Settings set to "American English / US"

Nokia 6350 Device

 

• Error = "The contacts cannot be imported. Check the file format"

This most likely means that you wrote the first line of your CSV file incorrectly.  As noted in a few posts, make sure:

• All fields are surrounded by one double quote (") on each side (e.g. "First name", not 'First name', nor |First name$$).  This does not an absolute requirement (which explains why srikanthkamath's post, where the Title field is not surrounded by quotes, worked for srikanthkamath).
• All fields are separated by the comma character (hence Comma-Separated Values), not a semicolon, as had been prescribed in some earlier posts.
• All fields are case sensitive.  Capitalization matters.
• Don't put whitespace around the comma used to separate fields.  If you do, the quotation mark will become part of your data field.  (Note that the software uses "" (two quotes) to signify a single quote on export.  So if your contact appears as "dude" in the software, it will export as ,"""dude""", (other fields omitted))

If these sanity tests all pass, check your data.  If there are extra or missing fields in the data, you will also get this error.

Example:

"First name","Last name"
"Christoforo"

and

"First name","Last name"
"Christoforo","Columbus","Explorer"

will fail, but:

"First name","Last name"
"Christoforo","Colombus"

will successfully import.

•  Error = "Failed to import " + some number + "contact" w/o format error.
  

I got this error without also getting the "Check file format" error, where the "some number" was however many lines (not including the header) were in my CSV file.  The device had a message saying, roughly, 'data transfer not possible check connection'.  After some jostling of the USB cable connecting the device to my PC and jumping to another sub menu fixed this problem.  Although I only encountered this error once (and thus, can not reproduce), apparently the device can keep a legitimately formated CSV file from loading.  (It was also keeping vCards (vcf file) from loading that had previously loaded.  On some other forums, I say that someone suggested turning off the device, removing the battery, sacrificing first born and a number of other steps that seemed unnecessary to help import data.  I think all of that may just be a way of stepping out of an error condition when the device can not communicate with PC running Nokia Suite properly.  Note: when things do work, each successful import step (regardless of how many contacts are imported) is followed by the same tone that is given when I manually enter a number on a Nokia 6350 running a particular version of firmware. Your mileage may vary.

Another symptom of this: Close the Nokia Communication Center; from  the Nokia PC Suite, select File > Contacts.  If you see "Refreshing contacts failed." or something to that effect, don't troubleshoot your CSV file. Instead, fix the connection first (repeat the close, <fix connection>, open contacts steps) until you can see all your contacts.

[Fluffmeister]

It's even worse than this - I think Nokia are assuming Unicode characters and are embedded all sorts of funnies into it. I also had the problem of it importing only a few percent of my contacts - my contacts list come from different sources, so trying to synch it with Outlook (where I don't actually keep my contacts anyway) is no good.

So I've spent the last few hours banging my head against a wall, and finally thought that the text output format looked promising. However, as someone  has pointed out, notes can mess this up - and I did wonder how it distinguished between line feeds in notes and ordinary line feeds, so I wrote a program to look at the format after entering a contact in my phone, then export it in text format (I suppose Nokia assume you must be a programmer if you buy this phone!). If you go with the text format, the line looks something like this in notepad:

First name:    First
Last name:    Last Name
Job title:    Job title
Company:    Company
Notes:    Here's quite a long, in fact avery long, line of notes, with commas and all sorts of things that might throw it.
Like lots
of
line feeds.
General mobile:    +441313
General phone:    +441616

Which looks straightforward enough.

However, Nokia obviously don't want you to import actual data into your phone yourself, so they've put a number of traps in the data.

Firstly, the first two characters of the line are ASCII 255 followed by ASCII 254. Then, each character - yes, every one - is followed by an ASCII 0 (I think this is to support Unicode). Here's a hex dump of the above:

File: EEE.TXT                           Page: 1 (0)
Dir: D:\ZZ
------------------------------------------------------------------------
 
    FF FE 46 00 69 00 72 00 73 00 74 00 20 00 6E 00       ..F.i.r.s.t. .n.
    61 00 6D 00 65 00 3A 00 09 00 46 00 69 00 72 00       a.m.e.:...F.i.r.
    73 00 74 00 0D 00 0A 00 4C 00 61 00 73 00 74 00       s.t.....L.a.s.t.
    20 00 6E 00 61 00 6D 00 65 00 3A 00 09 00 4C 00        .n.a.m.e.:...L.
    61 00 73 00 74 00 20 00 4E 00 61 00 6D 00 65 00       a.s.t. .N.a.m.e.
    0D 00 0A 00 4A 00 6F 00 62 00 20 00 74 00 69 00       ....J.o.b. .t.i.
    74 00 6C 00 65 00 3A 00 09 00 4A 00 6F 00 62 00       t.l.e.:...J.o.b.
    20 00 74 00 69 00 74 00 6C 00 65 00 0D 00 0A 00        .t.i.t.l.e.....
    43 00 6F 00 6D 00 70 00 61 00 6E 00 79 00 3A 00       C.o.m.p.a.n.y.:.
    09 00 43 00 6F 00 6D 00 70 00 61 00 6E 00 79 00       ..C.o.m.p.a.n.y.
    0D 00 0A 00 4E 00 6F 00 74 00 65 00 73 00 3A 00       ....N.o.t.e.s.:.
    09 00 48 00 65 00 72 00 65 00 27 00 73 00 20 00       ..H.e.r.e.'.s. .
    71 00 75 00 69 00 74 00 65 00 20 00 61 00 20 00       q.u.i.t.e. .a. .
    6C 00 6F 00 6E 00 67 00 2C 00 20 00 69 00 6E 00       l.o.n.g.,. .i.n.
    20 00 66 00 61 00 63 00 74 00 20 00 61 00 76 00        .f.a.c.t. .a.v.
    65 00 72 00 79 00 20 00 6C 00 6F 00 6E 00 67 00       e.r.y. .l.o.n.g.

File: EEE.TXT                           Page: 2 (256)
Dir: D:\ZZ
------------------------------------------------------------------------
 
    2C 00 20 00 6C 00 69 00 6E 00 65 00 20 00 6F 00       ,. .l.i.n.e. .o.
    66 00 20 00 6E 00 6F 00 74 00 65 00 73 00 2C 00       f. .n.o.t.e.s.,.
    20 00 77 00 69 00 74 00 68 00 20 00 63 00 6F 00        .w.i.t.h. .c.o.
    6D 00 6D 00 61 00 73 00 20 00 61 00 6E 00 64 00       m.m.a.s. .a.n.d.
    20 00 61 00 6C 00 6C 00 20 00 73 00 6F 00 72 00        .a.l.l. .s.o.r.
    74 00 73 00 20 00 6F 00 66 00 20 00 74 00 68 00       t.s. .o.f. .t.h.
    69 00 6E 00 67 00 73 00 20 00 74 00 68 00 61 00       i.n.g.s. .t.h.a.
    74 00 20 00 6D 00 69 00 67 00 68 00 74 00 20 00       t. .m.i.g.h.t. .
    74 00 68 00 72 00 6F 00 77 00 20 00 69 00 74 00       t.h.r.o.w. .i.t.
    2E 00 0D 00 0A 00 4C 00 69 00 6B 00 65 00 20 00       ......L.i.k.e. .
    6C 00 6F 00 74 00 73 00 0D 00 0A 00 6F 00 66 00       l.o.t.s.....o.f.
    0D 00 0A 00 6C 00 69 00 6E 00 65 00 20 00 66 00       ....l.i.n.e. .f.
    65 00 65 00 64 00 73 00 2E 00 0D 00 0A 00 47 00       e.e.d.s.......G.
    65 00 6E 00 65 00 72 00 61 00 6C 00 20 00 6D 00       e.n.e.r.a.l. .m.
    6F 00 62 00 69 00 6C 00 65 00 3A 00 09 00 2B 00       o.b.i.l.e.:...+.
    34 00 34 00 31 00 33 00 31 00 33 00 0D 00 0A 00       4.4.1.3.1.3.....

 The CSV format the Nokia produces also has this null padding, which is presumably why it claims that the format is invalid if you do an ordinary CSV file (but has a go at importing it anyway).

Chris.

[springsoft]

SOLUTION

In the various Nokia suites, including Ovi, you can connect more than one model of Nokia phone.

1. Connect phone via USB (or Bluetooth if available).

2. Select option to Sync Contacts.  This uploads contact details to software.

3. Confirm you now have them listed.

4. Connect new phone (see step 1) and select it.

5. Select option to Sync Contacts (ie repeat step 2).

6. Your contacts should now be on your new phone.

This worked for me when I tried it 2 years ago.

And worked again when transferring contacts from 6788 to 6760 Slide today.

Dave

[Fluffmeister]

I'm sure that works for transferring contacts from one Nokia phone to another, Dave, but isn't a solution to the problem of getting CSV data from a text file into your phone.

In the end, I did get it to work, not by using the CSV format, but the "business card" style format that is also acceptable. However, I had to write a computer program to massage my CSV data to produce this - but at least it was a form of plain text that Nokia *did* almost recognise. I say "almost", because it immediately claimed it was an "invalid format", but went ahead and imported the contacts anyway!

The lack of a decent import interface, given the sophistication of the phone, is pretty shocking. Surely Nokia aren't only marketing their phones at computer programmers? The "official" line that you have to synch it with Outlook Express is completely unacceptable - I "upgraded" to a Nokia from my Palm PDA, and that's where I'm importing contacts from. The Palm makes it very easy to import and export to text or CSV format, and I'd have expected Nokia to be capable of the same.

[veryirritated]

Even the formatting of the forum pages goes all wrong!  How LONG are these lines allowed to get?????

There seems to be a common feature running through all these postings (see also, for example, the LONG list of requests

for Thunderbird support in PC Suite): software development left only half-done, either because the Marketing department

failed to analyze the business requirements before giving the task to Development, or because Development had insufficient budget to do the work.  Given Nokia is (still) a leading brand, lack of budget seems unlikely.

So it must be the Muppets in Marketing.  I'll have to remember to send them an E-Xmas card with a suitable little tune

from Gargamel attached!!

Message Edited by veryirritated on 19-Jan-2010 12:51 AM

Message Edited by veryirritated on 19-Jan-2010 12:52 AM

[Fluffmeister]

Oh good, it's not just me seeing these ridiculously long lines then

Haven't Nokia heard of that new-fangled thing called "auto-wrap"? You know, that thing that came in just after typewriters.

[trondok]

It seems that PC Suite itself doesn't know how to produce the correct format.. Here's what I tried:

Create a test contact in the Communication Centre and export it to a csv file. Delete the contact in Communicaton Centre, then import it from the csv file. What happens? The name and company reappears, but the phone numbers are lost. Note that I did not touch the csv file in between.

I guess this might be caused by me having the wrong version of some component, maybe on the phone itself (N97). But if you are having problems producing the correct format in your import csv file, you may want to check first that Nokia's own file can be successfully imported.

[hensv]

THANK YOU!!!

Your solution worked for my 6350 phone.  I had to use semicolons in the formulas in column BD (in OpenOffice), then after copying that column to Notepad, did a replace of all ";" with "," (back to commas).

It has been a frustrating process because the error message is useless for debugging.

[hensv]

The above Thanks was in response to srikanthkamath's post (#26)

[Vicne]

OMG, I finally succeeded.

At first, I followed about every possible way described in this post but it didn't work.

In my French version, a simple dummy create/export/import cycle fails.

After reducing the test case, I observed that the export contains one blank after the each column header, so the export looks like :

"Titre ";"Prénom ";"Second prénom ";"Nom ";"Suffixe ";...

instead of

"Titre";"Prénom";"Second prénom";"Nom";"Suffixe";...

Once I removed the blanks and ran the procedure again, it finally worked !

Now please Nokia, take your customers into account. At least give details about *why* the import fails - and make sure an export/import cycle works ! I mean, this should be fixed since version 1.0 beta, and we're at version 7.40 ...

Just my 2 cents

Vicne

[kitka0102]

Hi

I'm from Poland, so sorry if I make some mistakes during writting in English.

VICNE - I have the same problem as you had, but I haven't fix it yet, maybe you could help me solve it.

I exported contacts via PC Suite to PC, got *.csv format and when I wanted to import them to another cellphone mostly there was no first name at all, just last name and the phone number. Because I have many persons with the same last name it;s quite difficult to figure it out who is who.

After couple of hours of trying to fix it I noticed that in some lines in csv file there are some marks missing, for example:

The good one goes like this:

;"";"";"Adam";"";"Kolwal";"";"";"";"";"";"";"";"";"";"";"691353666";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";""

and the bad one goes like that

;"Agata";"";"Raz";"";"";"";"";"";"";"";"";"";"";"607400000";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";""

So as you can notice the are some marks missing at each beginning of the line

I could fix it by myself and just write this marks with a "hand" but it doesn't work

so please help me, how am I suppose to do this? 

Forgive me if I made some vocabulary mistakes, I hope you know what I wanted to tell you.

[MILANRAUL1957]

Excelent solution.

My major difficulty solved.

I could update my contact book in one stroke.

God blase you.

I still curse Nokia for not having a straight forward solution to this.

[Jollyp]

I bought N97 mini & I exported the contacts using PC suite from my old N95 8GB in CSV format.

Now my issue is how do i import all these contacts to N97 mini.

Regards

Jolly

[Jollyp]

Help will be really appreciated !