Search found 177 matches

by robinwilson16
Wed Jan 24, 2018 11:54 pm
Forum: Announcements
Topic: Spammers!
Replies: 0
Views: 2224

Spammers!

Hello All Really sorry but I just realised the forum was getting hit with some serious spam. In total I have had to delete over 70,000 topics mainly about essay writing. I have also enabled further validation checks on new user registrations and restrictions on how many posts a new user can make. Du...
by robinwilson16
Tue May 16, 2017 11:30 pm
Forum: Information Interface (II) Screens
Topic: On Selected Index Changed within II
Replies: 1
Views: 1640

Re: On Selected Index Changed within II

Hello Ryan Sorry I'm not able to help with this as this is not something I have worked with and I don't believe we have the required II licence. If this is a web app, you aren't able to use standard JavaScript for this are you where maybe it could be outputted as part of the HTML? What about testing...
by robinwilson16
Tue May 16, 2017 11:26 pm
Forum: Servers and IT
Topic: VT2000 and UNIT-e
Replies: 2
Views: 1928

Re: VT2000 and UNIT-e

Hello Stuart Thanks for your reply. Can I ask how you know which scale each staff member is on without a connection to iTrent. Do you use another system for payroll? I think the main challenge is getting the other systems set up in the way they need to be to support VT2000. One problem we have is th...
by robinwilson16
Tue May 16, 2017 11:19 pm
Forum: SSRS/SQL Code Snippits
Topic: Calculating QCA Points and Generating ALPS Target Grades Using SQL
Replies: 4
Views: 1892

Re: Calculating QCA Points and Generating ALPS Target Grades Using SQL

Hello Mark The problem is that UNIT-e doesn't use standard SQL sequences and just uses a standard table which holds the current value of the sequence and all tables in the system use this table and field for their ID column. For this reason, to make the statement transaction-safe, avoid locking the ...
by robinwilson16
Tue May 16, 2017 12:36 am
Forum: SSRS/SQL Code Snippits
Topic: Graphical display of timetables
Replies: 1
Views: 508

Re: Graphical display of timetables

Hello Chaminda

Hope you are well!

Yes me too. I can imagine this getting quite complicated when events start overlapping with each other too.

Robin
by robinwilson16
Tue May 16, 2017 12:33 am
Forum: Bugs and Issues
Topic: Business Rule or Default?
Replies: 1
Views: 1541

Re: Business Rule or Default?

Hello Mark We have dome something similar to this so I think it would probably work for what you are trying to do. We have an II screen with two sets of studentperiodicilrcustom records and we filter these by going to the Data Manager and then entering the custom type value against Filter and Defaul...
by robinwilson16
Mon May 15, 2017 11:33 pm
Forum: SSRS/SQL Code Snippits
Topic: Calculating QCA Points and Generating ALPS Target Grades Using SQL
Replies: 4
Views: 1892

Calculating QCA Points and Generating ALPS Target Grades Using SQL

I have written some scripts to calculate the QCA points score for learners and then generate ALPS target grades for level 3 enrolments. Some features/limitations are: Merges data from QOEs as well as UNIT-e exams data from previous years For each learner only the highest grade is taken into account ...
by robinwilson16
Wed Mar 22, 2017 11:54 pm
Forum: Servers and IT
Topic: SQL Server 2016+ New STRING_SPLIT Function - Lack of Row Number - PLEASE VOTE!
Replies: 0
Views: 1881

SQL Server 2016+ New STRING_SPLIT Function - Lack of Row Number - PLEASE VOTE!

SQL Server has a new STRING_SPLIT function that makes it much easier to split a string into multiple rows of data. However the output does not contain a row number meaning that if you need to use windowing functions such as a running total you still need to revert to more traditional methods to spli...