Looking for a technique to create flexible, graphical dashboards in Trac wiki pages

62 views
Skip to first unread message

Chris Nelson

unread,
Oct 6, 2009, 4:11:41 PM10/6/09
to trac-...@googlegroups.com
I use the burndown chart and workload chart and they're great as far as they go but there are other ways I want to analyze Trac data and I would really prefer to embed graphical output into wiki pages than have stand-alone charts or tables. What I'm looking for is some guidance on how I can have a graphic embedded in a wiki page refresh when I view the page. This would be something like the DiaVisView plugin which regenerates the .png from the .dia whenever the .dia is newer but would instead run some script that generated the graphic (say, with a sqlite query creating a cvs file passed into csv2gnuplot which would create a .png). Maybe the skeleton of the DiaVisView plugin or the burndown chart would be a starting point but if there's a better approach, I'd love to hear it.

Chris
--
Christopher Nelson, Software Engineering Manager
SIXNET - Solutions for Your Industrial Networking Challenges
331 Ushers Road, Ballston Lake, NY  12019
Tel: +1.518.877.5173, Fax: +1.518.877.8346 www.sixnet.com

Olemis Lang

unread,
Oct 6, 2009, 4:50:32 PM10/6/09
to trac-...@googlegroups.com
On Tue, Oct 6, 2009 at 3:11 PM, Chris Nelson <Chris....@sixnet.com> wrote:
>
> I use the burndown chart and workload chart and they're great as far as they go but
> there are other ways I want to analyze Trac data and I would really prefer to embed
> graphical output into wiki pages than have stand-alone charts or tables.  What I'm
> looking for is some guidance on how I can have a graphic embedded in a wiki page
> refresh when I view the page.

If nobody mentioned TracGViz [1]_ [2]_ so far it's because I'm extremely shy

:P

You can see how it works at the issue tracker [4]_ , and some pages
[3]_ may be useful too . There are a lot of visualizations out there
[5]_ and anybody can build new ones ;o)

> This would be something like the DiaVisView plugin
> which regenerates the .png from the .dia whenever the .dia is newer but would
> instead run some script that generated the graphic (say, with a sqlite query creating
> a cvs file passed into csv2gnuplot which would create a .png).

That's a great idea. I thought about that once I discovered `gnuplot`
some time ago. Something like this goes after I can release a newer
version of TracGViz ;o)

> Maybe the skeleton
> of the DiaVisView plugin or the burndown chart would be a starting point but if
> there's a better approach, I'd love to hear it.
>

This is another idea I had in my mind : build extensions so that data
managed by third-party plug-ins may be used by widgets able to consume
data formatted according to Google Visualization Data protocol .

In this case it is possible to build an extension in order to export
the data the data you need to use so that it may be embedded in wiki
pages by using Google Visualization gadgets [3]_. If you think this is
a valid option I could even make some space in TracGViz repos, create
an skeleton and provide you with access in order to help you build an
a plugin to get this done (quick solution is = you only need to
implement two methods in an interface ;o)

If you need further assistance you may ask . Don't be shy !

;o)

Right now I'm working on adding support for Google Visualization Query
Language, and a few more features (e.g. tests ;o) ...

.. [1] Trac integration with Google Visualization API
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz)

.. [2] TracGViz download @ PyPI
(http://pypi.python.org/pypi/TracGViz)

.. [3] Embedding Visualization Gadgets in wiki pages
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/EmbedGVizGadget)

.. [4] Welcome to Simelo's projects site
(https://opensvn.csie.org/traccgi/swlcu/wiki/WikiStart)

.. [5] Google Visualization API Gadget Gallery
(http://code.google.com/apis/visualization/documentation/gadgetgallery.html)

--
Regards,

Olemis.

Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/

Featured article:
Nabble - Trac Users - Coupling trac and symfony framework -
http://feedproxy.google.com/~r/TracGViz-full/~3/hlNmupEonF0/Coupling-trac-and-symfony-framework-td25431579.html

Roger Oberholtzer

unread,
Oct 7, 2009, 9:28:30 AM10/7/09
to trac-...@googlegroups.com
On Tue, 2009-10-06 at 15:50 -0500, Olemis Lang wrote:
> On Tue, Oct 6, 2009 at 3:11 PM, Chris Nelson <Chris....@sixnet.com> wrote:
> >
> > I use the burndown chart and workload chart and they're great as far as they go but
> > there are other ways I want to analyze Trac data and I would really prefer to embed
> > graphical output into wiki pages than have stand-alone charts or tables. What I'm
> > looking for is some guidance on how I can have a graphic embedded in a wiki page
> > refresh when I view the page.
>
> If nobody mentioned TracGViz [1]_ [2]_ so far it's because I'm extremely shy
>
> :P
>
> You can see how it works at the issue tracker [4]_ , and some pages
> [3]_ may be useful too . There are a lot of visualizations out there
> [5]_ and anybody can build new ones ;o)

I looked at [3]. It was nice. I then copied the first command to my own
page, and I got:

Error: Failed to load processor iGoogleGadgetMacro
No macro or processor named 'iGoogleGadgetMacro' found

I have TracGViz 1.3.1 installed and, and tracgviz.* is Enabled. Do I need to update to 1.3.4? If so, is just to install it over 1.3.1?

> .. [3] Embedding Visualization Gadgets in wiki pages
> (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/EmbedGVizGadget)

--
Roger Oberholtzer

OPQ Systems / Ramböll RST

Ramböll Sverige AB
Krukmakargatan 21
P.O. Box 17009
SE-104 62 Stockholm, Sweden

Office: Int +46 8-615 60 20
Mobile: Int +46 70-815 1696

Olemis Lang

unread,
Oct 7, 2009, 10:14:02 AM10/7/09
to trac-...@googlegroups.com
On Wed, Oct 7, 2009 at 8:28 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
>>
>> You can see how it works at the issue tracker [4]_ , and some pages
>> [3]_ may be useful too . There are a lot of visualizations out there
>> [5]_ and anybody can build new ones ;o)
>
> I looked at [3]. It was nice. I then copied the first command to my own
> page, and I got:
>
>  Error: Failed to load processor iGoogleGadgetMacro
>  No macro or processor named 'iGoogleGadgetMacro' found
>

Thnx for the pointer. There's an error in the docs (not the wiki
formatting ;o). In fact if look at the example shown below you can
notice that it should be `iGoogleGadget` instead of
`iGoogleGadgetMacro`. The whole macro invocation should look like the
one shown below

{{{
[[iGoogleGadget(url=http://www.google.com/ig/modules/motionchart.xml,
_table_query_url=http://spreadsheets.google.com/tq?key=pCQbetd-CptE1ZQeQk8LoNw,
_table_query_refresh_interval=30000, width=400, height=300)]]
}}}

I'm fixing that right now, sorry for the inconvenience

> I have TracGViz 1.3.1 installed and, and tracgviz.* is Enabled. Do I need to update to 1.3.4? If so, is just to install it over 1.3.1?
>

I recommend you to upgrade if you want to use much more data sources .
Otherwise, iGoogleMacro has not changed at all between both versions
(AFAICR ;o) and if something changed is just implementation details.

In TracGViz 1.3.4 you'll also find support for TracLinks expansion
[2]_ and macro aliases (example here [1]_ using SimpleTable gadget).
That would allow you to write

{{{
[[[[MotionChart(table_query_url=[gviz:google:sheet:pCQbetd-CptE1ZQeQk8LoNw],
_table_query_refresh_interval=30000, width=400, height=300)]]
]]
}}}

and get back exactly the same results thus hiding the gadget URL
(should be easier to remember gadgets this way ;o). By default names
for Google's gadgets are available OOTB but It is also possible to
configure aliases for other gadgets too.

Damn it ! This is not documented
:-/

.. [1] Can one actually use Trac data ... ?
(https://opensvn.csie.org/traccgi/swlcu/ticket/22)

.. [2] Using TracLinks expressions to embed iGoogle gadgets
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/TracLinks)

RJOllos

unread,
Oct 8, 2009, 3:31:27 PM10/8/09
to Trac Users


On Oct 6, 1:50 pm, Olemis Lang <ole...@gmail.com> wrote:
> If nobody mentioned TracGViz [1]_ [2]_ so far it's because I'm extremely shy

Thank you for all of the info! The Trac-Hacks page [1] for this
plugin could definitely use an update. It doesn't do even begin to
provide the capabilities that you have just described.

[1] http://trac-hacks.org/wiki/TracGvizPlugin

Olemis Lang

unread,
Oct 8, 2009, 4:11:24 PM10/8/09
to trac-...@googlegroups.com

Mainly because that's not the place where all these features are documented
It's just an index page for a plugin hosted somewhere, so that users
can browse to
the real site,
mainly because it's quite unlikely (IMHO today) that the plugin will
be installed in th.org, and I don't want to miss the opportunity to
show how it looks like ;o)

