[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Import/Export tool needed (AREV Specific) ====
=== At 12 JAN 2000 02:46:01PM Morris Horton wrote: ===
{{tag>"AREV Specific"}}
I am new to AREV and am looking for some helpful hints...i have some .ov files that were generated by an AREV application....I need to dump the raw data contained within the .ov files to ascii text files...are there any products/tools available which can import/export AREV .ov files?
thx in advance,
MH
----
=== At 12 JAN 2000 02:53PM www.bizsoft.com wrote: ===
----
=== At 12 JAN 2000 03:25PM M. Horton wrote: ===
all i find at www.bizsoft.com is information on an InstallShield SDK...please advise.
MH
----
=== At 12 JAN 2000 04:14PM Claude Mansutti wrote: ===
Arev Comes withits own import/export routines. They are not perfect, but they work... sort of. If you are new to Arev I suggest you play with this section first.
Alternatively you can code something like:
Perform "PDisk AsciiFilename"
loop
Read each row of the table
convert @fm to , in the row
convert @vm to ?whatever in the row
Print the row
repeat
Perform "PDisk Prn"
I hope this helps
Claude
----
=== At 12 JAN 2000 04:38PM Victor Engel wrote: ===
The *.lk and *.ov files work together. In fact, the extension "ov" is short for "overflow", namely data that overflowed from the lk file. What you need to do is not to worry about the DOS filenames at all. Use the tools available in the application. For example, there are export utilities for Lotus 123, Dbase, and ASCII formats. You can also direct printer output to a file using the PDISK command.
----
=== At 12 JAN 2000 04:39PM M. Horton wrote: ===
thx for the suggestion Claude.
As a "hands-on" programmer, i'd really like to learn AREV, but i do not have the AREV development environment available to me....All i have are some .ov and .lk files which were created by an application which was built using AREV.....i hope this explains why i don't have my nose buried in an AREV programmers guide....if i could, i would.
MH
----
=== At 12 JAN 2000 04:58PM Jocelyn Amon wrote: ===
Our company, Financial Solutions Limited, markets a utility that will export Revelation data to ASCII format. It is easy to use but some knowledge of Revelation is required.
Alternatively, we provide a data export service. Please email me for our current rate for this.
email: finsol@ts.co.nz
Jocelyn Amon
----
=== At 12 JAN 2000 07:52PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote: ===
Hmm potential problem looming, AREV uses denormalised (1NF) data structures and so exporting is not always a piece of cake. In all honesty we believe you're better off getting someone to do it for you. Plenty of consultants available - check the Developers section of this site.
[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 13 JAN 2000 12:54PM Claude Mansutti wrote: ===
Have to agree with Andrew & Co at Sprezzatura.
If they are complex/involved, you may have to put the files in the hands of one the clever people on this forum. Unfortunately it may mean spending $$$$ or ££££ etc.
Claude
----
=== At 17 JAN 2000 03:23PM Richard Hunt wrote: ===
It is highly probable that each "file" you have, will be very unique when it comes to ASCII exporting. I suggest this...
Find someone that has the development version of AREV. Make copies of these files and let them ASCII export them. You will definately save lots of money and time, paying another person to do it for ya.
I strongly suggest you not attempt this on your own. "Linear hashed" files are very very complicated. Without the development version of AREV it will be very very very difficult.
These REV00000.LK and REV00000.OV data files also come with dictionary files too. the dictionary files hold the layout of the data file along with the conversion codes. They might be very useful!!!
I find it very easy to export ASCII files. So I am sure you can find someone to get the job done for you.
----
=== At 21 JAN 2000 06:18AM Peter Gorski - Polmax Poland wrote: ===
I HAVE FULL VERSION OF 2.12 ADV REV
BUT DICTIONARY IMPORT.EXPORT FILE IS MISSING
CAN SOMEBODY SEND THIS FILE TO ME VIA E-MAIL
polmax@polmax.com.pl
ITS VERY URGENT
----
=== At 07 MAR 2000 09:54PM Chris Leenhouts wrote: ===
There is a new utility called xPort at http://exorsys.com/revelation.htm which resolves all the technical and conceptual problems asssociated with Revelation database exports.
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=BD6B3A39588934C285256864006C95A3|View this thread on the forum...]]