PowerSchool: Community: Home

Automatically copy data from one field to another

By Al McDowall on March 15, 2010

Hi All,

First post for me and hopefully the first step on the path to feeling more positive about Powerschool!
Within the student table, I have two fields - Student_Web_ID and Student_Email. Student_Email is exactly the same as Student_Web_ID except with the addition of @domain.com on the end.

I would have thought there would be a straightforward way of copying the data from one field to another, but I have so far been stumped. I thought I had solved it using ~([01]Fieldname) but this only produces the right results within Powerschool (as it interprets the call on the fly). I need to fill the field with the correct data, as I will be exporting this data for use within Follet Destiny.

Right now, I am thinking I will simply export the relevant data, amend it as necessary and then import it back in to the email field. However, I find myself relying more and more on external software to manipulate and present the data held in Powerschool. Does anyone know of a way to complete what I feel is a basic task, solely within Powerschool?

Many thanks for any suggestions,

Al

Tags: DDA • PowerSchool

Comments

0 Responses to "Automatically copy data from one field to another"

Post Your Comment

I find Powerschool extremely unfriendly

By Al McDowall on March 15, 2010

Hi All,

This is only my second post and I apologise for starting out so negatively. I have been working in IT for about 10 years, though only the last three in education. So far I have found Powerschool to be counter-intuitive and the support documentation unreadable, bordering on cryptic.

I would love to know if anyone else has had difficulty with PS. Setting it up and querying it has been no problem, but we have failed to move much further than taking attendance. I have created my own database driven sites and do not expect to have such a hard time with what is basically on online database, yet time and again I am thwarted! Even creating custom reports using HTML templates proved more headache than it was worth and I ended up resorting to exporting the data and using a third party DTP program to merge the data into a reasonable looking document.

I am not aiming to begin a campaign against this software, nor am I looking for a group of like minded 'complainers'. However I would really like to find out if any of you have had issues, and how you have overcome them. Or perhaps the fault lies with me? I don't like to admit defeat, but I am getting ever closer to that stage!

Looking forward to moving forward,

Al

Tags: PowerSchool

Comments

0 Responses to "I find Powerschool extremely unfriendly"

Post Your Comment

Question on transferred students

By Brian Fleischman on March 15, 2010

I know that this has come up before, but I can't remember the answer.

Is there a way to access a students current grades before they transferred? We have a student that has transferred and there was no report printed showing their current grades before they were transferred out of Powerschool.

Any suggestions would be very helpful. Thank you.

Tags: PowerSchool

Comments

4 Responses to "Question on transferred students" (view all)

Kathy Rowell on March 15, 2010

in the search box type / and their last name - go to quick look-up and show dropped grades and everything should be there - then you can print a report.

Kris Schutt on March 15, 2010

If you search using the forward slash / you should find the student. Go to Quick Look up and click on "Show dropped classes also". Should do the trick!

Rhonda Hoyt on March 15, 2010

Pull up the Quick Look up for that student. If you are still in the same term, click on show dropped classes also. If you are in a different term, change your term at the top to a previous term (when they were enrolled). The grades should show.

Post Your Comment

PowerScheduler - Student Request Screens

By Dustin Favinger on March 1, 2010

Those of you who know me already know that I have very little hair left to pull out...I am working on scheduling for next year. I am having trouble getting the student request screens to display properly.

I have run the setup and copied my registration screens from last year. When I preview the screen and when I actually log in as a kid, it does not list the courses to choose from. I click on the 'pencil' icon but the box that comes up does not list any classes.

I have tried multi-class requirements, I have tried single class, etc. I have tried different course groups as well. Even tried firefox and IE to make sure it was not a browser issue.

Has anyone else had this issue? And better yet, how did you fix it?

Dustin Favinger
Cozad

Tags: PowerSchool • Scheduling

Comments

5 Responses to "PowerScheduler - Student Request Screens" (view all)

Bryan Williams on March 1, 2010

I have the same issue here as well. At first I thought it was because I had accidently generated the new scheduling year under this years container (forgot to switch year). After deleting and recreating, I was still having the problem. Same issue was happening on my test server.

What it boils down to is that we migrated our data from another Student Information System a few years back. This migration included Course Numbers which contained spaces. These spaces are not liked by PowerSchool in its current iteration. Take a look at PowerSource ID 58045. They want you to change the course numbers so that they do not contain spaces. It's not the best solution but it does work. (At least for me on my test server). I was hoping this latest release (6.1.0.2.0102) would have a fix for that. It didn't....

Dustin Favinger on March 1, 2010

Bryan,

Thanks. Unfortunately our course numbers do not contain spaces...I am just about to start surfing PowerSource for other possible causes.

Did your screens come up with all the correct messages and such, but then just not list courses when you go to the pencil icon?

Thanks

Dustin

Bryan Williams on March 1, 2010

Yes, everything else would show fine, just no courses listed when I clicked on the pencil icon. Are you running an image server? If so, recopy the scripts folder from PS server to your image server. If not, keep us posted on your outcome.

Post Your Comment

NSSRS Curriculum Report

By Kris Schutt on February 26, 2010

Does anyone have good info on how to set up PowerSchool to run the new curriculum report? When I run the report it comes out blank. Please help! Thank you!

Tags: NSSRS

Comments

2 Responses to "NSSRS Curriculum Report"

Wayne Wiens on February 26, 2010

