MSP_CALENDAR_DATA for enterprise user

[Jan Sundermeier]

Hello,
i am trying to change the personal calendar of a enterprise user in the
database. For local user i can make the changes in the table
MSP_CALENDAR_DATA. But unfortunately it doesn´t work by enterprise resources.
So can anyone tell me, in which table i have to search for the data.

Best regards

Jan Sundermeier

 

[Rod Gill]

Dangerous to edit Enterprise data directly in database. Can you not use the
PWA interface to notify of calendar changes?

 

[Jan Sundermeier]

hello,
the only dangerous that could happened is that someone make changes with the
PWA and in the database to the same time. So I don’t see any other problems.
So I want to make I automatically replication of the personal outlook
calendar and the corresponding resource calendar. I used a ADO Connection to
the database for insert the user, if he don’t exist and its works fine. So I
want to prefer to edit the data with the same connection. A other way, it is
possible to used the function “ResourceCalendarEditDays†in the Project Class
Library with enterprise resources?

Regards

Jan Sundermeier

 

[Gary L. Chefetz [MVP]]

Rod:

No, the PWA interface gives you nothing for this purpose prior to 2007
version. It pretends to with its language, but no calendar joy.

 

[Gary L. Chefetz [MVP]]

Jan:

The calendar data is not available in the database for 2003. You need to use
the object model to accomplish what you're trying to do. Keep in mind that
the data you can see, is an incomplete data extraction. The actual data for
the project is stored in a binary blob in the MSP_Projects table.