Bob,
I would definitely change your settings to limit the rows RBASE looks at. If you have an idea of the number of rows, just go higher by your comfort level and set that number of rows. As I stated earlier, that changed the speed to a minimum once I started to limit the rows. When I import 100 to 130 rows of data on a 10 column EXCEL file, it takes just a few seconds so I would imagine your 2000 rows may take less than a minute, maybe even 30 seconds. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, May 11, 2009 4:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: File Gatway option question Karen and Jim, I have found that the command line "Specification_file_name" and "SHEET_INDEX 3" do both work together and they achieve the desired end result. I am able to load only certain columns from a certain tab in an XLS work book via a program command line. (This works in 7.5 as well!) However, I have ran into what Jim describes below. While the command line does execute and loads the exact data expected, it takes a long time to execute. Once the Gateway command executes, the system seems to sit and wait for about 5 minutes. Task manager does not show any cpu usage. Then all of a sudden the table loads in a matter of seconds. However the time lapse from hitting starting the load to returning focus is about 5 minutes. Yet I can tell the actual loading only takes seconds. Not sure what this is but will continue to look into it. I do see in the RGW file the folloiwng : RowFirst=1 RowLast=2147483647 If the RowLast being a huge number is slowing this down, perhaps there is an option to make this number smaller. There is only about 2000 rows in the spread sheet. (Or I will just change it in the RGW file as Jim suggests.) Making progress! Thanks , -Bob ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, May 11, 2009 3:43:43 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Re: File Gatway option question Karen, I have been reading this discussion with interest. I use the specification file daily for a couple of Excel files. I use it for many reasons but one is the number of rows imported varies wildly in one of the files and I change that setting each day. If I were to use the below SYNTAX as you suggest, is there on option for the rows imported? In the past before I used the rows setting, the import would take much longer because RBASE seemed to "LOOK" at all the rows even if they contained no information. With 7.6 is the rows setting not that important? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, May 11, 2009 3:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: File Gatway option question Bob: Are you sure you need to use a specification file? In addition to using the sheet index, you can also map columns to table names: GATEWAY IMPORT XLS filename APPEND customer OPTION ADD_MAPPING Company=B | ADD_MAPPING CustAddress=C | ADD_MAPPING City=D Karen 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
