Category: Trackers

{syntax type="tiki" editor="plain"}
I tried this on the community forum but got no response.

I've found a problem with interlinked trackers that shows up when you look at the items.

Tracker "Course Type" has fields
F1 Course Type Name: Text
F2 Course Duration: Text

Tracker "Scheduled Courses" has fields
F3 Course Reference: Text
F4 Course Type Name: Item Link to F1
F5 Course Duration: Items List to F2 using F1,F4
F6 Course Start Date: Date

Tracker "Attendee Registrations" has fields
F7 Course Reference: Item Link to F3
F8 Course Duration: Items List to F5 using F3,F7
F9 Course Start Date: Items List to F6 using F3,F7

This mostly works, except when I view the items in the third tracker field F8 is blank

This is an ItemsList to an ItemsList to a Text field.
At each level there is only one result - the second tracker works fine


In addition, a TrackerList or TrackerItemField that should return the value of F8 also fails and while a Trackerlist that should return F7 works fine, a Trackeritemfield that should return F7 does not work.


Having delved into the code it looks like the cases where a tracker list points to a tracker list is just not handled well. There is clearly a need to recursively resolve the value to display (and how to display it) but this is not being done.

I'll continue to work on the code and see if I can solve it but wondered it anyone more familiar with the code is working on this or knows how to fix it quickly.

Many thanks

John

Create a tracker field, of type Text or Text Area (possibly other types are also buggy).
Hit "Add field and edit advanced options", then check "multilingual".
Save the field.

Afterwards, get to tiki-view_tracker.php?trackerId=<number> and attempt to "Insert New Item":
All fields with option "multilingual" lack any input field. They can't be filled (even when mandatory). → Problem!

Going back to edit the field and removing "multilingual" option corrects the issue.

{syntax type="tiki" editor="plain"}
When in tiki-view_tracker_item.php or in tiki-view_tracker.php there is a nice useful "no tab" button on the upper right.
It does not do anything

Firefox 7.0.1 on linux

I modified
http://dev.tiki.org/wish3118

but nothing appears here:
http://dev.tiki.org/tiki-tracker_view_history.php?itemId=3118

To reproduce:

Modify this tracker with user "marclaporte" (who is admin):
http://dev.tiki.org/wish3118

Try to edit a wish on dev.tiki.org and link it to another

Search for "jQuery" and you will see many are missing compared to: http://dev.tiki.org/tiki-view_tracker.php?trackerId=5&status=o&sort_mode=f_41_desc&filterfield=26&filtervalue[26]=jquery&filter=Go

{syntax type="tiki" editor="plain"}
We just updated our tikiwiki from 6.2 to 8.3 and came across a difficulty when viewing the rss-seed of tracker items. We cloned the database and have not changed anything about permissions, but it seems that only people from a certain group (and admin) can view the rss seed of the tracker while logged in, while others can't. This wasn't previously the case.

We kept the old wiki (6.2) and the tracker rss seed works. See for the example:
http://www.svi.nl/tikiold/tiki-tracker_rss.php?trackerId=5

The rss tracker in the new wiki doesn't. See:
http://www.svi.nl/tiki-tracker_rss.php?trackerId=5

Both have a different database, but they are identical. Also all the permissions concerning trackers are identical.

Is this a bug or has the functionality of the tracker changed? Tried to search in the tikiwiki and bug-reports but couldn't find anything.

EDIT: Apparently this wasn't working in 6.2 either but we created a workaround for it, which also seem to work for 8.3 (see below).

{syntax type="tiki" editor="plain"}
On dev.tiki.org

If I delete a tracker item, the notification email is entitled:

"Bugs & Wish list" item "" was modified at dev.tiki.org by "Marc Laporte"

1- So it's missing the decription of the wish

2- The content is
{CODE()}ItemID 2855 was deleted in the tracker Bugs & Wish list

Author: Marc Laporte
Date: 07:40 UTC{CODE}

So, it's missing the last info before it was deleted. What's the point of watching if I don't get a copy before it's deleted?

{syntax type="tiki" editor="plain"}
From 2011-06-23 to 2011-10-11, the bug tracker of dev.tiki.org was not properly recording the "submitted by" field (because of Tracker Revamp)

All the data is in the notification emails, and just needs to be restored manually.

Steps in 6.3:
*create tracker, set Auto-create corresponding categories
*define tracker_item like name, add two items.
As result category is created (as tracker name) and items are added as subcategories:

*Informatics Projects(0/1)
** Item1(0/0)
** Item2(1/1)

Same steps in 8.3, result:

*Tracker 1
**Tracker Item
***Name Type Category
***# Projects tracker item Tracker Item
***# Projects tracker item Tracker Item

Result, instead of tracker name category 'Tracker 1' was created, than subcategory 'Tracker Item' and empty object inside, displayed as table with links to non existing "http://localhost/tiki/tiki-view_tracker_item.php?trackerId=1&itemId="

Thanks,
Jakub

