Jump to content
  • 0
pdurber

Bulk Import, not through SiMs

Question

Due to the current situation

We're looking to create some "transition" groups in Frog for year 11's going into 12 and Year 8's going into 9's in September.

This is to keep them going with work over the lockdown and into the Summer holidays.

Most of the year 11's that have applied for our 6th form are already students who attend with us, but there are around 30 who are coming from other Schools.

The year 8's are coming from Middle Schools, So are not currently on our Roll, But we obviously have their details as they have applied to start with us in September.

The question is:- Can I bulk import the information into Frog somehow? So there would be a group called say,  12Transition Maths, which would contain all the students who have applied for A Level Maths.

Just wondering, to save some admin time.

Share this post


Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0
2 hours ago, pdurber said:

Due to the current situation

We're looking to create some "transition" groups in Frog for year 11's going into 12 and Year 8's going into 9's in September.

This is to keep them going with work over the lockdown and into the Summer holidays.

Most of the year 11's that have applied for our 6th form are already students who attend with us, but there are around 30 who are coming from other Schools.

The year 8's are coming from Middle Schools, So are not currently on our Roll, But we obviously have their details as they have applied to start with us in September.

The question is:- Can I bulk import the information into Frog somehow? So there would be a group called say,  12Transition Maths, which would contain all the students who have applied for A Level Maths.

Just wondering, to save some admin time.

You can create a csv file and then bulk import information into Frog.  For instance we (normally) have a Bridging Course for students that are thinking of coming to our 6th Form... current Yr 11's and others ET's!!  All i do is create a csv for the external kids with certain fields and upload them to Frog!!  I'll dig out a copy of the spreadsheet i use that might help!!

  • Thanks 1

Share this post


Link to post
Share on other sites
  • 0

I normally use this...   but i know there was change to the MySql database so you might need to include extra fields...

ET Summer 2019.csv

  • Thanks 2

Share this post


Link to post
Share on other sites
  • 0

Excellent, that's exactly what I need.

Where do I go in Frog to get to the importing though?

I had a look around and couldn't see anything.

Share this post


Link to post
Share on other sites
  • 0

Share this post


Link to post
Share on other sites
  • 0

DOH!

Why didn't I look there!

Thank you very much.

Just a quick question. In your file, you have the Authentication set to Active Directory. Are you adding the ET's to AD too? I was going to set them all to Frog, or does Frog push through to AD as well as read from it?

 

Share this post


Link to post
Share on other sites
  • 0
6 minutes ago, pdurber said:

DOH!

Why didn't I look there!

Thank you very much.

Just a quick question. In your file, you have the Authentication set to Active Directory. Are you adding the ET's to AD too? I was going to set them all to Frog, or does Frog push through to AD as well as read from it?

 

We create the kids AD accounts first so they can logon to desktops in school.... I then use that username to create the accounts on Frog....  so they only need to know one username/password!! 

Share this post


Link to post
Share on other sites
  • 0

Hi @pdurber

One word of caution - while you can create all these users via CSV, they will have new accounts created in the next academic year from the MIS import.  If these users are creating any work, having any assignments set etc.. then these will be attached to the manually created accounts.  You can switch the MIS tag from the MIS imported accounts to the CSV imported ones, but it's on an individual basis in the users app.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...