Hi Kate
Yes you can ignore what it says in the manual and only worry about those
names with ' in them :-)
It works for me anyway
Carol
> -----Original Message-----
> From: Kate Boardman [mailto:[log in to unmask]]
> Sent: 24 May 2001 10:40
> To: Cooper, Carol D.; [log in to unmask]
> Subject: RE: order of fields in a bath create user
>
>
> Carol, are you telling me that for you Blackboard doesn't demand the
> records to be encased in "" ??
> Kate
>
> ~~~~~~~~~~~~~~~~~~~~~
> Kate Boardman
> Learning Technologies Team
> IT Service
> University of Durham
> South Road
> Durham DH1 3LE
>
> tel.: 0191 374 1502
> [log in to unmask] <mailto:[log in to unmask]>
>
>
> -----Original Message-----
> From: A list to promote discussion amongst MLE Blackboard/Courseinfo
> users in UK [mailto:[log in to unmask]]On Behalf Of
> Cooper, Carol D.
> Sent: 24 May 2001 10:28 AM
> To: [log in to unmask]
> Subject: Re: order of fields in a bath create user
>
>
> I find with Excel97, that if I just put in the data (separate
> column for
> each field of course) that when you do save as csv (comma
> delimited file)
> Excel puts the commas in for you so there is no need to
> search and replace
> as Kate describes. What you have to be careful of is names
> which have an '
> in them such as O'Riley, if you are not careful Bb rejects
> that record. So
> for these type of names you must put " round them e.g. "O'Reily".
>
> Carol
>
>
> -----
> Carol Cooper
> eLearning Support Officer /Swyddoges Gynhaliaeth eDysgu
> Learning & Teaching Support Unit, University of Wales
> Institute, Cardiff,
> Llandaff Campus, Western Avenue, Cardiff CF5 2YB UK
> Uned Gynhaliaeth Dysgu Ac Addysgu, Athrofa Prifysgol Cymru,
> Caerdydd, Campws
> Llandaf, Rhodfa'r Gorllewinol, Caerdydd CF5 2YB DU
> Tel/Ffon: +44(0)29 2041 6264 | Fax/Ffacs: +44(0)29 2041 6257
> work: http:// <http://www.uwic.ac.uk/ltsu>
> www.uwic.ac.uk/ltsu personal:
> http:// <http://www.carol-cooper.co.uk> www.carol-cooper.co.uk
> Nursing/therapy eLearning webring:
> <http://nav.webring.yahoo.com/hub?ring=nursingtherapyel>
> http://nav.webring.yahoo.com/hub?ring=nursingtherapyel
>
> -----Original Message-----
> From: Kate Boardman [mailto:[log in to unmask]]
> Sent: 18 May 2001 17:05
> To: [log in to unmask]
> Subject: Re: [BLACKBOARD-USERGROUP] order of fields in a bath
> create user
>
>
> Good point Peter, and while we're on the subject, shall I
> share how I get
> these files, cos believe it or not it took a while to produce
> them, then if
> anyone's still wondering, my way works, and if anyone's got a
> better one,
> please let us all know! (Apparently you can do a similar-ish thing in
> Access)
>
> Create excel file with extra column of # or % either end.
> Save as .csv. Open
> in wordpad. Replace , with "," then #", with nothing and ,"%
> with nothing.
> Save and use to upload batches.
>
|