search

KingdomFirst / Excavator

We have now released Bulldozer on GitHub. Bulldozer is the super-powerful big brother to Excavator. Because Bulldozer is now published on GitHub we will no longer be supporting Excavator. Thank you for all the support here!
https://github.com/KingdomFirst/Bulldozer
19 stars 20 forks source link

Email addresses not imported from F1 into person table #197

Open tedinedh opened 6 years ago

tedinedh commented 6 years ago

I did have all tables checked. Now I get a key error. What I am missing is the email in the person table. Communications seems to have all of the group emails and communications sent from Rock RMS or F1.

excavator4

excavator1 excavator2 excavator3

dcs619 commented 6 years ago

The first error indicates that the GroupsAttendance table may be corrupt or unreadable in the MDF. You'd have to mount the MDF on your server and run an integrity check on it.

For the dictionary error, it looks like you have multiple financial batches with the same ForeignId. If you run this code SELECT ForeignId FROM FinancialBatch GROUP BY ForeignId HAVING COUNT(1) > 1 that will point you at the Rock Batch(es) that needs to be updated so Excavator can read the table.

tedinedh commented 6 years ago

Ran integrity check, no issues found. Ran Query, no records returned. Financial batch table is empty as is Groups Attendance.