How about leaving out the Dialog in your command line.
----- Original Message -----
From: Ed Rivkin
To: RBASE-L Mailing List
Sent: Wednesday, August 19, 2009 8:57 PM
Subject: [RBASE-L] - Problems using Gateway to Import Excel Follow-up Question
Thanks to Bernie Lis for his assistance and thoughts regarding my problems
below.
One of the date fields in the spreadsheet apparently wasn't defined as Date
so changing
my table def to text for import purposes and then changing it back to date
with Alter Table
solved the first part of my problem.
I've successfully defined a .rgw with the thought of imbedding the import
into an .rmd
command file. Unfortunately everytime I execute this using the following:
gateway dialog option SPECIFICATION_FILE_NAME 'May 2009 statement Sub.RGW'
the wizard still pops up and requires input to execute the import.
Any thoughts as to how to eliminate the Wizard prompting so I make this
transparent
to my user.
Thanks,
Ed
Aug 15, 2009 09:01:11 PM, [email protected] wrote:
Hi folks,
I am having two problems with Gateway Import. Couldn't find anything in the
archives
or Edge articles so I am again seeking your expertise.
a) The file imports fine with interactive setup initially with File
Import/Export button
and subsequent use of the wizard. Unfortunately the three date columns are
importing
as null values. Text, Integers, and Currency cells map just fine.
Looking at the spreadsheet date format, it is displayed as M/D/YYYY with no
leading
zeros. Changing the spreadsheet format to MM/DD/YYYY yields the same
result.
I have tried changing the date sequence in R:Base config settings and get
similar
results. The Wizard date settings are "MDY" date order, Four Digit Years is
checked,
Date Delimiter is "/", and Leading Zeros in dates is unchecked.
b) My second problem is that I tried executing the Gateway Import from the
R> prompt.
I eventually want to imbed the import in a .rmd file. When I try executing
the import at
the R> prompt, the error message, "Please Select Import Mode!" appears.
I am fairly confident the spreadsheet was created in Excel but I only have
Open Office
installed on my machine.
Thanks as always,
Ed
