garbage46

Update for those interested. I received an email from [email protected] asking for some further information in support of one of the applications I have submitted. Turns out I had typo'd the quote ID, but at least I know one of my applications has made it to the top of the pile! Fingers crossed for the decision soon.

Try this I created to loop through multiple sheets(tabs) with a Google Sheet. It could be that the element you're missing is using multidimensional arrays to loop through the sheets/tabs in your spreadsheet. Configure the variables with the mda array. Then run the heyHoLetsGo() function /** * * mda multidimension array can be used when multiple sheets to be to processed. * Each array format ['Sheet Name', 'Sent Column Number', 'Date Stamp Column number'] * 'Sheet Name' = The sheet name * 'Sent Column Number' = the column number of the column used to record if action has been taken e.g. email sent Yes/No * 'Date Stamp Column Number' = the column number of the column used to record date stamp the action was processed. * * *********************** * IMPORTANT: When counting in arrays, computers start counting at 0 not 1. * *********************** */ var mda = [ ['Starters', '20', '21'], ['Leavers', '7', '8'], ['Sheet 3', '20', '21'] ['Sheet 4', '20', '21'] ['Sheet 5', '20', '21'] ]; var l = mda.length; function heyHoLetsGo() { for (var c = 0; c < l; c++) { var currentTab = mda[c][0]; var firstCheckCol = mda[c][1]; var secondCheckCol = mda[c][2]; // test2(currentTab, firstCheckCol, secondCheckCol) checkForNewReport(currentTab, firstCheckCol, secondCheckCol) } } function test2(currentTab, firstCheckCol) { Logger.log("THIS IS THE TEST2 FUNCTION"); Logger.log("Current Sheet: " + currentTab); Logger.log("data[i][" + firstCheckCol + "]"); } function checkForNewReport(currentTab, firstCheckCol, secondCheckCol) { var sheetyMcSheet = currentTab; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); //Get the active Spreadsheet. var sheet = spreadsheet.getSheetByName(sheetyMcSheet); //Find the sheet we want. sheet.activate() //activate that sheet. var startRow = 3; // First row of data to process var numRows = sheet.getLastRow(); // Number of rows to process var dataRange = sheet.getRange(startRow, 1, numRows - 2, 56); var data = dataRange.getValues(); // Loop through all rows for (var i = 0; i < data.length; ++i) { var firstCheckCol = parseInt(firstCheckCol); // converting the col number into an integer var secondCheckCol = parseInt(secondCheckCol); // converting the col number into an integer if (data[i][0] != '') { // check timestamp column var emailAlreadySent = data[i][firstCheckCol]; Logger.log(getSheetName()); if (emailAlreadySent != 'Yes') { // send email notification to all staff listed in the function sendEmailNotification(currentTab, data[i]); // Set "Date Sent" cell in column to current date // Set "Email Sent" cell in column to "Yes" sheet.getRange(i + startRow, secondCheckCol + 1).setValue(Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy HH:mm")); // +2 to account for computer starts at zero and header row sheet.getRange(i + startRow, firstCheckCol + 1).setValue("Yes"); // +2 to account for computer starts at zero and header row } } SpreadsheetApp.flush(); } // End of Loop sheet.getRange('AH3').activate(); } function sendEmailNotification(currentTab, data) { var surname = data[7]; var forename = data[8]; var role = data[11]; var subject = 'New Activity'; var message = 'Hello, \n\nA new thing has happened on the ' + currentTab + ' tab regarding ' + forename + ' ' + surname +'. \n\nPlease see the new thing on the linked Google Sheet for more details: https://docs.google.com/spreadsheets/d/.......'; MailApp.sendEmail('[email protected]', subject, message); MailApp.sendEmail('[email protected]', subject, message); MailApp.sendEmail('[email protected]', subject, message); console.log(message); } /** * Returns the name of the active sheet. */ function getSheetName() { let activeSheet = SpreadsheetApp.getActiveSheet(); return activeSheet.getName(); }

Has anyone had any communication or confirmation from the "Adjudicator" in relation to their application for the new 12 month break clause following the Competition & Markets Authority decision back in January 23? The documentation states "The Adjudicator to communicate the outcome of the application to the Applicants between 10 February 2023 and 31 March 2023 (if no extensions)". So, I know we might need to wait a few more weeks. Having just gone through the process for this years annual entitlement and witnessing further attempts to trap customers in a new 3 year contract and I eager to begin the process of evaluating alternatives.