so no plan for updates, unless somebody else spend a little time in
order to maintain an index page in there, or unless I can include data
from the original site inside that page.

mainly ... unless ...

:)

--
Regards,

Olemis.

Featured article:
Search for milestone change in change history - Trac Users ... -
http://feedproxy.google.com/~r/TracGViz-full/~3/Gsj4xLjuCtk/578d40b734e5e753

jevans

unread,
Oct 8, 2009, 10:38:12 PM10/8/09
to Trac Users
> Search for milestone change in change history - Trac Users ...  -http://feedproxy.google.com/~r/TracGViz-full/~3/Gsj4xLjuCtk/578d40b73...

Hi,
I've read through your sites but still at a bit of a loss to
understand. Could you give some common uses for your plugin?
Thanks,
- jevans

Roger Oberholtzer

unread,
Oct 9, 2009, 7:28:57 AM10/9/09
to trac-...@googlegroups.com
On Wed, 2009-10-07 at 09:14 -0500, Olemis Lang wrote:
> On Wed, Oct 7, 2009 at 8:28 AM, Roger Oberholtzer
> <roger.ob...@gmail.com> wrote:
> >
> >>
> >> You can see how it works at the issue tracker [4]_ , and some pages
> >> [3]_ may be useful too . There are a lot of visualizations out there
> >> [5]_ and anybody can build new ones ;o)
> >
> > I looked at [3]. It was nice. I then copied the first command to my own
> > page, and I got:
> >
> > Error: Failed to load processor iGoogleGadgetMacro
> > No macro or processor named 'iGoogleGadgetMacro' found
> >
>
> Thnx for the pointer. There's an error in the docs (not the wiki
> formatting ;o). In fact if look at the example shown below you can
> notice that it should be `iGoogleGadget` instead of
> `iGoogleGadgetMacro`. The whole macro invocation should look like the
> one shown below
>
> {{{
> [[iGoogleGadget(url=http://www.google.com/ig/modules/motionchart.xml,
> _table_query_url=http://spreadsheets.google.com/tq?key=pCQbetd-CptE1ZQeQk8LoNw,
> _table_query_refresh_interval=30000, width=400, height=300)]]
> }}}

I tried this and got:



Error: Failed to load processor iGoogleGadget

No macro or processor named 'iGoogleGadget' found

Still with 1.3.1. I will try 1.3.newest when I can fiddle with the trac
site in question.

--
Roger Oberholtzer

Roger Oberholtzer

unread,
Oct 9, 2009, 7:45:13 AM10/9/09
to trac-...@googlegroups.com
On Fri, 2009-10-09 at 13:28 +0200, Roger Oberholtzer wrote:

> I tried this and got:
>
> Error: Failed to load processor iGoogleGadget
> No macro or processor named 'iGoogleGadget' found
>
> Still with 1.3.1. I will try 1.3.newest when I can fiddle with the trac
> site in question.

Just got the same thing with 1.3.4.

--
Roger Oberholtzer

Olemis Lang

unread,
Oct 9, 2009, 8:05:36 AM10/9/09
to trac-...@googlegroups.com

Please take a look at TracMacros wiki page.

- The macro should be listed and documented in there
- Otherwise it is disabled, please enable it
`tracgviz.ig.wiki.iGoogleGadget = enabled`
or use WebAdmin plugin
- Restart the server and try again
- If you still experience problems then please enable debug
create a ticket [1]_ and attach the log (in general only lines
having messages starting with `IG: ` prefix are relevant)

Thnx

.. [1] New ticket
(https://opensvn.csie.org/traccgi/swlcu/newticket?component=plugin_trac_gviz&type=defect)

Olemis Lang

unread,
Oct 9, 2009, 9:01:34 AM10/9/09
to trac-...@googlegroups.com
On Thu, Oct 8, 2009 at 9:38 PM, jevans <jeva...@gmail.com> wrote:
>
> Hi,

:)

> I've read through your sites but still at a bit of a loss to
> understand.

If you have any suggestions to enhance the documentation or doc

> Could you give some common uses for your plugin?
>

Briefly the main goal of the plugin is to integrate Trac with Google
technologies, especially those being useful to display multiple
contents everywhere WikiFormatting is allowed. So far this includes
iGoogle gadgets, and visualization gadgets.

The former are like a mini-site inside your site. so that encloses
infinite possibilities. For example if you want to embed GTalk gadget
in your wiki pages you can do it, if you want to build your own gadget
containing your own mini-app and embed it in your wiki pages the just
do it. If you have a Tweeter account and want to show your tweets in
your wiki pages then do it ... there are no limits !

Visualization gadgets are a subset of the former. They are built
specifically to display data from different locations in different
ways. Example data sources are Google Spreadsheets and ...

... your own Trac environment since it's able to offer the data
managed by plugins (tickets, wiki pages, files in your repos, ...
please read the reference page ;o) in the formats defined by GViz API
protocol. This also means that you can retrieve all these data in the
alternative formats supported by the protocol (e.g. CSV, TSV, HTML
...) plus other non-standard formats (e.g. MoinMoin wiki formatting,
RST coming soon ;o)

This doesn't end in here. Since the plugin is extensible (thnx Trac
devs for Trac architecture :) then you can implement your own data
sources. So, if you have a plugin that manages lots of data then you
can extend the two methods in `tracgviz.api.IGVizDataProvider` (AFAICR
;o) and automatically you'll be able to display your own data using
GViz gadgets.

If you read the docs for Google Visualization API, and iGoogle gadgets
then you'll find a lot of use cases. If you take a look at iGoogle
gadgets gallery and the visualization gadgets gallery you'll find a
lot of examples. Besides, if you have an specific question about
something that you want to do, then you may ask for support [2]_ and
specify what you need to do and I could help you to get it done.

Besides the plugin also offers some useful RPC handlers missing from
XmlRpcPlugin (e.g. for reports, timeline, VCS).

In fact I offered this opportunity so that you (users ;o) could help
me to discover the most common use cases, and document everything in
the FAQ [3]_.

The initial use case was that I wanted to display data (milestones,
tickets ...) about my projects in my blog (and I'll be able to do it
after 1.4.1 :o)

The next release will add very important features which will eliminate
current limitations, and subsequent versions will add much more value
, and useful features.

> Thanks,
> - jevans
>

Hope you like it once you try it

;o)

