Submitted by melinda on Wed, 11/20/2019 - 14:48
We used this to feed to our notification systems. (Absent notifications, Drills, Snow days, etc...)
The query:
SELECT s.dcid,
listagg(ea.EMAILADDRESS, ',')
WITHIN GROUP (ORDER BY s.dcid, ea.emailaddress) "Guardian_email"
FROM
STUDENTS s, STUDENTCONTACTASSOC sca, person p, PERSONEMAILADDRESSASSOC pea, EMAILADDRESS ea
Submitted by melinda on Tue, 11/05/2019 - 08:35
The below will target a div and make it appear and disappear depending on what is selected in another field.
~[wc:commonscripts]
<script>
$j(function($){
$j("#ELStatusField").change(function() {
if ($j(this).val() == "01" || $(this).val() == "06") {
$j('div#AccessEllsDiv').show();
$j('#AccessElls').attr('required', '');
$j('#AccessElls').attr('data-error', 'This field is required.');
} else {
$j('#AccessEllsDiv').hide();
$j('#AccessElls').val("");
Submitted by melinda on Fri, 07/26/2019 - 11:12
1. add custom fields
System> custom fields/ screen>Student Fields Click new.
Add new field to table
system> Page and data management> Manage Database Extentions>
Select table to extend> Usually "Students"
Select "Advanced Extentions"
Next
Select Table you want extention/field to go into
next
Then click next again
Step 4 is where you ad your newly created field
Click "add"
Migrate Data from: Select your fields from the drop down
Submitted by melinda on Tue, 05/14/2019 - 13:59
This error,
You can't make changes to this Skype Meeting because it has some properties that are not valid. If changes are necessary, please delete this meeting and reschedule.
What fixed it for our user:
Make sure Skype for Business is running!
Submitted by melinda on Tue, 10/30/2018 - 15:39
This view will allow you to export the "Point_awarded" field.
View needs to look exactly like below based off the "results" view in Quiz Module under Quiz tab> Results button click the sprocket.
Below is the "View" view (haha)
Submitted by melinda on Tue, 10/30/2018 - 11:52
I used this to display downloadable files that belonged to the node displaying.
Add Contextual Filter
Block written into my template
Submitted by melinda on Wed, 09/26/2018 - 20:26
This drove me crazy. Check the text in your body field, or whatever text field and see if you have the word "select" in your content text. Sometimes it identifies it as a SQL injection. Use a different word than "select" in your text.
Not sure if there's a work around but I use a synonym for it in my content.
Submitted by melinda on Wed, 04/04/2018 - 10:45
I have an inherited Joomla 2.5 site that the company if not ready to migrate to Joomla 3. As of March 31, 2018 Recaptcha v1 no longer works. The API has been retired.
Joomla 2.5 does not run recaptcha v2 without a work around. (Joomla 3 uses v2)
Here my work around if your Joomla 2.5 site is getting nailed with spam.
Captcha Q&A
https://extensions.joomla.org/extensions/extension/access-a-security/cap...
Submitted by melinda on Wed, 01/10/2018 - 14:30
I could really find any clear direction on how to do this anywhere so here you go:
I am assuming you know how to create a view.
Here's an overview of the view completed:
Submitted by melinda on Mon, 11/13/2017 - 15:29
Drupal will block a user's IP if too many attemps are made to access the Drupal 7 site within a set amount of time.
To change this default setting (5 times) add the following lines to your settings.php file.
$conf['user_failed_login_user_limit'] = PHP_INT_MAX;
$conf['user_failed_login_user_window'] = 5;
Pages