Category: Trackers

__Updated__: Experienced with CartoGraf_15 profile. When uploading files via the modals it fails with error "File could not be uploaded. File empty." because it is uploading them to a "User File Gallery" which has set maximum width image resize to 800px but that apparently fails. When the ID of the gallery is changed in tracker field setup to other file gal, or the width max size is removed, it works. It worked before in Tiki 12.x CartoGraf with image resizing. Uploading to the file gallery directly works as expected and the image is resized correctly.

There is a show instance to test.

When you have a tracker with a URL field, and the field display is set to "Show as link", and you enter something like "www.example.com" it is fine and converts to a link. But if you enter simply "example.com" it does not convert to a link and is treated like an internal link instead

If you enter something.example.com it also does not convert to a link. It should. Not sure if problem existed in Tiki 12. Please double check when fixing.

At this condition,
* Enabled Time Sheet feature
* Apply Time Sheet profile
* Add tracker fields of URL or Items List to the Time Sheet tracker.

And I click the TimeSheet link, I got the following pattern of error messages;

{CODE(caption="System error" wrap="1")}The following error message was returned:

Incorrect integer value: '{"linkToURL":1' for column 'trackerIdThere' at row 1
The query was:

INSERT INTO temp_tracker_field_options SELECT tiki_tracker_fields.trackerId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4 -1)) + 1 ), ',', ''), tiki_tracker_fields.fieldId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5 -1)) + 1 ), ',', ''), tiki_tracker_fields.type, tiki_tracker_fields.options FROM tiki_tracker_fields WHERE tiki_tracker_fields.type = 'l';
The built query was likely:

INSERT INTO temp_tracker_field_options SELECT tiki_tracker_fields.trackerId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4 -1)) + 1 ), ',', ''), tiki_tracker_fields.fieldId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5 -1)) + 1 ), ',', ''), tiki_tracker_fields.type, tiki_tracker_fields.options FROM tiki_tracker_fields WHERE tiki_tracker_fields.type = 'l';
{CODE}

There is one pending issue in PluginTrackerCalendar in 12x & 13x {sign user="xavi" datetime="2014-05-27T14:46:53+00:00"}, and it was working fine in 10x, as far as I remember

Show instance where some of this issues are reproduced:
http://xavi-9794-5177.show.tikiwiki.org
u: admin
p: 12345

!! Pending still:

If you use some uppercase letter in the string of the tracker field "location" (used as a the resource field for the resource-related views), then the item is not shown through the resource views, only through the calendar type of views.

Replacing uppercase letters with lowercase in the values of those fields solves the issue as a workaround until a proper fix is found/commited

Reproduced here:

http://xavi-9794-5177.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_10

In the resource month, 3 items are shown.
In the calendar view, 5 items are shown. The extra 2 are the ones with upper case in the contents of the "location" tracker field (the field used as resource).

With "__resource month__" view:
{img fileId="783"}

With "__month__" view:
{img fileId="784"}


!!- Things Fixed already
(1) In localhost, after applying the profile Tracker_as_calendar_10x I can't get the new items to display in the resource views modes if location field is set, only in the calendar modes. Tried manually rebuilding the search index, and no way either.
http://xavi-9794-5177.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_10

In a production site of mine, many seem to display, but not some of them with specific values in the location (resource) field.

__Update April 7th, 2014__: the issue seems to be related with using some uppercase letter in the string of the tracker field "location" (used as a the resource field for the resource-related views). Replacing uppercase letters with lowercase in the values of those fields solves the issue as a workaround until a proper fix is found/commited {sign user="xavi" datetime="2014-04-08T10:54:03+00:00"}

---

(2) In a production site not all the items are displayed in the calendar (standard or resource views).
http://2014.forumsocialcatala.cat/CalendariPrograma

Move the calendar focus to April 12th, 2014, and view to resourceDay. And notice that for instance, there are no items shown for room 112, 113 and a few others, while there should be some items listed, as can be shown by filtering the items through the field "Aula (Capacitat)" and choosing "112", for instance here:
http://2014.forumsocialcatala.cat/Inscripcions

__Update April 7th, 2014__: the issue seems to be related with using some uppercase letter in the string of the tracker field "location" (used as a the resource field for the resource-related views). Replacing uppercase letters with lowercase in the values of those fields solves the issue as a workaround until a proper fix is found/commited {sign user="xavi" datetime="2014-04-08T10:54:03+00:00"}

