Category: 1.9.x

{maketoc}

Using 1.9.cvs

!! 1st trial
!!! Using a tracker plugin code within this page content:
{CODE()}
{MAKETOCBOX(float=>none)}{MAKETOCBOX}
!! Ofertes de recursos o serveis

!!! Oferiments de transports
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Transport, exactvalue=>Transport, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de recursos (materials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Recurs, exactvalue=>Recurs, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de serveis (immaterials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Servei, exactvalue=>Servei, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments d'altres coses
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Altres, exactvalue=>Altres, goIfOne=>n)}Com????{TRACKERLIST}

!! Insereix nous oferiments a la base de dades
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}
{CODE}

!!!- Tracker 2 is this one:
{CODE()}
[TRACKER]
trackerId = 2
name = Ofertes
description = Ofertes de recursos i serveis de persones de la Vall del Corb i afins
useExplicitNames = n
showStatus = y
defaultStatus = o
showStatusAdminOnly = n
outboundEmail =
simpleEmail = n
newItemStatus = o
modItemStatus =
writerCanModify = y
writerGroupCanModify = n
showCreated = y
showLastModif = y
defaultOrderKey = -1
defaultOrderDir = asc
useComments = y
showComments = n
useAttachments = y
showAttachments = n
attachmentsconf = 0,1,3,0,2,0,0,0
useRatings = n
ratingOptions =
categories = 3
{CODE}

!!!- And its fields are these:
{CODE()}
[FIELD5]
fieldId = 5
name = Què ofereixes?
position = 10
type = t
options =
isMain = y
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = y
[FIELD6]
fieldId = 6
name = Tipus d'oferta
position = 20
type = d
options = Recurs,Servei,Transport,Altres
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = y
[FIELD7]
fieldId = 7
name = Descripció
position = 30
type = a
options = 1
isMain = n
isTblVisible = n
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
[FIELD17]
fieldId = 17
name = Foto
position = 35
type = i
options = 50,50,400,400,400
isMain = n
isTblVisible = n
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
[FIELD8]
fieldId = 8
name = Persones interessades
position = 40
type = l
options = 3,15,5,14,1
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
[FIELD16]
fieldId = 16
name = Demanda relacionada
position = 45
type = r
options = 3,9,1
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
[FIELD11]
fieldId = 11
name = Persona que ho ofereix
position = 50
type = u
options = 1
isMain = y
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = p
isMandatory = n
{CODE}

!!! I inserted this information:

