Please either Logon or create a New Account.
upload (3)
Hello ... anyone else working today??

I'm trying to import our new students for next year via a spreadsheet and Quick Import. I've tried both tab-deliminated (.txt) and .csv files but I'm getting nothing from PowerSchool after I click Import. No error message, no progress, no indication of anything. This is just a test file of 21 students. I'm selecting the Students table, selecting the field delimiter and end-of-line marker, mapping the fields, excluding my header file, and selecting the option to ignore the row if the student_number already exists. I'm in the right school. 

I've imported data a bazillion times with no problems. Not sure why I'm getting nothing today. And support is closed for the holiday. :-P

Any suggestions on what I might be doing wrong? I'm hosted with version 9.1.1. I'm referencing the Import/Export Guide for 9.x. Thanks!
3 Responses to "Importing problems"

After you click submit, do you get a screen that mostly is blank? If so, can you scroll down and find information? I have seen the blank screen which leads you to believe nothing happened, but there is text if you scroll down. I have heard this is caused by the Enhanced Parent Portal customization.

I've seen the mostly blank screen, too, but this page is totally blank. I don't have the EPP. However, I just installed the E-Registration module from Grant Wood AEA in Iowa. Maybe it's related??

FYI ... here was my fix: I needed to check the box for "Allow Updates of Enroll Status" when I imported the file with new students. I switched to Chrome, which gave me a popup with that message. Firefox just gave me the blank screen.

Post Your Comment

I managed to get my Unique IDs from NDE, but now I can't figure out how to get them in to PS. I know it's probably not that hard, but my brain is mush!!!

Tags: NSSRSupload
4 Responses to "Importing Unique ID to PS" (view all)

If you are upgraded to PS 7.0, you go tothe Staff Edit Information then Nebraska Faculty Information (near the bottom of the page), on that page there is a spot for it!

The process isn't too bad.

1) In Excel, bring in the state ID downloaded file by Get External Data. (If you don't know what this is, count yourself lucky and ask your NSSRS person)
2) Optional, but would save a little time, rename the SSN and Gender column so they will not map in PS. You can use any name, even garbage, as long as it isn't SSN or Gender.
3) Save the file as a txt (tab delimited) file. Name it anything that makes sense to you.
4) In PowerSchool, go to a staff members Edit Information page, scroll to the bottom and click on Faculty Information link.
5) Scroll to bottom of page and enter any number in the NE Staff ID field. You need to do this so the field shows up in the field list. If the field is not at the bottom of this page, you need to have the latest state upgrade installed.
6) Go to Special Functions > Import/Export > Quick Import
7) Select the Teachers table
8) Browse to your saved file from step 3.
9) All other fields can be the default.  (Suggest Field Map box should be checked)
10) On the next field mapping page, map:
Local_Staff_ID  =>  TeacherNumber
LastName  =>  Last_Name
FirstName  =>  First_Name
NDE_Staff_ID  =>  NE_StaffID
11) Check the box "Exclude First Row"
12) Check the box "Update teacher records if an imported...."
13) Click submit

I would now delete out all the staffs' SSN numbers, unless you know you have a use for them. Before you delete though, I would export out the Teacher_Number, First_Name, Last_Name & SSN. Then save this file in a secure location. This way, if in the next few months you find out you need this, you will have a file you can reference or import back into PowerSchool. Once a few months pass, I would delete that file.

Thanks. I guess I should have said Student Unique IDs. When I put their student_number in, it says that number is already in use. When I use ID, there isn't anything to map it to.

Post Your Comment

If you'd like to place a file or doc on the Community, you need to post an new article, i.e. it can't be done via a comment.  Once logged in, click on Publishing, then Add New Artcile. In the editing tool bar click on the Document Manager button  , which will allow you to upload a document.

Pictures can be done similiarly by clicking on the Image Manager button

For both of them, if this is the first time you've uploaded a doc or image, you'll have to:upload it to the community server, so the steps would include:

  • clicking on the appropriate button
  • select Upload in the tool bar
  • find the file and select it
  • click upload
  • make sure the file is selected
  • click on Insert in the lower right corner of the window.


For images, there is an image editor where you can reduce them in size to make them fit better in the community window.

0 Responses to "Uploading files to PS Community"

Post Your Comment