I convert people from ThroroughBred at least once a quarter... For a fact, the easiest method is to get them to either send reports to text files, or get a programmer to write a simple dump file...
In my case, I have them write the data into a dump file delimitted by 'Pipes' (|), a record per line ... I convert the line breaks to attributes (254) and the pipes to values (253), then TRIM the whole thing since they are all fixed-length fields... I then run a loop to REMOVE a record and parse and import... Works pretty fast - I can import the data WAY faster than their processes can export the files. I guess I've done 6 or 8 or so of these conversions, but have always has someone who knew the data on their Thoroughbred side, as the files I work with are **really bad** as far as data integrity, but that's more about the application than about Thoroughbred!! (And a reason we get them as customers! <g>) If you know UniBasic, you can slog your way through BusinessBasic - Myself, I learned about programming from MAI Basic/IV - the people that gave us BusinessBasic! I think Thoroughbred actually has variable names that are not I0$ and A2$ like when I worked with BB4. Once you get used to the file and printer 'channels', it's not that different to work with. David W. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, January 26, 2005 2:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] ThoroughBred to U2 file conversion Hi guys: I am looking at dumping data held in a ThoroughBred system, which I understand uses its own ISAM/B-Tree file access methods, to delimited flat ascii so that I can then upload onto a U2 database (Universe 10 under AIX 5.2) Does anyone know of software which will do this or is there anyone out there who has done it and could point us in the right direction ? Bob Witney Senior Sage & Seer EXPLORE! 1 Frederick Street Aldershot, Hampshire GU11 1LQ, UK Tel: 01252-760329 Fax: 01252 760001 www.explore.co.uk ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
