This topic is locked

Displaying dates from other tables in calendar

11/28/2013 3:42:06 PM
Calendar Template general questions
D
DUKE author

Hi Everyone,
I have added the calendar template to my project.
I have an old table in the project called "clients" with a few date fields (date1 date2 date3 etc...)
How do I display these dates from the "clients" table on the calendar?

S
Stoneman 12/3/2013



Hi Everyone,
I have added the calendar template to my project.
I have an old table in the project called "clients" with a few date fields (date1 date2 date3 etc...)
How do I display these dates from the "clients" table on the calendar?


Since you said this is an old table - The easiest way is to use a db utility and append this old data to the new calcalendar table by mapping the appropriate fields so the old data displays in the proper new fields.
If you are still using the old table and want the new calendar template to use that table - create a mysql view of the old table ensuring that it includes every field of the calcalendar table and that they are named the same as the calcalendar table. Rename the calcalendar table and give the view the name of calcalendar. It will work if you include all fields and all of the names are correct.
hope this helps.