Geek asks and answers

Import CSV contacts to Android 4 phone

I have a CSV file with all my contacts (exported from Thunderbird).

I have an Android 4 ice cream sandwich on my phone.

How to import contacts from a CSV file into your Android mobile phone (sony ericson Xperia Ray) without using any spyware (google, facebook, outlook, etc.)?

+5
source share
6 answers

Here is the version for Rubo77 for Windows:

  • Import the csv list into Windows 7 contacts (remember that you can only use the Windows contact fields once per csv field)

  • Export Windows contacts to separate VCF cards.

  • Merge them all together into one large vcf file:

    type *.vcf>..\all_adresses.vcf

  • all_adresses.vcf UTF-8, :

    all_adresses.vcf Notepad ++, Encoding > Encode UTF-8. .

  • Android- ( SD-)

+5

, google!

  • csv- Windows 7. (, )

  • VCF-.

  • vcf:

    cat *.vcf>../all_adresses.vcf

  • UTF-8, :

    iconv --from-code=ISO-8859-1 --to-code=UTF-8 all_adresses.vcf > all_adresses_correct.vcf

  • , Android- ( SD-)

Windows , , , .

+5

, ( Linux, cygwin Windows env):

  • Thunderbird CSV .
  • :

, , , , , , , , , , , , , 2, , , , , , 2, , , , , , , , - 1, - 2, , , , 1, 2, 3, 4, ,

, , , Email.

sed VCF 2.1:

BEGIN:VCARD
VERSION:2.1
N:LastName;FirstName
FN:FirstName LastName
EMAIL;PREF;INTERNET:local@domain
END:VCARD

script ( , , ..):

#!/bin/bash

# This script convert a ThunderBird AddressBook ( 17.04) exported as CSV file using commas into a VCF 2.1 file.
# rmistero - April 2013 - GNU GPL 3


CSV_FILE="contacts.csv"
VCF_FILE="contacts.vcf"

# sed is looking for regex pattern NOT containing commas between 2 commas.

sed -e "s/^\([^,]*\|\".*\"\),\([^,]*\),\([^,]*\),[^,]*,\([^,\"\']*\),.*$/N:\2;\1\nFN:\3\nEMAIL;PREF;INTERNET:\4\n/g" -e "1d" < $CSV_FILE |  sed -e "/^EMAIL/ a\END:VCARD" -e "/^N/ i\BEGIN:VCARD\nVERSION:2.1" | grep -vE "^$|\"" > $VCF_FILE

, USB- Android. "", "" "/" vCard.

, , , , .

. contacts.csv, :

grep -c EMAIL contacts.csv

, "EMAIL" (, ).

+4

Outlook vcf - . , , , . , .

0

MobiKin Assistant Android Android Excel CSV XLS . Android. Google MobiKin Assistant Android. , !

0

, Android 7.0, , ... , Windows Phone 8, , CSV...

( , (Comma Separated Values), - ...)

- Firefox, Google Chrome, http://google.com/contacts, GMail, , Firefox Beta , "" ( ), GMail. , " ...", , ( "" ); , Firefox Focus.

In the upper right corner, I selected "Show internal storage", and then in the upper left corner I opened the File Manager, selected the CSV file and imported it into the GMail contacts. Then it immediately syncs all the contacts with my Android phone.

0
source

More articles:


All Articles