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: [email protected] To: [email protected] (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" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> 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
