[RBASE-L] - Re: CHECK FOR VALUES

[Jim Belisle]

Jan,

I

In the Help section it states:

The import must be performed once using the graphic user interface and
saved using the "Specifications.." button. The specifications will be
stored in a file with the .RGW file extension.  

One of the specs is the ending row. Is this not necessary when setting
up a spec file?

 

James Belisle

________________________________

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of jan
johansen
Sent: Tuesday, March 29, 2011 7:14 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CHECK FOR VALUES

 

James,

 

It's still pretty early for me.

Why does it matter how many rows?

 

Jan
 


 

        -----Original Message-----
        From: "Jim Belisle" <j...@kaypark.com>
        To: rbase-l@rbase.com (RBASE-L Mailing List)
        Date: Tue, 29 Mar 2011 07:09:40 -0500
        Subject: [RBASE-L] - Re: CHECK FOR VALUES

        At the present time, I use a specification file in Gateway to
import into my tables from an EXCEL file.

        If I go to a TEMP table scenario, I would like to use code to do
the import, rather than having the GATEWAY box popup.

        The problem I foresee is in the number of rows imported since it
is almost always different. All the other items will remain the same. 

        I know I can create a var at the start of the code asking for
the number of rows to import. 

        How would I go about using the spec file but changing the number
of rows imported? 

          

        Here is the code thus far:

          

        (ask for the number of rows to import and put into var) 

        GATEWAY IMPORT XLS + 
        Workinfo.xls APPEND + 
        tworkinfoday + 
        SHEET_INDEX 0 + 
        OPTION SPECIFICATION_FILE_NAME worktemp.RGW

          

        James Belisle 

        
________________________________


        From: rbase-l@rbase.com [mailto: rbase-l@rbase.com] On Behalf Of
Gary Wendike
        Sent: Monday, March 28, 2011 10:39 PM
        To: RBASE-L Mailing List
        Subject: [RBASE-L] - Re: CHECK FOR VALUES

         

        I agree with Jan on using the temp table approach.  I also load
many files from xls, csv and access format a day and use a temp file to
process, check and adjust the data before I ever load to the permanent
table.  I never load directly into my permanent table.

         

        Gary 

         

        From: rbase-l@rbase.com [mailto: rbase-l@rbase.com] On Behalf Of
jan johansen
        Sent: Monday, March 28, 2011 3:50 PM
        To: RBASE-L Mailing List
        Subject: [RBASE-L] - Re: CHECK FOR VALUES

         

        Jim,

         

        I think you should import the XLS into a TEMP table to do your
evaluations on.

        If the evaluations pass, APPEND to the permanent table.

         

        Jan
         

        
         

                -----Original Message-----
                From: "Jim Belisle" <j...@kaypark.com>
                To: rbase-l@rbase.com (RBASE-L Mailing List)
                Date: Mon, 28 Mar 2011 15:25:44 -0500
                Subject: [RBASE-L] - CHECK FOR VALUES

                Everyday we import into RBASE to files from EXCEL. 

                One is a file with the time in and out for the whole
day. (one per day per employee)

                The other has punches for specific work done for the
day. (many punches per day)

                 

                Certain employees, because their job is the same each
day fail to punch in for the second file.

                What I want to do is check the excel file as it imports
into RBASE for those employees and add a row with specific information.

                Any ideas as to the best way to accomplish this would be
appreciated.

                 

                James Belisle