Will pay for your advice
Destin Richter
I need to convert a WordPerfect secondary file into a database format
such as .DBF, .SDF, or .DLM.
Please contact me if you can help. I will pay you for info that works.
Destin Richter
ric...@newmexico.com
Jack Linder
1. Use WP to retrieve the secondary file.
2. Set the paper size/font size for real wide paper and very small fonts.
(This will keep lines from word wrapping
3. Save it as a DOS text file (CTRL-F5).
4. Use the macro features of WP to edit it to give you one record per line,
with commas between the fields.
5. Use the FP IMPORT command to inport the DOS file.
Jack Linder
jack....@turner.com
kco...@boeing.hq.nasa.gov
In article <3ngqtj$q...@tierra.santafe.edu>, <ric...@newmexico.com> writes:
> Path:
centauri.hq.nasa.gov!newsfeed.gsfc.nasa.gov!ames!haven.umd.edu!purdue!lerc.nasa.gov!magnu
s.acs.ohio-state.edu!math.ohio-state.edu!uwm.edu!fnnews.fnal.gov!nntp-server.caltech.edu!
ferrari.mst6.lanl.gov!tesuque.cs.sandia.gov!lynx.unm.edu!SantaFe!usenet
> From: ric...@newmexico.com (Destin Richter)
> Newsgroups: comp.databases.xbase.fox
> Subject: Will pay for your advice
> Date: 24 Apr 1995 18:33:23 GMT
> Organization: The Santa Fe Institute
> Lines: 9
> Message-ID: <3ngqtj$q...@tierra.santafe.edu>
> NNTP-Posting-Host: dial131.roadrunner.com
> X-Newsreader: WinVN 0.92.6+
>
> Greetings:
>
> I need to convert a WordPerfect secondary file into a database format
> such as .DBF, .SDF, or .DLM.
>
> Please contact me if you can help. I will pay you for info that works.
>
> Destin Richter
> ric...@newmexico.com
Destin,
Try making the Word Perfect file an ASCII Text file. In foxpro, create a
database with one memo field. Type "APPEND BLANK". Type "APPEND MEMO <memofield name>
FROM <ascii text file name>". This will bring your document into the field. Make sure
that you include the path where your ascii text file is.
Another suggestion. Make the Word Perfect file an ASCII Text file. In foxpro,
type "MODI COMM" <ascii text file name>. Highlight the whole text file, copy it using
the "CTRL-C" key combination. Create a database with at least one memo field. Type
"APPEND BLANK". Open up the memo field by typing "CTRL-HOME" key combination. Then type
"CTRL-V" combination to paste your document. Type "CTRL-W" to save.
I hope this is what you are looking for.
Kelly Conboy
Stan Varlamov
: Greetings:
: I need to convert a WordPerfect secondary file into a database format
: such as .DBF, .SDF, or .DLM.
You can also convert a WP file into a text file (as first step for DBF
conversion) right in a FoxPro program. A WP file has special flexible
size header. Some bites contain the header size (call WP to find out what
bites). All you have to do is eliminate the header and suppress special WP
print control characters inside the file (by analyzing ASCII codes). Note
also, that "-" has a different ASCII code in WP. In order to perform all
that use FoxPro functions FOPEN, FCREATE, ASC, FREAD, etc. I have a
program doing this written a couple of years ago.
Stan.
--
s...@netcom.com
Terrence Blair
is used with GENSCRNX, and adds 3D-like features to forms. I would
appreciate any help. Thanks.
Terrence Blair
Bethesda, MD
Shar Feldheim
3rd Party Library, #10[Ithink]
dand...@umassd.edu
I got it at the following site:
ftp.hop.man.ac.uk/sys/ftp/foxpro/
That is also a web site if you add the http:// and remove the ftp.
from the beginning. My remaining list of FoxPro ftp sites follows:
SITE: lenti.med.umn.edu
IP ADDRESS: 128.101.81.1
DIRECTORY: /pub/foxpro
INDEX: /pub/foxpro/index
ADMIN: Gerald Skerbitz <gs...@lenti.med.umn.edu>
SITE:nstn.ns.ca
IP ADDRESS: 137.186.128.11
DIRECTORY: /pub/pc-stuff/foxpro
INDEX: not available at this time
ADMIN: Paul Russell <rus...@atl.sofkin.ca>
SITE: ftp.microsoft.com
IP ADDRESS: 198.105.232.1
DIRECTORY: developer/devtools/fox
INDEX: index.txt in each subdirectory
ADMIN: <csf...@microsoft.com>
SITE: mercurio.univr.it (mirrors nstn, lenti, and rahul sites)
IP ADDRESS: 157.27.1.2
DIRECTORY: pub/msdos/foxpro
INDEX: pub/msdos/foxpro/00
INDEX pub/msdos/foxpro/index.txt
ADMIN: Germano Rossi <ger...@chiostro.univr.it>
This info was gleaned from a site somewhere, but I don't remember
who to credit for compiling it. However, I can say that the sites
exist. I have visited them.
Try the web site, it's cool! :)
Dana
Keith Trangmar
past which can *CREATE* wordpervert secondary files, so the reverse
should be true: Each field is separated by CHR(5)+CHR(10), and
end-of-record markers are CHR(18)+chr(10), so the following should work:
InFileHandle=fopen(InFileName)
OutFileHandle=fcreate(OutFileName)
do while !feof(InFileHandle)
m.junk=fread(InFileHandle,1024) && read it in chunks of 1K
m.junk=strtran(m.junk,chr(5)+chr(10),chr(9))
&& convert end-of-field markers to tabs
m.junk=strtran(m.junk,chr(18)+chr(10),chr(13)+chr(10))
&& convert end-of-line markers to CR/LF
=fwrite(OutFileHandle,m.junk)
enddo
=fclose(InFileHandle)
=fclose(OutFileHandle)
This will create a text file delimited with tabs, which you can then read
into your table with APPEND FROM (OutFileName) DELI WITH TAB.
Hope this helps!
Keith Trangmar, Harlend Computer Services
Dartford, Kent. UK.
ktra...@cix.compulink.co.uk
"Can't think of anything witty to put at the end of my sig"
John R. Gammon
I think its on there.
Terrence Blair
displayed on the button according to the data in the record. E.g. I
want it to display the contents of the first name field and to change
as the user moves throughout the database records. I'm sure that this
can be done with a screen directive in GENSCRNX or regular GENSCRN, but
I don't know how? I'd appreciate any suggestions. Thanks.
Terrence Blair
Information Management Consortium
Bethesda, MD
301.419.8158
john sayre
I know you would have to inclus .dbf, .cdx, the .exe, but do you need
to include the .mnx,.pjt,.spx.,.sct?
Thanks,
John
Paul Klose
No, no, no, and no. Anything that is in the project file will be
incorporated in the .EXE unless specfically excluded. The files you
listed are for developers only and are not included in the project
(FXPs, MPXs, SPXs and FRXs are). Anything that is read-only (including
any read-only DBFs and CDXs) should be included in the project.
Additional files on the distribution disk are any other file that might
be updated during program execution (perhaps VUE or MEM files, for
example). I use FOXTOOLS.FLL and other DLLs and distribute these files
as well.
Sincerely,
Paul Klose
Brian Copeland
T>I am trying to put a push button on a form and to change the text
T>displayed on the button according to the data in the record. E.g. I
T>want it to display the contents of the first name field and to change
T>as the user moves throughout the database records. I'm sure that this
T>can be done with a screen directive in GENSCRNX or regular GENSCRN,
T>but I don't know how? I'd appreciate any suggestions. Thanks.
T>Terrence Blair
T>Information Management Consortium
T>Bethesda, MD
T>301.419.8158
It can be done with in the screen builder if you are using the btn_val
and refresh procedures generated by the screen wizard or you own
equivalents.
Define the push button in the normal manner, making sure the prompt that
you enter is as wide as the field to be shown.
From the menu select 'Screen' then 'Screen Layout'.
Select 'Cleanup & Procs.'
Insert the following as the last line in the 'btn_val' procedure just
before the return statment and as the first line in the 'refresh'
procedure.
SHOW GETS xx,1 PROMPT yyy
Where xx is the name of the variable for the push button and yyy is the
name of the memvar or field that is to be displayed (in your case the
name of the first name field or the memvar associated with it).
Brian Copeland
Brian.C...@canrem.com
Andrew Hodson
says...
>
>What file types have to be included on a distribution disk?
>I know you would have to inclus .dbf, .cdx, the .exe, but do you need
>to include the .mnx,.pjt,.spx.,.sct?
>
>Thanks,
>John
Nope
.DBF, .CDX , .IDX, .EXE should do fine
Andrew
Guich Bob
need the Foxuser.FPT & Foxuser.dbf files!!