Jan,
Thanks for the response. I am using 7.5 and Gateway will import the selected tab of the xls work book fine, if I use the GUI method. What I need to do is use the command line while only selecting certain columns from the spread sheet.. However, looking at RDOCS , I see an option " SHEET_INDEX 0" that is not in my standard help files. This looks like what I need, however, RDOCS does not show the " Specification_File_Name " option which I would need as well. So help shows the context for using a specification file at the command prompt but not the sheet index number. RDOCS shows the sheet index number option but not the file specification option. I have not had time to experiment, but perhaps even though not listed, both the " Sheet_Index " and " Specification_File_Name " will work together. I will give it a try later today. Thanks, -Bob ----- Original Message ----- From: " jan johansen " < janj @ jjcalibrations .com> To: " RBASE -L Mailing List" < rbase -l@ rbase .com> Sent: Monday, May 11, 2009 12:21:30 PM GMT -06:00 US/Canada Central Subject: [ RBASE -L] - Re: File Gatway option question Bob, It is unclear as to whether you are still trying this in 7.5 or not. It is my understanding that a single sheet XLS is a worksheet. A multi-tab XLS is a workbook. GATEWAY will work on a singlesheet XLS just fine. However if you need to import a workbook using GATEWAY, the computer MUST also have the full version of EXCEL also loaded as RBASE uses that part for the input. Hope this helps but I'm not sure I can answer anymore on this. Jan -----Original Message----- From: ttc [email protected] To: rbase -l@ rbase .com ( RBASE -L Mailing List) Date: Mon, 11 May 2009 16:00:52 +0000 ( UTC ) Subject: [ RBASE -L] - Re: File Gatway option question It appears that the RGW file does not contain the tab/spreadsheet name. Thus it appears I cannot specify which tab/spreadsheet in the XLS file to pull the data from. The GUI Gateway allows you to select which tab, but it appears the RGW file does not save that info. This was probably why my app was hanging. The RGW file contained column specs from the 3rd tab in the XLS file, which was not found in the first tab. It appears the GATEWAY command using the RGW file option only pulls the data from the first tab and if the column specs do not match, it may hang? If this is the case, what suggestions would anyone have for the below desired function: A spread sheet is maintained on the server as a central repository of certain data. Outside my control, the decision has been made to keep this data in Excel. 6 columns of data (out of 20) in the spread sheet is needed by my Rbase app and on occasion, I need to update the Rbase data base with info from these 6 columns. I want this update to be done by selecting a menu option and be performed without further human interaction. Since this update may have to be done on different PC's , I did not want to have to setup ODBC drivers on each to connect to the spread sheet. Thus the GATEWAY command to load the required data would work fine. However, I need to specify which data sheet to load. Any suggestions? Thanks, -Bob ----- Original Message ----- From: " ttc inc" < ttc [email protected]> To: " RBASE -L Mailing List" < rbase -l@ rbase .com> Sent: Monday, May 11, 2009 10:02:18 AM GMT -06:00 US/Canada Central Subject: [ RBASE -L] - File Gatway option question Is the option to use the Specification_File_Name in a GATEWAY command available in version 7.5? I have used it in a TurboV8 app with importing a text file but do not seem to be able to get it to work in 7.5 with an XLS file. In 7.5, I can save the RGW file OK, but HELP does not list the option for using it under GATEWAY. When I issue the command Gateway import XLS ItemReview . xls Replace TmpItem + OPTION SPECIFICATION_FILE_NAME MRPINFO . RGW The app seems to hang with the hour glass running but no CPU usage of the exe file. Thanks, -Bob TTC Inc. La Porte , IN 46350
