Append only to existing students

  • DiscoStu
3 years 6 months ago #9142 by DiscoStu
Append only to existing students was created by DiscoStu
Hello,

I currently have a large csv file containing all of last years data for my year 8 students in multiple columns from leadership. Unfortunately the file isn't sorted into classes. Is there a way I can append the data to my classes and have idoceo only append to students that already exist in a class?

So far every time I try it, it adds every student in year 8 to the class.

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #9171 by bert
Replied by bert on topic Append only to existing students
Hello DiscoStu,
We will add a small question before 'Appending' that will ask if you'd like to add the missing to students or append data only to those that are already present

Please Log in or Create an account to join the conversation.

  • DiscoStu
3 years 6 months ago #9172 by DiscoStu
Replied by DiscoStu on topic Append only to existing students
Brilliant thank you! Will that appear in a future update?

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago - 3 years 6 months ago #9173 by bert
Replied by bert on topic Append only to existing students
Sure, I'm working on it right now
Let me see if I can squeeze a Beta version for you to work on it before the official release
Last edit: 3 years 6 months ago by bert.

Please Log in or Create an account to join the conversation.

  • DiscoStu
3 years 6 months ago #9174 by DiscoStu
Replied by DiscoStu on topic Append only to existing students
Fantastic! Happy to beta test. Let me know what I need to do. The last time I beta tested idoceo was for version 4 but I've test flight installed. Thanks so much.

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #9175 by bert
Replied by bert on topic Append only to existing students
You should have Testflight's invitation in your inbox, just update from Testflight as usual

Please Log in or Create an account to join the conversation.

  • DiscoStu
3 years 6 months ago #9176 by DiscoStu
Replied by DiscoStu on topic Append only to existing students
Hi Bert,

Thanks for the invite. I'm testing now. It works great, thanks.

I was initially trying to append by copying the file from my onedrive account and it resulted in all students being imported. However when I import from within the classes page on iDoceo I get the option "Do you wish to add the missing students to your gradebook?". I select no and only the data I need is added.

This is huge time saver for me so your hard work is much appreciated.

Please Log in or Create an account to join the conversation.

  • DiscoStu
3 years 6 months ago #9180 by DiscoStu
Replied by DiscoStu on topic Append only to existing students
Hi Bert.

Upon closer inspection something strange is happening when I import the data it’s changing some students surnames (but not all) and then imports the wrong students data into the gradebook.

For example I have a student who’s surname changes from Mann to Taylor. The forenames all stay the same however. The data that is then imported matches the student with the surname Taylor. The spreadsheet I’m importing (csv) has the surnames under ‘surname’ and names under ‘forename’ on the adjacent column. I thought that it might be because the students have the same forename but a number of students have no similarity at all. Strange!

Any suggestions?

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago - 3 years 6 months ago #9181 by bert
Replied by bert on topic Append only to existing students
If you made sure that name and lastname are selected (in the name tab) when appending data send me a couple of screenshots if you have a chance to support @ idoceo.net

A sample fake file with the same columns you're importing would also be great
Last edit: 3 years 6 months ago by bert.

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #9182 by bert
Replied by bert on topic Append only to existing students
Do not bother DiscoStu, I'll prepare a new Beta

Please Log in or Create an account to join the conversation.