https://www.reed.co.uk/jobs/trust-it-operations-manager/49033220 We are seeking to appoint an experienced, highly enthusiastic and motivated Trust IT Operations Manager who will make an immediate impact in delivering successful outcomes supporting the delivery of a high quality, professional and forward-thinking IT service; aligned to the evolving needs of the academies and central services of the Trust. Supporting the Trust’s Strategic IT Lead, the Trust IT Operations Manager is responsible for working across the trust in the development, testing, implementation and maintenance of network infrastructure and systems across the academies in line with the Trust’s ICT strategy and policies. Duties include physical and virtual servers, end user devices, managed switches, wireless, firewall and filtering solutions.

Connect the Classroom funding as been approved for 8 schools in our MAT. All schools on a single domain. We have been moving towards installing Aruba switches if that makes any difference. We have been given the choice of Cisco Meraki or HP Aruba for a new wireless solution. There have been hints that the Aruba kit is more likely to be available (in stock). I am after opinions, pros and cons from those with experience of either solution. I guess there are quite a few of you who have been through or are going through a similar process.

Trust IT Technician Salary: £22,571-£24,920 dependent on experience (Grade E, points 12-17 on the NJC Pay Scale) Contract: Permanent Full Time (37 hours per week) 25 days annual leave + Bank Holidays Start Date: As soon as possible https://fcat.org.uk/job-vacancies/trust-it-technician

As always a little late to the party and throwing in my slightly different view on things... I would not include full copies of any emails which are mailing list or general business as usual for running the school, such as pupil lists sent to a group of staff, in which the requester is not the subject of the email. These can simply be summarised in your response along the lines of: ICO advice of this page How do we find and retrieve the relevant information? gives an example with the words "You do not have to provide the employee with a copy of each email" I am 99% sure I was given this advice by the ICO helpdesk on two separate occasions. But as others have pointed out the legal claim aspect could skew things - get legal advice! If you need a recommendation -> Dai Durbridge at https://www.brownejacobson.com/

https://fcat.org.uk/job-vacancies/fcat-it-support-technician

The email

So, have we gone from "3 years good! 1 year never" to "how does six months sound?"

I recently moved house, signed up to Sky and had a new fibre line installed straight into my home office. For a week or two some apps on my android phone would not work, others would work but very slowly. For example I could only access my Nest thermostat over 4g (WiFi off). I tried everything my tiny brain could think of; changing WiFi channels, 2.4GHz only, 5 GHz only. Speed tests would with be 150MB or 0. Hard wired PC was fine. One day I just did the old turn it off turn it in again and everything has been closed to perfect from then on. Conclusion: Probably some messed up IP or DNS cache on the router �� Problem free for over two months now �� just those first 7-10 days.

What exactly is core SIMS? On our renewal quotes we have modules like Assessment Reporting Suite, Attendance, Lesson Monitor, then there is Start-Up Kit II (Core, Reporting, Personnel, SENCO) Are all modules core SIMS or is the module with "core" Core SIMS? Can I have Core on three years, the modules on one year?

This guy https://www.whatdotheyknow.com/user/gareth_jackson?page=1 Spamming the same FOI requests to schools, currently up to around 670 requests sent since May 2021.

I have asked again today. We would like a one year or a two year deal. Different person, same response. No deal. I wonder how many schools are part way through multi year agreements with third party support or addons for SIMS which may have influence any decision to stick or move. No need to make a decision today, we all have until the end of March essentially or possibly even until the next census window after that. The MIS providers going to BETT have an opportunity to really demo and show off their products.

I use Google Data Studio for free... not quite as feature packed as Power BI but getting there and updates have been rolling out rapidly over the past 18 months. CommandReporter with some MSSQL and SSIS for ETL. Google Drive File Stream thingy to sync to "cloud" App Scritps with scheduled triggers for importing new csv's to Google Sheets Google Sheets as data sources for Data Studio dashboards. All locked down and secured through standard Google stuff, just like Google Drive. https://datastudio.google.com/overview

So, I have just emailed our ESS account manager for some updates and received an automated response... I wonder if they also went to Arbor/Bromcom/insert MIS here

Academies have the freedom to sign SLA's and contract with the provider of their choice, this includes your LA. Out MAT still has a number of SLA's with our LA. Similarly, you can get your support from your preferred supplier; ESS, LA or other provider

