My Current organization is not visible on the credit form

I can see an issue with the synced data. I'm looking into this.

Moving to the right project as the data is migrated with the wrong paragraph type.

https://www.drupal.org/u/bbu23 → is also running into the same issue.

For integrity checking, this is an initial query for a users at organizations manifest in D7. I has all users, so we get a username integrity check too. If we want to narrow the scope, some LEFT JOINs can be INNER

SELECT u.name, u.uid, fdf_on.field_organization_name_value AS organization_name, fdf_or.field_organization_reference_target_id AS organization_nid, fdf_c.field_current_value AS current FROM users u LEFT JOIN field_data_field_organizations fdf_o ON fdf_o.entity_id = u.uid LEFT JOIN field_data_field_organization_reference fdf_or ON fdf_or.entity_id = fdf_o.field_organizations_value LEFT JOIN field_data_field_current fdf_c ON fdf_c.entity_id = fdf_o.field_organizations_value LEFT JOIN field_data_field_organization_name fdf_on ON fdf_on.entity_id = fdf_o.field_organizations_value ORDER BY u.uid, organization_name;

And the initial version for the new site

SELECT ufd.name, ufd.uid, p_fon.field_organization_name_value AS organization_name, p_for.field_organization_reference_target_id AS organization_nid, p_fc.field_current_value AS current FROM users_field_data ufd LEFT JOIN user__field_user_organizations u_fuo ON u_fuo.entity_id = ufd.uid LEFT JOIN paragraph__field_organization_name p_fon ON p_fon.entity_id = u_fuo.field_user_organizations_target_id LEFT JOIN paragraph__field_organization_reference p_for ON p_for.entity_id = u_fuo.field_user_organizations_target_id LEFT JOIN paragraph__field_current p_fc ON p_fc.entity_id = u_fuo.field_user_organizations_target_id ORDER BY ufd.uid, organization_name;

I’ve packaged up the integrity checking as a shell script. Spot checking makes it look like a decent first pass.

The list of uids with a diff is:

sed -ne 's/^[+-][^\t]*\t\([0-9]*\)\t.*/\1/p' < user-organizations.diff | uniq

If that’s accurate, this currently affects 3,604 people.

I'm integrating the new integrity script into our cron rotation.

I will follow up with a drush command to fix the mismatched data.

fjgarlin → changed the visibility of the branch 1.0.x to hidden.

I've added a new drush command to fix the inconsistencies detected by the integrity check that we added.

I'm going to run that command manually first on a few selected users and if it works as expected, I will add some automation so we can fix directly when detected.

🙌

NW based on the missing automation.

@fjgarlin Please let me know when the fix will be ready for testing.

@vitaliyb98 - I've run it for your user. Can you try again?

@fjgarlin its works, thank you!

I’m seeing 2 remaining edge cases:

• The “current” bit is sometimes mismatched between sites.
• I didn’t get job title in the diff, and I believe we will have issues there.