I think hidden here is the answer to my issue as well.
I have been using the LoadDirectoryName.RBL for vFolderName.
So I would need to ensapsulate it as such
SET VAR vQuotes = (CVAL('QUOTES'))
SET VAR vLoadFile = +
(.vQuotes+.vFolderName+'\'+.vFileName+.vQuotes)
Jan
-----Original Message-----
From: "Paul Buckley" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 2 Dec 2009 18:51:22 -0500
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
