Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsAdd Event to Calendar by modifying the background databaseAdd Event to Calendar by modifying the background database
Previous
 
Next
New Post
11/20/2008 10:01 AM
 

Is is possible to add a calendar event (such as a looming deadline) programmatically (using ASP) to the DNN database that populates the Event Calendar? I have a separate database that I've embedded in DNN (via an IFrame ASP application) which will determine dates that would be nice to have appear on an Event Calendar as deadlines. Can you direct me to the actual database and parameter names that I would need to reference to set these values? Thank you for any help you can provide.

 
New Post
11/20/2008 10:19 AM
Accepted Answer 

Yes you can do this direct to the database. After all the module in the end is only a program, and is doing this programatically....

I can't direct you to the actual database, because that would depend on what you called the database when you installed DNN. But you should find a table within the database called 'Events'. Or it could have a prefix (otherwise know as an Object Qualifer) if you specified one when you did your DNN install, but it will still end in Events. You will also see a number of other tables beginning Events, but it should be reasonably self explanatory as to what they are.

Most of the attributes in the Events table are fairly self explanatory, just add a couple of fully populated calendar items, and you should get the idea.... The ones that are complicated are around recurrence, but if you are entering deadlines then if I remember correctly you just need RepeatType of 'N'.

One thing to note is that in the next release (4.1.0), substantially changes the handling of recurrences, and adds some extra mandatory fields, so you need to be prepared for the update when it happens. Sign up at www.DNNEvent.net and you will be notified when a beta release is available (hopefully soon). This will also add an extra table 'EventsRecurMaster' which you will also need to populate, but much of the data is the same as in the Events table. I won't go into detail here, but can expand on this if needed. See this blog entry for more details - http://www.thedivingclub.co.uk/Information/DNNBlog/tabid/368/articleType/ArticleView/articleId/97/categoryId/4/Recurring-Events-A-Major-Update.aspx

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
11/20/2008 10:25 AM
 

Thank you, Roger, for your extremely speedy reply. I will work with what you have provided me, and hopefully all will go well. I am also anticipating the much-referred to (via the forum) next release of the Events Calendar! As you noted, since my immediate need is not involving recurring events at this time, it will hopefully be a clean upgrade to 4.1.0. Again, thanks for your help, and wish me luck! :)

 
New Post
11/20/2008 11:36 AM
 

Just to re-enforce the point . An upgrade to 4.1.0 will required a code change at your end. All events, including non-recurring ones, will have a record in EventsRecurMaster. Shouldn't be a major problem though.

Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsAdd Event to Calendar by modifying the background databaseAdd Event to Calendar by modifying the background database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out