I had Grandparents showing up in the flattened parent list and had to add to the Object Filters (Join clause) -> Parent/ChildRelationship.List as Parent is true (for each Parent/Child Relationship Object included in Select Objects). But, I spent 2 hours afterwards using the EXACT formula in Excel to determine if Parent 1 address line 1 matched Parent 2 address line 1, Parent 3 address line 1, or Parent 4 address line 1 (and so on between other possible matches), and then cutting/pasting cells to get spouse/partners in household order (Parent 1/Parent 2 columns for household 1 and spouse/partners in Parent 3/4 columns for houshold 2). The parents just exported out randomly with parent 1 being married to parent 3 or 4. It appears to pull them in the order they were added to the student relationships but not certain. This can be a real problem when pulling the data to import into another database that is household-based. The room for manual error is great.

We noticed that parents aren't getting pushpages (using Advanced List Distr. group) when grandparents are added to student records. This is a big issue.

@angela addision I have an open support case 018454713. If you have any insight on this, that would be great. As far as i know grandparents, dont have parental access to the grandchildren but may for the parent. However, that shouldnt matter since the student is linked to the parent who has a Parent role. Why would the grandparents even appear when they don't hold the role of Parent?

Hi @Noelle Becker I can't think of anything that was changed recently that would cause grandparents to show up in your parent lists (I realize the ordinal issue is a different problem). In the case of your lists that used to be fine now showing grandparents though, I'm wondering if something changed in your data i.e. grandparents being set to have parental access or list as parent selected? Can you put a support ticket in for that one and they can dig into what's going on there with you? If you already have one and would like to message me directly I can look into what happened,

The fact that grandparents are now showing up in a parent list is unbelievable. Please fix this ASAP!!!! This is a direct quote from the knowledgebase and I am baffled that they think this is ok... "There is no way to change these ordinals after they are created. Removing all relationships and re-adding them in a new order will not change the relationship ordinals assigned to them. " My report that was always correct is now all messed up due to adding grandparents. They aren't even in the parent role and it's affecting my flattened lists. Unreal!

yes, please. Divorced parents also have specific needs...and if we have a parent who is "primary" they don't show that way in the directory. For parents who have different last names, we should be able to order them any way we want; for now, the default is alphabetical which isn't always best.

Please! This would save sooooo much time.

How has this problem not been resolved yet?

I would also say in regards to the relationship ordinals that we should be able to designate for a student role that the parent/guardian is always relationship ordinal 1 and 2; siblings should follow and then everybody else (cousin, grandparents etc.)

We need the ability to prioritize the family hierarchy and designate a primary parent in some situations.  This is the time of the modern family!

Our school just went "live" with the onproducts. We are experiencing the same problem and would love to see a resolution to this problem.

I couldn't agree more!  We spend countless hours weeding through spreadsheets we have pulled form lists in order to get them properly aligned.

Also related: https://blackbaudk12.ideas.aha.io/ideas/K12CO-I-920

(change order of parents on a contact card, as this affects how salutations must be written: Mr & Mrs, or Mrs & Mr)

This would be helpful!

RELATED:  https://blackbaudk12.ideas.aha.io/ideas/K12CO-I-120

This would be helpful!

Nadine Peters npeters@hhca.org