Unix migration to excel

[jim at halemfg.com]

Brian,
This worked!
Using the Filepro menu to drive the transfer I typed in:  rreport apvendm -fp formname -m hale -u -a and I'm off and running!

You guys are great - saved a ton of typing. I owe you a beer.
��


Jim Benson
Hale Manufacturing Company
O 800.873.4253  F 315.894.5046
halemfg.com

-----Original Message-----
From: Filepro-list <filepro-list-bounces+jim=halebookcases.com at lists.celestial.com> On Behalf Of Brian K. White via Filepro-list
Sent: Friday, April 8, 2022 9:03 PM
To: filepro-list at lists.celestial.com
Subject: Re: Unix migration to excel


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

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list