You are here

melinda's blog

VLookup in Excel for matches

Add users to new sheet (sheet2)
Sort Sheet2 A to Z

 Create New column on sheet 1 at far left (In front of A)

click on cell that lines up with the cell I need to start in that avoids headers

type in the cell the Function VLOOKUP

=VLOOKUP(Cell you want to look up, Cell range you want to look in, 1, FALSE)

   EX =VLOOKUP(C4,Sheet2!A1:A23,1,FALSE)

Before you copy to the next row and beyond, highlight the Cell range in formula bar, (in the above formula is Sheet2!A1:A23) you want to look in, then hit F4.

Opigno Quiz import module text in title/question field too long in excel import

Took me forever to find this answer. My questions that i was importing had too many chartacters in the excel sheet I was importing.  Added the lines below. 

In

profiles>Opigno_lms>modules>Opigno quiz import app

Go to the file opigno_quiz_import_app.module and where you have

// Start a new one.
$node = (object) array(
'title' => $question,

can you please put

// Start a new one.
$trimmed = substr($question, 0, 250);
$node = (object) array(
'title' => $trimmed,

 

Opigno LMS- when the homepage changes to "Access denied" for anonymous users

This is just a quick reference on where to find the permissions for the front page of Opigno LMS. 

It took me a second to figure out what I did in error to cause my home page to go to an "Access Denied" page for all users that were not logged in.

There is a feature called "Homebox" for Opigno, which I thought only controlled the dashboard view for users when they are logged in. But not the case, it controls the Front page as well. So changing the permission on which users can see the "HomeBox" directly effects who can see what on the Front page. Weird right?

Forced watermark for browser printing (When user has browser to not print background images)

This solution came in handy for web pages that displayed "unofficial" information that users could print out.

 

HTML

<div id="printDiv">
     <div id="background">
  <p id="bg-text">Unofficial</p>
    </div>

CSS

#bg-text
{
    color:lightgrey;
    opacity: 0.1;
    font-size:120px;
    transform:rotate(300deg);
    -webkit-transform:rotate(300deg);
}

PowerSchool Parent Portal Printable Un-Official Transcripts :) Using some DATs

Project Description: Allow parents to print out their student's unofficial transcript from the parent portal. Included a forced "Unofficial" watermark that the browser is forced to print.

What I used: DATs, CSS, HTML and Javascript.

The Code

<!DOCTYPE html>
<html>
<head>
    <style>
 

Concat Mom and Dad email columns in PowerSchool using LISTAGG in oracle

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

Jquery and PowerSchool- If statement - show hidden fields

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("");

Add custom fields to PowerSchool

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

you can't make changes to this skype meeting because it has some properties that are not valid. if changes are necessary, please

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! 

Drupal Quiz Module- Export Points instead of text answers for multiple choice questions.

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)  

 

Pages

Subscribe to RSS - melinda's blog