Questions.
I was hoping to import events from other system using the following sql statement:
insert into events (moduleid, eventdatebegin, eventdateend, eventtimebegin, duration, eventname, eventdesc, importance, repeattype, every, createdby, createddate, approved, portalid, signups, maxenrollment, enrollroleid, enrollfee, enrolltype, location, category, LastUpdatedAt, OriginalDateBegin, LastUpdatedID, OwnerID, EnrollListView, NewEventEmailSent, DisplayEndDate, AllDayEvent, RecurMasterID, DetailPage, DetailNewWin) values ( 416, 'Aug 13 2007 12:00AM', 'Aug 14 2007 12:00AM', 'Aug 13 2007 12:00AM', '1440', 'title', 'description', 2, 'N', 0, 2, getdate(), 1, 0, 1, 12, 1, 0.00, 'FREE', 1, 1, 'Aug 13 2007 12:00AM', 'Aug 13 2007 12:00AM', 2, 2, 1, 1, 1, 1, 1, 0, 0)
It didn't work. The problem is item RecurMasterID. I guess I have to insert the same event into EventsRecurMaster first, then Events. My question is why? Does this mean EventsRecurMaster table is the main table to store events? Thanks.
Luke