RE: Converting FileMaker Pro 4.1 files from Mac to AS/400

I have converted comma delimited filemaker pro files and had to write a few
programs to go through the data and parse it out.  Part of the problem was a
few "free" form fields that people just keyed in anything they wanted which
included special characters and a host of other things.  I tried a bunch of
different ways to get the incoming data to look consistent but in the long
run I ended up creating a flag field in the existing data (byte 1) that I
set if I just couldn't figure the data out and had the users manually key
the correct information via green screen.  If you want I could give you the
programs I used...

Dave Miller
www.virtual400.com
Your Virtual 400 Service Provider

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Rob Dixon
> Sent: Wednesday, July 26, 2000 5:00 AM
> To: midrange-l@midrange.com
> Subject: Converting FileMaker Pro 4.1 files from Mac to AS/400
>
>
> I have been asked to convert some FileMaker Pro 4.1 files from a Mac to
> an AS/400 with V3R7.  The largest file has about over 22,000 records
> and, I am told,  took 15 days !!! to convert to a Tab delimited file on
> a Mac G3.  I now have these on my Windows 95 PC.
>
> I have had a quick look at the first few records and they are a total
> mess.  I have seen some very bad database designs over the years but
> this has to be the worst.
>
> Has anyone any experience of converting FileMaker Pro files to the
> AS/400?  What would be the best way of transferring them to the AS/400?
> Any other tips, suggestions?
>
> Any help would be gratefully received.
>
> Rob Dixon
>
> ________________________________________________________
>
> Erros plc
>
> 44 (0) 1844 239 339
>
> http://www.erros.co.uk/ERROSHOME/erros_home.htm - The AS/400 Neural
> Database for the Internet
>
> _________________________________________________________
>
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---