Export problem

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
elestial.com] On Behalf Of Jeff Harrison
> Sent: Thursday, February 08, 2007 11:39 AM
> To: filepro-list at seaslug.org
> Subject: Export problem
> 
> Hello all.  I'm trying to generate some export processing 
> tables for a customer that has filepro 4.0.X on a SCO Unix 
> system.  I'm running into a few problems - One main issue is 
> that I don't have access to their system - I was given a copy 
> of their maps only, and I have set up a test working area on 
> a local system that has a working copy of these that I can 
> mess around with.  
> 
> Now, I'm pretty sure I can generate acceptable processing 
> tables that will run on 4.0, but I believe that 4.0 will 
> require an output format to exist before I can run them 
> right?  Nowadays I always use the -fp flag to do such things 
> so I don't need to create the blank output format.  I don't 
> think 4.0 had that available did it?  This is an issue 
> because I may need to generate processing for 100s of different files.
> 
> I thought of doing this in clerk with a lookup - instead of 
> as a report, but I would guess that I can't count on there 
> always being an index set up for the lookup, and for a record 
> # lookup I would probably be limited - I'm not sure how 4.0 
> would behave with a lookup next on a dash lookup.  
> 
> Any thoughts would be appreciated.  Thanks.
> 
> Jeff Harrison
> jeffaharrison at yahoo.com
> 
> Author of JHExport and JHImport.  The fastest and easiest 
> ways to export and import filepro data.

A few things:

The following have been available since at least 3.0 or earlier:

Export - will create your export file
Getnext/getprev
-v sort/select


Without knowing what type of files you need to create, it may be difficult
to tell you how to proceed.

You might consider creating a file with file & output name and then use IUA
in that file to select the format wanted, get any selection criteria for
that output and pass the values using the -r option using system to run the
output. You will need to hash @pm for the selection criteria in a selection
process called using -v.

One could also add a brief description of the output to the screen in this
file so that the correct file is generated.

Richard Kreiss
GCC Consulting