OL97: Converting Windows Cardfile Files to Outlook

• Microsoft Outlook 97

SUMMARY

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

MORE INFORMATION

Workaround 1

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



• Expand and run the converter.



• Import the Default.scd file into Outlook.

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

1. Download the Import/Export Pack from the Microsoft Web site:

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




2. Save the file to the following location:

   c:\Program files\Microsoft Office\Office

Expand and Run the Converter

1. Double-click the file, Sch_suplfilt.exe in:

   c:\Program files\Microsoft Office\Office




2. Run the converter by double-clicking the file, Ilxlate.exe in:

   c:\Program files\Microsoft Office\Office




3. On the Transfer menu, click Import.



4. In the Available Systems list, click Windows Cardfile/Calendar and click OK.



5. In the Section list, click to select Cardfile.



6. Type the name or browse to the Cardfile file to be converted.



7. On the Fields tab, map the Cardfile fields to the appropriate Schedule+ Contact fields, and click Import.

Import the Default.scd File into Outlook

1. On the File menu, click Import and Export.



2. Click to select "Import from Schedule+ or another program or file" and click Next.



3. Click Schedule+ 7.0 and click Next.



4. Type the name or browse to the Default.scd file and click Next.



5. Click to select, "Import 'default.scd(Contacts)' into 'Contacts'" and click Map Custom Fields.



6. Map the incoming Schedule+ fields to the appropriate Outlook Contact fields, click OK and Finish.

Workaround 2

• Print the Cardfile records to a text file.



• Manipulate the comma-delimited file in Microsoft Word.



• Import the tab-delimited file into Outlook.

Print the Cardfile Records to a Text File

1. In Windows 3.x, click the Printers icon in Control Panel.



2. Configure the Generic/Text Only printer driver to the FILE port.



3. Open the .crd file you want to import.



4. On the File menu, click Print Setup.



5. In Print Setup, click to select Specific Printer, click the Generic/Text Only driver and then click OK.



6. On the File menu, click Page Setup, click to clear the Header and Footer check boxes, set the Left Margin to zero, and click OK.



7. On the File menu, click Print All.



8. Type a name for the file including the desired path and a .txt extension, and click OK.

Manipulate the Comma-Delimited File in Microsoft Word

1. In Word, open the .txt file from the above steps.



2. On the Edit menu, click Select All.



3. On the Table menu, click "Convert Text to Table."



4. In Number Of Columns, type 18, click "Separate text at Paragraphs", and click OK.



5. Delete any completely empty columns by selecting them, and on the Table menu, click Delete Columns.



6. Verify that the fields of each record are in the correct column. Those that are not must be manually adjusted.



7. Place the cursor in the first row of the table and on the Table menu, click Insert Rows.



8. In the newly inserted row, type a field name for each column.

1. On the Table menu, click Select Table.



2. On the Table menu, click "Convert Table to Text."



3. In Convert Table To, click "Separate text with Tabs" and click OK.

1. Type a double quotation mark in front of the first character in the file.



2. On the Edit menu, click Replace.



3. In Find What, type "^p" (without the quotation marks), in Replace With, type ("^p") (without the parentheses), and click Replace All.



4. In Find What, type "^t" (without the quotation marks), in Replace With, type (",") (without the parentheses), click Replace All and click Close.



5. On the File menu, click Save As.



6. Type a name for the file and in Save As Type, click Text Only and click Save.

Import the Tab-delimited File into Outlook

1. On the Outlook File menu, click Import and Export.



2. Click "Import from Schedule+ or another program or file" and click Next.



3. Click "Comma Separated Values" and click Next.



4. Browse to or type the name of the comma-delimited file and click Next.



5. Click the folder you want to import the records into and click Next.



6. Click to select "Import '<filename.txt>' into '<foldername>.'"



7. 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:

Q164271 OL97: Converting Schedule+ Files to Outlook 97

Q162990 OL97: Troubleshooting Schedule Plus Import Problems

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 : kbinterop IntpImEx
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbhowto