-Notes from Noteeverything to DejaOffice.
Import contacts from Android
Notes for Kies:
-export to csv (only phone contacts):
field contents between quotation marks, and columns delimited by comma
Too many fields(all) are exported in a fixed order, and the first line the field name in your language
groups in 1st field an delimited by double semicolon
-export to vcf(only phone contacts). 1 per file (will loss groups and extended information)
content of all vcf file can be joined in a vcf file using the msdos copy command
(only phone contacts). There is no reason to extract google account contacts as they are in the cloud and there are other methods to do it.
BB Contacts Imp/Exp: requires a first line with headers, and it will map to BB contacts
|BB Contacts Imp/Exp|
-export to csv: field contents between quotation marks, and columns delimited by comma.
Number and position of fields is variable.
To know field names, you can create a dummy contact with enough information and export it to csv
Fields in the header of a csv file exported by BB Imp/Exp:
Mapping CSV from Android with "Contacts Imp/Exp" headers from csv file.
Use a good spreadsheet software like Gnumeric or Libreoffice (avoid excel because it cannot export properly)
Verification after export:
Check that long numbers i.e 420721958625 are not shorten to a form like xxxE+11 (another reason to avoid the use of Ms Excel)
Check numbers that phones beginning with a 0 have it
Check numbers with a country prefix +xx
Steps to convert:
From Kies csv file, remove as many columns as possible, generally normal users don't use more than 10 fields.
Groups: If you have contacts classified by groups, you can associate "Group" column from Android contacts to "OrganizationAffiliation/OrganizationAffiliationName" column in BB
If contacts are associated to multiple groups it, and you want to keep it, it would require more complex steps, before mapping if decide to kept only a group per contact and remove additional.