James
I use the DIALOG to ask for certain variables I will need. The XLS
file should always match the column layout of the temp table. If you
only want a certain number of rows to load then I would suggest you copy
your worksheet to something else. Then open your copied XLS file and
delete the rows you do not want. Save the file.
Buddy
Both vSheet and vRowStart are integer.
DROP tmpexamgrades
CREATE TEMPORARY TABLE `TmpExamGrades` +
(`StudentID` TEXT (9),`ExamGradStudents` TEXT (40),`ExamHold` TEXT
(1), +
`Key1QuesRight` INTEGER,`Key1QuesAsked` INTEGER,`Key1Percent` DOUBLE,
+
`Key2QuesRight` INTEGER,`Key2QuesAsked` INTEGER,`Key2Percent` DOUBLE,
+
`Key3QuesRight` INTEGER,`Key3QuesAsked` INTEGER,`Key3Percent` DOUBLE,
+
`Key4QuesRight` INTEGER,`Key4QuesAsked` INTEGER,`Key4Percent` DOUBLE,
+
`Key5QuesRight` INTEGER,`Key5QuesAsked` INTEGER,`Key5Percent` DOUBLE,
+
`PBLAttend` INTEGER,`FinalGrade` DOUBLE,`PassOrFail` TEXT (1), +
`ExamMean` DOUBLE,`ExamStdDev` DOUBLE,`ExamDifference` DOUBLE)
SET VAR vDoGateway = ('GATEWAY IMPORT XLS C:\TEMP\BOOK2.XLS APPEND +
TmpExamGrades OPTION SHEET_INDEX' & (CTXT(.vSheet)) + '|FIRST_ROW' &
(CTXT(.vRowStart)))
&vDoGateway
From: [email protected] [mailto:[email protected]] On Behalf Of Jim
Belisle
Sent: Tuesday, March 29, 2011 9:02 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CHECK FOR VALUES
I AM CURRENT WITH LAST VERSION OF 7.6
James Belisle
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of jan
johansen
Sent: Tuesday, March 29, 2011 7:59 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CHECK FOR VALUES
James,
What version? I think you are 7.6. Are you current?
I vaguely remember a reported problem with GATEWAY a couple of years
ago.
Jan
-----Original Message-----
From: "Jim Belisle" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 29 Mar 2011 07:53:22 -0500
Subject: [RBASE-L] - Re: CHECK FOR VALUES
Jan,
The situation is the same here. The number of rows is always
different but the Columns are the same.
I know you use the CSV approach, but I would like to get the XLS
approach to work, just so I know what I am doing wrong.
I used this code in a CMD file and got this error. "The file
exists but is not a storage object"
GATEWAY IMPORT XLS +
Workinfo.xls APPEND +
tworkinfoday +
SHEET_INDEX 0 +
OPTION SPECIFICATION_FILE_NAME worktemp.RGW
James Belisle
________________________________
From: [email protected] [mailto: [email protected]] On Behalf Of
jan johansen
Sent: Tuesday, March 29, 2011 7:42 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CHECK FOR VALUES
James,
That's if you want to use an RGW. If you just want to import a
file use
GATEWAY IMPORT CSV .vFileName CREATE CSVImportTable
In my case, the excel sheet always has the same columns but the
rows can change.
Jan
-----Original Message-----
From: "Jim Belisle" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 29 Mar 2011 07:31:25 -0500
Subject: [RBASE-L] - Re: CHECK FOR VALUES
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: [email protected] [mailto: [email protected]] 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" <[email protected]>
To: [email protected] (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: [email protected] [mailto:
[email protected]] 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: [email protected] [mailto:
[email protected]] 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" <[email protected]>
To: [email protected] (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
