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
