fixed : export contacts database from AddressBook to Excel

Question [1] : I’m new to Mac, I just switched to my first Mac, before I only used Windows PCs. How can I import my contacts from my Windows PC into my new Mac running OSX ?

Question [2] : I’m a Mac user myself, but I need to share my contacts database from Apple AddressBook with WindowsPC-users I’m working with. Since there is no Apple AddressBook for Windows, this seems impossible. What can I do ?

Answer to both [1] and [2] : It’s possible, and it isn’t that complicated either.

There are (free) MacOSX-applications that can do this for you.

! BEWARE ! there are 2 applications around that are extremely similar (and therefore easily confused) both in name and features :

Address Book Exporter 2.1.2 (from 2003 ; with a space in the name)

http://www.macupdate.com/info.php/id/9312/address-book-exporter

AddressBook Exporter 1.0 (from 2005 ; without a space in the name)

http://www.macupdate.com/info.php/id/17501/addressbook-exporter

The first one (from 2003 ; with a space in the name) is the best one. That’s the one that still works properly with Apple AddressBook from MacOSX 10.6 “Snow Leopard”.

How to install :

  • download the application (from 2003 ; with the space in the name)

http://www.macupdate.com/info.php/id/9312/address-book-exporter

  • drag the application-icon to your Applications folder

How to use it :

  • startup the application “Address Book Exporter 2.1.2”
  • from the “Groups” list, choose “All” to start converting your entire AddressBook, or choose only the selection that you want to export
  • if you would like to convert / export a selection that is not listed, go back into your AddressBook and create a (temporary) group from your selection
  • now, in “Address Book Exporter 2.1.2” check the checkbox of “Export using current field settings”
  • click the “Configure Settings” button
  • in the pull-down menu that appears, check the checkboxes of everything that you would like to export, and click “OK”
  • click the “Export Address Book” button
  • if you like, you can change the name of the exported file
  • then choose a destination on your Mac where you will be able to easily find the exported file (e.g. “Desktop”) and click “Save”
  • quit “Address Book Exporter”
  • open “MS Excel”
  • drag the icon of the exported file (from the Desktop) onto the MS Excel icon in the Dock, to have it opened in Excel
  • and… here you are : all your contacts are in Excel now
  • from there you can “Save As” to have a .xls-file that you can share with WindowsPC-users
Advertisements

fixed : import contacts database from Excel into AddressBook

A common question of Windows-to-Mac-switchers is “How can I import my contacts from Excel into my Mac ?”.

