Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Conversions / January 2005

Tip: Looking for answers? Try searching our database.

Wordperfect .dat datafiles -convert to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian Hooker - 06 Jan 2005 15:16 GMT
A) I have over 100 big WordPerfect 10 mail lists that are in .dat files and
also many forms/labels that merge from those .dat files. I would like to get
with the 90's and convert these to Word datafiles and merge doc's. Is there
an easy/reliable way to do this?
B) It seems that WordPerfect handles the editing/adding/deleting of records
from those .dat files better, with like a form. Is there an equivalent ease
of use in Word?
C) Is the data best converted to Word or another Office program (eg Excel)?
D) All those mail merge forms in WP. Once data is in Word, can I convert
those WP > Word and then link the new Word data to them, or, will I have to
re-create everything (groan).

I read http://www.gmayor.com/convert_labels_into_mail_merge.htm, however,
the volume of work to do this with many lists would be huge.
Keith - 06 Jan 2005 20:00 GMT
>A) I have over 100 big WordPerfect 10 mail lists that are in .dat files and
>also many forms/labels that merge from those .dat files. I would like to get
>with the 90's and convert these to Word datafiles and merge doc's. Is there
>an easy/reliable way to do this?

The WP DAT files separate each record with a Hard Page. A Word "DAT"
file is essentially a table. One way of converting a WP DAT file to a
Word format is (from WP) to merge your data into a WP table and then
save it as a Word file. The try a merge from within Word and when Word
asks for the data file, point it in the right direction. Word will then
recognise that file as a data file.

>B) It seems that WordPerfect handles the editing/adding/deleting of records
>from those .dat files better, with like a form. Is there an equivalent ease
>of use in Word?

Word has a similar edit window (once it recognises the file as being a
data file).

>C) Is the data best converted to Word or another Office program (eg Excel)?

Depending on the size of your databases I would consider using a proper
database (for example, Access). You would then be in a better position
to administer your data (validating data input, removing duplication,
etc). This would have the additional benefit of it being accessible to
both wordprocessors (see D below)

>D) All those mail merge forms in WP. Once data is in Word, can I convert
>those WP > Word and then link the new Word data to them, or, will I have to
>re-create everything (groan).

