Tuesday 22 January 2013

moving nokia contacts and editing csv files

problem : I have a .csv file (comma separated values ) that contained contacts from a nokia phone. The contacts were to move from one phone to the other . I was using the nokia pc suite to add the contacts onto the new phone. After extracting the contents from the previous phone  I was give the contacts in form of .csv file.Problem was that trying to import the contacts into the nokia pc suite the software was stating that the contact were the wrong format.
solution: This is where I personally got bored to my knees but someone had to do it .So I opened the .csv file in note pad it looked like this

Name,Mobile Phone,Home Phone,Business Phone,Company,Job Title,Car Phone
A,07000000,,,,,


Then we went to the nokia pc suit to the contacts section and exported one contact as a .cvs file so that we could get at what the difference was between the exproted .csv file it could accept and the one it was refusing to import.

The exported contact looked like this 


"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 e-mail","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 e-mail","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 e-mail","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",""
"","contact","","","","","","","","","","","","072222222","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""


so I opend it in excel thinking I had found the holy grail copy pasted onto the columns my contacts from the original faulty .csv then saved as .csv . Aching to import , then failure checked the .csv file format it looked like below.

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 e-mail,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 e-mail,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 e-mail,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
,A,,,,,,,,,,,,07000000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


discouraged it tried to edit manualy to add the double quotes by copy pasting a proper contact and replacing the contact with another contact in its place so as to give the new contact the proper format contaning double quotes . After around 40 contanct it hit me there should be a software that can help and oley came cved. Awsome software by the way. All I had to do was to open the faulty .csv ,the one exported from excell with all the contacts but would not import. I went to options then set it to save with double quotes and voila I was able to import

1 comments:

Unknown said...

GRAANDE!!! I have spent in unuseful tries many, many days: But now I had a result!

Post a Comment