--(3) As anonymous, when you mouse over each item you see that there is the url associated to show the item.-- E.g.:
http://xavi-9794-5177.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_10

--However, when you click on the item in the calendar, nothing happens.--

--When you do this as registered or admin, you get the popup window to edit the data. But users (anons, etc) expect to be able to at least see the full item details when clicking on the name.--

Fixed by jonnyb {sign user="xavi" datetime="2014-04-03T00:12:24+00:00"}

---
--(4) How can we choose to show in the box on the popup window, the info from some other tracker field/s of the same item? Like with maps, that you can show some other details inside the popup box.--

-- Like contents of fields: "Priority" and "Description" in: http://xavi-9794-5177.show.tikiwiki.org/tiki-admin_tracker_fields.php?trackerId=1 --

Fixed by jonnyb, when you set some fields to be shown in the popup, at the tracker edition field for popup fields {sign user="xavi" datetime="2014-04-03T00:12:24+00:00"}

---

--(5) How can we predefine some view (lets say, resource week) (so that, the link is provided for others to see that specific view).--

Fixed in r50638. {sign user="xavi" datetime="2014-04-03T00:12:24+00:00"}

---

--(6) How can we predefine some date with some params in a url, for instance? (so that, the link is provided for others to see that specific dates).--

Fixed in r50665 {sign user="xavi" datetime="2014-04-04T19:32:40+00:00"}



Xavi

{syntax type=tiki}
{syntax type="tiki" editor="plain"}
This is the ((Tracking system for Tiki issues)).
If this is your first time, please read: ((How to Submit a new item on the Wishlist))

{syntax type="tiki" editor="plain"}
New users are kind of lost in the process of creating a new tracker from scratch.
After they hit on save the form of the new tracker details, they are shown:
tiki-admin_trackers.php?trackerId=N

(being N the new tracker Id)

Instead, it would be much easier for tiki newbies (or even for everybody?) if they were autoomagically sent to
tiki-admin_tracker_fields.php?trackerId=N

Because it's not intuitive (from the newbie point f view) to know what to do from that interface with so many links at the moment when the new tracker has been created.
---
UPDATE: Still desirable in Tiki 12 LTS for usability for new users. {sign user="xavi" datetime="2013-11-17T09:43:36+00:00"}

usability: allow to show the form to post new comments to tracker items below the item.

Many new users to tiki sites, in barter networks (such as http://intercanvis.net ) they don't know how to contact the person who added the offer or demand just from the screen where they are seeing the item.

(for sure, captach should be shown when allowing anons to post comments to tracker items)

Use table sorter with plugin list or customSearch to perform sum values from a field

A lot of work done here:
http://framework.zend.com/manual/1.12/en/zend.currency.html

Using 2.0beta code, afaicr.

There are two different users (from two people) in a site: "Xavi" and "Xavier"

This user (which is me)
http://intercanvis.net/tiki-user_information.php?view_user=Xavi

shows some data from the user "Xavier" (the data from the group tracker, afaik):
^
Nom: xavier
Cognoms: rocabert argila
Usuari: xavierrocabert
Telèfon: 932372798
Barri / Població: barcelona
^

As you can see, this information belongs to this other user:
http://intercanvis.net/tiki-user_information.php?view_user=Xavier

admin home/community/user preference screen is on

* Created a user tracker with a user preference field, "realName", which is asked from the user at registration time. One can fill in at registration an edit box for the field, but the field is not updated. Neither is the realName user preference set (if looking at the user preference screen).

* If the realName user preference is set on the user preference screen, it does show up in the tracker.

* The view_tracker_item / edit tab does not show an edit box. (another bug perhaps)

unknown
* if it worked for email user pref.

known
* a standalone tracker plugin does work either, while the item's last modification date changes (used for an existing tracker item, offering a single input field to change the real name)
* wikiplugin_tracker.php does not contain any 'p', which would refer to the user preference type

{syntax type="tiki" editor="plain"}
Trying to select users with user selector is not working at all

Users Information Tracker Fields Asked at Registration Time
(fieldIds separated with :)
corresponds with the Tracker plugin's fields

No autoassign is possible by the time of registration, while the plugin would offer that TW5<=.

I would like to send a message to my users, with a unique URL, so they can update their user tracker without needing to login.

{syntax type="tiki" editor="plain"}
Please see:
((doc:User Preference Field))
((doc:User Trackers))


Missing:
Avatar, Full name, URL, avatar, etc.


Also, each relevant field here should optional tiki-user_preferences.php

{img fileId="297"}

Username rename in trackers doesn't work when there are multiple values.

If admin log as a user and use a form (tracker view, tracker plugin on a wiki page, etc) for a tracker where there is a username selector tracker field (with auto-select option or not) it will be set as the logged user is the admin or display the list of all the users.

It should work as intended and the username selector tracker field should work as I was the user I choose to log with.

It some case (user tracker information - Tiki log in) it can salvage the admin groups and real name.

I do not know when the regression was introduced (that used to work in earlier Tiki12 versions maybe?), but with latest Tiki12 and trunk (as of Nov 7, 2014), the setup to have users choose group at registration time, and fill in the form of the associated user tracker item for each group, fails at some point, since the user can't get to see the form at all, but just a never-ending spinner attempting to load something (the form)

{img fileId="956" thumb="y" rel="box[g]"}

In that place, the loading spinner never ends.

Reproduced in general here:
http://xavi-9794-5501.show.tikiwiki.org/tiki-register.php

Login as admin to see the setup:
u: admin
p: 12345

In this show instance the spinner does end, but no form is shown either wih the fields to be filled, etc.

{syntax type="tiki" editor="plain"}
The problem is summarized in 2:

1) The category perm checking for individual tracker item always happens no matter what.