Get ready for more groaning. Word forms will need to be redone :-( I've never tried running a WP merge from a Word data file so can't help.

>I read http://www.gmayor.com/convert_labels_into_mail_merge.htm, however,
>the volume of work to do this with many lists would be huge.
Charles Kenyon - 10 Jan 2005 22:44 GMT
See Graham Mayor's site on creating merge data files from other files.
Essentially you generate labels with your data in Word Perfect and then
convert that using -
http://www.gmayor.com/convert_labels_into_mail_merge.htm
It can be done but it involves a lot of hand work I believe.

The merge docs themselves should be recreated, possibly building from text
files. See below:

Here is some general info on moving from Word Perfect to Word:

Word and Word Perfect work very differently from one another. Each program's
methods have strengths and weaknesses; but, if you try to use one of these
programs as if it were the other, it is like pushing on a string! You can
easily make a lot of extra work for yourself. If you are unwilling to take
the time to learn to use Word's methods, you should stick to using Word Pad.
You'll have a lot less grief, although you'll miss out on a lot of raw
power.

See http://www.addbalance.com/word/wordperfect.htm
http://www.mvps.org/word/FAQs/General/WordVsWordPerfect.htm
http://www.mvps.org/word/FAQs/General/TipsAndGotchas.htm
http://www.mvps.org/word/FAQs/General/RevealCodes.htm
http://www.mvps.org/word/FAQs/General/WordPerfectConverters.htm
http://businesssoft.about.com/compute/businesssoft/library/blconvert.htm
for information on Word for Word Perfect users.

For more:
http://www.mvps.org/word/FAQs/Customization/CreateATemplatePart2.htm
http://www.mvps.org/word/FAQs/Customization/CreateATemplatePart1.htm
http://www.addbalance.com/usersguide/templates.htm
http://www.mvps.org/word/FAQs/Numbering/WordsNumberingExplained.htm
http://www.addbalance.com/usersguide/styles.htm
http://www.mvps.org/word/FAQs/Customization/WhatTemplatesStore.htm

Function Keys

In Word 2000 (or later) You can get the function keys to display in a
special toolbar at the bottom of the screen if you want (something like
pressing F3 twice in WP). The following macro will do this.
Sub ShowMeFunctionKeys()
   Commandbars("Function Key Display").Visible = True
End Sub

Word's Extend key (F8) gives something similar to block processing.

Formatting and Styles

Learn about Styles - really learn!
http://www.addbalance.com/usersguide/styles.htm I resisted for years and now
regret every day of those years because although that string was still very
hard to push, it kept getting longer and longer, and had some very important
projects tied to it! Once you understand styles and the Word concept of
organizing things into Chinese boxes everything falls into place and instead
of pushing a string, you can push a button that turns on the very powerful
text processing machine known as Microsoft Word and it will start doing your
work for you instead of running around behind you trying to undo what you
just thought you did.

Converting documents Word / Word Perfect

Some special characters in Word Perfect documents don't convert well to
Word. There is a macro to assist with this described at
http://www.columbia.edu/~em36/wpdos/wptoword.html#macroword and can be found
at http://www.columbia.edu/~em36/wpdos/WPSymbolConv.bas.
This was prepared by Edward Mendelson.
Otherwise, look at the macro from http://support.microsoft.com/?kbid=212396
Use these on _copies_!

As for converting documents from Word Perfect to _use_ in Word... In a word,
don't plan on it. I would not recommend using converted documents long-term.
They will be filled with formatting anomolies that will get you at the worst
time. This is especially true of any documents containing automatic
numbering or bullets. Try recreating form documents in Word using the
following process:
In Word Perfect (if you still have it, in Word if not) save your files as
text files.
Use your converted files as references to show you how you want your
formatting to look.
Create a new document in Word and insert the text from the text file. Save
this new document as a Word template. Format it the way you want using
styles, not direct formatting. Save it again.
To use a template within Word, use File => New and pick your template. This
will create a new document for you.

Merge documents have special problems and should be recreated from text
files or retyped in Word. To convert data files, consider generating labels
in WP as a document, converting that to Word, and then using
http://www.gmayor.com/convert_labels_into_mail_merge.htm to get a new Word
data file.

Note that conversions usually do create documents that look passable and
print OK; the problems I'm referring to have to do with editing / making
changes, that is, using the documents long-term. (See below on reusing
documents vs. using templates.)

Conversion back to Word Perfect: There is a problem (in addition to the ones
mentioned for conversion _to_ Word) with Version 2002 (XP) and later of
Word. The conversion file only works for conversion _to_ Word, not from Word
to Word Perfect! Earlier versions went both ways. To fix this, you need to
find the old conversion file WPFT532.CNV from a Word 97 or Word 2000
installation and copy it to your new installation, replacing the file of the
same name. Note, the change making the file one-way was done as a security
measure. While I don't know of any problems the old file causes, keep the
new installation's file somewhere as a backup just in case.

Boilerplate and Forms

In WP a lot of people use macros to hold chunks of text - boilerplate. In
Word this function is filled by Templates, AutoText and AutoCorrect, not
macros. Follow the links at
http://addbalance.com/word/wordwebresources.htm#AutoText for more
information on these tools.

You can use FILLIN and ASK fields or UserForms to query the user. For some
form documents, Word's "online forms" work very well. For more about online
forms, follow the links at
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles.

Reusing Documents vs. Using templates

General practice in WP is to have a document and copy and edit it to create
a new document. This is not good practice in Word. In Word, construct a
good, tight, template for your documents and use that template when
constructing new documents. Among other things, this can avoid embarrassing
"metadata" (http://www.addbalance.com/usersguide/metadata.htm) and things
like surprise headers and footers from creeping into new documents.

It's a lot of reading, I know. It's OK to chunk it down and do a bit each
day, but I would recommend that you make it a top priority to do that bit
each day. In the (short) long run, it will save you both time and grief.
Signature


Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> A) I have over 100 big WordPerfect 10 mail lists that are in .dat files
> and also many forms/labels that merge from those .dat files. I would like
[quoted text clipped - 11 lines]
> I read http://www.gmayor.com/convert_labels_into_mail_merge.htm, however,
> the volume of work to do this with many lists would be huge.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.