Kenny-
SET VAR vpathnm TEXT = '..\Data Files\Data\' -- Includes a space and it
works, this just drops down one dir in this example and ..
SET VAR vcid TEXT = custNo FROM custable WHERE .....
SET VAR vpathnm TEXT = (.vpathnm + .vcid)
SET VAR isitthere = (CHKFILE(.vpathnm))
IF isitthere = 0 THEN
CLS
SET VAR vmess1 TEXT = ('File Folder is NOT Found!' + .vpathnm)
PAUSE 2 USING .vmess1 +
CAPTION 'File Operations Error ...' ICON stop +
BUTTON 'Click here to continue ...' +
OPTION MESSAGE_FONT_NAME Verdana +
|MESSAGE_FONT_COLOR RED +
|MESSAGE_FONT_SIZE 9 +
|MESSAGE_FONT_BOLD ON +
|BUTTON_COLOR WHITE +
|BUTTON_FONT_COLOR GREEN +
GOTO done
ENDIF
Works for me time and time! This is in 7.6 and 9.0 Now I think I
cut/pasted the whole thing- I hope!
And yes I also agree with the RWG but I also tweaked mine a little after
to included some extra. The RGW is 99.9999% gReat! In a lot of cases 100%
Sincerely,
Paul D.
Ps I cannot be held responasible for ANY error(s) that I might have
forgotten - Ok <lol> I hope the examples help you. .x. (cross fingers)
From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley
Sent: Wednesday, December 02, 2009 6:51 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
Kenny,
I am doing this on a project right now. What I have found is I have had to
add the single quotes to the path & file name to get things to work. The
spaces in this will give a big headache. Give that a try. For what it's
worth I also recommend using the RGW option for more consistent results.
Paul Buckley
From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp
Sent: Wednesday, December 02, 2009 6:26 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
I moved the file to a short and simple path (n:\checks.xls) instead of a var
with long path and it did NOT error. Tried with C:\Documents and
Settings\kenny\My Documents\checks.xls in the var and I got an access
violation.
I will test further to see if the path (in a var) is causing the problem.
Kenny
From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp
Sent: Wednesday, December 02, 2009 5:15 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
Thanks Paul D.,
Same problem. I have tried many options with and without RGW, and different
XLS files. Again, the GUI works fine, trying to automate for users. Tried
putting all inside a variablw and R>&vcmd. Then I got something about
"specify import mode", but I was using the syntax from the help files.
Tried both create and append table options.
New XP computer with fresh 1st time install of RBase for Windows.
Kenny
My RGW:
[Common]
App=R:BASE 7.6
Description=Gateway Import: specification
Specification=Import specification
DatasetKeys=
Mode=0
TableType=XLS
SourceFileName=C:\Documents and Settings\kenny\My Documents\checks.xls
CharacterSet=0
[Mappings]
Count=6
Map0=tmpchecknum = A
Map1=tmpdate = B
Map2=tmpdescription = C
Map3=tmpdummy1 = D
Map4=tmpdummy2 = E
Map5=tmpcheckamt = F
[Text]
FieldDelimiter=09
TextQualifier=22
RecordSeparator=0D0A
Fixed=0
RowFirst=1
RowLast=2147483647
[DataFormat]
DateOrder=0
DateSeparator=2F
TimeSeparator=3A
DecimalSeparator=2E
FourDigitYear=1
LeadingZerosInDate=0
From: [email protected] [mailto:[email protected]] On Behalf Of Paul
InterlockInfo
Sent: Wednesday, December 02, 2009 5:05 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
What happens if you use RGW? Do you get the error. If not, keep the rgw
and use it in the command.
Sincerely,
Paul D.
From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp
Sent: Wednesday, December 02, 2009 5:56 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
Sorry, I meant to include that.
7.6 for Windows 7.6.8.31102 I believe that is the most recent.
Kenny
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen
Sent: Wednesday, December 02, 2009 4:30 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway import XLS
Kenny,
It is important to know which version and which update (well maybe just the
update).
There was a problem with GATEWAY import that was fixed roughly March of this
year.
Jan
-----Original Message-----
From: "Kenny Camp" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 2 Dec 2009 16:25:38 -0600
Subject: [RBASE-L] - Gateway import XLS
I am trying to automate gateway to import an XLS spreadsheet from an
accounting program that we export to XLS. It works as expected using the
GUI, but when I try it from the R> it creates the table correctly, but then
throws an access violation (sometimes) and a 2442 error "LIKE clause accepts
only a constant with a TEXT or NOTE data type. Compiled version just throws
an access violation.
I created a simple XLS file with simple data and still get the error.
One of many command lines that cause the error for me:
R>gateway import XLS .vfilepath create t_checks
Any ideas what I am doing wrong? I have never attempted automating gateway
before.
Kenny Camp
