Category: Trackers

Hello,

Here is a wish in regards to my learning curve.

I heard that Tiki is good at allowing others to create forms.

Here is the print screen of __this form_, which is quite impressive.

---

::{img src="http://yogapartout.com/extlinks/ftp/useCase/imgs/printScreens/wishToLearnViaVideoHowToCreateAformLikeThis.jpg" link="http://yogapartout.com/extlinks/ftp/useCase/imgs/printScreens/wishToLearnViaVideoHowToCreateAformLikeThis.jpg" width="800"}::

---

I'm actually _the Tiki's most populare Newbie_ as I am still learning the basics about Tiki.

Here is my panel box of what my form, the only one I have looks alike on my admin panel

---

::{img src="http://yogapartout.com/extlinks/ftp/useCase/imgs/printScreens/LearnViaVideoHowToCreateAform.jpg" link="http://yogapartout.com/extlinks/ftp/useCase/imgs/printScreens/LearnViaVideoHowToCreateAform.jpg" width="800"}::

---

Is there a video somewhere that shows how to create (this actual form I'm using to communicate this need) a form?

Daniel.

This tracker is made to help filtering and sorting the features vs categories vs options we need to tag a bug/regression/wish with.

r45946

See source of http://dev.tiki.org/Bug+Tracker+Input+Form
Happens with any tracker plugin form using a wiki template.

After created trackers with Item Link fields, Time Sheet features got system error as follows;

{CODE()}
The following error message was returned:

Incorrect integer value: '{"trackerId":2' for column 'trackerIdThere' at row 2
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}


In addition, I catched stacktrace...

