Jan,
Thanks, but please see my recent post to Paul about partial success. Was using PLUGINS LoadFileNameplus.rbl vfilepath|enable_sizing|fullpath on|title Select Excel File But now I am trying without plugin or var or complex (spaces) path. Just tried on an earlier update and different computer with same result. The code below fails with 2442 error when I trace the eep on both versions. SET TRACE ON -- set err mess 2442 off DELETE FROM t_checks gateway import xls n:\checks.xls create t_chk return From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, December 02, 2009 5:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway import XLS Kenny, I ran into this issue today. Are you using the filechoose.rbl or something like that? It's the spacing in the Document and Settings. So if your file existed in the C:\myfiles\whatever\whoknows\myfilename.xls then it will probably work. I don't quite know what the answer is but the problem partially lies in the space in the path. Jan -----Original Message----- From: "Kenny Camp" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 2 Dec 2009 17:26:20 -0600 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
