I'm doing an extract from a Revelation database (V3.1) and while not familiar with TCL commands I am okay with SQL/ODBC/transferring data between applications. When I do LISTMEDIA there is no IMPORT.EXPORT listed anywhere (I think there should be). If there should be one, can I get it from somewhere and then how do I load it into the database and then use it ?

Any help would be appreciated asap as (as is the way) time is of the essence !!

Mike

Mike,

There are lots of ways to do what you are asking. The first thing to do is to determine which Revelation product you are working with they have four. You are probably using either RevG or Arev. Perhaps the crudest way of achieve a transfer is to use the concept that revelation holds that DOS is just one big file called "DOS" which can be written to or read from. You can then use the

Mike,

There are lots of ways to do what you are asking. The first thing to do is to determine which Revelation product you are working with. They have four. You are probably using either RevG or Arev. With one of these, perhaps the crudest way of achieve a transfer is to use the concept that revelation holds that DOS is just one big file called "DOS" which can be written to or read from. You can then use the TCL COPY command to read and write between your application file and DOS. NOTE that all of the Revelation TCL commands should be displayed to you with the help key pressed at the TCL colon prompt. The syntax for coping between files is:

 COPY      () TO:( 

        ]targetFileName]  

Note the "TO:(" format. No spaces, no right parenthesis. There are number of flags but the most important one for you is capital "O" which stands for overwrite.

So if I wanted to copy a record 1000 from my application's COACC file to a "record" (i.e. ASCII TEXT FILE) called MIKE in DOS I would type:

 COPY  COACC   1000  (O)  TO:( DOS  MIKE

The (O) is used to overwrite any existing file in DOS with the name MIKE.

Again, there are many other approaches particularly if you are able to compile source code in your copy of Revelation.

Tom

Mike,

One minor correction to my earlier response. The "TO:" must be together with no spaces and the "(" string must be together with no spaces. You can optionally put the whole thing together without spaces if you want (i.e. "TO:(" ) So if you are going from TCL to DOS you could type "TO: (DOS" or "TO:(DOS", both would work.

Also in addition to the "(O)" overwrite options flag there are two others of importance in import and export, namely (I) and (R). The (I) option converts and copies Revelation @FM (char 254) to CRLF and (R) does the reverse: converts CRLF in DOS files to @FM in Revelation.

Tom

From TCL (press F5) run the developers main menu. Runmenu Main.

From there got to Developer and Import/Export.

Just a caution. If you are trying to export from Ceridian's HR1 the above won't work. Not only will it not work, but you have a much larger problem than you anticipate. If you are trying to export HR1 data, then I can point you to Improvisations, who have that problem nailed.

If there is no COPY command available how else can I get at it ? Is it possible to get hold of the IMPORT.EXPORT facilities seperately ? or even get at it via ODBC. I dont have access to the data all the time as it is on-site and I'm going there in a day or so and want to be as prepared as poss

Mike

Even easier at TCL type: RUNMENU EXPORT

If the IMPORT.EXPORT/IMPORTEXPORT (depending on version) file does not exist for the application, simply create it.

Curt,

Why won't standard exports work from HR-1? I've written several little export definitions from our HR-1 package and the information comes out just fine.

Is there something I'm missing?

Matt Sorrell

[email protected]

Mike,

The diversity in the answers you are seeing to your question is because we are not sure what Revelation Product you are using for your application (RevG, ARev, OI or jRev I am sure its not jRev).

So which Revelation product are you using?

Two of the products (OI and jRev) support ODBC while RevG and ARev do not. All the products support the COPY command. In RevG and ARev you must be in the database engine command line (called "TCL") to execute the COPY command. There is usually a clear doorway to TCL but if all else fails you could try while inside your application and press . If you get an exclaimation point ("!") prompt then you are the TCL debugger and you can type END to go to the TCL command line. You could also try by-passing your application at start up to go directly to the TCL prompt say through SYSPROG. Again it is all dependent on which product you are using and the design of your application. Oh, by the way if you do get to TCL or the DEBUGGER you can exit by typing "OFF".

Tom

The original message states: "…an extract from a Revelation database (V3.1)…"

Dah… Missed that!

If you need a do-it-yourself utility or a full service transfer of all your data, see http://exorsys.com/revelation.htm.

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.

I've had a look at the COPY command and can extract an individual record, how can I do them all (the F1 key doesn't ive me any help)

Also is there a way of list all files/tables held within the database as I need to extract them all

Thanks a lot

Mike

How do I create it ?

Tom

I'm sure I'm using ARev 3.1 and I've got the COPY command to do stuff but cannot find any on-line help (I'm sure I could make some progress without bugging you guys if I could - brave statement I know)

ANyhow I've posted a couple more queries about the COPY command and also how to create the IMPORT.EXPORT facility

Do you also know how to get a list of all the files/tables within the database ?

Mike

Apologies, it looks like RevG !!!

Sorry

OK so RevG it is. I must be Psyche. To answer some of your questions

1) The key involves the on-line help in TCL give detail for a given command. But these will only show up if the help files have been loaded.

2) The command LISTFILES is used to list the database. The parameter is used if the database is a sub-directory or enter the path if it is in another location from the main directory.

To directly access the database in a different volumne type ATTACH . You can also indirectly access a specific file in a different volume by using a QFILE established with the SET-FILE command.

3) The is a "PORTER" utility that was distributed on the RevG Utility diskette for import and export. If you do not have this I can send it to you. Just contact me at [email protected]

Do you have a run-time only version or do you have a full system including the complier?

Tom

The wildcard symbol '*' is used to copy all the records for example to copy all records from file A to file B you would type:

  COPY  A  *  TO:(B

LISTMEDIA is used to view the list of files on a given volume. LOOKDICT is used to view the dictionaries of a given file. The filename is a RevG file name not DOS file name. The RevG file names are shown with LISTMEDIA.

from TCL type:

MAKETABLE

or if you have access to the Main ARev menu - DB Admin -] Tables -] Define.

You can pretty much use the defaults for everything. Don't worry about creating dictionary records.

Now I am confused again.

Are talking about AREV or RevG? I thought he said it was RevG.

View this thread on the forum...