Below you will find information taken from the Nebraska Reporting Release Notes Feb. 12, 2010

Edit Section and Edit Course Page Updates

Reference: PSSR-3830

Description: New fields are required on the Edit Section and Edit Course District Information pages for the NE Curriculum report.

Resolution: The following fields were added to or updated on the Edit Course District Information page (table and field name noted):

Special Course Indicator – [Courses]NE_Spec_Course_Code. Use this field to indicate if the course is a special course.

Alternate Course Number – [Courses]alt_course_number. This existing field is now used to record the Course Code. For more information about Course codes, see Appendix D, Course Codes and Clearing Endorsements: http://ess.nde.state.ne.us/DataCenter/DataCollections/Default.htm.

A checkbox, “Exclude from State Reporting (Curriculum Report)” is now available. Selecting this option will exclude a course only for the Curriculum report.

The following fields were added to or updated on the Edit Section page (table and field name noted):

• Semester Code – [Sections]NE_SemesterCode. Select the code to indicate when the course is offered and the length of the course.

• Minutes Per Session – [Sections]NE_MinPerSession. Provide the average number of minutes the class meets during the entire school year.

• Assignment Grade Level – [StaffAssignment]NE_StaffAssignGrade. Use this field to record the Grade_Taught_Code. This field is also located on the Staff Assignments page. The following values were added to the pop-up menu on both pages:

o (42) Grades K-2

o (43) Grades K-3

o (44) Grades K-6

o (45) Grades K-8

Kris Schutt on February 26, 2010

THANK YOU! Don't know how I missed that one!

Post Your Comment

Ethnicity and Race

By Greg Boettger on February 22, 2010

I am not sure if I have done something wrong or not, but I was wondering if anyone is seeing the following. When I go in and mark a students race and submit, the check boxes go away and are blank. I go look at the student race table and they are there. Then I go back into the same student and check the boxes again and same thing happen except when I go back tot he Student race table, there are duplicate records for the same student.

Has anyone seen this at all? I wonder what I am doing wrong.

Tags: NSSRS

Comments

3 Responses to "Ethnicity and Race"

Kathy Riese on February 22, 2010

The check boxes stay checked for us. Sorry???

Wayne Wiens on February 23, 2010

I have seen this at several schools and it is a known issue. There is a PS KB article, 58608 that describes a workaround. Since most of the schools are just getting started with this and they didn't have much entered, we just deleted all the records in the Teacher/Student race tables instead of doing the workaround. The one thing I forgot to do once, was to quit PowerSchool and restart. I kept deleting the records in the Race table, but it still didn't work, then I finally realized I didn't restart PS.

To delete the records:

Navigate to DDA

Select the StudentRace or TeacherRace table

Select all records

Click on the Modify Records

Verify you have the correct table!!!!!

Check the delete box and then click the delete button

Quit PS and then restart PS.

Greg Boettger on February 24, 2010

Deleting the records and restarting the server did appear to work. Now the check boxes stay and things are updated in the StudentRace table. Thanks Wayne.

Post Your Comment

Transcript with immunizations

By Tanya Phillips on February 19, 2010

Does anyone have a way to add immunizations to the transcript? I've got the health screens up, and am getting them running, but would like to have this on my transcripts. Any suggestions??

Tags: Immunization • transcripts

Comments

0 Responses to "Transcript with immunizations"

Post Your Comment

PowerSchool Sharing Agenda 2-8-2010

By Graci Gillming on January 28, 2010

PowerSchool Sharing Session February 8, 2010

ESU 10 - Kearney

9:00 a.m. - 2:30 p.m.

Register: https://odie.esu10.org/workshops

It is time to get started with the scheduling process and this session will focus on scheduling using PowerScheduler.

9:00-11:45 BUILD: this where PowerScheduler creates the optimal master schedule based upon student requests and course/teacher constraints.

12:45-1:30 Student Request Screens: we will cover how to create student request screens and course groups so students can register online.

1:30-3:30 LOAD: this is where PowerScheduler loads the students' requests into the master schedule

If you are planning to use your current schedule for next year, you will not need the morning BUILD session. If you have any questions, please feel free to contact me.

Wayne Wiens

wwiens@esu9.org

402.463.5611

Tags: agenda • Meeting

Comments

0 Responses to "PowerSchool Sharing Agenda 2-8-2010"

Post Your Comment

February NSSRS Reports

By Rebecca Vanek on January 20, 2010

Hello Everyone,

What are the start dates and end dates we are to use, for student and student enrollment?

Thanks

Rebecca Vanek
Ord Public Schools

Tags: NSSRS

Comments

1 Response to "February NSSRS Reports"

Kathy Rowell on January 21, 2010

Since school enrollment uploads only new information, use the day after your last submission and then today's date. The report will be short and only show in and out since your last submission.

Remember this one has no headers

Good Luck

Post Your Comment

Trouble uploading to NDE

By Kathy Rowell on January 18, 2010

I have tried to upload my student filr to NDE and keep getting an error that the submission (student) is not available in the current selection. The only thing it will let me select is National Assessment. I thought Students could be uploaded any time. Don't I have to upload student before student enrollment? I have to do this by Feb 1 for the NeSA labels?

Tags: NSSRS

Comments

0 Responses to "Trouble uploading to NDE"

Post Your Comment

1 2 3 4 5 6 7 8 9 ...