Here’s the way to import a contacts database from Excel (Mac or Windows) into Apple AddressBook :

  1. open the contacts database in Excel (on Mac or Windows)
  2. save the contacts database under a new name (e.g. “addresses-export.xls”), to make sure you will have a emergency-backup
  3. rearrange the data in the (copy of the) contacts database in such a way that the upper row will only contain column headers, and every next line will only contain the data of one contact (with all data in the correct column)
  4. for street addresses you will need 4 (or 5) separate columns : “street name (including home number)”, “postal code”, “town”(, “province”) and “country” ; if you want to include both a home and a work address, you should make that 2x 4 = 8 columns
  5. make sure to use separate columns to match the different data groups you have, so make separate columns for “home phone”, “work phone”, “mobile phone”, “home fax”, “work fax”, etc.
  6. if you have completely rearranged the data to suit this layout, go to “Save As”
  7. choose the option “Format : Comma Separated Values (.csv)”, choose an easily accessible location to save the file (e.g. on your Desktop) and click “Save”
  8. quit Excel
  9. open Apple AddressBook
  10. click on the ‘button with the plus sign’ in the lower left corner to create a new group and choose a proper group name for the addresses you are about to import (e.g. “Excel import January 1st”)
  11. then, in the upper menu bar under “File”, choose “import”
  12. select “”addresses-export.csv” (or whatever you’ve clued your database file) from the Desktop (or other location where you’ve saved it) and click “Open”
  13. you will now get a “Text File Import” window, in which you have to indicate what the  right name of each ‘column’ should become in Apple AddressBook
  14. for addresses you will have do this in a way that might not be obvious : first select “Address (home)” or “Address (work)” next to the “Address”-heading from your Excel-file, after that an the list will automatically extend to include “PostalCode”, “City” and “Country” (note that this will leave an extra “PostalCode” and “City” just below, that you have to change to the “Do not import” label.
  15. If you’re done setting this up, double-check it again (if you don’t set this up properly and faultless, the outcome will not be acceptable, and you will have to redo the complete import-procedure)
  16. make sure that the little checkbox is checked next to “Ignore first card” and click “OK”
  17. if you will now look in the “Last Import” group (the green group) you will see all imported data
  18. now, just to be sure : double-check some data to make sure everything has been imported the way you want it
  19. then select only one contact from the “Last Import” group and press the CMD+A (“Select All”) to select all contacts and then drag the entire selection onto the group that you’ve previously created, named “Excel import January 1st” or what you’ve called it
  20. Note : the “Last Import” group is only a temporary group, so to make sure you will be able to easily find your Excel-imported contacts as a group in the future, the group “Excel import January 1st” has been created ; if you decide at any time that there’s no need anymore to be able to access these Excel-imported contacts as a separate group, you can easily delete the group name “Excel import January 1st”, without deleting the contacts themselves from AddressBook

…after following this step-by-step instruction, you will have all your Excel-contacts in AddressBook also !

Old School Mac [3] : will my printer work with OSX ?

— THIS IS A REPOST FROM LONG WAY BACK ; JUST FOR ENTERTAINMENT — ORIGINALLY POSTED ON MACOSX.NL (a.k.a. ONE MORE THING) IN 2004

Question : Will I be able to use my WindowsPC’s printer on my new Mac ? Mine is a HP DeskJet 916.

Answer : Yes – the general rule is : any printer that you can connect to your OSX-Mac, will be useable (a least partially) from within OSX

About the meaning of “any printer that you can connect to your OSX-Mac” in the sentence above :

To connect a printer to a OSX-Mac, you need to connect it using a USB- or UTP/Ethernet-cable ; printers that can only be connected using a Parallel PC-printerport will therefore not do…

In this case it’s about a HP DeskJet 916 (HP calls it the “DJ916”) ; that one is included in the so-called DJ9xx-range… those ones are compatible with an OSX-Mac, but when using older versions of OSX you will probably need to use a ‘detour’ using the UNIX-base of OSX combined with the Linux-drivers by HP ; follow these links for more info :

http://www.allosx.com/1034107267/index_html http://hpinkjet.sourceforge.net/productssupported.php http://www.linuxprinting.org/tylerb/hpijs/

That last link is to the actual HPIJS for MacOSX, but be aware ! : do read the instructions and keep a copy of them for future reference before you do any install !

Note : using MacOSX 10.3 Panther your printer will be compatible if it is listed here :

http://www.apple.com/macosx/upgrade/printers.html

the original post(s) can be found here :

http://www.onemorething.nl/community/topic/hp-printer-op-mac

Old School Mac [1] : share internet among OSX-Windows-OS9

— THIS IS A REPOST FROM LONG WAY BACK ; JUST FOR ENTERTAINMENT — ORIGINALLY POSTED ON MACFIXIT IN 2003

I finally figured out how to share the cable internet connection from my OSX-G4 with my WinMe-PC and my old OS9-Mac !! (without a Router !! – just a Hub !!)

NOTE : I only tested this with WinMe, but it should work with any Win-version from Win95 onwards (because Win95/98/98SE/Me are all from the same OS-family and WinXP is also quite similar – even a little easier on networking)

Here’s how to do it :

STEP 1 : HARDWARE SETUP

  • connect the incoming UTP-cable to the Build-in Ethernet-card on the G4
  • connect the UTP-cable for local networking from the G4’s 2nd Ethernet-card to the Hub
  • connect another UTP-cable from the PC to the Hub
  • connect yet another UTP-cable from the OS9-Mac to the Hub
  • IMPORTANT : make sure that all UTP-cables are connected to ‘normal’ Hub-ports ; do not connect to the Uplink-port, because that will prevent from using the Network-printer

STEP 2 : OSX INTERNET-CONNECTION VIA BUILT-IN ETHERNET-CARD SETUP

  • go to Apple Menu / System Preferences / Network / Built-in Ethernet
  • in TCP/IP : choose ‘Using DHCP’
  • in PPPoE : leave all alone
  • in AppleTalk : choose ‘Off’ [uncheck switch]
  • in Proxies : choose ‘Use Passive…’

STEP 3 : OSX LOCAL NETWORK (LAN)-CONNCETION VIA 2ND ETHERNET-CARD SETUP

  • go to Apple Menu / System Preferences / Network / … [name of 2nd Ethernet-card]
  • in TCP/IP : type IP Address = 192.168.0.1 [or any alternative you choose]
  • in TCP/IP : type Subnet Mask = 255.255.255.0
  • in PPPoE : leave all alone
  • in AppleTalk : choose ‘On’ [check switch]
  • in Proxies : choose ‘Use Passive…’

STEP 4 : OSX LOCAL NETWORK (LAN)-CONNECTION FIREWALL SETUP

  • go to Apple Menu / System Preferences / Sharing / Firewall
  • put Firewall ‘On’
  • add ‘New’ to open an extra connection port
  • click ‘Other’ and type the Port Number that is needed to connect to your Internet Service Provider (ISP)’s Proxy [e.g. 80] -> give this new port a Description [e.g. your ISP’s name]
  • go to Apple Menu / System Preferences / Sharing / Internet
  • put Internet Sharing ‘On’

STEP 5 : WIN-ME (PC) LOCAL NETWORK (LAN)-CONNECTION SETUP

  • go to Start / Preferences / Configuration Panes / Network / Configuration
  • select ‘TCP/IP -> …’ [for your Ethernet-card]
  • select ‘Configure’ : a window ?TCP/IP? opens
  • in IP-address : choose ‘manually configure IP-address’
  • type IP-address = 192.168.0.2 [or any other IP-address you choose]
  • type Subnet Mask = 255.255.255.0
  • in WINS : leave all alone
  • in Gateway : add 192.168.0.1 [the IP-address of the interent-connected OSX-Mac]
  • in DNS-configuration : choose ‘activate DNS’
  • type Host = … [network-name of the OSX-Mac]
  • type Domain = … [network-name ot the Workgroup both the OSX-Mac and PC are part of]
  • add all (normally 2) DNS-server IP-addresses your ISP has provided
  • in Bindings : check both ‘File- and Printer-sharing’ and ‘Client for Microsoft Networks’
  • in Advanced : leave all alone
  • in NetBIOS : leave all alone

STEP 6 : WIN-ME (PC) INTERNET BROWSER SETUP

  • go to Start / Applications / Internet Explorer / Extra / Internet Options
  • in Connections : choose ‘LAN-configuration’
  • in LAN-Configuration : uncheck ‘automatically detect…’
  • in LAN-Configuration : uncheck ‘use automatic configuration script’
  • in LAN-Configuration : check ‘use Proxy
  • type Address = … [the Proxy-IP-address your ISP has provided]
  • type Port = … [the Proxy Port-number your ISP has provided]
  • check ‘do not use Proxy for local …’

STEP 7 : OS9-MAC SETUP

  • go to Apple Menu / Control Panels / TCP/IP
  • choose ‘Configure Manually’
  • type IP Address = 192.168.0.3 [or any other IP-address you choose]
  • type Subnet Mask = 255.255.255.0
  • type Router = 192.168.0.1 [the IP-address of the OSX-Mac]
  • type Nameserver Address = … [the DNS-server IP-addresses your ISP has provided]
  • choose ‘Options’
  • check Make Active ‘Always’
  • go back – choose ‘Info’
  • see if all settings are made correctly
  • go to Internet Explorer / Edit / Preferences / Proxies
  • check ?Web Proxy?
  • type Web Proxy = …. [the Proxy-IP-address your ISP has provided]
  • type Port = … [the Proxy Port-number your ISP has provided]
  • check ?Always Use Web Proxy?

…that’s it – it’s that simple (looking back solutions always seem obvious…)

…but there’s one little flaw : MacOSX 10.2 “Jaguar” automatically turns off Internet Sharing on restart… only upgrading to MacOSX 10.3 “Panther” will fix that…

——————–

in this setup, it’s also very easy to make your PC’s harddisk(s), CDromplayer(s) and floppydisk available for MacOSX :

  • on the Windows Desktop go to ‘My Computer’
  • right-click the icon of the disk or drive you would like to share
  • in the pull-down menu that appears, select ‘Share…’
  • under the Share-tab, select ‘Shared as’
  • type Sharename = … [anything you like]
  • select Access Type = Full
  • click ‘OK’

…now ‘a hand’ has appeared under the icon, meaning this is a ‘shared disk’

to connect from MacOSX :

  • go to Finder / Go / Connect to Server… [or type Apple-K while in the Finder]
  • type Address = smb://192.168.0.2 [the PC’s IP-address]

…and you get a pop-up window asking you which PC-‘shared disk’ to mount

the original post(s) can be found here :

http://archive.macfixitforums.com/ubbthreads.php/ubb/showflat/Number/483947/site_id/1#import