progress to filepro

[Bill Campbell]

On Fri, Feb 18, 2011, Enrique Arredondo wrote:
>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 ?

It would be fairly simple to write a python or perl script that
reads these files and creates appropriate map files for FilePro.

Converting data is a bit more complicated as the FilePro key
files are basically fixed length records with no line terminating
characters with a 20 byte header containing FP specific info
about the record.  Once upon a time, I knew what this was, but
it's been many years since I played with this directly.  I'm sure
I have source code around that has it so could figure it out.  It
would probably be easier to import from tab-delimited ascii files.

Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

Government is a broker in pillage, and every election is a sort of advance
auction in stolen goods. -- H.L. Mencken