here is a bit of a hack solution, but it should work. Steps below: (1) Scheduled Batch File to Run CommandReporter to get data in .csv then open an prepared Excel workbook (2) Use the Workbook_Open() function to run the code below that will clear the sheet and import the new .csv (3) add in your code to create the Pivot Table that generates the house points score (4) add in the code to export cell to .txt 3 and 4 can be separate functions called from Workbook_Open() or just included in one massive Sub BATCH FILE "C:\program Files (x86)\SIMS\SIMS .net\commandreporter.exe" /user:[color="#0000FF"]edugeek[/color] /password:[color="#0000FF"]12345678 [/color]/report:"[color="#0000FF"]housepoints export to text[/color]" /output:"[color="#0000FF"]f:\datasync\housepoints.txt[/color]" start excel.exe "[color="#0000FF"]f:\datasync\spreadsheet.xlsm[/color]" EXCEL CODE Private Sub Workbook_Open() Dim Ws As Worksheet Dim FileName As String Set Ws = ActiveWorkbook.Sheets("[color="#FF0000"]Sheet1[/color]") [color="#008000"]'CHANGE AS NEEDED[/color] FileName = "[color="#0000FF"]f:\datasync\housepoints.txt[/color]" [color="#008000"] ' *** CODE REPEATS TWICE TO CLEAR TO PREVIOUS DATA PROPERLY ***[/color] Cells.Select Selection.ClearContents Range("A1").Select With Ws.QueryTables.Add(Connection:="TEXT;" & FileName, _ Destination:=Ws.Range("[color="#0000FF"]A1[/color]")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With Cells.Select Selection.QueryTable.Delete Selection.ClearContents Range("A1").Select With Ws.QueryTables.Add(Connection:="TEXT;" & FileName, _ Destination:=Ws.Range("[color="#0000FF"]A1[/color]")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With [color="#0000FF"][PIVOT TABLE FUNCTION OR CODE HERE] [/color] [color="#008000"]' *** EXPORT CELL VALUE TO TEXT FILE ***[/color] Dim myFile As String, cellValue As Variant myFile = "[color="#0000FF"]C:\temp\edugeek.txt[/color]" cellValue = Range("[color="#0000FF"]A1[/color]").Value Open myFile For Output As #1 Print #1, cellValue Close #1 ActiveWorkbook.Save [color="#008000"] '****** '* comment out Application.Quit line until you are happy the code works are intended. '* once saved this spreadsheet will always close when opened '* ~WORKAROUND~ open Excel. File -> Open, browse to file '* the hold down SHIFT key and open file. Hold shift until file open. '******[/color] Application.Quit End Sub

Add this to a batch file and set up a scheduled task. "C:\program Files (x86)\SIMS\SIMS .net\commandreporter.exe" /user:[color="#0000FF"]edugeek[/color] /password:[color="#0000FF"]12345678[/color] /report:"[color="#0000FF"]housepoints export to text[/color]" /output:"[color="#0000FF"]f:\datasync\housepoints.txt[/color]" Change the parts in blue:- username, password, report, text file output path Remember to include folder path in the "Start In Optional" path. I have encountered issues when leaving this part blank

ESS say no one has been given a one year renewal and do not know where that information came from. Reading between the lines I believe that the original terms and conditions are not legal, specifically the February auto renewal part which could lead to new terms and conditions in which this auto renewal will be removed. If everyone holds out as long as possible they may have to offer one year renewals. *HODL*

Here you go, some simple VBA to write cell value to a .txt file Just change the myFile path and cellValue range Sub eduGeek() Dim myFile As String, cellValue As Variant myFile = "C:\temp\edugeek.txt" cellValue = Range("A1").Value Open myFile For Output As #1 Print #1, cellValue Close #1 End Sub

Can you share the content/format of text file you intranet site is reading from? You can probably use CommandReporter to generate a .txt file

Just came to post the same thing

Interesting that The Key have created a page of guidance because of this nonsense. https://schoolleaders.thekeysupport.com/administration-and-management/financial-management/procurement-and-payment/renewing-mis-contracts-your-rights-and-responsibilities/ Also interesting that no reps for ESS SIMS or whatever have commented on this thread.

Does anyone have a phone number I can call to complain and request a one year renewal?