Comma Separated Values (windows or dos)??

Discussion in 'Mac Apps and Mac App Store' started by Cyroceon, Feb 14, 2008.

  1. Cyroceon macrumors 6502a

    Cyroceon

    Joined:
    Feb 9, 2008
    #1
    I am going to be switching over to a Macbook in the near future and I would like to bring all my contacts from outlook(which are also the ones on my iphone) to AddressBook on OSX. When exporting contacts there are two formats I can use, CSV Windows or CSV DOS. Which one of these would be read by AddressBook without a hitch? Thanks in advance, as I am just prepping my stuff so that the switch will be seamless.
     
  2. TEG macrumors 604

    TEG

    Joined:
    Jan 21, 2002
    Location:
    Langley, Washington
    #2
    Either. I believe the difference is how new lines are created. AddressBook can read both the LF/CR(DOS) and the CR(WIN) forms.

    TEG
     
  3. JNB macrumors 604

    JNB

    Joined:
    Oct 7, 2004
    Location:
    In a Hell predominately of my own making
    #3
    When in doubt, I generally recommend DOS, as it is pretty much guaranteed to not have any additional hidden formatting. not a huge issue, but prevents any "clean up" afterwards.
     
  4. Cyroceon thread starter macrumors 6502a

    Cyroceon

    Joined:
    Feb 9, 2008
    #4
    I also found a way to highlight and drag all contacts into a backup folder as vCards. Is that better? That gives each individual contact his/her own vCard.
     
  5. TEG macrumors 604

    TEG

    Joined:
    Jan 21, 2002
    Location:
    Langley, Washington
    #5
    VCards work well as they are a defined standard format. That would make it much easier, then just drag them, en masse, to your address book.

    TEG
     
  6. Gelfin macrumors 68020

    Gelfin

    Joined:
    Sep 18, 2001
    Location:
    Denver, CO
    #6
    Provided it works, this is a much better option. vCards are a standard, but it's certainly not beyond Microsoft to deviate from a standard in ways that break competing products. Therefore, test whether AddressBook properly understands vCards generated by Outlook before you burn any bridges.

    For reference, the information you've received about the difference between "Windows" and "DOS" encoding is not accurate. Windows and DOS use identical linebreak encoding (CRLF). The difference between the two would be important only if you have certain special characters in text fields, such as accented characters. If you export as Windows CSV, those fields will be encoded using the Windows-1252 code page. "DOS" encoding is typically Code Page 437, which is the mapping of characters used in old pre-Windows PCs. If you export as one and then import using a tool that expects the other, most things will look fine but you'll get some unexpected character substitutions if, say, you know someone with an umlaut in his name.

    If you end up having to go that route, choose to export as Windows CSV, then when importing to Address Book change the Text Encoding field to "Western (Windows Latin 1)." vCards are still better if they work, though.
     
  7. Cyroceon thread starter macrumors 6502a

    Cyroceon

    Joined:
    Feb 9, 2008
    #7
    I got them as vCards and everything looks good. Thanks guys.
     

Share This Page