Janx1975 Posted June 27, 2018 Posted June 27, 2018 Hi, I have just been tasked with getting staff work emails into their existing SIMS accounts for some online service enrolment, most staff appear to have personal email addresses or non at all etc. Is there a (foolproof) tool that would allow me to be able to import a list of emails to a list of existing staff entries? I dont really want to be entering 100+ email addresses in manually... but I cant see a way from my forays with google and edugeek search. 1
fiza Posted June 27, 2018 Posted June 27, 2018 Our SIMS Support Unit did this for us. Afaik we just provided a CSV with details of email addresses. 2
MrMat Posted June 27, 2018 Posted June 27, 2018 Yup speak to your Support Unit/Capita. Taken from MyAccount: Log a case with the SIMS Service Desk and request a copy of patches 23212 and 17195, the DBDIAGNOSE_EMAIL_PHONE_IMPORT_REPORT.sql script and the instructional document. You will need to follow the instructions in the document to create the CSV file to import the information into SIMS.net. Patch 23212 will read the CSV file and import the applicable email and/or telephone details. It will also write a log file to the SIMS database that the SQL script will report on. These results will include details of any records that were not imported. Patch 17195 will then delete the temporary log file that was created by patch 23212. It's a bit fiddly but it's not too bad. 1
Janx1975 Posted June 27, 2018 Author Posted June 27, 2018 Thanks I will get a CSV ready for them and cross my fingers!
Janx1975 Posted July 3, 2018 Author Posted July 3, 2018 I have just compiled the .csv and will be doing the import on Thursday after school - any idea how long it generally takes to complete this from your experience MrMat?
MrMat Posted July 3, 2018 Posted July 3, 2018 I have just compiled the .csv and will be doing the import on Thursday after school - any idea how long it generally takes to complete this from your experience MrMat? It's been a while but it's pretty quick if I remember correctly.
matt40k Posted July 3, 2018 Posted July 3, 2018 If only you had a tool that could do it yourself... https://simsbulkimport.uk/ 2
bobsmith Posted July 4, 2018 Posted July 4, 2018 If only you had a tool that could do it yourself... https://simsbulkimport.uk/ hey matt - if only you posted a link that you could actually download from..... https://simsbulkimport.uk/Download/ Janx1975 - I did it the lazy way - get the admin staff to input them and make it part of the standard record creation procedure from now on 1
matt40k Posted July 4, 2018 Posted July 4, 2018 You can download it... just got to ask the right question to the right people (not me!) Also I thought this was baked into SIMS now? - http://www.edugeek.net/forums/mis-systems/191767-updating-field-spreadsheet.html#post1642781
Janx1975 Posted July 4, 2018 Author Posted July 4, 2018 I will look into this tool for Admin staff to use following the bulk import that I will have to do this time round, many thanks! I am a new Network Admin, and "SIMS stuff" was always done by my NM in my previous employment so I never got my hands dirty with it. I'm already fed up with having to wait until staff logout of SIMS! lol.
bobsmith Posted July 4, 2018 Posted July 4, 2018 You can download it... just got to ask the right question to the right people (not me!) Also I thought this was baked into SIMS now? - http://www.edugeek.net/forums/mis-systems/191767-updating-field-spreadsheet.html#post1642781 That thread looks like it's only true of UDFs....
jmak Posted July 4, 2018 Posted July 4, 2018 You can download it... just got to ask the right question to the right people (not me!) Also I thought this was baked into SIMS now? - http://www.edugeek.net/forums/mis-systems/191767-updating-field-spreadsheet.html#post1642781I think that's only for User Defined Fields... Any chance one of the right people could pm me? [emoji6]
jmak Posted July 6, 2018 Posted July 6, 2018 I think that's only for User Defined Fields... Any chance one of the right people could pm me? [emoji6]Bump: Still hoping that one of the right people might PM me.... [emoji85][emoji86][emoji87]
Boredguy Posted July 6, 2018 Posted July 6, 2018 Must admit, I manually added all our staff e-mail accounts into SIMS. Took a lot less time than doing the Y7's each year
matt40k Posted July 7, 2018 Posted July 7, 2018 Bump: Still hoping that one of the right people might PM me.... [emoji85][emoji86][emoji87] You're google skillz are failing you ... http://www.edugeek.net/forums/sims-bulk-import/99098-sims-bulk-import-5.html#post1563549 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now