Imported Activities Don't Appear in Calendar (Until They Are Edited Then Saved)

[machineghost]

My company recently migrated from SalesForce, and we exported the activities of several of our salespeople in to SugarCRM (via the activities import). It worked reasonably well, except that none of the new activities show up in the calendar ... initially. When you edit and then save them though (even if you change nothing) they suddenly appear in the calendar.

My question is: does anyone know how I can do the equivalent of editing/saving every activity at the database-level (or in some other mass way)? Our salespeople have A LOT of activities, and I can't afford to spend all day going through and editing/saving all of them

[eggsurplus]

My suggestion is to look at the database record before and after a save to see what data changes. If nothing in the direct table than there must be a linked table that gets populated/updated. Something data-wise is causing it to start appearing for you.

[machineghost]

Great suggestion eggsurplus! It took a bit of playing around with the DB, but eventually I realized that it was creating a new meetings_users records when I did the edit/save. When I compared the previous record to the newly created one, I noticed that the user_id of the previous one was set to the salesperson's SalesForce id, whereas the new one had their SugarCRM ID. After I understood that, all it took was a quick:

UPDATE meetings_users
SET user_id = *user's Sugar ID*
WHERE user_id ='*user's SalesForce ID*';

to fix all the records in one fell swoop. Thanks for the help.

[eggsurplus]

Awesome news! Always feels great when you save numerous hours worth of work.