2) Even when it makes sense to check for category perms, the filter appears to not take into account specific tracker perm, because trackeritem is a "different" object from tracker.

The problem is in the following piece of code in trackerlib.php

{CODE()}
function filter_categ_items($ret) {
//this is an approxomation - the perm should be function of the status
global $categlib; include_once('lib/categories/categlib.php');
if (empty($ret['itemId']) || $categlib->is_categorized('trackeritem', $ret['itemId'])) {
return Perms::filter(array('type' => 'trackeritem'), 'object', $ret, array('object' => 'itemId'), 'view_trackers');
} else {
return $ret;
}
}
{CODE}

{syntax type="tiki" editor="plain"}
Using a Tracker with an Attachment field with the TRACKER plugin:

If the user __does not__ have permission to attach files to tracker items (but can insert/create new tracker items), Tiki will, nevertheless, allow the user to select a file to submit with the tracker. Upon submission, there is no notification to the end-user that their attachment was not really included.

Trying to set up a manual currency exchange method I used the dollar sign "$" in a mathematical field to add it visually as a string.

(str $)

Since then the field is broken and it kept displaying the last version of the value that was calculated (before I change the euro sign to dollar sign)

I refreshed, flushed and rebuilt several time.
I have the feeling the Tiki is acting a bit weird now. ?

Seems it was interpreted as a "coding" value and not as an "ascii" char.

{img fileId="1534" thumb="box"}
{img fileId="1535" thumb="box"}
{img fileId="1536" thumb="box"}
{img fileId="1537" thumb="box"}

Selecting a field in the parameter "Sort Fields" of an Items List tracker fields block index from being rebuilt.

It throw the following error:
{CODE()}warning: Divide by zero on "0"
error: The search index could not be rebuilt.
Expression #1 of ORDER BY clause is not in SELECT list, references column 'kindergarten_tiki20x.ttif0.value' which is not in SELECT list; this is incompatible with DISTINCT{CODE}

Un-selecting it solve the issue and the index is rebuilt correctly.

PS: I created an instance but wasn’t able to access it to demonstrate (error 500).

Tested with 1.10 SVN from June 20, 2008...

When using the TRACKER plugin on a wiki page, if the user submits the tracker successfully, Tiki scrolls to an anchor in the tracker from to display the success message.

However, if the tracker was not submitted successfully (such as missing a mandatory field), the page is redisplayed at the top of the page -- Tiki does not scroll down to the form to show the error message. The user will be unaware that the tracker was not submitted.

To test:
1. Create a long wiki page.
2. At the bottom of the wiki page use the TRACKER plugin to add a form
3. Attempt to submit the form (using invalid data).

Like this:
http://versioncontrolblog.com/comparison/Bazaar/CVS/Git/Mercurial/Subversion/index.html
http://www.wikimatrix.org/