Search the Community

Hi, We have created a UDF field for pupils (single line) and need to import for all pupils. On my CSV I have two fields (to make things easy), Admission Number and UDF data. When I run through the import procedure, the Admission number is used to match and finds the pupil information. But when it comes to importing the new data into the UDF, the report shows "NOT IMPORTED". When I checked the logs, this looks like the entry where it fails. 05/08/2015 10:18:46 Trace Set UDF: False - 15670 - ca281102 Any ideas on how I can get this working? Much appreciated, Pete

So first intake with the new exchange server, unlike the old 2007 I can't bulk select 117 users and click create mailbox. Now I have to use the superior powershell method! or do it 1 at a time Enable-Mailbox [email protected] -Database "Mailbox Database 0768102315" This command works great is simple and clear! Now how to use it with the other 116 pupils? I'm thinking I need to tell it to look at a csv how do I do this. I think that the CSV only needs the upn in it. Examples on line seem to include unnecessary details in the CSV and use them in the script? SIDENOTE: This is the first step I'll migrate to o365 later. (if I give the pupils emails from within o365, although they work the local exchange server is unaware of them, I worry what that may mean in the future.) Hybrid.

Hello, Sorry if this is an easy question, I am not that proficient with SIMS. We have entered a lot of results in one column (let's say targets) that I want to delete. If I go to the marksheet, and clear the cell, it doesn't really remove it. I have found a tedious workaround but I believe there should be a quick way to delete the whole column at once. Can anyone tell me the trick? Thanks a lot, you are the best.

Is there any way (please say there is) to bulk import clients into italc from a text file? There's an export function - surely there should be an import? Or am I just blind?

Hi.. We're a small educational charity who need to communicate with 200 parents on a weekly basis. We need to be able to group parents together so we can send out group messages as well as individual messages. We also need to be able to schedule messages to be sent at certain times. Currently we use Text Magic, however we are now sending 40-50k texts a year and it's costing close to £2k. We also have some parents asking for email communication instead of texts. Can anyone recommend something similar to Text Magic which also has email functionality and will be more cost effective? or an email alternative without the texting. We're based in the UK. I know about ParentMail but I think it might be too expensive for us. Thanks!

import_users.zip I've been working on and tweaking this code for the last few days in-between the other normal jobs that we all have to do and this is the result. <# .SYNOPSIS Import AD Users from a CSV File. .DESCRIPTION Import AD Users from a CSV File. The script will request user input for a password and LOG / CSV file and then just get on with the task at hand. .NOTES Authors: © Alex Haines Modified for use at Millfields First School in Bromsgrove by Alex Haines in December 2010. Original basic code was from a TechNet forum post - http://social.technet.microsoft.com/Forums/en-US/ITCG/thread/5b0420a6-2ff7-445f-8887-07c295073f45 Some other code was taken from another TechNet post later on to add Home Folder features - can't credit as can't remember - sorry! Last edited on 09th February 2011. This script ASSUMES a Domain called "millfields.local" You must edit appropriate spots to reflect the CORRECT domain name in your environment. Also ensure and test in a TEST domain vs production before unleashing the script. YOU HAVE BEEN WARNED!!! .PARAMETER CSVFilePath Path of CSV file to import .PARAMETER LOGFilePath Path of ERROR LOG file if needed during script processing .EXAMPLE import_users.ps1 -CSVFilePath C:\Scripts\Users.csv -LOGFilePath C:\Scripts\ErrorLog.txt #> # Forcefully request info on where the LOG & CSV file should be created. param ([parameter(Mandatory=$True,HelpMessage='Path of ERROR LOG file to write to:')]$LOGFilePath, [parameter(Mandatory=$True,HelpMessage='Path of CSV file to import from:')]$CSVFilePath) # Test for existence of supplied LOG - if not exit. if (Test-Path $LOGFilePath){ Write-Host '' Write-Host 'The Path to the ERROR LOG file appears to already exist. APPENDING TO & CONTINUING SCRIPT!' $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': The chosen LOG file (' + $LOGFilePath + ') already exists! Do not panic, I will just append to it.' | Out-File $LOGFilePath -append } else{ Write-Host '' Write-Host 'The Path to the ERROR LOG file is not valid. CREATING & CONTINUING SCRIPT!' $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': The chosen LOG file (' + $LOGFilePath + ') was not valid! Do not panic, I will just create it.' | Out-File $LOGFilePath -append } # Test for existence of supplied CSV - if not exit. if (Test-Path $CSVFilePath){ Write-Host 'The Path to the CSV file appears valid. CONTINUING SCRIPT!' Write-Host '' $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': The chosen CSV file (' + $CSVFilePath + ') exists so the script continued!' | Out-File $LOGFilePath -append } else{ Write-Host 'The Path to the CSV file appears invalid. EXITING SCRIPT!' Write-Host '' $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': ERROR 4 - The chosen CSV file (' + $CSVFilePath + ') did not exist so the script had to be terminated as there was no work to do!' | Out-File $LOGFilePath -append Exit } <# Get a temporary password for the users. If you don't the accounts will create no problem but they will be "Disabled" accounts. This will mean you have to go through and enable them after the import. As we don't really want to have to do this, I advise you leave this step in place - you could hardcode the $Password variable if you wanted as it makes no real difference. For Secure Mode use -AsSecureString (This blanks out the password as you type and hides it from view when using 'Up Arrow'). #> $Password=READ-HOST 'Enter a Temporary Secure Password (eg Golf!911)' -AsSecureString <# Go through EACH item in the list (Header row is treated as variable names by default) #> $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': Start of the main loop.' | Out-File $LOGFilePath -append FOREACH ($USER in (IMPORT-CSV $CSVFilePath)) { <# I could just Assign straight in from the Cmdlet but I'm putting them into Individual variables so you can see how the data is referenced (check your CSV headers, those are the exact names but are NoT cAsE sEnSiTiVe). A standard csv from county will be given with 6 Headers givenName | sn | gname | department | uname | ctPassword #> $FirstName=$USER.givenName $LastName=$USER.sn $JobTitle=$USER.gname $Department=$USER.department $Username=$USER.uname $Password=$USER.ctPassword <# You will see that most of the lines below don't have any data in them - this is deliberate as in most situations, the schools won't need them. If you do, just replace with the correct header name as your csv file requires in the format =$USER.header #> $Title='' $Office='' $Email=$Username+'@millfields.worcs.sch.uk' $Extension='' $Mobile='' $Address='' $City='' $StateProv='' $PostalZip='' $Country='' $ImmediateSupervisor='' $HomeDirectory='\\ALABAMA\Homes$\'+$Username $HomeDrive='Y:' $ProfilePath='\\ALABAMA\Profiles2010$\'+$Username $LogonScript='student.bat' $Domain='millfields.local' $UPN=$Username+'@'+$Domain $DisplayName=$Username+' - '+($FirstName+' ').Substring(0,1).Trimend()+'.'+$LastName $Company='Millfields First School' $PhoneNumber='01527 831 885 + '+$Extension $Web='http://millfields.networcs.net' $Description=$FirstName+' '+$LastName+' belongs to the '+$JobTitle+' group and joined the school in '+$Department+'.' $Fax='' <# SAM USERID cannot be greater than 20 characters so trim away - LEGACY! #> $SAM=(($Username+' ').Substring(0,20)).Trimend() <# Check to see if the user already exists. If it does add it to an error log and then continue with the next user. If it doesn't then add the user and loop. #> $count = Get-QADUser –samAccountName $SAM | Measure-Object if ($count.count –gt 0) { Write-Host 'The user'$SAM' failed. This is because the user already exists!' $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': The user ' + $SAM + ' failed. This is because the user already exists!' | Out-File $LOGFilePath -append } else { # Create the home folders and assign permissions. # Checks starting character of accname and load balances to two (or more) servers if desired. $server1 = 'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z' #$server2 = 'o','p','q','r','s','t','u','v','w','x','y','z' Switch ($SAM.substring(0,1).tolower()) { { $server1 –contains $_ } { $homeserver = '\\alabama\'; break; } { $server2 –contains $_ } { $homeserver = '\\alaska\'; break; } } # Test for non-existence of created home directory - if not skip creation. if (Test-Path $homeserver'Homes$\'$SAM){ Write-Host exists? $homeserver'Homes$\'$SAM $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': ERROR 6 - User ' + $SAM + '.' | Out-File $LOGFilePath -append } else { # Make the directory. Mkdir ($homeserver + 'Homes$\' + $SAM) } # Construct two commands to add Read/Write access to the directory. $cacls1 = "cacls " + $homeserver + "Homes$\" + $SAM + " /E /G " + $SAM + ":R" $cacls2 = "cacls " + $homeserver + "Homes$\" + $SAM + " /E /G " + $SAM + ":W" $cacls3 = "cacls " + $homeserver + "Homes$\" + $SAM + " /E /G " + $SAM + ":F" $cacls4 = "cacls " + $homeserver + "Homes$\" + $SAM + " /E /G " + $SAM + ":C" # DEBUG #Write-Host $cacls1 #Write-Host $cacls2 #Write-Host $cacls3 #Write-Host $cacls4 # Now create the user. NEW-QADUSER -ParentContainer $Domain'/Imported' -Name $DisplayName -UserPassword $Password -City $City -Company $Company -Department $Department -email $Email -FAX $Fax -Firstname $FirstName -Lastname $LastName -Mobilephone $MobilePhone -Office $Office -Phonenumber $PhoneNumber -Postalcode $PostalZip -samaccountname $SAM -StateorProvince $StateProv -StreetAddress $Address -Title $JobTitle -UserPrincipalName $UPN -webpage $Web -Description $Description -displayname $DisplayName -HomeDirectory $HomeDirectory -HomeDrive $HomeDrive -ProfilePath $ProfilePath -LogonScript $LogonScript $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': The user ' + $SAM + ' succeeded.' | Out-File $LOGFilePath -append # Run the two commands. cmd /c $cacls1 cmd /c $cacls2 cmd /c $cacls3 cmd /c $cacls4 } } # Close the log file. $(Get-Date -format "dd/MM/yy HH:mm:ss") + ': EoF' | Out-File $LOGFilePath -append ' ' | Out-File $LOGFilePath -append The code works well and successfully imported my users into AD with their home folders all correctly assigned. The only thing I had to do afterwards was move the users from the Imported OU to the correct OU and assign them to any groups, but this is very easy to do. Feel free to modify or recommend changes, but please post them back on this forum or send me a PM. Also, if you are going to use it or republish it, please link back to this post so Edugeek can get some more members. Oh and if anyone is wondering why I didn't use one of the many other scripts out there, I found that none of them would work in a Server 2008 R2 environment!

Hello! Our headteacher wants to know how to send an email to ALL STAFF without having to add individual emails one by one to a distribution list. How can I set up these groups centrally as admin so they appear on everyone's lists? I'd like to be able to do it via a csv or something. Or by being able to select all the emails already in the system and putting them in that way. It's a horribly convoluted system this Outlook 365 Hope you can help!!

I am looking for a way of adding applicants on to SIMS quickly. I can see there have been a few threads on this with similar senarios, but I have not found the answer yet, and those threads have not had replies in a while. We are a sixth form free school academy, taking applicants from many schools in the area. Applications come to us through a local online applcation system, and via our website (as we take students from across 3 local authorities). I have combined the data from the systems into an excel file to have a common format for all applications. I am looking at entering some of this data into SIMS, previously this has been done one applicant at a time, directly in SIMS, but I am hoping there is a more efficient way. Having all the data in a spreadsheet I was hoping with a few tweaks I could upload it directly to SIMS, but having been given the permissions to add data into SIMS I realise this is not as straightforward as I'd hoped. I would appreciate any guidance or experience anyone has to offer. Thanks Doug

Can anyone recommend a bulk user creation tool or powershell script that can create active directory users & exchange 2010 mailboxes? I would like to be able to do the following: Create AD users & mailboxes from a CSV script Check and deal with duplicate users Set profile path Add to groups Set login script path Create home dir & permissions Many Thanks in advance.