.. [2] Submit a support request
(https://opensvn.csie.org/traccgi/swlcu/newticket?component=plugin_trac_gviz&priority=trivial&type=support)

.. [3] TracGViz FAQ
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz#FAQ)

Roger Oberholtzer

unread,
Oct 9, 2009, 10:20:38 AM10/9/09
to trac-...@googlegroups.com
On Fri, 2009-10-09 at 07:05 -0500, Olemis Lang wrote:
> On Fri, Oct 9, 2009 at 6:45 AM, Roger Oberholtzer
> <roger.ob...@gmail.com> wrote:
> >
> > On Fri, 2009-10-09 at 13:28 +0200, Roger Oberholtzer wrote:
> >
> >> I tried this and got:
> >>
> >> Error: Failed to load processor iGoogleGadget
> >> No macro or processor named 'iGoogleGadget' found
> >>
> >> Still with 1.3.1. I will try 1.3.newest when I can fiddle with the trac
> >> site in question.
> >
> > Just got the same thing with 1.3.4.
> >
>
> Please take a look at TracMacros wiki page.
>
> - The macro should be listed and documented in there

It is not listed. Other added macgos (e.g., grapgviz) are listed.

> - Otherwise it is disabled, please enable it
> `tracgviz.ig.wiki.iGoogleGadget = enabled`
> or use WebAdmin plugin
> - Restart the server and try again

It is (has been) enabled as:

tracgviz.* = enabled

> - If you still experience problems then please enable debug
> create a ticket [1]_ and attach the log (in general only lines
> having messages starting with `IG: ` prefix are relevant)

I see this:

Trac[loader] DEBUG: Loading tracgviz from /usr/lib/python2.5/site-packages/TracGViz-1.3.4-py2.5.egg
Trac[chrome] DEBUG: Babel not found: ImportError: No module named babel

The two lines follow each other. Otherwise, all is fine in the log (set
to DEBUG). Does TracGViz require Babel?

--
Roger Oberholtzer

Olemis Lang

unread,
Oct 9, 2009, 10:58:29 AM10/9/09
to trac-...@googlegroups.com
On Fri, Oct 9, 2009 at 9:20 AM, Roger Oberholtzer

I thought I had removed that dependency since version 1.2.1 . Let me
see ... yes it shouldn't have done that. I don use Babel any more

Please, could you try to install Babel and try again ?

This is bizarre .

Roger Oberholtzer

unread,
Oct 11, 2009, 1:51:31 PM10/11/09
to trac-...@googlegroups.com
On Fri, 2009-10-09 at 09:58 -0500, Olemis Lang wrote:

> I thought I had removed that dependency since version 1.2.1 . Let me
> see ... yes it shouldn't have done that. I don use Babel any more
>
> Please, could you try to install Babel and try again ?

I added Babel. I did not see any error. I restarted Apache, but I do not
see any reference to Babel in the log. This includes the message about
it not being found. Still, the macro returns the message I originally
reported. And I do not see it listed in the macro page.

I have attached the log. I restarted everything, and then tried to
access the macro. Maybe you see something in the log.

--
Roger Oberholtzer

trac.log.gz

Olemis Lang

unread,
Oct 12, 2009, 10:39:48 AM10/12/09
to trac-...@googlegroups.com
On Sun, Oct 11, 2009 at 12:51 PM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
> On Fri, 2009-10-09 at 09:58 -0500, Olemis Lang wrote:
>
>> I thought I had removed that dependency since version 1.2.1 . Let me
>> see ... yes it shouldn't have done that. I don use Babel any more
>>
>> Please, could you try to install Babel and try again ?
>
> I added Babel. I did not see any error. I restarted Apache, but I do not
> see any reference to Babel in the log. This includes the message about
> it not being found.

There's something weird in there.

- Firstly the following line indicates that plugin is loaded but also
that it did not load any GViz provider (i.e. data sources ;o)
Are they enabled ?

{{{
2009-10-11 19:31:13,036 Trac[api] DEBUG: IG: Providers cache ({},)
}}}

In my test environment the log looks like this

{{{
2009-08-10 13:36:59,580 Trac[api] DEBUG: IG: Providers cache
({'/gviz/ticket/fields': <tracgviz.ticket.GVizTicketFields object at
0x8f5da0c>, '/gviz/wiki/index': <tracgviz.wiki.GVizWikiPages object at
0x8f56e8c>, '/gviz/ticket/resolution':
<tracgviz.ticket.GVizResolutionProvider object at 0x8f5cd0c>,
'/gviz/ticket/severity': <tracgviz.ticket.GVizSeverityProvider object
at 0x8f5d16c>, '/gviz/wiki/attachments':
<tracgviz.wiki.GVizWikiAttachments object at 0x8f5672c>,
'/gviz/ticket/actions': <tracgviz.ticket.GVizTicketActions object at
0x8f5d1ec>, '/gviz/search': <tracgviz.search.GVizSearchProvider object
at 0x8f0b4ec>, '/gviz/ticket/component':
<tracgviz.ticket.GVizComponentProvider object at 0x8f5c48c>,
'/gviz/source/file/history': <tracgviz.vcs.GVizSourceFileHistory
object at 0x8f849cc>, '/gviz/ticket/log':
<tracgviz.ticket.GVizTicketChangeLog object at 0x8f590cc>,
'/gviz/report/view': <tracgviz.ticket.GVizReportProvider object at
0x8f565cc>, '/gviz/report/list': <tracgviz.ticket.GVizAvailableReports
object at 0x8f5636c>, '/gviz/source/revlog':
<tracgviz.vcs.GVizChangesets object at 0x8f842cc>,
'/gviz/ticket/attachments': <tracgviz.ticket.GVizTicketAttachments
object at 0x8f59f8c>, '/gviz/timeline/filters':
<tracgviz.timeline.GVizTimelineFilters object at 0x8f84c0c>,
'/gviz/source/labels': <tracgviz.vcs.GVizQuickJumpEntries object at
0x8e82e8c>, '/gviz/ticket/version':
<tracgviz.ticket.GVizVersionProvider object at 0x8f5c2cc>,
'/gviz/ticket/list': <tracgviz.ticket.GVizTicketList object at
0x8f597cc>, '/gviz/ticket/milestone':
<tracgviz.ticket.GVizMilestoneProvider object at 0x8f5de6c>,
'/gviz/ticket/priority': <tracgviz.ticket.GVizPriorityProvider object
at 0x8f5d66c>, '/gviz/ticket/status':
<tracgviz.ticket.GVizStatusProvider object at 0x8f5c06c>,
'/gviz/source/changes': <tracgviz.vcs.GVizChangesetDetails object at
0x8f8494c>, '/gviz/timeline/log':
<tracgviz.timeline.GVizTimelineEvents object at 0x8f84e8c>,
'/gviz/source/files': <tracgviz.vcs.GVizSourceFiles object at
0x8f8480c>, '/gviz/search/filters':
<tracgviz.search.GVizSearchFiltersProvider object at 0x8ede92c>,
'/gviz/ticket/type': <tracgviz.ticket.GVizTypeProvider object at
0x8f5c38c>},)
}}}

So you're definitely missing a lot of things, everything indeed :-/

> Still, the macro returns the message I originally
> reported. And I do not see it listed in the macro page.
>
> I have attached the log. I restarted everything, and then tried to
> access the macro. Maybe you see something in the log.
>

- Secondly there's no indication in the log file about the error you
mention above. But the same happens to me . It seems that
the fact of not finding a macro is not reported to the log.
Shouldn't it happen ?

Q:
- How is it possible to know whether a macro is loaded or not ?

- Besides, if you had enabled gadget aliases you should have
several lines like this one (and you have none :-/ )

{{{
2009-10-12 10:26:12,720 Trac[wiki] DEBUG: GVIZ: LinkFormatter SHREF
rule triggered. Match=
'http://www.google.com/ig/modules/motionchart.xml' Full match=
'<_sre.SRE_Match object at 0x8f7c440>' Link= '<a class="ext-link"
href="http://www.google.com/ig/modules/motionchart.xml"><span
class="icon">http://www.google.com/ig/modules/motionchart.xml</span></a>'
}}}

So the only thing I can say so far is that the plugin is loaded but,
for some unknown reason, macro and further components are not enabled
at all. Therefore everything points to an issue with config options or
alike. In my `trac.ini` I see the following lines, please could you
try'em ? But it seems you already did it
:-/

{{{
[components]
tracgviz.* = enabled
}}}

BTW I see these ones when I disable igooglegadgetmacro
;o)

{{{
[components]
tracgviz.* = enabled
tracgviz.ig.wiki.igooglegadgetmacro = disabled
}}}

PS: If the fairy god mother has bewitched your Trac environment then
it's time to look for Shrek

:)

Roger Oberholtzer

