Banjo

Data Review is just an aspect that has been added to a template that cannot be edited from within that Marksheet. Effectively making it a read-only column – good for things like Key Stage results/TAs. If this is the case then the original Marksheet where the data was entered may no longer be on the system and could have been deleted. Does the aspect heading have the infinity (f) symbol in the column heading. If it doesn’t then the above applies. If it's a "Data Review using a Formula" column then it's a virtual ‘temporary’ aspect and has to be generated from within that template/marksheet. If it’s a “Data Entry using a formula” aspect on the marksheet then potentially the ‘result’ aspect that you can see can be used in more than one formula across any templates/marksheet. Each time someone calculates from another marksheet the results in this template can change. You will need to search across every every template/formula to look for the aspect name to see if it’s been used by accident. There is a bug I’ve seen in AM, where by importing templates certain aspects are switched around in the templates and formulas.

This site is worth taking a look at. https://www.gov.uk/government/publications/data-protection-and-privacy-privacy-notices Include any changes or sharing of data into your schools privacy notice. The priviacy notice should be available on request at the school office and should ideally go out to students/parents as part of the "induction pack".

True, but Schoolcomms is probably the most integrated into SIMS than the rest.

There should guidance notes on this from AL.

You could make them an additonal marksheet with just FSM in it?

Speak to Schoolcomms, what your asking can be done with their product. Timetable and also the students exam timetable can be made available via the App. If you use SIMS behaviour then the parents can get an instant notification via the app when their kids get reward in class or have been misbehaving. Products - Schoolcomms They are more importantly a really nice bunch of people who will bend over backwards to sort any issues out.

This is the best place: https://www.gov.uk/government/organisations/department-for-education/about/statistics

Can you ping the server from the affected workstations when they can't connect? Do you use the server name or the IP address in the connect.ini file as it might be worth switching these around to test ? Bad switch or a bad port maybe, has part of the network dropped from a gig down to 100mb?

The pointed I have clearly failed to make is - Do you tick the box exclusively for pupils who have been PP funded for that year OR for everyone the school knows is eligible for the funding i.e. in receipt of a FSM, but joined the school after the census and was not included by the DfE in the funding round for that year. There is a big difference. I’ve argued that there should be two tick boxes:– 1) PP eligible & funded by the DfE for that year 2) PP eligible but not funded by the DfE for that year

But what is 'PP status’? Is it pupil eligibility for PP or the school/pupil in direct receipt of PP funding for that year? Phil from his above reply thinks the tick box represents an entitlement to a free lunch!

This is one area of SIMS that is a little confusing. In school you have pupils who due to their contextual circumstances are entitled to a FSM and attract PP funding. You also have pupils who are in receipt of FSM due to their contextual circumstance but are not yet PP funded at the establishment due to their FSM/onroll date. In SIMS in Panel 9 (Meals) there is already a tick box for Free Meal with PP underneath?? What schools want to know is the number of pupils they have been PP funded for from the DfE £1320 etc and the total number of PP eligible pupils they have in school – not necessarily the same thing.

Do you mean KS2 to KS4?

drag and copy from the template, open excel and paste in.

Do you want different clients and dbs or just different dbs on the same PC? You can copy and paste/rename the sims .net folder (contains pulsar) and run that from any location. By editing the connect.ini you can connect to an old db. This doesn't have to be updated and can be used to access an old archived DB. You can run 1 client and connect to many db's by editing your connect.ini file. [sIMSConnection] ServerName=mis\SIMS2012 DatabaseName=sims DatabaseMode=OnLine [simsdatabases] FriendlyName0=sims1 Server0=mis\SIMS2012 databasename0=sims1 Databasemode0=OnLine FriendlyName1=sim2 Server1=mis\SIMS2012 DatabaseName1=sims2 DatabaseMode1=OnLine FriendlyName2=sims3 Server2=mis\SIMS2012 DatabaseName2=sims3 DatabaseMode2=OnLine [sIMSOffline] PreviousRedirect= PreviousServerName=mis\SIMS2012 PreviousDatabaseName=sims1 PreviousDatabaseMode=OnLine

