Unix migration to excel

[Brian K. White]

As Mark said, keyhale means the data is in a qualifier named "hale"
What to do about it?

If you were accessing this data from some other process table using 
lookups, you would add "@hale" to the "apvendm" file name.
if:
then: lookup apvendm at hale k=...

But in this case you're using a report/output process where there is no 
lookup command but just directly exporting the records you're standing 
on. So in this case you have to put yourself into that qualifier from 
the commandline before entering rreport, using either the PFQUAL 
environment variable, or the "-m" commandline flag to rreport.

So the simplest for you is
rreport apvendm -fp formname -m hale -u -a


You can also set PFQUAL in your environment before running "p" and 
browse around all the files and see if there are any other "hale" 
qualifier data.

$ export PFQUAL=hale
$ p

(now everything you see anywhere in filepro is only the hale qualifier)

You can also just scan the entire tree at once instead of guessing
# find . -type f -name 'key*' -a -! -name 'key'

That finds all key* files but filters out the ones that are just named 
"key" so you see only the extra qualifiers.
That way you can't miss any other files that may have a hale qualifier, 
or even other unsuspected qualifiers. Qualifiers can be used for all 
sorts of things and unless you wrote everything yourself, you have no 
idea how the programmer might have arranged things, so you make no 
assumptions and just scan every file for any possible non-default 
qualifiers.

-- 
bkw


On 4/8/22 14:53, jim--- via Filepro-list wrote:
>   
>
> I am an end user that has been using Filepro since late 90's. It is now time
> for me to move on and allow the next generation's opportunity to make a
> living at woodworking. So, sadly we are moving away from the tried-and-true
> Filepro.
>
>   
>
> I am assigned the task of migrating Filepro Unix files over to Microsoft
> excel files. I have written an export routine: export word filename =
> /upss/vend.csv -r=\n -f=,
>
> Assigning values to vend from a Filepro file output routine. I have success
> with this on all the files I have created over the years. In the Y2K craze I
> bought AP and GL software from BIT (Business Innovative Technologies). These
> files are elusive.
>
> In Define Files I have found the file "apvendm" holds the data I need to
> migrate. Problem is, there is nothing in this file / zero records. Digging
> into the Unix directory appl/filepro/apvendm I see a file called keyhale
> that appears to hold the records I am looking for. However, this file is not
> shown in the Filepro menu / Filepro Directory. I suspect it all has
> something to do with qualifiers (that I'm not familiar with) and cannot
> figure out a workaround to write out the file. Anybody care to volunteer
> some help to an old timer?
>
>   
>
> I hope I made myself clear.
>
>   
>
> Thank you,
>
>   
>
> Jim Benson
>
> Hale Manufacturing Company
>
> O 800.873.4253  F 315.894.5046
>
> halemfg.com
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20220408/54406703/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list