{CODE()}
* /d1/scms/tiki12b/tiki-timesheet.php : 0 -> {main}(array ( ))
* /d1/scms/tiki12b/tiki-timesheet.php : 27 -> tracker(array ( ))
* /d1/scms/tiki12b/lib/core/Tracker/Query.php : 116 -> __construct(array ( ))
* /d1/scms/tiki12b/lib/core/Tracker/Query.php : 571 -> query(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb/Bridge.php : 27 -> query(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb/Pdo.php : 121 -> handleQueryError(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb.php : 148 -> handle(array ( ))
{CODE}

I hope it could be help to solve. If it need more, please let me know what to do next or action plan.

Tracker item link and item dynamic list type field seems to be broken.
Checking another user issue on Tiki 18 (see related) I wanted to check also on Trunk.

--See instance--

See video:
https://share.vidyard.com/watch/Firvq3xhK9NQBFpQSGrZ8F?

item link displaying duplicated items frmo a category field

I'll see if I'm able to reproduce in a show instance

http://xavi-9794-5929.show.tikiwiki.org/tiki-index.php?page=Services#step2
u: admin
p: 12345

Product name "Oracle Database" is duplicated in the dropdown.

Reproduced also in the tracker itself (aside of plugins in wiki pages)
http://xavi-9794-5929.show.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=insert_item&trackerId=2&modal=1

I am using the "Item List" field in one tracker with "Item Link" in the other. It works well, but when I click on "Insert new item" the new item should automatically select the proper field value that is tied to whatever tracker item generated the request. As it stands now, you have to drop the list down and manually select the correct linked item, but that can be a real pain when the tracker gets big.

I've tracked the problem - it appears that the issue is in tiki-view_tracker_item.tpl. The code to set up the link is here:
<div style="clear:both;text-align:right;"><a href="tiki-view_tracker.php?trackerId={$cur_field.options_array[0]}&amp;vals%5B{$cur_field.options_array[1]}%5D=
{section name=ox loop=$ins_fields}
{if $ins_fields[ox].fieldId eq $cur_field.options_array[2]}
{$ins_fields[ox].value}
{/if}
{/section}
">{tr}Insert new item{/tr}
</div>

However, when you have a two item link (e.g. 8,37,31|32,38,1), then cur_field.options_array[2] never matches any ins_fields{ox].value, and consequently that part of the vals parameter is always blank.

Some options for tracker field Item Links are broken;

Multiple Fields display type : table is not working anymore a single check box is displayed without any text.

When setting Display to Link and Select multiple values to yes (Multiple Fields display type: dropdown - table is broken as explained above) no link is displayed only text.

Will create an instance as soon as instance are back online.

When creating/modifying an Item Link field the list of electable tracker ID's is incomplete (in my site only 3 of 40 trackers appear in the list, trackers 1, 2, and 9)
I don't see any difference between these trackers and the others, to be tho only ones in the list

The same happens with items list, only the same 3 trackers are on the list!

There is no easy way to create a numbered list of items (automatic numbering). There is no easy way to automatically assign a unique identifier to a item in a tracker. In other words, you can't display the ItemId in a tracker.

Need the ability to show the ItemId as another field in the tracker. This id is very useful when creating tables or lists in a tracker and I beleive is a must have. For example, if I create a list of ideas, I would like to have an idea number associated to each idea.

I hope someone is already working this.

Best,
Diego

---
Working on a fix for this as I need this as well. Among other things, also lets you display 0-padded item ID's and hyphenated item ID's prominently in the item viewer.

{syntax type="tiki" editor="plain"}
With the tracker field Item Link there is a status filter.
This allow to displays certains items on item creation based on their status.

In my example I have holidays event from 2019 up to 2025.
Each time an event date is reached I close the item so user can register only to futur event.

It worked fine till I upgraded to Tiki27.

After the upgrade the status filter is not applied.

{img fileId="3077" thumb="box"}

{img fileId="3076" thumb="box"}

{img fileId="3075" thumb="box"}

Tested using MySQL full-text search and Manticore Search.

~~#d0021b:Update: The bug appears when using multiple fields option in the ItemLink field options. It was tested with one item in the field.~~

I upgrade a Tiki using git and Tiki22 the 30/09/2020 and didn’t had that notice in my index rebuild log.

I upgrade for a second time the same Tiki (db) using git and Tiki22 the 05/10/2020 and this notice appears in my index rebuild log for (I believe) all the itemlinks I have in my trackers.

{CODE()}
2020-10-04T18:36:12+00:00 INFO (6): addDocument trackeritem 384 {"memoryUsage":"27.9 MiB"}
2020-10-04T18:36:12+00:00 ERR (3): NOTICE: Trying to access array offset on value of type null {"code":null,"file":"/home/xxx/public_html/lib/core/Tracker/Field/ItemLink.php","line":1002}
2020-10-04T18:36:12+00:00 ERR (3): NOTICE: Trying to access array offset on value of type null {"code":null,"file":"/home/xxx/public_html/lib/core/Tracker/Field/ItemLink.php","line":1002}
2020-10-04T18:36:12+00:00 ERR (3): NOTICE: Trying to access array offset on value of type null {"code":null,"file":"/home/xxx/public_html/lib/core/Tracker/Field/ItemLink.php","line":1002}
2020-10-04T18:36:12+00:00 ERR (3): NOTICE: Trying to access array offset on value of type null {"code":null,"file":"/home/xxx/public_html/lib/core/Tracker/Field/ItemLink.php","line":1002}
{CODE}

I have 2 itemLink, 1 itemList and 1 Dynamic ItemList in the tracker for the item 384.
The data displayed are correct, I have no missing.
I have several itemList values = 0
And 2 mathematical calculation that do their calculation.

Seems to be a false and general notice no matter what the data displayed.

In ItemLink if the setting for "Format for Customising Multiple Field"s has a "=" between two tracker fields (e.g. %0=%1) then one should be treated as value and the other as data.

This will be consistent with the behavior of the "Other" setting in DropDown field type and will simulate the options of the HTML select tag.

The enhanced functionality will enable ItemLink to display one set of data in a drop down but store the corresponding value in the tracker field; for those situations where we wish to store the value and not the data that the user selects in the drop down.

Currently the functionality is:
<select>
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="mercedes">Mercedes</option>
<option value="audi">Audi</option>
</select>

The enhancement will make this possible:
<select>
<option value="68768">Volvo</option>
<option value="543543">Saab</option>
<option value="678654">Mercedes</option>
<option value="32342">Audi</option>
</select>

When I point an itemlist on a multilingual text field from another tracker, It does not show anything.
Doing the same on a non-multilingual tracker works fine.

See both in a show instance.

I have tested Items List tracker fields as followed example, http://doc.tiki.org/Items+List+and+Item+Link+Tracker+Fields

But it does not work correctly. That is Company tracker didn't show the Products lists.

In addition, so I have changed 'Company name' field type of the Products into Text Field instead of Item Link, and insert some value 'Apple', 'Macromedia'. Then the tracker Company show the Products list well.

I have tested it at version 11.1 and 12.x.

The interactive part on creating a tracker item from r52312 vanished in r55703.

(more details later, I am really testing instance creation)

{syntax type="tiki" editor="plain"}
JavaScript pop-up calendars get hidden behind CSS "layers" in Trackers, especially when using the tabbed view. I've noticed this problem with more than one theme (Strasa and Tikipedia). It's a shame, since the popup calendar (or date picker) is such a useful tool, and works well in the 4.0 Add Calendar Item interface.

Workaround - Turn "tabs" off when inserting a new item, or else use the date selector control (not as nice) also provided with trackers.

The hidden date picker / popup calendar occurs in the latest versions of Explorer and Firefox, so it doesn't seem to be a browser problem, but rather a stylesheet problem (?).

~~#f00:__UPDATE - DEC 16, 2009__~~

This bug has been seen before...
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1585&show=view&trackerId=5

The "fix" can be made locally - see workaround below

For text area trackers:

http://www.felgall.com/jstip42.htm

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

(17:34:00) snarlydwarf: god, i love tiki.
(17:34:37) snarlydwarf: "why are you haveing people go to a tracker, lookie, heres a wiki page that looks prettier but still fills out the tracker form"
(17:37:18) snarlydwarf: oooh, someone with commit wanna fix an annoying jscal feature?
(17:37:41) snarlydwarf: at line 745 of lib/jscalender/calendar.js
(17:37:57) snarlydwarf: in the 'this.isPopup' clause
(17:38:36) snarlydwarf: add div.style.zIndex = "300";
(17:38:51) snarlydwarf: so the dumb calender doesnt pop up behind tabs
(17:39:09) snarlydwarf: 300 seems sufficient to be 'higher' than other items on the page
(17:39:44) snarlydwarf: you can see this if you have a jscal input in a tracker and use tabs
(17:40:05) snarlydwarf: (at least in 1.10)
(17:40:41) nyloth: snarlydwarf: thanx. Don't hesitate to commit this, or to send it to the devel mailing list

I added a jscalendar field to a new tracker. On the item entry page, the calendar is drawn underneath the form.

# Create a field of type JSCalendar
# go entering a new tracker item
and see weird behaviour:

__With Konqueror:__
* JSCalendar opens
* You can select a date
* Clicking besides the calendar closes it
* The field still reads the current date, that was shown, when starting to create the tracker item

__With FireFox:__
* JSCalendar opens
* You can select a date
* JSCalendar is closed immediately
* The date field is empty

Saving the Tracker item saves the always the current date and time with both browsers

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

When you click on the Edit button of a KanBan card it load a new page to edit the trackeritem.

Everywhere else (by default) the edit trackeritem screen opens in a modal.
It should be the same for the card of a Kanban plugin.

I created an instance : http://bsfez-11581-8358.show2.tiki.org/tiki-index.php?page=Basic-board

If a user selector field is used in KanBan it should behave accordingly to the Tiki preferences for the username display.

If the Tiki is set to use the user real name it shouldn't be different in Kanban.