Converting Files

Converting Files

This space is being written at the moment, so information might seem incomplete. Come back later, or watch this space so you can receive update notifications when new stuff is being written.

Introduction

Although the following programs are being considered for PipeDream File conversion, the majority of files are just transferred as 'Plain Text' files and then used on the target word processor. What happens if the text formatting needs to be retained, or the formulae in spreadsheets are retained? This is what this section is exploring.

 


PC PipeDream

Starting
Program

Conversion Programs


Smartsuite


Fireworkz


Lotus Approach

Target
Programs


Word 2013


Excel 2013

 

 

PC PipeDream

Conversion is done when saving files.

When saving files, 

 File Save 

The file is usually saved as PipeDream file. When converting a file, the only line that we are interested in is the last one which gives five options.

 

Format

To be used

Type of File

Name

Comments

Pd

In PipeDream

Multi function

PipeDream

 

Lotus

In Spreadsheets

Contains formulaes

Lotus 1-2-3

Microsoft do not convert this file format in Excel 2013.
Lotus /IBM SmartSuite Approach 9 has issues in Windows 8.

Comma

In Databases

One line per record, commas separating fields

Comma delimited

 

Tab

In Word processing

 

Plain Text

 

Auto

When Loading

Will load correct format if saved by PipeDream

 

 

Smartsuite

IBM have taken over from Lotus with the Smartsuite product and it is still available.  Fortunately, I still have that product. The oldest one that has AmiPro 3.1 for Windows 3 installed on the Virtual Windows xp Professional using the same procedure below.

This program supports the following conversions.

Word Processing

  • MS Word Word 97 (*.DOC), MS Word Word for DOS 3, 4, 5, 6 (*.DOC), MS Word Word for OS/2 (*.DOC), MS Word Word for Windows 1.0 (*.DOC), MS Word Word for Windows 2.0 (*.DOC), MS Word Word for Windows 6.0 (*.DOC), MS Word Word for Windows95 7.0 (*.DOC).

Spreadsheet

  • Lotus 1-2-3 (*.W*), Lotus 1-2-3  97 (*123),Lotus 1-2-3 for OS/2 (*.WG*),Lotus 1-2-3 R3 (*.WK3),Lotus 1-2-3 R4 (*.WK4),

  • MS Excel (*.XLS), MS Excel 3.0 (*.XLS), MS Excel 4.0 (*.XLS), MS Excel 5.0 (*.XLS), MS Excel 7.0 (*.XLS), MS Excel 97 (*.XLS), 

Database

  • dBase/ANSI (*.DBF), dBase/ASCII (*.DBF)

A full listing of all the conversions are listed here.

 

Fireworkz

 

Input Files

Output Files

Fireworkz for Windows was released after PC PipeDream. It can only convert PipeDream files into Lotus 1-2-3 format and not the other way round. Download may be obtained from here.

Summary of Conversions

File Conversion

File Ext

 

 

Type of File

Program

 

File Ext

OS

Notes

PipeDream

*.pd 

>

Plain Text File

Word-processor

Z88 PipeDream

 

.txt

OZ

This is the easiest way of just using text. It ignores any formatting commands. Do not use columns, just do all the typing in Col A.

PipeDream

*.pd 

>

TAB File

Word-processor

PC PipeDream

 

.txt

DOS

This is the easiest way of just using text. It ignores any formatting commands. Do not use columns, just do all the typing in Col A.

PipeDream

*.pd 

>

WordStar

Word-processor

PTW

PC Link2

*.ws

DOS

 

 

 

 

 

 

 

 

 

 

 

PipeDream

*.pd 

>

Lotus 1-2-3

Spreadsheet

Fireworkz

 

*.wk1

Win 32bit

 

PipeDream

*.pd 

>

Lotus 1-2-3

Spreadsheet

PC PipeDream

 

*.wk1

DOS

 

PipeDream

*.pd 

>

Lotus 1-2-3

Spreadsheet

PTL

PC Link2

*.wk1

DOS

 

 

 

 

 

 

 

 

 

 

 

PipeDream

*.pd 

>

Comma

Database

PC PipeDream

 

*.csv

DOS

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

web analytics