This is the SQL Config ini file that contains the settings that Capita use to install SQL Express. Our instance name was SIMS2012 and the server name is mis-db-001. You could adapt this to install the full version of SQL when migrating or upgrading your instance. ;SQL Server 2012 Configuration File [OPTIONS] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Detailed help for command line argument ROLE has not been defined yet. ROLE="AllFeatures_WithDefaults" ; Detailed help for command line argument ENU has not been defined yet. ENU="True" ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block. UIMODE="AutoAdvance" ; Setup will not display any user interface. QUIET="False" ; Setup will display progress only, without any user interaction. QUIETSIMPLE="True" ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found. UpdateEnabled="False" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server Data Tools, and other shared components. FEATURES=SQLENGINE,REPLICATION,SNAC_SDK ; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services. UpdateSource="MU" ; Displays the command line parameters usage HELP="False" ; Specifies that the detailed Setup log should be piped to the console. INDICATEPROGRESS="False" ; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. X86="False" ; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed. INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" ; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed. INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" ; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS). INSTANCENAME="SIMS2012" ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance. INSTANCEID="SIMS2012" ; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature. SQMREPORTING="False" ; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature. ERRORREPORTING="False" ; Specify the installation directory. INSTANCEDIR="C:\Program Files\Microsoft SQL Server" ; Agent account name AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" ; Auto-start service after installation. AGTSVCSTARTUPTYPE="Disabled" ; CM brick TCP communication port COMMFABRICPORT="0" ; How matrix will use private networks COMMFABRICNETWORKLEVEL="0" ; How inter brick communication will be protected COMMFABRICENCRYPTION="0" ; TCP port used by the CM brick MATRIXCMBRICKCOMMPORT="0" ; Startup type for the SQL Server service. SQLSVCSTARTUPTYPE="Automatic" ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). FILESTREAMLEVEL="0" ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="True" ; Specifies a Windows collation or an SQL collation to use for the Database Engine. SQLCOLLATION="Latin1_General_CI_AS" ; Account for SQL Server service: Domain\User or system account. SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="MIS-DB-001\Administrator" ; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication. SECURITYMODE="SQL" ; Provision current user as a Database Engine system administrator for SQL Server 2012 Express. ADDCURRENTUSERASSQLADMIN="True" ; Specify 0 to disable or 1 to enable the TCP/IP protocol. TCPENABLED="1" ; Specify 0 to disable or 1 to enable the Named Pipes protocol. NPENABLED="0" ; Startup type for Browser Service. BROWSERSVCSTARTUPTYPE="Disabled"

In Exams - you make a marksheet, put a tick against the students you want to enter for an exam and press save. The make a exams entry file, by pushing a button and then upload that to the exams board. If you remove or add a tick from the marksheet (eg a student drops out) then you make an amendment file that you upload to the exam board. Results file come back to the schoool and you click on a button to import them - simple really. Having said that, the Exams module can be a pain in the backside managing the basedata!

The Sims db isnt already in the SQL 'Data' folder ?

Run SQLApplicationsetup.exe and make sure it goes into the right SQL BIN folder. Run Db attach from that folder. Depending on your SIMS version it should be March 2015 or later in the details tab.

Have you tried moving them one at a time? Start with Sims and get that across. Then FMS, then discover. Have you checked you have logged into both SQL instances and not the same one twice?

And Solus 3 helps how?

Is the new server running the lastest (or the same) version of SIMS as the old server? What version of DBattach are you using on the new server? "Login to SIMS on the new test server - seems to be taking a while to load - not got the invalid username or password box or incompatible database box yet ... buggar, spoke too soon - incompatible database!"

Login to SIMS on 2008 create a new backup from system manager. Use the dbattach in the 2014 BINN folder and restore that over the top of the exisiting DB. That should work. On the new server you have two connect ini ? local in program files (should say redirect) and the one in the shared folder? Do they both point to 2014?

I don't think the migration tool works across servers. Deattach the DB's from the old server and copy and paste it to the root of your new server. On your old server move the DB into a new folder and reattach to 2008. On the new server attach the DB's and make sure the ini points to 2014. Login, and then setup the docserver and attach a blank text files to a student’s record to test. Copy the old documents across into the new 2014 folder that will have been created. If you use Discover you can use the backup utility to create a backup that you can then restore on the new server. Don't use sims dB attach or fms attach for this. The client updates will be a pain and its a config file rather than a .ini to update. If you use FMS then you will need a patch to enable filestream on the new instance. You can use the same process to migrate as Sims, but you may have to change quite a few workstation FMSConnect.ini files depending on how its configured. Good Luck!

That's normal. Create a new folder in the data directory (SQL2008) and cut and paste the DB's into that new folder. If they move, then they are no longer attached to the instance. Update your connect.ini to point to 2014 and all done - (unless you used redirect) which I wouldn’t recommend.

If for example collecting 10 results in a Marksheet per student, you can set the last column up (#11) to be a calculated field that checks for blanks in the first 10 and changes colour to RED or displays the word Incomplete etc,