Need to print a form from an import process using *report

[Don Coleman]

John:

I have an import process running from *report (fPv5.0.13RN9 on Windows 2000
Advanced Server & WIN2000 & WIN_XP clients) which runs every 8 minutes.  The
app. creating the fP data file takes between 2-4 minutes and my import takes
approx. 4 minutes to complete.  Throughout the day there are quite a few
records that are changed due to a change in the customer's order, operator
error etc.  These orders (prescriptions actually) are then cataloged via a
workflow application that I developed in fP and is ultimately sorted and
packaged automatically via conveyor.  I need the error log sheets to
facilitate the "pulling" of orders that have been changed by the operator
that have already been sorted/packaged.  I will then direct these "error
log" sheets to one of five laser printers situated around their
sorter/conveyor.  

My original plan (not well-thought-out) was to add a form command to my
import process and direct them to the appropriate printer around the sorter
via the PFPOSTPRINT command & Bob Rasmussen's Print Wizard program (Strongly
recommended!).  It occurred to me after the fact that the form command is
not available in *report.  I created a new fP file that I post the
appropriate data fields to, print the form from that file as part of the
batch import process, and delete the entries that have already been printed.
Of course, on the day I want to test it there are very few changes
occurring.  Two before lunch, none as of yet after lunch.  

It was either this method or do some type of ascii export and print function
as described by several contributors.  Any other suggestions are welcome.  

Don Coleman 

-----Original Message-----
From: John Esak [mailto:john at valar.com] 
Sent: Monday, November 28, 2005 1:34 PM
To: Don Coleman
Cc: Fplist (E-mail)
Subject: RE: Need to print a form from an import process using *report

Hi Don,
I saw all the answers... but I don't know how anyone could answer the
question you've posed... even Ken. At least, I didn't understand the exact
nature of what you need to do. Hopefully, one of the others did, and they
got a good anser to you. I see Ken and others have replied... but I haven't
read them yet. I'm curious to see what they all suggested. If none of them
hit the mark, try again and explain the situation differently a second time.
Maybe I won't be as dense 2nd time around. :-)

John


> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Don
> Coleman
> Sent: Monday, November 28, 2005 10:02 AM
> To: filePro List
> Subject: Need to print a form from an import process using *report
>
>
> List:
>
> I need to print an error log (form) from an import process
> (*report) to show
> any existing entries in a file which are being updated with new/modified
> information contained in the import file.
>
> I know I can't use "form" directly in the import.  Anyone have any
> innovative work arounds?  The only thing I came up with was to post the
> important fields to another file and then run form from there.  Any other
> suggestions?  TYIA.
>
> Don Coleman
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list