Unix migration to excel

[scott.walker at ramsystemscorp.com]

To be used with Mark's info.....perhaps if you set 

PFQUAL="hale";export PFQUAL

Then go into fp and see if it finds your data.

Regards,
Scott


-----Original Message-----
From: Filepro-list
<filepro-list-bounces+scott.walker=ramsystemscorp.com at lists.celestial.com>
On Behalf Of Fairlight via Filepro-list
Sent: Friday, April 8, 2022 5:29 PM
To: filepro-list at lists.celestial.com
Subject: Re: Unix migration to excel

If it's 'keyhale' then the qualifier is 'hale'.

m->

On Fri, Apr 08, 2022 at 02:53:25PM -0400, jim--- via Filepro-list thus
spoke:
>  
> 
> 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/20220
> 408/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
> 

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