OL97: Error Converting Outlook Contacts to Schedule+

Last reviewed: January 19, 1998
Article ID: Q166380
The information in this article applies to:
  • Microsoft Outlook 97

SYMPTOMS

When importing Microsoft Outlook 97 Contacts into Microsoft Schedule+ 7.0, you may get one of the following error messages:

   The import file has too many fields. Make sure the character you
   selected to separate the fields matches the separator in the import
   file and that you select the correct character to surround strings.

   -or-

   There was a problem importing the file. The problem occurred near
   line x.

CAUSE

Outlook stores much more information about contacts than Schedule+. If you export the entire Outlook data set, this generates more fields than the Schedule+ importer can handle. Also, if a date field is empty, it is exported as 0/0/00, which is not acceptable to Schedule+.

RESOLUTION

To correct this problem, export only those fields that can be imported into Schedule+. Then import the file into Microsoft Excel for an interim cleanup step. In Microsoft Excel, remove any empty date fields and any completely unused columns.

MORE INFORMATION

To Export Contacts From Outlook

  1. On Outlook's, File menu click Import and Export.

  2. Click "Export to a File" and click Next.

  3. Click the Contact folder you want to export and click Next.

  4. Click "Comma Separated Values (Windows)" and click Next.

  5. Type a path and file name for the file to be exported and click Next.

  6. Click "Map Custom Fields...".

  7. Click Clear Map.

  8. Drag the following fields from the left pane to the right pane:

          Anniversary
          Assistant's Name
          Assistant's Phone
          Birthday
          Business City
          Business Country
          Business Phone
          Business Phone2
          Business Postal Code
          Business State
          Business Street (NOTE: Not "Business Address")
          Company
          Department
          Business Fax or Home Fax or Other Fax (NOTE: Schedule+ only
          supports one "fax" field)
          First Name
          Home City
          Home Country
          Home Phone
          Home Phone 2
          Home Postal Code
          Home State
          Home Street (NOTE: Not "Home Address")
          Last Name
          Mobile Phone
          Notes
          Pager
          Private
          Spouse
          Title
          User 1
          User 2
          User 3
          User 4
    

          NOTE: If User 1, User 2, User 3 and User 4 are not used
          in Outlook, any other four fields may be substituted.
    

  9. Click OK and Finish.

NOTE: Outlook stores these settings for the specific format and export item type, in this case "Comma Separated Values (Windows)" and Contact items. Subsequent exports using this same format and item type will already have the same mapped fields.

To Import and Manipulate Contacts in Microsoft Excel

  1. On Microsoft Excel's File menu, click Open.

  2. Navigate to the file exported above and click Open.

  3. On the Edit menu, click Replace.

  4. Type 0/0/00 in Find What.

  5. Leave Replace With, empty.

  6. Click Replace All.

  7. Select any completely unused columns and on the Edit menu, click Delete.

  8. On the File menu, click Close, click Yes, and then click Save to replace the existing file.

To Import Contacts to Schedule+

  1. On the Schedule+ File menu, point to Import and click Text.

  2. Type or Browse to the file name to be imported, then click Next.

  3. Click Yes and then click Next.

  4. Click Comma, select the quotation mark (") as "character used to surround text fields", and click Next.

  5. Click Contact List and click Next.

  6. Select types for each field in the incoming file.

  7. Click Finish.

    NOTE: Once set, Schedule+ retains these settings.

REFERENCES

For information on exporting Outlook Appointments to Schedule+, please see the following article(s)in the Microsoft Knowledge Base:

   ARTICLE-ID:  Q166307
   TITLE     :  OL97: How to Convert Outlook Appointments to Schedule+ 7.0

Keywords          : IntpOff kberrmsg
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbhowto


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 19, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.