Exporting AREV data (AREV Specific) [Revelation On-Line Wiki]

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

At 13 JUL 1999 01:50:33PM Alan Watson wrote:

AREV Specific

Hi all,

Im a newbie to AREV. I have a client using AREV 2.1. I would like to export the data. Not having a lot of luck. Can anyone suggest any third party utilities, books or just advice in general.

Thanks in advance for any help.

Alan

At 13 JUL 1999 02:50PM Warren wrote:

If you don't have multivalued data or normalization of MV'd data is not required, the ASCII export utility from the Utilities menu should suffice.

Writing a quick and dirty ASCII export program doesn't require a great deal of effort: Read the RBasic manual on OSOPEN, OSCLOSE, OSREAD, OSWRITE, OSBREAD, and OSBWRITE.

You'd just have to nest loops to handle the MV data to write child records.

At 14 JUL 1999 09:20AM dsig@teleport.com wrote:

As Warren mentioned, if your data is not multivalued you can use the ascii export that comes with Arev.

You can optionally write your own something like

EQU TRUE$ TO 1

EQU FALSE$ TO 0

EQU TAB$ TO CHAR(9)

EQU CRLF$ TO CHAR(13):CHAR(10)

OPEN "","AREVFILE" TO AREVHANDLE THEN

you can only open a file that exists

if it doesn't exist write out blank file

you probably want to do this to start fresh ..
   OSOPEN "DOSEXPORTFILE" TO DOSHANDLE ELSE
        OSWRITE "" ON "DOSEXPORTFILE"
        OSOPEN "DOSEXPORTFILE" TO DOSHANDLE ELSE STOP
   END
   CURDOSPNTR=0     
   EOF=0       ;* END OF FILE FLAG
   SELECT AREVHANDLE
   LOOP
        READNEXT AREVID ELSE EOF=1
   UNTIL EOF DO
        READ REC FROM AREVHANDLE, AREVID THEN
             CONVERT @FM TO TAB$ IN REC     ;* FLDS TO TABS
             REC := CRLF$                   ;* DOS REC DELIM
             OSBWRITE REC ON DOSHANDLE AT CURDOSPNTR
             CURDOSPNTR += LEN(REC)
        END
   REPEAT
END

Now this is a very simple export .. exports all records and all fields to a tab delimited file. IF you have multivalued data you need to extract those fields separately(sp?) to create normalized data.

If you have more questions .. ask here or email me and I will help get your data out.

dsig@teleport.com onmouseover=window.status=imagine … ;return(true)"

David Tod Sigafoos ~ SigSolutions

Cell: 503-341-2983

dsig@teleport.com

At 16 JUL 1999 10:22PM Eric Drews, Drews Enterprises wrote:

I tend to create a program to do the exporting of data from Arev since that provides me with a greater amount of control, and possibly some better efficiency. I do data conversion as a large part of my business. OSBWRITE is probably the statement of choice for the export.

Regards,

Eric Drews

Drews Enterprises

www.drews-ent.com

edrews@drews-ent.com

908 665 2513

View this thread on the forum...