VsiFax and filePro -- frustration!

John Esak john at valar.com
Sun Aug 29 23:16:15 PDT 2010


I know this is not close to the answer you want. But, I wrote a fairly
simple process to capture the output of the vsi command which sends the fax.
This number is used by the ongoign VSI logs to track whether a fax is
eventually successful or not.  I then attached the output of the logs
(filtered by this number to the appropriate customer/order record in
filePro, so anyone could press an @key and trace all the faxes and whether
they were successful or not.  It was just a matter of storing the value
returned by the fax spooler. To the appropriate  filePro record and
depositing it in a field.  When it became obvious that there were going to
be several faxes attached to that filePro record, I started storing the
retrieved spool/log ID's in a detail file attached to the order/customer
record.  This was not a lot of processing, just a few lines.

So, I am just responding to the thing you said about VSIFAX not keeping a
log of what happens to the faxes... It does.

John 
 

> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Steve Parker
> Sent: Saturday, August 28, 2010 12:44 AM
> To: filepro-list at lists.celestial.com
> Subject: VsiFax and filePro -- frustration!
> 
> Dear All,
> 
> I am finally at a point of total frustration trying to get VisFax to
> interface properly with a filePro "report" I need to process.
> 
> SCO Unix 6.0	Problem #1	I have not been able to install 
> the latest
> version of VsiFax. Unknown errors to their technical support, 
> so I finally
> have ignored it, as it is not that important. At least not at 
> this point,
> but who knows about later. LEAST of my problems right now. 
> Using version 6.0
> and not 6.1.
> 
> I simply want to be able to FAX monthly statements and be 
> able to track
> their success / failure through a log. (There are about 2000 
> +- sent each
> month.)
> 
> So we have a statement form that prints monthly and works 
> fine. So far, so
> good.
> 
> But there is only one way I've found that will send an entire 
> file by FAX,
> and that is by embedding codes through filePro that VsiFax 
> can interpret for
> FAX the number, etc. And one person suggested taking that 
> file and parsing
> it with a Unix shell script into separate files organized by 
> customer number
> and date (embedded in the "report" file for each customer, 
> copied out to the
> VsiFax auto-send directory and away they go.
> 
> But once done, there is no way to track what fails, as there 
> is not log file
> created by VsiFax using this process.
> 
> So I opted for an alternate method where a file is created on 
> the fly, a
> system command sends the FAX, another system command removes 
> the file and
> then the next customer is run. This method uses the -p 
> /path/filename on the
> menu's command line, and a careful sprinkling of the "PRINT" 
> command to
> create the file in question.
> 
> After I was all done, it worked -- except after the first FAX 
> was sent, the
> second, and every succeeding FAX, contains ^M (line feeds / carriage
> returns) at the TOP of the next record. I was told this was 
> because the Unix
> "spooler" was open and that there is no way around it.
> 
> And so approach #3 (or so) where I am NOT using a -P command 
> (or if I do, it
> is to a /path/junk file that is not used) but instead am 
> trying to use the
> "PRINTER FILE" command. Problem is that I cannot seem to 
> "assemble" a full
> document! Mostly what I get is just the END of the form, with 
> the totals and
> closing information from the sub-total lines, like "THANK YOU FOR YOUR
> BUSINESS" or "WE BUY USED CAT LITTER AT TOP DOLLAR" at the 
> very bottom.
> 
> I'm pretty sure the problem is that I don't entirely 
> understand how the
> PRINTER FILE command works, unlike the PRINT command that I 
> DO understand!
> If not, then this approach may not work at all.
> 
> The records are selected through a -v process.
> 
> The selected records are processed one by one through the 
> report, hitting an
> "end" statement at the end of each record. When the customer 
> number changes,
> a GOSUB statement sends the FAX. I've even gotten clever 
> enough that the
> file names are unique with the "customer number" { "-" { date (without
> slashes) so the failed FAXes can be easily tracked and 
> processed manually.
> 
> At this point I'm looking for some ideas. I'm pretty lost on 
> this right now,
> and pretty burned out as well!! LOL!
> 
> Any ideas? In particular, can anyone shed light on "block" #1 
> with the extra
> line feeds, or with "block" #2 some insight on the PRINTER 
> FILE command that
> will help me understand what I am doing wrong?
> 
> Thanks!
> 
> Steve Parker
> ABC Computing Services
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 



More information about the Filepro-list mailing list