The Student Email field

ParatrooperJoe
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.

 

 

14 Replies
DataJeannie
PowerSchool Champion
PowerSchool Champion

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) -- 10,000 + students
Hosted by PowerSchool
AOI and Meeting Attendance


I am not a PowerSchool Employee


DataJeannie
PowerSchool Champion
PowerSchool Champion

(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) -- 10,000 + students
Hosted by PowerSchool
AOI and Meeting Attendance


I am not a PowerSchool Employee


ParatrooperJoe
Journeyman


@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

 

 

ParatrooperJoe
Journeyman

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.

 

 

BishalG
Community Support Expert
Community Support Expert

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
Say Thanks by clicking the thumbs up icon in a post!
If a suggestion helps solve your issue, please select Accept As Solution on the post so others can see the solution, too!
angiemarch
Hobbyist

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?

michaelhernly
Hobbyist

Agree - PS has the Student Email field so why would you want a custom field.  PS should fix it.

SowmyaN
Expert

Hi @michaelhernly 

 

Thank you for sharing your ideas with PowerSchool!

 

We recommend creating a feature request on the PowerSchool Ideas Portal to share your suggestion with the PowerSchool SIS product team. 



Sowmya Karmel
PowerSchool Community Moderator
Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!
nicolinsky
PowerSchool Champion
PowerSchool Champion

@SowmyaN So are you talking about Enhancement ID: 4327 added on 02/14/2013, or maybe Enhancement ID: 8365 added on 09/13/2016, or possibly Enhancement ID: 10405 added on 05/07/2019?

jamiem7
Lead Community Moderator
Lead Community Moderator

I recommend using the PowerSchool Ideas Portal in the Community.  All ideas have been added here from PowerSource.  The idea with the ID SIS-I-8612 refers to sending student emails set up to be autocomm.  You can vote and comment on the idea in the Community Ideas Portal.  To search for the idea, simply navigate to the Ideas Portal and enter the ID in the search field.  You can learn more about the Ideas Portal in the Community here.  The FAQs can be found here.



Jamie H.
Lead Community Moderator

Explore becoming a PowerSchool Mentor today!
nicolinsky
PowerSchool Champion
PowerSchool Champion

If you are also a Schoology customer, you will forced to use the built-in fields

EricS6
Journeyman

The same goes for Canvas. We have 38,000 students and a very high churn rate. Having to do this manually is ridiculous.

NaveedK
Padawan

Hi @ParatrooperJoe 

We need to upload a CSV file using Data Import Manager to update the Student Email field. What Target should we pick from the "Import Into:" dropdown box.
Thank you

JeffG9
PowerSchool Champion
PowerSchool Champion

@NaveedK 

______________
Full Disclosure: I do not work for PowerSchool