unread,
Oct 12, 2009, 12:03:07 PM10/12/09
to trac-...@googlegroups.com
On Mon, 2009-10-12 at 09:39 -0500, Olemis Lang wrote:
> On Sun, Oct 11, 2009 at 12:51 PM, Roger Oberholtzer
> <roger.ob...@gmail.com> wrote:
> > On Fri, 2009-10-09 at 09:58 -0500, Olemis Lang wrote:
> >
> >> I thought I had removed that dependency since version 1.2.1 . Let me
> >> see ... yes it shouldn't have done that. I don use Babel any more
> >>
> >> Please, could you try to install Babel and try again ?
> >
> > I added Babel. I did not see any error. I restarted Apache, but I do not
> > see any reference to Babel in the log. This includes the message about
> > it not being found.
>
> There's something weird in there.
>
> - Firstly the following line indicates that plugin is loaded but also
> that it did not load any GViz provider (i.e. data sources ;o)
> Are they enabled ?
>
> {{{
> 2009-10-11 19:31:13,036 Trac[api] DEBUG: IG: Providers cache ({},)
> }}}
>
> In my test environment the log looks like this
>
> {{{
> 2009-08-10 13:36:59,580 Trac[api] DEBUG: IG: Providers cache
> ({'/gviz/ticket/fields': <tracgviz.ticket.GVizTicketFields object at
> 0x8f5da0c>, '/gviz/wiki/index': <tracgviz.wiki.GVizWikiPages object at

...

> So you're definitely missing a lot of things, everything indeed :-/

Is there no additional debug I can enable in TracGViz?

I wonder about these lines in my log:

Skipping "trac.mimeview.txtl = trac.mimeview.txtl [textile]":
("DistributionNotFound: textile>=2.0" not found)

Could this result in something missing that makes TracGViz unhappy? I
get a similar message for:

trac.mimeview.pygments
trac.mimeview.silvercity
spamfilter.bayes
spamfilter.ip_blacklist

> {{{
> [components]
> tracgviz.* = enabled
> }}}

In the Admin interface, there is only one item offered in TracGViz,
whcih is "TracGVizSystem", which I have set to enabled. Also, my
trac.ini does contain:

{{{
[components]
tracgviz.* = enabled
}}}

>
> BTW I see these ones when I disable igooglegadgetmacro
> ;o)
>
> {{{
> [components]
> tracgviz.* = enabled
> tracgviz.ig.wiki.igooglegadgetmacro = disabled
> }}}
>
> PS: If the fairy god mother has bewitched your Trac environment then
> it's time to look for Shrek

I think all my other plugins are working. I will check again just to be
sure. I think (95% certainty) that it is only TracGViz that is hesitant
to start. And yet it offers no complaint. Such a polite plugin.


Olemis Lang

unread,
Oct 12, 2009, 12:32:07 PM10/12/09
to trac-...@googlegroups.com
On Mon, Oct 12, 2009 at 11:03 AM, Roger Oberholtzer

<roger.ob...@gmail.com> wrote:
>
> On Mon, 2009-10-12 at 09:39 -0500, Olemis Lang wrote:
>> On Sun, Oct 11, 2009 at 12:51 PM, Roger Oberholtzer
>> <roger.ob...@gmail.com> wrote:
>> > On Fri, 2009-10-09 at 09:58 -0500, Olemis Lang wrote:
>> >
>> >> I thought I had removed that dependency since version 1.2.1 . Let me
>> >> see ... yes it shouldn't have done that. I don use Babel any more
>> >>
>> >> Please, could you try to install Babel and try again ?
>> >
>> > I added Babel. I did not see any error. I restarted Apache, but I do not
>> > see any reference to Babel in the log. This includes the message about
>> > it not being found.
>>
>> There's something weird in there.
>>
>>   - Firstly the following line indicates that plugin is loaded but also
>>     that it did not load any GViz provider (i.e. data sources ;o)
>>     Are they enabled ?
>>
>> {{{
>> 2009-10-11 19:31:13,036 Trac[api] DEBUG: IG: Providers cache ({},)
>> }}}
>>
>> In my test environment the log looks like this
>>
>> {{{
>> 2009-08-10 13:36:59,580 Trac[api] DEBUG: IG: Providers cache
>> ({'/gviz/ticket/fields': <tracgviz.ticket.GVizTicketFields object at
>> 0x8f5da0c>, '/gviz/wiki/index': <tracgviz.wiki.GVizWikiPages object at
>
> ...
>
>> So you're definitely missing a lot of things, everything indeed  :-/
>
> Is there no additional debug I can enable in TracGViz?
>

Well all debug goes to trac.log through Trac logging API, but if
components are not loaded then there's nothing to log ... what I don't
understand is why is it happening ...

> I wonder about these lines in my log:
>
>  Skipping "trac.mimeview.txtl = trac.mimeview.txtl [textile]":
>        ("DistributionNotFound: textile>=2.0" not found)
>
> Could this result in something missing that makes TracGViz unhappy?

Nop, they're irrelevant. I know them very well , I didn't include a
data source for mime types main because of that ;o)

[...]


>
>> {{{
>> [components]
>> tracgviz.* = enabled
>> }}}
>
> In the Admin interface, there is only one item offered in TracGViz,
> whcih is "TracGVizSystem", which I have set to enabled. Also, my
> trac.ini does contain:
>
> {{{
> [components]
> tracgviz.* = enabled
> }}}
>

Well, I believe you ...

>
> I think all my other plugins are working. I will check again just to be
> sure. I think (95% certainty) that it is only TracGViz that is hesitant
> to start. And yet it offers no complaint. Such a polite plugin.
>

Ahhhhh !!! politeness of the plugin is a genetic side-effect ;o)

Please try this one ... :

in tracgviz/__init__.py file you'll find code like the one shown
below. Please remove the comment before `raise` statement, and try
again.

Since you get nothing but TracGVizSystem then that means that
`XmlRpcPlugin` is missing and also that you skipped that part when you
installed the plugin (and that's documented [1]_ ;o)

Is this the case ?

{{{
#!python

try:
from api import TracGVizSystem
from rpc import *
from stdhash import *
from proto import GViz_0_5
from stdfmt import GVizJsonEncoder, GVizHtmlEncoder, GVizCSVEncoder
from extfmt import *
from ticket import *
from wiki import *
from search import *
from timeline import *
from vcs import *
from ig import *
msg = 'Ok'
except Exception, exc:
# raise
msg = "IG: Exception %s raised: '%s'" % (exc.__class__.__name__, str(exc))
}}}

How could I forget that one ? would you all help me with my funeral ?

.. [1] Trac integration with Google Visualization API

(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz#Dependencies)

Roger Oberholtzer

unread,
Oct 12, 2009, 3:16:44 PM10/12/09
to trac-...@googlegroups.com
On Mon, 2009-10-12 at 11:32 -0500, Olemis Lang wrote:

> Please try this one ... :
>
> in tracgviz/__init__.py file you'll find code like the one shown
> below. Please remove the comment before `raise` statement, and try
> again.
>
> Since you get nothing but TracGVizSystem then that means that
> `XmlRpcPlugin` is missing and also that you skipped that part when you
> installed the plugin (and that's documented [1]_ ;o)
>
> Is this the case ?

After the edit, when I run:

python setup.py install

I get:

Traceback (most recent call last):
File "setup.py", line 22, in <module>
from __init__ import __doc__ as DESC
File "/root/TracThingWeHaveAdded/TracGViz-1.3.4/__init__.py", line 40,
in <module>
from rpc import *
File "/root/TracThingWeHaveAdded/TracGViz-1.3.4/rpc.py", line 44, in
<module>
from tracrpc.api import IXMLRPCHandler
ImportError: No module named tracrpc.api

I am off to [1] to see what I missed. I thought

easy_install TracGViz

picked up all dependencies. Perhaps not.

Roger Oberholtzer

unread,
Oct 12, 2009, 3:37:51 PM10/12/09
to trac-...@googlegroups.com
On Mon, 2009-10-12 at 11:32 -0500, Olemis Lang wrote:

> Ahhhhh !!! politeness of the plugin is a genetic side-effect ;o)
>
> Please try this one ... :
>
> in tracgviz/__init__.py file you'll find code like the one shown
> below. Please remove the comment before `raise` statement, and try
> again.
>
> Since you get nothing but TracGVizSystem then that means that
> `XmlRpcPlugin` is missing and also that you skipped that part when you
> installed the plugin (and that's documented [1]_ ;o)
>
> Is this the case ?

Busted. I wonder why only that one is missing. I see that it does not
install successfully via easy_install. I had to get the zip source and
install. Maybe I missed that the first time.

I am now able to embed google thingies. My first task is a way to make
plots of filtered data that gets updated if the filter software changes.

--
Roger Oberholtzer

Roger Oberholtzer

unread,
Oct 12, 2009, 4:27:51 PM10/12/09
to trac-...@googlegroups.com

Flush with excitement with getting basic google gadgets to work, I tried
using a wiki page attachment as a data source (shamelessly stolen from
your example, but modified for the local location):

_table_query_url=[attachment:wiki:GooglePlayground:timeline.json]

The file is at wiki/GooglePlayground in my site. When the page is
rendered, I get this:

Error: Macro
iGoogleGadget(url=http://www.google.com/ig/modules/time-series-line.xml,
_table_query_url=[attachment:wiki:GooglePlayground:timeline.json],
_table_query_refresh_interval=30000, width=600, height=400) failed

Unable to extract TracLink from DOM object.

Surely I did not miss another plugin...

--
Roger Oberholtzer

Olemis Lang

unread,
Oct 12, 2009, 4:35:03 PM10/12/09
to trac-...@googlegroups.com
On Mon, Oct 12, 2009 at 2:37 PM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Mon, 2009-10-12 at 11:32 -0500, Olemis Lang wrote:
>
>> Ahhhhh !!!   politeness of the plugin is a genetic side-effect ;o)
>>
>> Please try this one ... :
>>
>> in tracgviz/__init__.py file you'll find code like the one shown
>> below. Please remove the comment before `raise` statement, and try
>> again.
>>
>> Since you get nothing but TracGVizSystem then that means that
>> `XmlRpcPlugin` is missing and also that you skipped that part when you
>> installed the plugin (and that's documented [1]_ ;o)
>>
>> Is this the case ?
>
> Busted. I wonder why only that one is missing. I see that it does not
> install successfully via easy_install. I had to get the zip source and
> install. Maybe I missed that the first time.
>

I'll check out and fix that !

Thnx !

> I am now able to embed google thingies. My first task is a way to make
> plots of filtered data that gets updated if the filter software changes.
>

I see a big party coming !

Olemis Lang

unread,
Oct 12, 2009, 4:43:08 PM10/12/09
to trac-...@googlegroups.com
On Mon, Oct 12, 2009 at 3:27 PM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
>
> Flush with excitement with getting basic google gadgets to work, I tried
> using a wiki page attachment as a data source (shamelessly stolen from
> your example, but modified for the local location):
>

Oh !
If you stole it from my site then you must pay the double of the original price.
Damn it, It's free !

:)


> _table_query_url=[attachment:wiki:GooglePlayground:timeline.json]
>

{{{
_table_query_url=[raw-attachment:wiki:GooglePlayground:timeline.json]
}}}

but ...

> The file is at wiki/GooglePlayground in my site. When the page is
> rendered, I get this:
>

... are you sure ?

> Error: Macro
> iGoogleGadget(url=http://www.google.com/ig/modules/time-series-line.xml,
> _table_query_url=[attachment:wiki:GooglePlayground:timeline.json],
> _table_query_refresh_interval=30000, width=600, height=400) failed
>
> Unable to extract TracLink from DOM object.
>
> Surely I did not miss another plugin...
>

Nop. This time this means that the TracLinks expression was not
expanded to a valid location so target URL is missing. Please check
out that the TracLinks expression and the source file are both ok

;o)

Roger Oberholtzer

unread,
Oct 13, 2009, 2:26:14 AM10/13/09
to trac-...@googlegroups.com
On Mon, 2009-10-12 at 15:43 -0500, Olemis Lang wrote:
> On Mon, Oct 12, 2009 at 3:27 PM, Roger Oberholtzer
> <roger.ob...@gmail.com> wrote:
> >
> >
> > Flush with excitement with getting basic google gadgets to work, I tried
> > using a wiki page attachment as a data source (shamelessly stolen from
> > your example, but modified for the local location):
> >
>
> Oh !
> If you stole it from my site then you must pay the double of the original price.
> Damn it, It's free !
>
> :)
>
>
> > _table_query_url=[attachment:wiki:GooglePlayground:timeline.json]
> >
>
> {{{
> _table_query_url=[raw-attachment:wiki:GooglePlayground:timeline.json]
> }}}
>
> but ...
>
> > The file is at wiki/GooglePlayground in my site. When the page is
> > rendered, I get this:
> >
>
> ... are you sure ?

I admit I copied your example and made a quick edit just to see how this
all works. The file is an attachment to the page with the google stuff,
so I changed it to:

_table_query_url=[attachment:timeline.json]

Now I get a google outline for the plot, but after a while it says it
times out.

One more thing: where is the best documentation for these gadgets? That
is, all the args they take. I think I am looking at everything else but
them. Including things in a google iSite is described. But not this. I
sense from comments that Google have not really documented things for
this sort of use. So, where should I swing the dead chicken?


Olemis Lang

unread,
Oct 13, 2009, 8:47:02 AM10/13/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 1:26 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Mon, 2009-10-12 at 15:43 -0500, Olemis Lang wrote:
>> On Mon, Oct 12, 2009 at 3:27 PM, Roger Oberholtzer
>> <roger.ob...@gmail.com> wrote:
>> >
>> >
[...]

>
> I admit I copied your example and made a quick edit just to see how this
> all works. The file is an attachment to the page with the google stuff,
> so I changed it to:
>
>        _table_query_url=[attachment:timeline.json]
>
> Now I get a google outline for the plot, but after a while it says it
> times out.
>

That's a connectivity issue when the gadget is refreshing data (i.e.
`_table_query_refresh_interval=30000`) . Omit this field and it
*SHOULD* not refresh the contents displayed by the gadget

> One more thing: where is the best documentation for these gadgets? That
> is, all the args they take.
>

[...]
>

Multiple answers :

- Every GViz gadget [1]_ supports _table_query_url and
_table_query_refresh_interval . That's std
- GViz gadget built by Google are all documented (see `Help`
link below each entry in the gallery [1]_ )
- Google's gadgets are all documented
- Third-party gadgets and GViz gadgets have to be
documented by their respective owners. Docs are included
in the gadget descriptor and most of them are documented
(... but ...)
- You can try Gadgets Creator Page [3]_. It displays all parameters
accepted by gadgets and you can modify properties and
see how it will look like ;o)

> I
> sense from comments that Google have not really documented things for
> this sort of use. So, where should I swing the dead chicken?
>

You mean that Google didn't document a feature in their products?
Quite unlikely !
The only thing I found they didn't document was the way to access data
in worksheets inside a Google Spreadsheet [2]_, and they updated the
docs few days after ;o)

.. [1] Google Visualization API Gadget Gallery - Google Visualization API ...
(http://code.google.com/apis/visualization/documentation/gadgetgallery.html)

.. [2] [visualization-api] Links to data inside sheet in GoogleSpreadsheets
(http://www.mail-archive.com/google-visua...@googlegroups.com/msg02523.html)

.. [3] Gadget Creator Page
(http://gmodules.com/ig/creator?synd=open&url=http://www.google.com/ig/modules/motionchart.xml)

Roger Oberholtzer

unread,
Oct 13, 2009, 9:47:36 AM10/13/09
to trac-...@googlegroups.com
On Tue, 2009-10-13 at 07:47 -0500, Olemis Lang wrote:

> You mean that Google didn't document a feature in their products?
> Quite unlikely !
> The only thing I found they didn't document was the way to access data
> in worksheets inside a Google Spreadsheet [2]_, and they updated the
> docs few days after ;o)

I am sure google documented things for how they thought most folk would
use use them, which in an igoogle web page. To put the gadgets in an
unrelated web page, while obviously supported, seems more of a
challenge. Which is fine. I am up to the challenge.

I guess there is a learning curve here. I am obviously not inserting
something into a spreadsheet at google (I want to use data in my Trac
page). Let's take the example of a map. I need to supply a file with
some sort of locations. How should they be formatted? Street addresses?
Lat/long? Other? There must surely be key words that are recognized in
the _table_query_url data source. I doubt I can just make my own.

Olemis Lang

unread,
Oct 13, 2009, 10:48:45 AM10/13/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Tue, 2009-10-13 at 07:47 -0500, Olemis Lang wrote:
>
>> You mean that Google didn't document a feature in their products?
>> Quite unlikely !
>> The only thing I found they didn't document was the way to access data
>> in worksheets inside a Google Spreadsheet [2]_, and they updated the
>> docs few days after ;o)
>
> I am sure google documented things for how they thought most folk would
> use use them, which in an igoogle web page. To put the gadgets in an
> unrelated web page, while obviously supported, seems more of a
> challenge. Which is fine. I am up to the challenge.
>

You're right. I have plans to integrate TracGViz with WYSIWYG plugin,
but there are urgent issues that need to be closed before that, add to
that I need to survive , and the subsequent (current) limited time
(I'm also attending to some lectures ...) I have

:-/

It's a shame , but it seems the mystical beings (or whatever ...) have
designed the world so that I cannot do what I like to do, and survive
at the same time.


> I guess there is a learning curve here. I am obviously not inserting
> something into a spreadsheet at google (I want to use data in my Trac
> page). Let's take the example of a map. I need to supply a file with
> some sort of locations. How should they be formatted? Street addresses?
> Lat/long? Other? There must surely be key words that are recognized in
> the _table_query_url data source.

Take a look at the example data source for that gadget [2]_ in the gallery [1]_

;o)

> I doubt I can just make my own.
>

I'm sure, you're gonna make the best ones ever seen

;o)

>> .. [1] Google Visualization API Gadget Gallery - Google Visualization API ...
>>        (http://code.google.com/apis/visualization/documentation/gadgetgallery.html)
>>

.. [2] GeoMap example
(http://spreadsheets.google.com/pub?key=pCQbetd-CptHo44c-Bt43eg)

Olemis Lang

unread,
Oct 13, 2009, 10:52:30 AM10/13/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <ole...@gmail.com> wrote:
> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
> <roger.ob...@gmail.com> wrote:
>>

BTW

I wanted to say *THANK YOU*. This thread has populated my TODO list
with many interesting and useful ideas and new features.

:o)

Olemis Lang

unread,
Oct 13, 2009, 11:35:34 AM10/13/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <ole...@gmail.com> wrote:

I mean perhaps that's not the exact gadget you'r talking about, but
it's obvious that if the gadget author doesn't mention how to feed
data in then nobody can do it.

I'm probably missing something so, CMIIW

Olemis Lang

unread,
Oct 13, 2009, 11:59:59 AM10/13/09
to trac-...@googlegroups.com

Maybe the most common solution for gadgets in this case could be to
rely on a service (e.g. Google Maps ) and provide the id of the map to
be embedded or OTOH to add an option to the gadget so that users may
specify an URL pointing to KML files ... and both of them would be
handled just fine using the current approach.

Olemis Lang

unread,
Oct 13, 2009, 12:34:30 PM10/13/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 10:59 AM, Olemis Lang <ole...@gmail.com> wrote:
> On Tue, Oct 13, 2009 at 10:35 AM, Olemis Lang <ole...@gmail.com> wrote:
>> On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <ole...@gmail.com> wrote:
>>> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
>>> <roger.ob...@gmail.com> wrote:
>>>>
>>>> On Tue, 2009-10-13 at 07:47 -0500, Olemis Lang wrote:
>>>>
[...]

>>>>
>>>> I am sure google documented things for how they thought most folk would
>>>> use use them, which in an igoogle web page. To put the gadgets in an
>>>> unrelated web page, while obviously supported, seems more of a
>>>> challenge. Which is fine. I am up to the challenge.
>>>
>>> You're right. I have plans to integrate TracGViz with WYSIWYG plugin,
>>> but there are urgent issues that need to be closed before that, add to
>>> that I need to survive , and the subsequent (current) limited time
>>> (I'm also attending to some lectures ...) I have
>>>
>>> :-/
>>>
>>> It's a shame , but it seems the mystical beings (or whatever ...) have
>>> designed the world so that I cannot do what I like to do, and survive
>>> at the same time.
>>>
>>>
>>>> I guess there is a learning curve here. I am obviously not inserting
>>>> something into a spreadsheet at google (I want to use data in my Trac
>>>> page). Let's take the example of a map. I need to supply a file with
>>>> some sort of locations. How should they be formatted? Street addresses?
>>>> Lat/long? Other? There must surely be key words that are recognized in
>>>> the _table_query_url data source.
>>>
>>
>> I mean perhaps that's not the exact gadget you'r talking about, but
>> it's obvious that if the gadget author doesn't mention how to feed
>> data in then nobody can do it.
>>
>
> Maybe the most common solution for gadgets in this case could be to
> rely on a service (e.g. Google Maps ) and provide the id of the map to
> be embedded or OTOH to add an option to the gadget so that users may
> specify an URL pointing to KML files ... and both of them would be
> handled just fine using the current approach.
>

Or something like this gadget [1]_ which accepts queries to search for
locations, business and directions , but not parameter.

I'll write an entry to document how to use GMaps official gadget [2]_
so, please, take a look at the FAQ in a while ;o)

.. [1] Google Maps Gadget
(http://www.gmodules.com/ig/creator?synd=open&url=http%3A//sharing.ri.sch.edu.sg/maps.xml&pt=%26context%3Dd%26type%3Dgadgets%26synd%3Dig%26lang%3Den%26.lang%3Den%26country%3Dus%26.country%3Dus%26start%3D0%26num%3D1%26target%3Dbnb%26objs%3D&sn=bnb&lang=en)

.. [2] Google Maps Data Connector
(http://9tm49u91btpu7le36r63p2sj07eqiv5p.open.gmodules.com/ig/creator?synd=open&url=http%3A//www.google.com/ig/modules/map.xml&pt=%26context%3Dd%26type%3Dgadgets%26synd%3Dig%26lang%3Den%26.lang%3Den%26country%3Dus%26.country%3Dus%26start%3D0%26num%3D1%26target%3DFoc%26objs%3D923c3&sn=Foc&lang=en)

Olemis Lang

unread,
Oct 15, 2009, 3:47:24 PM10/15/09
to trac-...@googlegroups.com
On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Tue, 2009-10-13 at 07:47 -0500, Olemis Lang wrote:
>
>> You mean that Google didn't document a feature in their products?
>> Quite unlikely !
>> The only thing I found they didn't document was the way to access data
>> in worksheets inside a Google Spreadsheet [2]_, and they updated the
>> docs few days after ;o)
>
> I am sure google documented things for how they thought most folk would
> use use them, which in an igoogle web page. To put the gadgets in an
> unrelated web page, while obviously supported, seems more of a
> challenge. Which is fine. I am up to the challenge.
>
> I guess there is a learning curve here. I am obviously not inserting
> something into a spreadsheet at google (I want to use data in my Trac
> page). Let's take the example of a map. I need to supply a file with
> some sort of locations. How should they be formatted? Street addresses?
> Lat/long? Other? There must surely be key words that are recognized in
> the _table_query_url data source. I doubt I can just make my own.
>

Please take a look at this (new) page [1]_ where I document how to
write your files including raw GViz JSON data and please let me know
if it was useful for you or not. Any other suggestion will be welcome
as well.

Thnx a lot ! ... once again ...

.. [1] Preparing your data to be compatible with GViz wire protocol
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/RawData)

--
Regards,

Olemis.

Featured article:
Looking for a technique to create flexible, graphical dashboards ...
- http://feedproxy.google.com/~r/TracGViz-full/~3/QO5N8AG0NnM/d6e3b3fd323d5b52

Roger Oberholtzer

unread,
Oct 16, 2009, 2:18:52 AM10/16/09
to trac-...@googlegroups.com
On Thu, 2009-10-15 at 14:47 -0500, Olemis Lang wrote:

> Please take a look at this (new) page [1]_ where I document how to
> write your files including raw GViz JSON data and please let me know
> if it was useful for you or not. Any other suggestion will be welcome
> as well.

(I think we are veering off list topic here, so if this continues,
perhaps we should move the discussion off list? Perhaps we can wait for
someone to complain. The discussion is still about using a Trac plugin.)

Your discussion was very useful. Thanks!

Still, I seem to be missing something. Let's take the map as an example:
you provide two columns, one with locations, and the other a label to
show there. My real question is: how did you know that this is what map
took? Must the values be called 'Location' and 'Distance'? Or does it
use column one for locations, and two for labels, no matter what they
are called? What types of values can 'Location' be? Obviously street
addresses. How about Latitudes and Longitudes, as is the case in Google
Map? This is the type of documentation that I thing Google are missing.
A bit of documentation glue to put all their parts together.


Olemis Lang

unread,
Oct 16, 2009, 8:42:24 AM10/16/09
to trac-...@googlegroups.com, Google Gadgets API, google-visua...@googlegroups.com
@trac-users list

>>>On Tue, 2009-10-13 at 07:47 -0500, Olemis Lang wrote:
>>> You mean that Google didn't document a feature in their products?
>>> Quite unlikely !
>>> The only thing I found they didn't document was the way to access data
>>>> in worksheets inside a Google Spreadsheet [2]_, and they updated the
>>>> docs few days after ;o)
>>
>>> I am sure google documented things for how they thought most folk would
>>> use use them, which in an igoogle web page. To put the gadgets in an
>>> unrelated web page, while obviously supported, seems more of a
>>> challenge. Which is fine. I am up to the challenge.
>>
>> I guess there is a learning curve here. I am obviously not inserting
>> something into a spreadsheet at google (I want to use data in my Trac
>> page). Let's take the example of a map. I need to supply a file with
>> some sort of locations. How should they be formatted? Street addresses?
>> Lat/long? Other? There must surely be key words that are recognized in
>> the _table_query_url data source. I doubt I can just make my own

On Fri, Oct 16, 2009 at 1:18 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Thu, 2009-10-15 at 14:47 -0500, Olemis Lang wrote:
>
>> Please take a look at this (new) page [1]_ where I document how to
>> write your files including raw GViz JSON data and please let me know
>> if it was useful for you or not. Any other suggestion will be welcome
>> as well.
>
> (I think we are veering off list topic here, so if this continues,
> perhaps we should move the discussion off list? Perhaps we can wait for
> someone to complain. The discussion is still about using a Trac plugin.)
>

Well I'd have preferred to do it here [1]_ for two reasons :

- The issue would be documented in the site and FAQ
- users would be able to access all this in the future

I suggested you to do it that way but it was me who created the ticket
... I think that this part is a little bit OT but it's not about
gadgets in general, but rather about the workflow and steps related to
TracGViz plugin.

Anyway, if somebody complains we could move the discussion to the
aforementioned ticket [1]_ , but in this case it would very hard to
follow ... so, what a dilemma, isn't it ?

> Your discussion was very useful. Thanks!
>

:)

> Still, I seem to be missing something. Let's take the map as an example:
> you provide two columns, one with locations, and the other a label to
> show there. My real question is: how did you know that this is what map
> took?

There are two ways to get to Rome in this case :

- If you find the gadget by searching the visualization gallery [2]_ then
you have two links : Help [3]_ and Example [4]_ . If you follow and get
to [3]_ you will find once again a link to [4]_ . Even if the procedure is
specific to Google Spreadsheets, the columns are just the same
- If you find it by searching the iGoogle gadgets dir [5]_ then the first msg
you will see in there points once again to the location of docs [3]_

If you search a little you'll even find videos explaining how to use
the gadget [6]_

> Must the values be called 'Location' and 'Distance'?

Nop ... AFAIK you don't even need to include that, just take a look at
the image in [3]_

> Or does it
> use column one for locations, and two for labels, no matter what they
> are called?

That's the first thing that's explained in [3]_

> What types of values can 'Location' be? Obviously street
> addresses. How about Latitudes and Longitudes, as is the case in Google
> Map?

Why don't you try to include such values it just like you do it using
Google Maps ? In the end what you are looking in there is Google Maps
(inside a box ;o) so it's the same service ... BTW how d'u do that ?
I'm a GMaps neophyte and would like to try ;o)

> This is the type of documentation that I thing Google are missing.
> A bit of documentation glue to put all their parts together.
>

Well, after all this being said, if you mean that that could be done
better, well perhaps that's the case, but there's nothing I can do
either. Nonetheless I still think that the plugin is useful, and I
agree with you that there are some features that could be enhanced .
I'll be working on that in upcoming releases .

PS: I'm cross-posting this message to both Google Gadgets API and
Google Visualization API mailing list (see Cc) . I invite you to
follow this part of the thread in there.

BTW. What would you all think if the plugin provides a way to
integrate OpenOffice Calc (no support in MS Excel for python scripts
... sorry :-/ ) with Trac ? Would it be useful for you ? I mean that
might be even better, faster and more integrated to existing tools .

Looking forward to your comments ;o)

.. [1] How to display maps by storing data in attachments ?
(https://opensvn.csie.org/traccgi/swlcu/ticket/60)

.. [2] Google Visualization Gadget Gallery
(http://code.google.com/apis/visualization/documentation/gadgetgallery.html)

.. [3] Map help
(http://documents.google.com/support/bin/answer.py?answer=91601)

.. [4] Map example
(http://spreadsheets.google.com/pub?key=pCQbetd-CptFAQduF9vEUXA)

.. [5] iGoogle directory
(http://www.google.com/ig/directory?type=gadgets&url=www.google.com/ig/modules/map.xml)

.. [6] Video search
(http://www.google.com/search?client=opera&rls=en&q=google+maps+gadget+site:youtube.com&sourceid=opera&num=100&ie=utf-8&oe=utf-8)

Roger Oberholtzer

unread,
Nov 5, 2009, 3:22:27 PM11/5/09
to trac-...@googlegroups.com
On Thu, 2009-10-15 at 14:47 -0500, Olemis Lang wrote:

> .. [1] Preparing your data to be compatible with GViz wire protocol
> (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/RawData)

I have been trying to get tracgviz to do a simple table of data on my
wiki page. I only get a square and then red text that it has timed out.

My wiki text is:

[[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
_table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title=´LSOC-0105-90_SN0611344_20090305', _table_query_refresh_interval=30000, width=600, height=400)]]

all on one line.

The trac log contains this:

Trac[web_ui] INFO: IG: Gadget border store <tracgviz.ig.db.DefaultBordersRepository object at 0xb8b8e90c>
Trac[formatter] ERROR: Macro
iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
_table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title=´LSOC-0105-90_SN0611344_20090305', _table_query_refresh_interval=30000, width=600, height=400) failed:


Traceback (most recent call last):
File

"/usr/lib/python2.5/site-packages/Trac-0.12multirepos-py2.5.egg/trac/wiki/formatter.py", line 494, in _macro_formatter
return macro.process(args, in_paragraph=True)
File
"/usr/lib/python2.5/site-packages/Trac-0.12multirepos-py2.5.egg/trac/wiki/formatter.py", line 192, in process
text = self.processor(text)
File
"/usr/lib/python2.5/site-packages/Trac-0.12multirepos-py2.5.egg/trac/wiki/formatter.py", line 179, in _macro_processor
text)
File "build/bdist.linux-i686/egg/tracgviz/ig/wiki.py", line 200, in
expand_macro
return self.do_expand_macro(formatter, args)
File "build/bdist.linux-i686/egg/tracgviz/ig/wiki.py", line 190, in
do_expand_macro
urlencode(gadget_params), ''])
File "/usr/lib/python2.5/urllib.py", line 1251, in urlencode
v = quote_plus(str(v))
UnicodeEncodeError: 'ascii' codec can't encode character u'\xb4' in
position 0: ordinal not in range(128)

I think it must be complaining about my data file. Which is attached. I
think it looks ok.

I have tried many alternatives, but I do not get past this. The only
things I can see are different in my try is (1) the attachment is on a
wiki page with a name like transducer/inclinometer, or (2) my json file
has tabs. But the docs imply white space is allowed.

So I am guessing it is too obvious so I do not see the problem.

Help!

--
Roger Oberholtzer

LSOC-0105-90_SN0611344_20090305.json

Olemis Lang

unread,
Nov 5, 2009, 4:45:51 PM11/5/09
to trac-...@googlegroups.com
On Thu, Nov 5, 2009 at 3:22 PM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
> On Thu, 2009-10-15 at 14:47 -0500, Olemis Lang wrote:
>
>> .. [1] Preparing your data to be compatible with GViz wire protocol
>>         (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/RawData)
>
> I have been trying to get tracgviz to do a simple table of data on my
> wiki page. I only get a square and then red text that it has timed out.
>
> My wiki text is:
>
> [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
> _table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title=´LSOC-0105-90_SN0611344_20090305', _table_query_refresh_interval=30000, width=600, height=400)]]
>
> all on one line.
>
> The trac log contains this:
>
[...]

>
>  File "build/bdist.linux-i686/egg/tracgviz/ig/wiki.py", line 200, in
> expand_macro
>    return self.do_expand_macro(formatter, args)
>  File "build/bdist.linux-i686/egg/tracgviz/ig/wiki.py", line 190, in
> do_expand_macro
>    urlencode(gadget_params), ''])

Triggered by iGoogleMacro yes ...

>  File "/usr/lib/python2.5/urllib.py", line 1251, in urlencode
>    v = quote_plus(str(v))
> UnicodeEncodeError: 'ascii' codec can't encode character u'\xb4' in
> position 0: ordinal not in range(128)
>

Seems to be related to bizarre Unicode characters in one of the URLs .
Seems to be an issue with urllib module in Py stdlib. If you take a
look at the bottom of the last traceback you'll see that there's where
it is raised

;o)

> I think it must be complaining about my data file. Which is attached. I
> think it looks ok.
>

Nope ... it's the URL, please check it out

After first inspection seems to be the backquote in

{{{
title=´LSOC-0105-90_SN0611344_20090305'
}}}

> I have tried many alternatives, but I do not get past this. The only
> things I can see are different in my try is (1) the attachment is on a
> wiki page with a name like transducer/inclinometer, or (2) my json file
> has tabs. But the docs imply white space is allowed.
>

None of those ...

> So I am guessing it is too obvious so I do not see the problem.
>
> Help!
>

I'm calling both Batman and Superman (they have cell phones you know
?) . If they don't get there soon then, please, submit a ticket to the
prj site .

:)

--
Regards,

Olemis.

Featured article:
Can I call a wiki-macro from another wiki-macro? | Trac | Users -
http://feedproxy.google.com/~r/TracGViz-full/~3/Can8A-Em7gI/44142

Roger Oberholtzer

unread,
Nov 5, 2009, 4:10:26 PM11/5/09
to trac-...@googlegroups.com
On Thu, 2009-11-05 at 16:45 -0500, Olemis Lang wrote:

> Nope ... it's the URL, please check it out
>
> After first inspection seems to be the backquote in
>
> {{{
> title=´LSOC-0105-90_SN0611344_20090305'
> }}}

That is what is in the log, not my macro. I confess that I copied the
macro from the log. I assumed it would be the same as what I had. Seems
not.

So, here is what I actually have in the page:

[[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
_table_query_url=[raw-attachment:wiki:/transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title="LSOC-0105-90_SN0611344_20090305", _table_query_refresh_interval=30000, width=auto)]]


--
Roger Oberholtzer

Olemis Lang

unread,
Nov 6, 2009, 7:57:02 AM11/6/09
to trac-...@googlegroups.com
On Thu, Nov 5, 2009 at 4:10 PM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Thu, 2009-11-05 at 16:45 -0500, Olemis Lang wrote:
>
>> Nope ... it's the URL, please check it out
>>
>> After first inspection seems to be the backquote in
>>
>> {{{
>> title=´LSOC-0105-90_SN0611344_20090305'
>> }}}
>
> That is what is in the log, not my macro. I confess that I copied the
> macro from the log. I assumed it would be the same as what I had. Seems
> not.
>

In the first message you mentioned

{{{

My wiki text is:

[[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
_table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json],
title=´LSOC-0105-90_SN0611344_20090305',
_table_query_refresh_interval=30000, width=600, height=400)]]

}}}

and the backquote was there ...

> So, here is what I actually have in the page:
>
> [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
> _table_query_url=[raw-attachment:wiki:/transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title="LSOC-0105-90_SN0611344_20090305", _table_query_refresh_interval=30000, width=auto)]]
>
>

