Export problem

Joe Chasan joe at magnatechonline.com
Thu Feb 8 09:08:18 PST 2007


On Thu, Feb 08, 2007 at 08:38:36AM -0800, Jeff Harrison wrote:
> 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.

-fp came in 4.8
 
> 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.

as for doing it in clerk
@once came in 5.0 for clerk
@menu came in 4.1

however - if you added a screen with no user-accessible fields
called "noupdate_jeff" (or some ridiculous name that fits within
4.0 naming limits - which may be 8 chars, not sure), and called
the file with -xa (add records mode) on that screen, i suppose you 
could do all processing in the one table (called with -z your-table-name
as input table, -y !!! to override possible automatic) as if user 
pressed <Esc><Esc> then delete the record you added and exit so runs 
only once.

my only concern is that at one point i think filePro had import/export
limited to either input or output prc tables - this goes back a long
time (but so does v4.0!), and i'm not sure which one it was or which
version it was changed in.
 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264


More information about the Filepro-list mailing list