progress to filepro

[Jeff Harrison]

----- Original Message ----

> From: Enrique Arredondo <henry at vegena.net>
> To: filepro-list at lists.celestial.com
> Sent: Fri, February 18, 2011 10:32:16 AM
> Subject: progress to filepro
> 
> Hi
> 
> I'm trying to move all databases from a system that's using Progress  and I 
> dumped the databases and when I tried to dump the file definitions  using 
> the data administration tool from progress that it can generate a  field 
> creation file so I was wondering if filepro can read that file some  way 
> and create the file definitions, here's a snippet of the  file:
> 
> ADD FIELD "chg-num" OF "ex-end" AS integer ^M
>    FORMAT  "zzzzz"^M
>    INITIAL "0"^M
>    LABEL "Ending Chg  Number"^M
>    POSITION 212^M
>    SQL-WIDTH 4^M
>    HELP  "Enter the last PO Change Order to consider."^M
>    ORDER  2150^M
> 
> 
> Is there kind of converter that will make the files in filepro  or am I out 
> of luck and have to manually add all the fields on filepro  ?
> 
> Thanks

I am not aware of anything that does this.  It should be possible to write a 
utility for this in filepro though.  The first step in creating the file in 
filepro would be to create a valid map.  I would create a "blank" map by calling 
ddefine and redirecting the appropriate keystrokes to it.  Then, using scripting 
(or filepro's file IO ) update the map, adding the appropriate line for each 
field.  Make sure you keep the password and checksum characters intact on the 
first map line.  Also, make sure you adjust the #characters in the key/data and 
# fields in the key in the map header appropriately.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport