OL97: Converting Windows Cardfile Files to Outlook

Last reviewed: January 19, 1998
Article ID: Q164994

The information in this article applies to:

Microsoft Outlook 97

SUMMARY

Microsoft does not provide a converter to import Windows Cardfile files into Microsoft Outlook 97. This article describes two workarounds for importing these files.

MORE INFORMATION

WORKAROUND #1

Use the Import/Export Add-on Pack for Schedule+ Version 7.0, to import the Windows Cardfile file into Schedule+ then into Outlook, as follows:

Install the Import/Export Add-on Pack for Schedule+ 7.0:

a. Download the Import/Export Pack, from Microsoft's web site at:

        Http://www.microsoft.com/scheduleplus/freestuff/impconv/default.htm

   b. Choose to save the file to disk at:

         c:\Program files\Microsoft Office\Office

   NOTE: Because the Microsoft Web site is constantly updated, the site
   address may change without notice. If this occurs, link to the Microsoft
   home page at the following address:

      http://www.microsoft.com/

Expand and run the downloaded converter program:
a. Expand the downloaded converter programs by double clicking,
```
      Sch_suplfilt.exe in the, c:\Program files\Microsoft Office\Office
      folder.
```
b. Run the converter by double-clicking the file Ilxlate.exe In the,
```
      c:\Program files\Microsoft Office\Office folder.
```
c. On the Transfer menu, click Import.
d. On the Available Systems list, click Windows Cardfile/Calendar
```
      and click OK.
```
e. In the Section, drop-down list, click Cardfile.
f. Type the name or browse to the Cardfile file to be converted.
g. On the Fields tab, map the Cardfile fields to the appropriate
```
      Schedule+ Contact fields, and click Import.
```
RESULTS: This will generate a Schedule+ default.scd file.
Import the Default.scd file into Outlook.
a. On Outlook's File menu, click Import and Export.
b. Click, Import from Schedule+ or another program or file, and
```
      click Next.
```
c. Click Schedule+ 7.0 and click, Next.
d. Type the name or browse to the Default.scd file and click, Next.
e. Place a checkmark in Import "default.scd(Contacts)" into "Contacts"
```
      and click, Map Custom Fields.
```
f. Map the incoming Schedule+ fields to the appropriate Outlook Contact
```
      fields and click OK, then Finish.
```
RESULTS: The default.scd file is imported into Outlook.

WORKAROUND #2

You can import Windows Cardfile files into Outlook using a three step process, as follows:

Step 1 - Print the Cardfile Records to a Text File

In Windows 3.x, click the Printers icon in Control Panel.
Configure the Generic/Text Only printer driver to the FILE port.
Open Cardfile and load the .crd file you want to import.
On the File menu, click Print Setup.
In the Print Setup dialog box, click the Specific Printer option, click the Generic/Text Only driver and then click OK.
On the File menu, click Page Setup, clear the Header and Footer check boxes, set the Left Margin to zero, and click OK.
Click Print All, on the File menu.
Type a name for the file including the desired path and a .txt extension, then click OK.

Step 2 - Manipulate the Comma-Delimited File in Word

Convert the text file to a table:
a. In Word, open the .txt print file from above.
b. On the Edit menu, click Select All.
c. On the Table menu, click Convert Text to Table.
d. In the Number of columns window, type 18, click "Separate text at
```
      Paragraphs", and click OK.
```
e. Delete any completely empty columns by selecting them, then on the
```
      Table menu click Delete Columns.
```
f. Verify that the fields of each record are in the correct column.
```
      Those that are not must be manually adjusted.
```
g. Place the cursor in the first row of the table and from the Table
```
      menu click Insert Rows.
```
h. In the newly inserted row, type a field name for each column.
Convert the table to tab-delimited text:
a. On the Table menu, click Select Table.
b. On the Table menu, click "Convert Table to Text."
c. In the Convert Table To dialog box, click "Separate text with Tabs"
```
      and click OK.
```
Enclose fields in quotation marks and replace tabs with commas:
a. Type a double quotation mark in front of the first character in the
```
      file.
```
b. On the Edit menu, click Replace.
c. In the Find what window type (^p) without the parentheses, in the
```
      Replace with window, type ("^p") without the parentheses, and click
      Replace All.
```
d. In the Find what window type (^t) without the parentheses, in the
```
      Replace with window, type (",") without the parentheses, click
      Replace All and click Close.
```
Save the comma-delimited file:
a. On the File menu, click Save As.
b. Type a name for the file and in the Save as type window click Text
```
      Only and click Save.
```

Step 3 - Import the Tab-delimited File into Outlook

On Outlook's File menu, click Import and Export.
Click "Import from Schedule+ or another program or file" and click Next.
Click "Comma Separated Values" and click Next.
Browse to, or type the name of the comma-delimited file and click Next.
Click the folder into which you want to import the records and click Next.
Place a checkmark beside Import "<filename.txt>" into "<foldername>" folder.
Click "Map Custom Fields" and map the incoming Cardfile fields to the appropriate Outlook fields and click OK and Finish.

REFERENCES

For more information on importing Schedule+ files, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID:  Q164271
   TITLE     :  OL97: Converting Schedule+ Files to Outlook 97

   ARTICLE-ID:  Q162990
   TITLE     :  OL97: Troubleshooting Schedule Plus Import Problems

A freeware utility to convert Cardfile databases into tab-delimited text files is available on some Bulletin boards. This utility, TRANSFIL.EXE, is in an archived file named CARDXLT2.ZIP. It is also available directly from the author:

   Peter Horn
   43 Trevor Road
   Lansdowne 7764
   Republic of South Africa

   Tel. and Fax: +27 +21 696-1983
   EMail: HORNPETE@UCTVAX.UCT.AC.ZA

Keywords          : IntpImEx kbinterop
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.