I have the same problem. Anyone have a sollution? The new student contacts page loaded, but I can't add contacts. I've tried in IE and Firefox. Am I missing something simple?

Thanks!
Marc

You're welcome!

I don't think that it would be hitting a memory limit for display. I have tested the customization on Firefox and IE with 10+ contacts before without display problems.

There have been some times when I have first implemented the customization on a new server where some fields would not display properly even though the data was entered. One thing you can try is running the "Rebuild custom fields mirrored data" special operation (https://powersource.pearsonschoolsystems.com/d/powerschool_6623) and see if that fixes things.

Brent Johnson
Database Specialist, Programmer
Traverse Bay Area ISD

I'm not sure what kind of reporting you're looking to do but here is a query that will pull all contacts and their information that have recvmail=1:

SELECT * FROM
(SELECT num,studentid,
MAX(CASE WHEN field_name LIKE '%_ecpriority' THEN string_value ELSE NULL END) AS priority,
MAX(CASE WHEN field_name LIKE '%_first' THEN string_value ELSE NULL END) AS firstname,
MAX(CASE WHEN field_name LIKE '%_last' THEN string_value ELSE NULL END) AS lastname,
MAX(CASE WHEN field_name LIKE '%_rel' THEN string_value ELSE NULL END) AS relationship,
MAX(CASE WHEN field_name LIKE '%_street' THEN string_value ELSE NULL END) AS street,
MAX(CASE WHEN field_name LIKE '%_city' THEN string_value ELSE NULL END) AS city,
MAX(CASE WHEN field_name LIKE '%_state' THEN string_value ELSE NULL END) AS state,
MAX(CASE WHEN field_name LIKE '%_zip' THEN string_value ELSE NULL END) AS zip,
MAX(CASE WHEN field_name LIKE '%_recvmail' THEN string_value ELSE NULL END) AS recvmail,
MAX(CASE WHEN field_name LIKE '%_email' THEN string_value ELSE NULL END) AS email,
MAX(CASE WHEN field_name LIKE '%_homephone' THEN string_value ELSE NULL END) AS homephone,
MAX(CASE WHEN field_name LIKE '%_cellphone' THEN string_value ELSE NULL END) AS cellphone,
MAX(CASE WHEN field_name LIKE '%_workphone' THEN string_value ELSE NULL END) AS workphone,
MAX(CASE WHEN field_name LIKE '%_employer' THEN string_value ELSE NULL END) AS employer
FROM
(SELECT regexp_replace(field_name, '^contact(\d+)_.+$', '\1') AS num, field_name, string_value, studentid FROM pvsis_custom_students
WHERE regexp_like(field_name, '^contact\d+_.+$', 'i')
ORDER BY num
)
GROUP BY num, studentid
)
WHERE recvmail=1
ORDER BY studentid,priority, lastname

Hope this helps.

Brent Johnson
Database Specialist, Programmer
Traverse Bay Area ISD