Exporting Revelation data to FoxPro (AREV Specific)
At 15 APR 1999 02:44:53PM Lilik Saputro wrote:
Hi,
My employer has been using an OLD software which was written in Revelation. The last software update was done in 1988. The company that wrote it went out of business years ago. My employer want to use a new system based on FoxPro database and I have been given the job to do the data convertion. Does anybody know if there is an ODBC driver that will let me access the Revelation database through FoxPro or is there another way to convert the data into FoxPro ? Thank you in Advance
Lilik Saputro
At 15 APR 1999 03:31PM Richard Wilson wrote:
if it is back in 1988 then I would guess is maybe Rev g2b and not
advanced revelation. there was a program called porter that will
create flat csv type files you may want to look for it.
let me know if you need more assistance
At 15 APR 1999 03:48PM Warren wrote:
Unless Bizsoft has ODBC drivers for Revelation there are none that I know of.
As Richard suggests, use the PORTER utility included on the F and G utilities disk.
Be aware that PORTER does not normalize multivalued data and data needs to be normalized for the one-to-many relationship files used by Foxpro. So you'll probably end up writing an export program from scratch.
At 15 APR 1999 06:43PM Bryan deSilva wrote:
Lilik:
You've gotten good advice here. If you need help converting multi-valued data (normalizing from typical Revelation data structures) let me know. It's what we do for a living .
Bryan