(INQUIRY): Issue regarding calendar--based field-types not collecting and displaying in Wiki page Tracker
I am a new user of Tikiwiki v1.9.11 and CMS’s in general; and it has been over 25 years since I performed any “programming??? (coding) — although I have been in the systems architecture domain for years, and worked on ANSI and ISO standards in the 1990’s.
I have a problem that is vexing me . . .
I have installed Tikiwiki v1.9.11 on an Apple Mac platform that is running MAMP:
Mac OS X (10.5), the operating system
Apache Web server version 2.2.6
MySQL, the database management system (or database server)
P for PHP, Perl, or Python, all programming languages used for web development — with PHP version 5.2.5
My target production environment is:
Server cluster running Linux Network Appliance shared redundant disk array
Apache 1.3.29
Perl 5.8.x + Modules
MySQL 3.23.58
PHP 4.3.x
SSL available via a secure transaction server
Edit access via FTP and/or UNIX shell (telnet/ssh)
I have just completed the skins and was in the process of trying to implement a “Doodle.ch??? http://www.doodle.ch/main.html type of meeting and event organizing capability that would poll and post user preferences for meeting/event dates and times.
I first tried unsuccessfully to get hold of a copy of the “Foodle??? code — an Open Source “Doodle.ch???. Then I tried unsuccessfully to load something called “RDVz??? into the MAMP environment.
Finally I tried to use Tikiwiki inherent functionality to build the capability that I desired. I created a “Tracker??? called “Event Scheduler??? that had as its seven fields:
(1) “ItemId??? {Type = “system???}
(2) Name "Event or Meeting" {Type = “Text Area}
(3) Your Name "Proposer or Responder" {Type = “Text field}
(4) Your e-Mail "Proposer or Responder" {Type = “email}
(5) Your First Choice {Type = “date and time???}
(6) Your Second Choice {Type = “date and time???}
(7) Your Third Choice {Type = “date and time???}
I then assigned all of the “permissions??? appropriately (I believe).
Then I created a populated Tracker item (instance) called “Sample Event???.
Next I created a Wiki page called “Event Calendar??? that had the following content:
Welcome to the "Events Scheduling Process".
The purpose of this "Events" category is to provide you with a self-organizing process for requesting, scheduling, and accessing our products and services ("corporate" programs, workshops, classes, private sessions, consultations, . . . ). This process uses your inherent abilities to self-organize and provide leadership regarding what has individual and/or collective heart and meaning for you.
"TRACKER(trackerId=3, fields=14:15:16:17:18:19, showtitle=y, showmandatory=y, action=Choose Preferences)}Thank you! {TRACKER"
"TRACKERLIST(trackerId=3, fields=>14:15:16:17:18:19, showtitle=y, )}
Notice
"TRACKERLIST"
Note: I have replaced the syntax brackets with quote marks so that I can post the code here without it being interpreted as wiki-syntax . . .
When I saved and viewed the Wiki page, it would only display fields 14, 15, and 16. It would then take the information in and create a new Item instance that displayed all of the fields (14 – 19) correctly, but containing data for only fields 14, 15, and 16 in the new Item instances. I got the same result for Type = “date and time???, “date only???, and “jscalendar???.
So I got curious and modified fields 14, 15, and 16 to Type = “Text field???:
(1) “ItemId {Type = “system???}
(2) Name "Event or Meeting" {Type = “Text Area}
(3) Your Name "Proposer or Responder" {Type = “Text field}
(4) Your e-Mail "Proposer or Responder" {Type = “email}
(5) Your First Choice {Type = “Text field???}
(6) Your Second Choice {Type = “Text field???}
(7) Your Third Choice {Type = “Text field???}
The Wiki Tracker form collected and displayed the data correctly — it displayed what I entered.
My questions are this:
Why do the calendar-based field-types not collect and display in the Wiki page Tracker form?
How can I make them collect and display properly?
How do I subsequently collect, compare, sort, and display the aggregated data from fields 14, 15, and 16 across all Item instances that contain the same value for the FID=14 “Name of Event or Meeting??? — regardless of what field-type I end up using for fields 14, 15, and 16?
Thank you so very much for your consideration,
Mark R. Jones