Newbie Question

Walter Vaughan wvaughan at steelerubber.com
Thu Jan 8 10:11:50 PST 2015


Two ways
	1) create a "selectcak" processing table like this (append "-v
selectcak" to your command line)
		If	ft ne "T"
		Then	ft(1,,g)="T"; input cv(8,*,g) "Enter CAK value"
		If 	42 eq cv
		Then 	select;end
	(In the above example I have assumed that the field 42 is the field
you want select upon)

	2) brute force re/write your sel.cakSelection1 (it's clear text).
Not recommended however.

-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com]
On Behalf Of CKelly at affiliatedtrans.com
Sent: Thursday, January 08, 2015 12:15 PM
To: dan at onlinemgt.com
Cc: filepro-list at lists.celestial.com
Subject: RE: Newbie Question

But how would I go about having the value be dynamic? 

/u/appl/filepro/vregstr> /u/appl/fp/dreport vregstr -f CAK_Data1 -u -p
/tmp/Anzio_Shipment_Mapping -pc "nocodes" -s cakSelection1

This works with a saved selection but I want the value I am looking for to
be dynamic

-----Original Message-----
From: onlinemgt at gmail.com [mailto:onlinemgt at gmail.com] On Behalf Of daN
baueR
Sent: Thursday, January 08, 2015 11:07 AM
To: Christopher Kelly
Cc: filePro Mail Group
Subject: Re: Newbie Question

On Thu, Jan 8, 2015 at 11:01 AM,  <CKelly at affiliatedtrans.com> wrote:
> I recently started at a company utilizing FilePro.
>
> I am able to export ALL records without issue using a command as follows.
>
> /u/appl/fp/rreport vregstr -f CAK_Data1 -a -u -p /tmp/cak_output -pc
"nocodes"
>
> But I would like to limit the results based on a dynamic selection Field
60 eq "ReadyToProcess"
>
> I can do this via the request output application via a selector sentence
but how can I do it via script?
>
>
>
> Christopher A. Kelly   |   IT Development / Administration   |
Affiliated Transportation Systems, Inc.   |
ckelly at affiliatedtrans.com<mailto:ckelly at affiliatedtrans.com>   |
888.668.2874 x102
>
>

The easiest way (in my opinion) would be to create and name a selection set.
Depending on what you're looking for in field 60.
Something like:

60 eq Y

Save that with a name of 'vregstr' for instance and then your script line
would just have to change to:

/u/appl/fp/rreport vregstr -f CAK_Data1 -s vregstr -u -p /tmp/cak_output -pc
"nocodes"

I suggest using the same name for the selection set to remind you at a later
date that it's associated with a specific report.

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



More information about the Filepro-list mailing list