Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Trac: Users

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

 

 

First page Previous page 1 2 Next page Last page  View All Trac users RSS feed   Index | Next | Previous | View Threaded


olemis at gmail

Oct 13, 2009, 7:48 AM

Post #26 of 45 (1123 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> 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)

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 13, 2009, 7:52 AM

Post #27 of 45 (1122 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <olemis [at] gmail> wrote:
> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
> <roger.oberholtzer [at] gmail> 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)

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 13, 2009, 8:35 AM

Post #28 of 45 (1122 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <olemis [at] gmail> wrote:
> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
> <roger.oberholtzer [at] gmail> 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 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

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 13, 2009, 8:59 AM

Post #29 of 45 (1122 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 10:35 AM, Olemis Lang <olemis [at] gmail> wrote:
> On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <olemis [at] gmail> wrote:
>> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
>> <roger.oberholtzer [at] gmail> 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 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.

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 13, 2009, 9:34 AM

Post #30 of 45 (1122 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 10:59 AM, Olemis Lang <olemis [at] gmail> wrote:
> On Tue, Oct 13, 2009 at 10:35 AM, Olemis Lang <olemis [at] gmail> wrote:
>> On Tue, Oct 13, 2009 at 9:48 AM, Olemis Lang <olemis [at] gmail> wrote:
>>> On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
>>> <roger.oberholtzer [at] gmail> 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)

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 15, 2009, 12:47 PM

Post #31 of 45 (1112 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Tue, Oct 13, 2009 at 8:47 AM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> 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.

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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Oct 15, 2009, 11:18 PM

Post #32 of 45 (1110 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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.



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Oct 16, 2009, 5:42 AM

Post #33 of 45 (1110 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

@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.oberholtzer [at] gmail> 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)

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Nov 5, 2009, 12:22 PM

Post #34 of 45 (1023 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
Attachments: LSOC-0105-90_SN0611344_20090305.json (1.04 KB)


roger.oberholtzer at gmail

Nov 5, 2009, 1:10 PM

Post #35 of 45 (1029 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Nov 5, 2009, 1:45 PM

Post #36 of 45 (1034 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Thu, Nov 5, 2009 at 3:22 PM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> 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.

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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Nov 6, 2009, 4:57 AM

Post #37 of 45 (1025 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Thu, Nov 5, 2009 at 4:10 PM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> 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)

--
Regards,

Olemis.

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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Nov 6, 2009, 5:25 AM

Post #38 of 45 (1030 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Nov 6, 2009, 5:43 AM

Post #39 of 45 (1020 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Fri, Nov 6, 2009 at 8:25 AM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> 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 ...

--
Regards,

Olemis.

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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Nov 6, 2009, 5:50 AM

Post #40 of 45 (1025 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


mark.cooke at siemens

Nov 9, 2009, 1:54 AM

Post #41 of 45 (1006 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Nov 9, 2009, 5:10 AM

Post #42 of 45 (1004 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Mon, 2009-11-09 at 09:54 +0000, Cooke, Mark wrote:
> 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)

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


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Nov 9, 2009, 6:53 AM

Post #43 of 45 (1006 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Mon, Nov 9, 2009 at 4:54 AM, Cooke, Mark <mark.cooke [at] siemens> wrote:
>
> 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)
>

Thnx Mark

There is a typo in there (missing colon).

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


olemis at gmail

Nov 9, 2009, 7:01 AM

Post #44 of 45 (1005 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

On Mon, Nov 9, 2009 at 8:10 AM, Roger Oberholtzer
<roger.oberholtzer [at] gmail> wrote:
>
> On Mon, 2009-11-09 at 09:54 +0000, Cooke, Mark wrote:
>> 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)
>
> 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.
>

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)

--
Regards,

Olemis.

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

Featured article:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


roger.oberholtzer at gmail

Nov 9, 2009, 7:25 AM

Post #45 of 45 (1012 views)
Permalink
Re: Looking for a technique to create flexible, graphical dashboards in Trac wiki pages [In reply to]

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 :)

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

--
Roger Oberholtzer


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

First page Previous page 1 2 Next page Last page  View All Trac users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.