Tips for Techies

The format of the CSV (comma separated value) file that you import into hotComm must be similar to one of these formats:

• Microsoft Outlook and Outlook Express
  
  
  • The first row contains these headings. Other headings in the row are ignored. Data is imported from the columns that have these headings. The headings are case-sensitive and must be exactly as shown here.
    

    
    Name
    First Name
    Last Name
    Nickname
    E-mail Address
    
    

  • Data may be text delimited with double-quotation marks, but double-quotation marks are not required. Microsoft Outlook adds the quotation marks; Outlook Express does not.
    
    

  This is an example of a file exported from Microsoft Outlook 2000

  "First Name","Last Name","Company","Business City","E-mail Address" "Amelia","Earhart",,,"amelia@xyz.net" "Bob","Testing","XYZ Corp",,"Bxx@xyz.net"

  This is an example of a file exported from Microsoft Outlook Express 5:

  First Name,Last Name,Name,Nickname,E-mail Address,Business City,Company Amelia,Earhart,Amelia Earhart,,amelia@xyz.net,, Bob,Testing,Bob Testing,Bxx,bxx@xyz.net,,

  
  
  
• Netscape
  
  

  The first row does not contain headings, but does include an @ in at least one field. In this case, the hotComm import takes data from specific columns. The columns and data are:

  Column	Data
  1	Display name
  2	Last name
  3	First name
  7	Email address
  17	Nickname

  This is an example of a file exported from Netscape 4.77:

  Amelia Earhart,Earhart,Amelia,,,,amelia@xyz.net,,,,,,,,,,AE Bob Testing,Testing,Bob,,,,bxx@xyz.net,,,,,,,,,,Bxx