The Student Email field

Journeyman

The Student Email field

I know how to manually upload a csv file using Data Import Manager to update the Student Email field in power school for students. 

 

However, I am wondering is there a way to automate this process such as:

 

1.  During enrollment/transfer (or otherwise setting up a new student) to auto populate the Student Email field. We use a standard pattern for emails that goes like this:  firstname.lastname@ourdomain.org.  

 

2. Setup the Data Import Manager with a scheduled import of the CSV file from our local server (such as over sftp).

 

I mean, we dont have a huge turnover or anything, I just like to have things automated if possible.

 

Thanks in advance for your input.

 

 

6 Replies
Highlighted
PowerSchool Champion
PowerSchool Champion

Re: The Student Email field

How are your students being enrolled?

 

It's just a few clicks for a registrar entering student data by hand to put that information in the right place.

 

If you are importing, I suppose you could concatenate first name, . , last name, @ , domain name and do an autocomm?

 

But, if you don't have much turnover, and people are doing the enrolling by hand, it would seem easier to let the registrar do it in the UI.

 

 

Hope this helps!
Jeannie

Jeannie White
Edkey, Inc. - The Sequoia Family of Schools, Arizona, USA
10 LEAs (Subdistricts) -- ~6000 students
Hosted by PowerSchool
AOI and Meeting Attendance


I am not a PowerSchool Employee
Highlighted
PowerSchool Champion
PowerSchool Champion

Re: The Student Email field

(not autocomm... scheduled Data Import Manager template)

Hope this helps!
Jeannie

Jeannie White
Edkey, Inc. - The Sequoia Family of Schools, Arizona, USA
10 LEAs (Subdistricts) -- ~6000 students
Hosted by PowerSchool
AOI and Meeting Attendance


I am not a PowerSchool Employee
Highlighted
Journeyman

Re: The Student Email field


@DataJeannie wrote:

How are your students being enrolled?

 

It's just a few clicks for a registrar entering student data by hand to put that information in the right place.

 

If you are importing, I suppose you could concatenate first name, . , last name, @ , domain name and do an autocomm?

 

But, if you don't have much turnover, and people are doing the enrolling by hand, it would seem easier to let the registrar do it in the UI.

 

 


Oh I agree! Its getting the registrar to actually remember to do it! lol

 

 

Highlighted
Journeyman

Re: The Student Email field

Scheduled Data Import Manager Template??

 

I cannot find a "Scheduled" section for Data Import, I can only schedule Data Exports....

 

Is Scheduling a Data Import possible? If so thats what I need and would love to know where its hidden at.

 

 

Highlighted
Community Support Expert
Community Support Expert

Re: The Student Email field

Hi @ParatrooperJoe,

PowerSchool SIS version 7.6 and above does not offer the option to import data into the Student Email field using AutoComm, however, data can be manually imported using Data Import Manager. 

If you wish to schedule importing student email address on PowerSchool SIS, you can create a custom student email field and use AutoComm to schedule an import into the custom student email field.  You can reach out to a Designated Support Contact of your school district and they should be able to help you with the process of setting up and scheduling data import into a custom field.



Bishal G.
PowerSchool Community Support Expert
Remember to give Kudos to suggestions that help you!
If a suggestion helps solve your issue, please select Accept As Solution on the post so others can see the solution, too!
Highlighted
Journeyman

Re: The Student Email field

Creating a custom email field so you can automate the student email field to update is a horrible solution. Why can't PS fix this issue?