and it still does not work ?

try to change

raw-attachment:wiki:/transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json

and use

raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json

i.e. remove first slash after wiki:

PS: If you have enabled gadget aliases you could just write

[[SimpleTable(...)]]

ignoring url parameter

;o)

Roger Oberholtzer

unread,
Nov 6, 2009, 8:25:11 AM11/6/09
to trac-...@googlegroups.com
On Fri, 2009-11-06 at 07:57 -0500, Olemis Lang wrote:

> In the first message you mentioned
>
> {{{
>
> My wiki text is:
>
> [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
> _table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json],
> title=´LSOC-0105-90_SN0611344_20090305',
> _table_query_refresh_interval=30000, width=600, height=400)]]
>
> }}}
>
> and the backquote was there ...

Yes. It is in the log message from Trac, which I foolishly copied to my
post. In fact, the wiki page contains title="mm". The message in the log
seems to have the title quotes rewritten.

Note that I have a problem even when the only option is
_table_query_url=[...]

> > So, here is what I actually have in the page:
> >
> > [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
> > _table_query_url=[raw-attachment:wiki:/transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json], title="LSOC-0105-90_SN0611344_20090305", _table_query_refresh_interval=30000, width=auto)]]
> >
> >
>
> and it still does not work ?
>
> try to change
>
> raw-attachment:wiki:/transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json
>
> and use
>
> raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json
>
> i.e. remove first slash after wiki:

