Unix migration to excel

[Jose Lerebours]

-m or -mq will do the trick ... to keep it interactive.

PFDATA may be set via menu script when using the application and 
possibly, said endpoint is not
known to normal fp menu

If he needs to have a full read on what/why/when/where, I would check 
the menus he uses to access the
file and see if it is setting environment variables prior to 
*clerk/*report.

I am betting that it may be simply using -m hale for that file!

It seems to me that he got it under control as far as what to do to dump 
the data, telling the code what
key/data segments to use was his issue.


On 4/8/22 7:53 PM, scott.walker--- via Filepro-list wrote:
> 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
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Jose Lerebours
954-559-7186
https://www.asisuites.com
Accounting - Retail - Wholesale - Distribution
Manufacturing - Warehousing - Transportation - eCommerce - Web Development
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fpgroups.vcf
Type: text/vcard
Size: 500 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20220408/c7ea217b/attachment.bin>