In a Pinch, use:
output SomeFileName.csv
{if all columns}
Unload data from SomeTable using ColList as CSV
{or if specific columns}
Unload data from SomeTable using * as CSV
Output Scr
----- Original Message -----
From: "Wills, Steve" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 17, 2010 10:00 AM
Subject: [RBASE-L] - RE: Gateway Export in EEP
Frank, given the inability to use Gateway in an EEP, if the
functionality must be delivered in an EEP, could you format it via a
report, then print that report, outputting to XLS?
I am only suggesting the possibility, as I have never done this, but it
might offer you another avenue to a solution.
P=1.0: Value <= $0.02,
Steve in Memphis
From: [email protected] [mailto:[email protected]] On Behalf Of A.G.
IJntema
Sent: Thursday, June 17, 2010 6:46am 06:46
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Gateway Export in EEP
Hi Frank,
Your name looks Dutch maybe even Friesian.
You can create an RGW at export by taking the first row at Select Format
(gateway, export). The first option is Use Export wizard
The you are able to create an export wizard and it can be saved as RGW.
It took me also a while before I noticed this option
The procedure can look like this
GATEWAY EXPORT XLS <filename> +
SELECT +
<field1>, +
<field2>, +
...
<fieldn> +
FROM <viewname> +
WHERE <whereclause> +
OPTION |SHOW_PROGRESS ON +
|ACTION OPENVIEW +
|SPECIFICATION_FILE_NAME <filename_rgw>.rgw
However you cannot use this procedure in an EEP, because an EEP does
not allow to make use of GATEWAY.
Hope this helps
Tony IJntema
The Netherlands
From: [email protected] [mailto:[email protected]] On Behalf Of frank
van der Zwaag
Sent: donderdag 17 juni 2010 13:22
To: RBASE-L Mailing List
Subject: [RBASE-L] - Gateway Export in EEP
Hi All,
does anybody have a sample EEP script that I can use to export the data
from a view into an xls spreadsheet using a pre-defined export format
(rgw) file.
Thanks
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