Makes no difference.

Even though the result looks the same in the page, the log is different:

Trac[db] INFO: IG: Configured path for gadget borders u''
Trac[db] INFO: IG: Image repository for gadget borders
in /vol1/trac/rsoft/htdocs/gadget/border
Trac[graphviz] INFO: version: 0.7.5dev - id: $Id$
Trac[util] INFO: IG: Missing XML-RPC handler ticket.component
Trac[util] INFO: IG: Missing XML-RPC handler ticket.version
Trac[util] INFO: IG: Missing XML-RPC handler ticket.type
Trac[util] INFO: IG: Missing XML-RPC handler ticket.status
Trac[util] INFO: IG: Missing XML-RPC handler ticket.resolution
Trac[util] INFO: IG: Missing XML-RPC handler ticket.priority
Trac[util] INFO: IG: Missing XML-RPC handler ticket.severity
Trac[util] INFO: IG: Missing XML-RPC handler ticket.milestone
Trac[util] INFO: IG: Missing XML-RPC handler ticket
Trac[util] INFO: IG: Missing XML-RPC handler ticket
Trac[util] INFO: IG: Missing XML-RPC handler ticket
Trac[util] INFO: IG: Missing XML-RPC handler ticket
Trac[util] INFO: IG: Missing XML-RPC handler ticket
Trac[util] INFO: IG: Missing XML-RPC handler wiki
Trac[util] INFO: IG: Missing XML-RPC handler wiki
Trac[util] INFO: IG: Missing XML-RPC handler search
Trac[util] INFO: IG: Missing XML-RPC handler search
Trac[util] INFO: IG: Hash method 'None'