||Què ofereixes? *: | Manual d'administració de Webs com aquesta
Tipus d'oferta *: |Recurs
Descripció: | En pdf..., i en català . tot i que la versió en anglès és més complerta.
Foto: |
Demanda relacionada: |
Persona que ho ofereix | admin
| submit button ||
''(At this page: [http://www.moviments.net/valldelcorb/Ofertes] )''

!!! I get this message after attempting to insert a new record:
^
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='Ofertes' where `itemId`='13'' at line 1
^

!! 2nd trial
I made another trial in another page just having the tracker plugin ([http://moviments.net/valldelcorb/prova]), with just this content in the page:
{CODE()}
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}
{CODE}

I got this message:
^
Warning: mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='prova' where `itemId`='14'' at line 1 in query:

update tiki_trk_2 set =? where `itemId`=?


in /home/httpd/tiki19/lib/tikidblib.php on line 134
^

On ((Add to WishList)), quicktags are missing.

When a tracker field type is email, a new option:

sendEmail=y|n|oy|on


This will permit that people that fill in a form get a copy of what they are filling out, which is often the case in public forms.


If this is set to (y)es, an email is sent to this email
If this is set to (n)o, no email is sent to this email
If set to (oy)ptional, the checkbox is check by default
If set to (on)ptional, the checkbox is not check by default

A checkbox is added at the bottom of the form like here:
http://www.comsol.com/support/form.php

2- A distinct email notification tracker would be needed (in addition to templates/mail/tracker_changed_notification.tpl) because we may not always want to disclose the same information to people that fill the form cv admins watching the forms.

3- The "from" email of the notification of this tracker should be the email which is filled in (as an option). So when I am notified about this tracker, I can just click "reply".

The user tracker is very useful:
tiki-view_tracker_item.php?view=+user

However, sometimes, I may want to manage this info in many different wiki pages. For example, I would like to put these three user forms on different wiki pages:

{CODE()}
{TRACKER(trackerId=>9, fields=>1:2:3, usertracker=>y)}{TRACKER}
{CODE}

{CODE()}
{TRACKER(trackerId=>9, fields=>1:4:5, usertracker=>y)}{TRACKER}
{CODE}

{CODE()}
{TRACKER(trackerId=>9, fields=>1:6:7, usertracker=>y)}{TRACKER}
{CODE}

trackerId #9 is a usertracker and field 1 is the login (so we can associate to appropriate tracker)


I would have more freedom to add instructions, comments, etc

Combined with [tiki-view_tracker_item.php?itemId=122|WikiPluginTracker : Confirmation message to any URL], I could create multi-page user trackers.

If the info has already been filled in, the tracker plugin will come-up pre-filled, like tiki-view_tracker_item.php?view=+user does.

We could also have the same concept for the group tracker:
tiki-view_tracker_item.php?view=+group

And why not extend to any tracker?

Trackers standard fields are afaik
- ItemId
- Created
- LastMod

You can't acces/modify/use those. But it would be necessary for example to:
- use the ItemId in the Item Link field
- make a default sort by creation date
- much more surely ;)

When using the Tracker-plugin in an article-body like this (or however, just use it in a way, that it shows fields ;) ):

~np~
{TRACKER(trackerId=>3,fields=>7:8{TRACKER}
~/np~

then it breaks in a way, that it parses the tracker-field-name as a link.

~np~
<input type="text" name="track[7]" value=""size="30"/>
~/np~

becomes

~np~
<input type="text" name="track<a class="wiki" href="7">7</a>" value=""size="30"/>
~/np~

Tracker filter is amazingly cool.

If there is a long list of tracker items, one should be able to search and filter all items based on a text string in any column.


[http://dev.tikiwiki.org/tiki-view_tracker.php?trackerId=5&status=o&sort_mode=f_41_desc&filtervalue%5B26%5D=webmail&filtervalue%5B56%5D=Accepted&filtervalue%5B48%5D=&filtervalue%5B27%5D=&filtervalue%5B28%5D=&filtervalue%5B54%5D=&filtervalue%5B55%5D=&filterfield=26&filter=filter|such things exist!] but are not available in Trackerlist plugin.

Here:
[http://dev.tikiwiki.org/Dynamic Filter]

I would like to add a text field for the description of the bug report.

And have multiple requests like this:
https://sourceforge.net/tracker/?atid=506846&group_id=64258&func=browse

I couldn't make trackerfilter and trackerlist plugins work with a tracker with mirror tables

Trackerlist plugin prevents the rest of the page from rendering.

Steps to reproduce:

1. Create a new tracker with Id 1
2. Add two trackerlistings with the same tracker id along with some garbage at the end of the page. An example page might look like this:

^
~np~{maketoc}~/np~


~np~!Design~/np~

~np~garbage here


~np~!Issue tracker~/np~

~np~!!Add an issue~/np~

~np~{TRACKER(trackerId=>1,fields=>1:2:3:4:5:6, action=>Add)}ITEM ADDED!!!!{TRACKER}~/np~


~np~!! View existing issues~/np~


~np~!!!Open issues~/np~
~np~{TRACKERLIST(trackerId=>1,fields=>1:2:3:5:6,
showtitle=>n,showlinks=>y,showdesc=>n,showinitials=>y,showstatus=>y,status=>o|p|op)} ~/np~


~np~!!!Closed issues~/np~
~np~{TRACKERLIST(trackerId=>1,fields=>1:2:3:5:6,
showtitle=>n,showlinks=>y,showdesc=>n,showinitials=>y,showstatus=>y,status=>c)} ~/np~



~np~garbage here.~/np~
^

3. Notice how the closed issues section doesn't even show up. Everything after the first trackerlist isn't shown.

The following code would show the value for tracker item ID #62:
{CODE()}
{TRACKERLIST(trackerId=>7,fields=>59,itemId=>62)}{TRACKERLIST}
{CODE}

We don't always need the field names when using a trackerlist. Especially if we are just listing one field.

A new parameter could be added:

showfieldname=>y|n default to yes (which is current behavior)

This could be used in conjunction with [tiki-view_tracker_item.php?itemId=938|Trackerlist Plugin: get results for a specific tracker item ID]. In which case, the following code could be used in a wiki page to show the value of field #59 for tracker item ID #62:
{CODE()}
{TRACKERLIST(trackerId=>7,fields=>59,itemId=>62,showfieldname=>n)}{TRACKERLIST}
{CODE}

Wiki pages could be built to include these dynamic fields. And the values could be updated via the tracker. A bit like the dynamic variables feature.

Some recent work from Kerrnel22 has improved the system field type in TikiWiki. (ItemID & Ratings)

However, this has uncovered some suprises.


1- When tracker fields are modified, a new "system" ItemID appears. It's great that it's now accessible but it shouldn't appear without active admin intervention.
{THUMB(id=28, url="tiki-browse_image.php?imageId=28")}{THUMB}

2- Ratings column moved from left to right after I changed some settings for the tracker.
{THUMB(id=27, url="tiki-browse_image.php?imageId=27")}{THUMB}

3- Any favorable behavior change should be ported to 1.10 as well.



I am not sure it's related, but I sometimes get this error when I add a tracker field:
{THUMB(id=43, url="tiki-browse_image.php?imageId=43")}{THUMB}

On IRC:
13.08.2007 03:03:11 [nkoth_] marclaporte: The reason why items don't appear in the tracker for page=cache is because those items have no rating, and the default sort mode as set in the admin...trackers is rating. It can't sort stuff with no rating so those are not shown.


Nelson is right on. See the 4 attached screenshots, in order.

1- Unrated_but_Categorized_tracker_item.jpg
2- Dev_Tracker_theme1.jpg
3- Rated_and_Categorized_tracker_item.jpg
4- Dev_Tracker_theme2.jpg

These were taken on 2007-08-13, with latest BRANCH-1-9 __after__ Nelson Ko (nkoth)'s recent fix to templates/tiki-plugin_trackerlist.tpl

http://tikiwiki.cvs.sourceforge.net/tikiwiki/tiki/templates/tiki-plugin_trackerlist.tpl?view=log&sortby=date&pathrev=BRANCH-1-9

Possibly related to doc/devtools/cleanCatTrackers.php which Sylvie has been using to periodically clean trackers up.

null rating and 0 is not the same thing.

----

Can you please retest in currently supported Tiki versions (e.g. Tiki12, ...)? Willing to clear the list of valid bug reports on rating... {sign user="xavi" datetime="2014-02-07T09:51:44+00:00"}

This problem occurs only when using the features "mirror-tables" AND "explicit names".

Using such a setup you can create a tracker like

- test

but then afterward no more trackers like:

- test 2
- test hello
- test (<- just a space here)

Quoting doesn't help!

Trackers item can be assigned to categories. Very powerful! 2 bugs discovered as ((tw:DogFood))ing this site.

However
1- If category listing is modified, the tracker category list is not updated. Ex.: Mobile Tiki is now in categories but is not in the list below.

2- categories are shown when creating, however, they don't appear when we edit a tracker. Try to edit this item and you will see!

Please see this example:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&offset=0&sort_mode=lastModif_desc&itemId=1088

Whatever was highlighted in the search in transformed accidentally:

<spanexternal link style="color:black;background-color:#ffff66;">fckeditor</span>

Trackers need a "view own items" permission. This would allow a user to view their own tracker items only. Thus, one could stop users seeing each others support calls, or in my particular planned app, other people's product registrations.

An example of the use of this is in product registration. My users would enter a serial number and some other details, like product location. Other products registrations are confidential, so thy shouldn't be able to see them.

If at a later date, a user wants to change their product details, so maybe change the location of the product, then they will see a list of only their products.

---
Related:
Tiki trackers for help desk -> customer support requests (requests are private)
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1293

Categories are multi-select fields. So sorting is not possible. Trackerlist plugin should not offer to sort (now with clickable title)

In a tracker (tiki-view_tracker_item.php) with mandatory fields or fields with a validation (ex.: email), if I don't fill the form properly, on save, I will be in view mode with the "Following fields are incorrect" warning. I must then click edit again to correct the info. This is not logical. I should stay in edit mode unless the form is saved without error.

1- If no country is selected, the image shows a broken link to img/flags/.gif

It should be blank or a transparent image.

2- When selecting country, the drop-down list should be like the others (blank field followed with the options), not with "None" in the middle of the list.

Problem: Someone could assign a tracker item to me, but how will I know unless I watch the whole tracker and check for my name in all the watches?

When I pick a login/username as "Assigned To", this person would need to receive a notification. Next to the username drop-down, there could be a checkbox "send a notification email to this person"


This is not so important, but a similar idea:
If it was the group which was picked, it could send an email to all members of the group.

todo
1) simple implementation: additional parameter to user field when defining the field: send to the specified user whenever the tracker changes
2) more difficult: this additional paramater can be 'always send email' or 'send email if the tracker modifior checks a box"

In a form, I give options. But sometimes, I would like to pre-select one of those options.

The list of options is separated by commas. Ex.:
1 low,2,3,4,5,6,7,8,9 high

Maybe adding stars around the default value?
1 low,2,3,4,*5*,6,7,8,9 high

Will this conflict with the new multilingual trackers?

When creating a new tracker item and when there are drop-down choices, the first choice is a blank field. This is the appropriate behavior.

However, when the field is mandatory, the first item on the list is automatically chosen. This is not OK because we can't be sure this was the person's choice (or they just didn't notice)

tiki-admin_tracker_fields.php?trackerId=X

Edit tracker fields "Type" has a problem to showing options to users.

phpBB is a popular open source forum software.
Sometimes, a forum is not enough.
So, the data must be migrated from phpBB to Tiki forums...

If you want to help:
Please post links to similar scripts.
ex.: phpbb to invision board, etc
If/when we do a script, we should do for all major forums.
---
__From kerrnel22 on 11/20/07:__

I have almost completed an integrated TikiWiki forum migration tool for 1.9.8.x and 1.10. Initial release will be to migrate only Tiki forums from one Tiki install to another. However, hooks are in place, and the intention is there, to work on extending the migration tool to importing of phpBB2 (or any other forum software) into Tiki. If you would like more information, email tiki.kerrnel@kerris.com. I expect a general release of the forum migration tool (for Tiki forums only) into cvs of both branches for beta testing by December 1/07. If all goes well, I'll have something released for phpBB2 migration prior to Dec 31.