I know nothing about ThoroughBred, so I'm talking in general. I've done a couple of conversions from some relics and picked up this little trick.
The Monarch method works great for any conversion, but if you know nothing about the system and/or it's database and the reports provide enough data to do the conversion. Setup a Laptop/PC as a printer and use a terminal emulation package to capture the output to a file. Then use Monarch to map and covert the data. Rather clumsy way of doing it but it works and needs no knowledge of the database you are converting from. The only requirement is that the existing system can produce reports. ---------------------------------------------------------- Vance Forste (Senior Programmer/Analyst) Caligor Hospital Supply a division of Henry Schein Inc. ----- Original Message ----- From: "Richard Taylor" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Wednesday, January 26, 2005 9:50 AM Subject: RE: [U2] ThoroughBred to U2 file conversion > Wow, I have not heard that name in a while. > > I had to convert a client off ThoroughBred to a Universe base ERP system > many years ago. We never did find a good, direct export function. > Instead we printed reports to text files then used a product called > Monarch to map these files and covert the data to a format we could import > into U2. A bit tedious yes, but it worked fairly well. > > Rich Taylor | Senior Programmer/Analyst| VERTIS > 250 W. Pratt Street | Baltimore, MD 21201 > P 410.361.8688 | F 410.528.0319 > [EMAIL PROTECTED] | http://www.vertisinc.com > > Vertis is the premier provider of targeted advertising, media, and > marketing services that drive consumers to marketers more effectively. > > "The more they complicate the plumbing > the easier it is to stop up the drain" > > - Montgomery Scott NCC-1701 > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney > Sent: Wednesday, January 26, 2005 3: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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
