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
> www.bsdvt.org
> 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
>> www.bsdvt.org
>> 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: image.png]
>>>
>>> For the staff files we used:
>>> users.teachernumber AS LOCALED_ID
>>>
>>>
>>> Michelle M. Devino
>>> Data Manager
>>> Colchester School District
>>> [log in to unmask]
>>> 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
>>>> www.bsdvt.org
>>>> 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*
*.*
*Useful resources:*
* * Vermont PowerSchool Users Group
<https://groups.google.com/forum/#!forum/psug-vermont>*
* * School-IT <https://list.uvm.edu/cgi-bin/wa?A0=SCHOOL-IT>*
* * Maple Run HelpDesk <https://maplerun.on.spiceworks.com/>*