{syntax type="tiki" editor="plain"}
We recently upgraded from Tiki 3.x to Tiki 6.x and noticed that the Tracker Field User Select does not work with the variables of 0,1 entered and the selection of specific users. What it does do is just show the entire list of users as you type in a username.

So for example we have a tech ticket issue system setup using a tracker. Afer a user has submitted a ticket/tracker item, an IT person would go to an "Assigned" field (which is a user selector field) and choose the particular tech from a drop down list which was generated from the option of "Select list items that will be displayed:"

Is this an actual bug or are we misconfigured?

I am pretty new at this, so I am not sure if I posted the bug and patch at the correct place and in the correct form. Please let me know if I should change something. Unfortunately I do not have time at the moment to learn how to commit patches via SVN and am also a bit unsure about my fix, so please take a look and include it in the next release if you think it is correct.

Scenario:
Tiki LTS 6.6, Tracker not publicly accessible (by anonymous users), RSS Feeds enabled, RSS for Trackers and for Individual tracker items enabled, RSS basic Authentication enabled.

Behaviour:
If I try to subscribe to the RSS feeds of my tracker (by adding http://tiki.***.***/tiki-tracker_rss.php?trackerId=9 to Outlook) I always get the error "Tiki RSS Feed Error Message: You do not have permission to view this section". Same happens if I log out of Tiki and copy the address in my browser.

Tested in version 3.3 and 7:
Importing tracker items through CSV does not properly process the date field.

My exported CSV contains e.g. "24/12/2010 19:55"
The imported data only contains "24/12/2010" The time has been left out.

{CODE(caption="incorrect code 3.3" colors="php")}# Version 3.3
Line 1697
} elseif ($field['type'] == 'f' || $field['type'] == 'j') {
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
}{CODE}

Replaced by following code :
{CODE(caption="correct code 3.3" colors="php") } elseif ($field['type'] == 'f' || $field['type'] == 'j') {
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
}{CODE}

The same for the latest version 8.3

{CODE(caption="Incorrect code 8.3" wrap="0" colors="php")} case 'f':
case 'j':
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = preg_split('#-#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
}{CODE}


{CODE(caption="Correct code v8.3" wrap="0" colors="php")}# Line 1730
case 'f':
case 'j':
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm, $ss) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
break;
{CODE}

Importing tracker items through CSV only sets the created and lastModif value properly if the dates from the CSV file are in the numerical php date format.

When you import a csv file where the created and lastModif dates are written as proper dates, the imported tracker items have a created and lastModif date/timestamp of the date & time of the import action.

example csv :

"itemId","status","created","lastModif","VRID -- 265"
"849","o","07/12/2009 13:24","07/12/2009 13:24","4"

Whenever I export a csv file, it contains the dates as shown above, so you can't just export data and import data on the fly without modifying all the values...

c.f. [https://dev.tiki.org/item3500|bug 3500]

When using the checkbox option in TrackerList the actionUrl is stated as
$checkbox.action and not as the link you entered.

{syntax type="tiki" editor="plain"}
Relation should be
* visible in view mode:
* and editable in tracker item edit mode

ex.:
https://trunkdev.tiki.org/tiki-view_tracker_item.php?itemId=4025

If you create a tracker with one field which is a text area set to WYSIWYG, plus another field which is an Item Link that has the "Add Items" options set, the WYSIWYG editor will not load using the TRACKER module. It must be a conflict in the two scripts. Disabling the "Add Items" option allows the WYSIWYG editor to load fine.

Go to tiki-list_trackers.php → Edit one Tracker → Categories tab → Only first-level categories can be selected.

With this bug and bug 4208, it seems totally impossible to design elaborate category-based permissions with trackers.

Say I have a ((doc:TrackerList)) report: I want to edit several items, I would like the whole report to become editable with a single save button

Say I have a desktop spreadsheet file. I can copy-paste this to Tiki spreadsheet and it makes it fun & fast to move data to Tiki. (It's also easy to export to .csv to re-use in the desktop spreadsheet).

But what if I want my info in a tracker?

((doc:PluginTrackerList)) has displaysheet=y which displays in spreadsheet view. This is nice but we'd need to be able to edit existing records, and easily add records.

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

A Page Selector field from a Tracker plugin on a wiki page does not populate with the name of the page even with option Auto-Assign set to 1. Replicated on clean installs of 8.1-8.4 and 9.0b. Works fine on 7.2.

Bug is still present in master.

If I choose the field type "date and time" in tracker, I can't set a date before 1970 in the data entry even when I say "start date" 1940.

i

Using 1.10cvs code from mid june 2007

I created several trackers. Enabled RSS for individual trackers. Created rss modules for two individual trackers (rss 1 and rss 2).
Granted common permissions for anon. (view, ...), and most tracker permissions for Registered group.

Added a call to rss plugin within a wiki page:
{CODE()}
{rss id=1}

{rss id=2}
{CODE}

When viewing the page as registered, I see:

^
Tiki RSS Feed Error Message: Permission denied you cannot view this section
^

Did I miss any special perm to be granted for registered? A bug?

(I granted all perms from tracker section - to them, or inherited from anonymous - except for tiki_p_admin_tracker)