Print

Print


I had it create duplicate records a few years ago.  I was finding them here and there for a long time afterward... like the bad penny that keeps turning up. 

On Sun, Nov 4, 2018 at 8:36 PM Gloria Ormsby <[log in to unmask]> wrote:
I have another question about this. PowerSchool had an article that said without the schoolid, the import created dupe records. Has anyone else run into that? And another thing is the QuickImport has the Teacher table but the Data Import Manager has no teacher table but has usercorefields table. I want the teacher table right?

Has anyone done an import successfully without the schoolid? This article shows someone did it without the schoolid and it created duplicate records. https://support.powerschool.com/thread/18153?fromSearchResults=true 


Gloria Ormsby
Student Data Manager
Burlington School District
802-864-8434 ext. 48002


On Wed, Oct 31, 2018 at 10:27 AM Gloria Ormsby <[log in to unmask]> wrote:
Yes Michelle. Melissa, I need to ask Karyn about that. Are we using the Users table or the Teachers_NCF31 table?


Gloria Ormsby
Student Data Manager
Burlington School District
802-864-8434 ext. 48002


On Wed, Oct 31, 2018 at 10:22 AM Michelle Devino <[log in to unmask]> wrote:
Hi Gloria,

Are you saying that in this area of PowerSchool it showed the teacher's username?

image.png

For the staff files we used:
users.teachernumber AS LOCALED_ID


Michelle M. Devino
Data Manager
Colchester School District
Direct: 802.264.5761
Help Desk: 802.264.5727

CONFIDENTIALITY NOTICE: This e-mail is intended only for the use of the individual or entity to which it is addressed and may contain information that is protected student information, privileged, confidential and exempt from disclosure under FERPA.  If you have received this communication in error, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender by reply e-mail and delete the original message immediately.


On Wed, Oct 31, 2018 at 10:03 AM Gloria Ormsby <[log in to unmask]> wrote:
Good morning

We currently have staff members that don't have the state Educator ID. We also don't have a local id for staff as the ID field is their login id. I need to somehow import the Educator IDs that we now have in a spreadsheet into PS. What field will I use to match the data? Is the only option to export from PowerSchool and them VLookup? Looking for some creative ideas here!

Thanks!

Gloria

Gloria Ormsby
Student Data Manager
Burlington School District
802-864-8434 ext. 48002

--
--
You received this message because you are subscribed to the Google
Groups "PSUG-VT" group.
To post to this group, send email to [log in to unmask]
To unsubscribe from this group, send email to
[log in to unmask]
For more options, visit this group at
http://groups.google.com/group/psug-vermont?hl=en

---
You received this message because you are subscribed to the Google Groups "PSUG-VT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [log in to unmask].
For more options, visit https://groups.google.com/d/optout.

--
--
You received this message because you are subscribed to the Google
Groups "PSUG-VT" group.
To post to this group, send email to [log in to unmask]
To unsubscribe from this group, send email to
[log in to unmask]
For more options, visit this group at
http://groups.google.com/group/psug-vermont?hl=en

---
You received this message because you are subscribed to the Google Groups "PSUG-VT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [log in to unmask].
For more options, visit https://groups.google.com/d/optout.


--
Melissa Hayden-Raley
Database Administrator
Maple Run Unified School District
.

-----------------------------------------------------------------------

Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT