Skype: bulk import

October 22nd, 2009 § 0

Skype
Out of the box, Skype doesn’t have a bulk import feature. I only found one extra and it costs 15$.
Here’s a tip how to do it for free.

  1. Open Skype and go to ‘Contacts’
  2. Go to Advanced
  3. Backup contacts to file
  4. Open the backup with Notepad or another text editor
  5. The file is full of vcards, just copy a vcard, and past it at the bottom. All you have to do is alter the info. (ref is reference to importtime so you don’t have to alter this tag)
  6. if you need to import many contacts, write a script to add extra vcards.
  7. When your file is ready, go back to Skype/Advanced and import restore the backup.

An autoit script to do this might look something like the code below (untested)
Phone.xls has a column with nummers and a column with names

#include
$oExcel = _ExcelBookOpen("phone.xls")
_ExcelSheetActivate($oExcel,"sheetName")
For $i = 1 To 3 ;Loop
$phone = _ExcelReadCell($oExcel, 1, $i);cell with phone
$name = _ExcelReadCell($oExcel, 1, $i);cell with name
$file = FileOpen("backupfile.vcf", 1)

; Check if file opened for writing OK
If $file = -1 Then
MsgBox(0, "Error", "Unable to open file.")
Exit
EndIf

FileWriteLine($file, "BEGIN:VCARD")
FileWriteLine($file, "VERSION:3.0")
FileWriteLine($file, "N:"+$phone)
FileWriteLine($file, "X-SKYPE-PSTNNUMBER:"+ $phone)
FileWriteLine($file, "X-SKYPE-DISPLAYNAME:"+ $name + " " + $phone)
FileWriteLine($file, "REV:01091022T130411Z")
FileWriteLine($file, "END:VCARD")

FileClose($file)
Next
_ExcelBookClose($oExcel)

Where Am I?

You are currently browsing entries tagged with Skype at westworld: a webmasters best friend.