I unloaded the table into V8 and ran the same cmd file. All worked perfectly with
no modifications to the syntax. Jan was correct in that it seems to be fixed in 7.6 / 8 Thanks all, -Bob ----- Original Message ----- From: "Gary Wendike" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, July 15, 2009 1:17:48 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Gateway syntax 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
