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