Trac[web_ui] INFO: IG: Gadget border store

<tracgviz.ig.db.DefaultBordersRepository object at 0xb8ae59cc>

The difference is that now I am using a browser at work. Previously, the
browser was at home. In both cases they are Firefox on openSUSE. The
Trac site itself is the same one. I cannot think that matters. Yet there
is a difference in the log. Even though the

> PS: If you have enabled gadget aliases you could just write
>
> [[SimpleTable(...)]]

I started with this. When I had a problem, I tried the iGoogleGadget
macro. It makes no difference. The problem remains.

I have a Trac wiki test page for this where I have placed your
timeline.json file, and a simple table is displayed properly getting the
data from the wiki page attachment. This is why I have been suspecting
my json file. For the life of me, I cannot see what the issue is.

--
--
Roger Oberholtzer


Olemis Lang

unread,
Nov 6, 2009, 8:43:05 AM11/6/09
to trac-...@googlegroups.com
On Fri, Nov 6, 2009 at 8:25 AM, Roger Oberholtzer
<roger.ob...@gmail.com> wrote:
>
> On Fri, 2009-11-06 at 07:57 -0500, Olemis Lang wrote:
>
>> In the first message you mentioned
>>
>> {{{
>>
>> My wiki text is:
>>
>> [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
>> _table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json],
>> title=´LSOC-0105-90_SN0611344_20090305',
>> _table_query_refresh_interval=30000, width=600, height=400)]]
>>
>> }}}
>>
>> and the backquote was there ...
>
> Yes. It is in the log message from Trac, which I foolishly copied to my
> post. In fact, the wiki page contains title="mm". The message in the log
> seems to have the title quotes rewritten.
>
> Note that I have a problem even when the only option is
> _table_query_url=[...]
>

