Ok....allow me to end this problem that I unknowingly began earlier today!
I see the error of my ways....I did, in fact, download the DI file as a spreadsheet,
thus causing the file to have quotes around each entry. Diane Mack and
Terry King helped me to see what I did wrong. There is nothing, I REPEAT...
NOTHING wrong with the HEI programming and if I stated, either implicitly
or explicitly, that there was, I sincerely apologize.
It's true what someone once said (I think it was Will Rogers!)....
there's no fool like an old fool! *blush*
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
I promise not to cause an uproar statewide ever again.
etc., etc., etc....
Embarrassingly yours...
LH
:-)
>>> [log in to unmask] 09/21/00 02:32PM >>>
Did you download from the Regents' site by clicking the "Text" button or by
clicking the "Spreadsheet" button?
Downloading to a spreadsheet and then saving the spreadsheet as a text file
may cause double-quotes to surround each line of data, depending on the
spreadsheet software you are using. Note that each line of data is a single
cell in the spreadsheet (there's only one column!); those double-quotes are
enclosing a single text entry.
Downloading straight to a text file will not put in the double-quotes.
Diane Mack
Senior Research Analyst
Office of Institutional Research
Ohio University
-----Original Message-----
From: Ohio Association for Institutional Research (Ohio AIR)
[mailto:[log in to unmask]]On Behalf Of Larry Hunter
Sent: Thursday, September 21, 2000 2:04 PM
To: [log in to unmask]
Subject: Re: Don't "quote" me on this....
Terry,
Thanks for pointing out about the Key Value Pair, but I did that and I still
had problems until I eliminated the quotation marks. Once I eliminated
the quote marks, everything worked fine.
L.
>>> [log in to unmask] 09/21/00 12:05PM >>>
Hello Larry,
Your information about how the HEI file works (or doesn't work) with the
IPEDS
import is wrong! It works very well. What you probably did not do as one
of the
steps in the import is to check 'Key Value Pair' in the "File Type"
selection.
If you follow that, I believe you'll will see that it works.
Thanks, Terry
Larry Hunter wrote:
> Please forgive me if you have already found out this information, BUT...
>
> when you are doing the IPEDS Completions Survey and you download
> your institution's data from HEI, you MUST remove the quotation marks
> that appear on each record (from HEI) before trying to upload that
> file onto the IPEDS database for your use. Does that make sense?!
>
> I tried to upload, not realizing I must remove the quotes, and guess
what...
> it didn't work! The good thing is that I used my handy-dandy IPEDS
> training manual (*tongue planted firmly in cheek!*) and found the
> number for the IPEDS Help Desk,and believe it or not, the Help Desk
> was very Help-ful! ;-) (and extremely friendly, too!)
>
> So, I just thought I'd throw this out to any of you who, like me, did not
know
> this information. Perhaps some of the guys from HEI (I know you are out
> there reading this! hehehe) could talk to someone in HEI programming
> so that the quotes could be forever removed. Then again, perhaps not!
> Who knows!
>
> In any case, enjoy your IPEDS experience and I'll see you in a few
weeks...
>
> Larry
--
====================================
Terry L. King, Dir Info Sys & Inst Research
Northwest State Community College
22600 State Route 34
Archbold, Ohio 43502
(419 267-5511 x251
FAX: (419) 267-3688
http://www.nscc.cc.oh.us/index.htm
|
