Bob, just a thought...you show the SHEET_INDEX to be 1. I don't know if you are looking to get data from the first tab or the second tab of the workbook. However, this will be considered by RBase to be the second tab of the workbook. If you are looking for the first tab, you should be using 0 for the SHEET_INDEX.
Second thought...I don't know if it makes any difference on the order of the options, however, the example in the help file starts with SHEET_INDEX then SPECIFICATION_FILE_NAME. Gary ________________________________ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, July 15, 2009 12:30:16 PM Subject: [RBASE-L] - RE: Gateway syntax Thanks Buddy, I tried this operation by changing the file name to include no spaces. I still got the same results, so the space issue is somewhat moot. Jan thought that it might an issue that was fixed in 7.6/8.0. When I get a chance, I will try it in 8.0 and report back. Thanks again, -Bob ----- Original Message ----- From: "Buddy Walker" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, July 15, 2009 12:22:36 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Gateway syntax Bob Since the filename has spaces you might what want to try building the syntax. SET VAR VQ = (CVAL(‘QUOTES’)) SET VAR vDoGateway = + (‘GATEWAY IMPORT XLS’ & .vq + .vFilename + .vq & ‘APPEND TmpItem + OPTION specification_file_name MRPINFO.rgw|SHEET_INDEX 1’) &vDoGateway Buddy From:[email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, July 15, 2009 12:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway syntax This is 7.5. -Bob ----- Original Message ----- From: "jan johansen" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, July 15, 2009 10:57:23 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Gateway syntax Bob, What version are you running? There was an issue that was reported I think back in February with GATEWAY IMPORT and has since been fixed in 7.6 and V8. Jan -----Original Message----- >From: [email protected] >To: [email protected] (RBASE-L Mailing List) >Date: Wed, 15 Jul 2009 15:51:18 +0000 (UTC) >Subject: [RBASE-L] - RE: Gateway syntax >Yes the filename contains spaces. > > >R>sho var vfilename >M:\MRP\Item Sales Review.xls > >Using the & instead of the . pops up an error stating >"Select import mode!" > >I have replaced the variable with the actual path in quotes >'M:\MRP\Item Sales Review.xls' and the system locks up as before. > >I renamed the file so no spaces where included. I changed all references to >the >file name accordingly. Still locks up when issued at R:> but runs OK in >Gateway >menu with same specification file loaded. > >The task manager shows no CPU usage, it just hangs with the hour glass and >I have to kill the process. ??? > >Thanks >-Bob > > > >----- Original Message ----- >From: "Buddy Walker" <[email protected]> >To: "RBASE-L Mailing List" <[email protected]> >Sent: Wednesday, July 15, 2009 10:15:20 AM GMT -06:00 US/Canada Central >Subject: [RBASE-L] - RE: Gateway syntax > > >Bob > Try using &vfilename instead of .vfilename. Does the path/filename contain >spaces. > >Buddy > >From:[email protected] [mailto:[email protected]] On Behalf Of >[email protected] >Sent: Wednesday, July 15, 2009 9:15 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Gateway syntax > >Does anyone see an error in the below syntax? When I execute it, Rbase locks >up and >I have to kill the process to get out. > >However, if I run GATEWAY via the menu, load the specification file >MRPINFO.rgw and >execute, it works fine. > >--Load data into tmpitem from excel spread sheet > >set var vFileName text = 'M:\MRP\Item Sales Review.xls' > >GATEWAY IMPORT XLS .vFilename APPEND TmpItem + >OPTION specification_file_name MRPINFO.rgw|+ >SHEET_INDEX 1 > > > >Thanks all, >-Bob
