+ Post New Thread
Results 1 to 5 of 5
Virtual Learning Platforms Thread, LP+ Usernames in Technical; Hi Guys, We're finally starting to make some headway at my school with the LP+ VLE with some material uploaded ...
  1. #1

    Join Date
    Jan 2009
    Location
    Northampton
    Posts
    145
    Thank Post
    14
    Thanked 11 Times in 11 Posts
    Rep Power
    12

    LP+ Usernames

    Hi Guys,

    We're finally starting to make some headway at my school with the LP+ VLE with some material uploaded and the sites setup. We are now ready to give our year 11's their usernames and passwords to start using the system.

    The problem giving the usernames out. I want to create a mailmaerge using Sims that will conatin student name, form, their new VLE username, password and email address. The spreadsheet LP+ provides is in the following format:

    AccountName Forename Surname Password Email

    Does anyone know anyway I can automate the creation of letters rather than copying and pasting the details into over 1000 letters to studentS?

    Any help/advice will be greatly appreciated!!!

    :-)

  2. #2


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,699
    Thank Post
    352
    Thanked 804 Times in 719 Posts
    Rep Power
    348
    Without the use of a primary/foreign key between the two data sets I don't know how you could do this unless the names are unique within the dataset, IE, there is only one John Smith.

  3. #3

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72
    Quote Originally Posted by hillskill View Post
    Hi Guys,

    We're finally starting to make some headway at my school with the LP+ VLE with some material uploaded and the sites setup. We are now ready to give our year 11's their usernames and passwords to start using the system.

    The problem giving the usernames out. I want to create a mailmaerge using Sims that will conatin student name, form, their new VLE username, password and email address. The spreadsheet LP+ provides is in the following format:

    AccountName Forename Surname Password Email

    Does anyone know anyway I can automate the creation of letters rather than copying and pasting the details into over 1000 letters to studentS?

    Any help/advice will be greatly appreciated!!!

    :-)

    Are your LP+ usernames based around UPN?

    If so export your list from SIMS, stick it next to the LP+ list in excel, a quick formula to compare the username (LP+) & UPN (SIMS), correct any errors.

    Once that's done just mailmerge away.

  4. #4

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,998
    Thank Post
    1,359
    Thanked 1,831 Times in 1,137 Posts
    Blog Entries
    19
    Rep Power
    602
    LP+ usernames for students are based around the first 2 characters of first name, the first 2 characters of family name followed by an incrementing number.

    The closest I can suggest (and will shortly check for you) is that the order of return is the same as the order of input. That way you should be able to just match the columns up.

  5. #5

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,998
    Thank Post
    1,359
    Thanked 1,831 Times in 1,137 Posts
    Blog Entries
    19
    Rep Power
    602
    The order is not completely correct to the order you sent it across (due to the odd user not provisioning properly and having to go through again) but it should be close. You may need to add some extra rows / cells in to get it to match.

    The other option is to give the helpdesk a call (0870 609 4405) and talk things through to see what you can get out of the system. Fresh provisioning should now include UPN and year as well as a help to others going through the same.



SHARE:
+ Post New Thread

Similar Threads

  1. Adding names to usernames in AD
    By a_d_atkinson in forum How do you do....it?
    Replies: 3
    Last Post: 10th March 2009, 12:05 PM
  2. Monitoring a group of usernames not machines
    By Obiwan in forum Network and Classroom Management
    Replies: 1
    Last Post: 21st October 2008, 03:38 PM
  3. ISA2006 logging client usernames
    By adamf in forum Windows
    Replies: 1
    Last Post: 30th April 2008, 09:34 PM
  4. Usernames
    By wesleyw in forum Learning Network Manager
    Replies: 20
    Last Post: 21st June 2007, 08:00 PM
  5. Kids Usernames
    By Gatt in forum How do you do....it?
    Replies: 37
    Last Post: 18th September 2006, 11:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •