csv upload to the grade book

csv upload to the grade book

de steve hopley -
Número de respuestas: 4

Hi all

Ive been developing a local marking database for years now and have had it up loading to blackboard with no problem now i need to upload my marking to my employers moodle system.

my Problem is this Im trying to upload grades and feedback from a local database to moodle.

I can export to CSV and upload grades no problem.

the  catch is that, feedback because it is freetext has commas and covers more than 1 line so needs to be quoted .

Problem: moodle doesnt seem to process quoted strings.

suggestions  please im at a loss.

En respuesta a steve hopley

Re: csv upload to the grade book

de Andrew Davis -

Hi Steve. What version of Moodle are you using?

I realize you can't put up the actual data but would it be possible for you to attach something representative of the data that is causing the problem?

En respuesta a Andrew Davis

Re: csv upload to the grade book

de steve hopley -

Thanks andrew ,

version number  : 1.9.7 will be upgrading to 2 when the finished verion is released says the person incharge of it.

data fomat looks somthing like this (line breaks exagerated  but you get the idea.)

"name" , "email", "grade" , "feedback"
"david" , "david@my.com"  , "Pass" , " good work pass criteria
acieved , more work on task 4
to achieve the merit. " 
"john" , "john@my..." , "refer" , " A good start a couple of things need
attention in task 2 look at what ive written on the work."

  As i say moodle just isnt parsing out the quotes so i get errors like

no user exists with email ""david@my.com""   

sorry its a link  this editor keeps making it one  enfadado

thansk in advance

steve.

 

 

En respuesta a steve hopley

Re: csv upload to the grade book

de Andrew Davis -