Loading...
 
Features / Usability

Features / Usability


(INQUIRY): Issue regarding calendar--based field-types not collecting and displaying in Wiki page Tracker

posts: 1

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

posts: 4614 Japan

Hi,

That's some impressive work and I'm sorry I can't respond with a solution, but I'd say your best bet would be to post this to the developers mailing list (http://sf.net/mail/?group_id=64258) where the people working on the calendar and trackers will be more likely to see it.

-- Gary


posts: 1550 Canada

>Why do the calendar-based field-types not collect and display in the Wiki page Tracker form?

I don't know. I guess it has never been coded or it's broken.

>How can I make them collect and display properly?

I would try with TikiWiki 2.0, maybe it's been fixed. If not, please report a bug.

>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?

"TRACKERLIST(trackerId=3, fields=>14:15:16:17:18:19, showtitle=y,filterfield=14,filtervalue="event A" )}
"TRACKERLIST"

You could also use PluginTrackerFilter which would make drop downs for you.

This is an interesting use of trackers and a candidate for http://profiles.tikiwiki.org

Best regards,

M ;-)