I'll try to do this myself in my site using your file . But in the
mean time, could you please try this

[[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
_table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json],

width=600, height=400)]]

>
>> PS: If you have enabled gadget aliases you could just write
>>
>> [[SimpleTable(...)]]
>
> I started with this. When I had a problem, I tried the iGoogleGadget
> macro. It makes no difference. The problem remains.
>
> I have a Trac wiki test page for this where I have placed your
> timeline.json file, and a simple table is displayed properly getting the
> data from the wiki page attachment. This is why I have been suspecting
> my json file. For the life of me, I cannot see what the issue is.
>

Let's see what I can find later ...

Roger Oberholtzer

unread,
Nov 6, 2009, 8:50:55 AM11/6/09
to trac-...@googlegroups.com
On Fri, 2009-11-06 at 08:43 -0500, Olemis Lang wrote:

> I'll try to do this myself in my site using your file . But in the
> mean time, could you please try this
>
> [[iGoogleGadget(url=http://www.google.com/ig/modules/simple-table.xml,
> _table_query_url=[raw-attachment:wiki:transducer/inclinometer:LSOC-0105-90_SN0611344_20090305.json],
> width=600, height=400)]]

I have tried this before. And, I have just tried it again (to be sure).
I did a cut and paste, making sure the macro is on one line (is that
required?) Same result. White box with a busy icon, then text claiming
"Request timed out"


--
Roger Oberholtzer


Cooke, Mark

unread,
Nov 9, 2009, 4:54:11 AM11/9/09
to trac-...@googlegroups.com
Hello,

> I have a Trac wiki test page for this where I have placed your
> timeline.json file, and a simple table is displayed properly getting
the
> data from the wiki page attachment. This is why I have been suspecting
> my json file. For the life of me, I cannot see what the issue is.
>

Just a thought but have you tried any of the online JSON validators? I
found them quite useful when I was starting with JSON (and the trying to
generate json in excel!). There are at least two linked from the bottom
of the JSON site (http://www.json.org)

Cheers,

~ Mark C

Roger Oberholtzer

unread,
Nov 9, 2009, 8:10:39 AM11/9/09
to trac-...@googlegroups.com

Start of embarrassed explanation:

There was a missing ':' in one of the numbers. It was not easy to see.
But http://www.jslint.com/ found it right away.

End of all that.

Mark, thanks for that pointer. I looked at the links at the bottom of
that page before. I just never 'saw' the lint checker.

--
Roger Oberholtzer

Olemis Lang

unread,
Nov 9, 2009, 9:53:02 AM11/9/09
to trac-...@googlegroups.com

Thnx Mark

There is a typo in there (missing colon).

Olemis Lang

unread,
Nov 9, 2009, 10:01:57 AM11/9/09
to trac-...@googlegroups.com

Probably process will be easier and more reliable using the conversion
script (CSV -> GViz) [1]_ . Did you try to do so ?

.. [1] Providing CSV data
(https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/RawData#UsingCSVfiles)

Roger Oberholtzer

unread,
Nov 9, 2009, 10:25:47 AM11/9/09
to trac-...@googlegroups.com
On Mon, 2009-11-09 at 10:01 -0500, Olemis Lang wrote:

> Probably process will be easier and more reliable using the conversion
> script (CSV -> GViz) [1]_ . Did you try to do so ?

Nope. The data sources are planned to be JSON generated by software. So
these foolish mistakes will not happen. Of course, they will then only
be the big complicated ones only software can cause :)

--
Roger Oberholtzer

joseph....@rrd.com

unread,
Nov 11, 2009, 1:41:11 PM11/11/09
to trac-users+...@googlegroups.com, trac-...@googlegroups.com


Best Regards,
 
Joe
 
________________________________________________________________________________________
Joseph H. Dayney | Software Engineer | RR Donnelley
630W 1000N | Logan, UT 84321 | (: 435-755-4278 | 801-453-5015 |È: 435-770-7244 | Ê: 435-755-4210 | *: joseph....@rrd.com
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
 


Roger Oberholtzer <roger.ob...@gmail.com>
Sent by: trac-...@googlegroups.com

11/09/2009 06:11 AM

Please respond to
trac-...@googlegroups.com

To
trac-...@googlegroups.com
cc
Subject
[Trac] Re: Looking for a technique to create flexible, graphical  dashboards in Trac wiki pages


Reply all
Reply to author
Forward
0 new messages