Recently, I had the need to create a large number of Active Directory users. I had an Excel spreadsheet with all the necessary info (CN, sAMAccountname, First and Last Name, email, phone number, job description), and I remembered reading on Microsoft Technet years ago for how to do this.
Sure enough, there is an article out there called “Create User Accounts from Information in an Excel Spreadsheet“. I very quickly was able to get 300+ users plugged into AD, customizing this for my needs.
I recently had a need to migrate all of my Outlook Contacts over to Apple Mail/Address Book and Microsoft Entourage for Mac. Since the Outlook PST format is proprietary (direct export/import from Outlook to Entourage is not supported), I needed to find a way to do this. I decided I had 3 options:
1.) I could spend $10 and buy Outlook2Mac.
2.) I could setup an IMAP server on a Linux box and copy all of my contacts to the IMAP server and import from there to Mac email programs, which would populate the Apple Address Book.
3.) I could export my contacts into vCard format (*.vcf) and import into Mac.
Since I was planning to later convert the physical machine to VMware, I chose option 3.
To do this, I found a great VBscript online here (thanks to Dave Moats). I created a new folder on my WIndows XP PC at c:\vcards and ran the script as follows:
cscript exportContacts.vbs c:\vcards
Hope you find this link and script helpful, I sure did, and have added it to my arsenal for