Google Org Chart issue

[TheInnovator]

I am trying to implement a Google Org chart and add the position as you see here
https://developers.google.com/chart/interactive/docs/gallery/orgchart#Data_Format
(Mike 'President' and Jim 'Vice President')

When I try the same I get the following
http://isaac.issharepoint.com/examples/WebPartPages/BuildOrgChart.aspx

Here's a snippet of my code:

I am using it in a SharePoint page

$(xData.responseXML).SPFilterNode('z:row').each(function() {													
					//OrgName=$(this).attr("ows_OrgName");	
					name = "{v:"+$(this).attr("ows_Name")+", f:<font color='red'>test</font>},'',''";

					//alert("name: "+name);
					ReportTo = $(this).attr("ows_Title");
					//ReportTo = $(this).attr("ows_ReportToOrg");
					
					ToolTip = $(this).attr("ows_ToolTip");	
						
					data.addRow([name, ReportTo, ToolTip]);
				});
				}	

Thanks for any help you can provide	

[Sergey Grabkovsky]

You are quoting the entire object. Your code should look more like this:

$(xData.responseXML).SPFilterNode('z:row').each(function() {
  //OrgName=$(this).attr("ows_OrgName");  

  var name = {
    v: $(this).attr("ows_Name"),

    f: "<font color='red'>test</font>"

  };

  //alert("name: "+name);
  ReportTo = $(this).attr("ows_Title");
  //ReportTo = $(this).attr("ows_ReportToOrg");

  ToolTip = $(this).attr("ows_ToolTip");

  data.addRow([name, ReportTo, ToolTip]);
});​

- Sergey

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

[Isaac Sogunro]

That fixed the error but now the "Name" does not show.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/RxjMv-_F0Yc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

--
-Isaac-

http://twitter.com/#!/feedy0urmind
You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you.
- James Allen

[asgallant]

Setting the formatted value (the "f" parameter) overrides the default value, so you have to include whatever you want displayed in the formatted value, eg:

$(xData.responseXML).SPFilterNode('z:row').each(function() {
    //OrgName=$(this).attr("ows_OrgName");
    var name = {
        v: $(this).attr("ows_Name"),

        f: "<font color='red'>" + $(this).attr("ows_Name") + "</font>"

    };

    //alert("name: "+name);
    ReportTo = $(this).attr("ows_Title");
    //ReportTo = $(this).attr("ows_ReportToOrg");

    ToolTip = $(this).attr("ows_ToolTip");

    data.addRow([name, ReportTo, ToolTip]);
});​

- Sergey

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/RxjMv-_F0Yc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

[Isaac Sogunro]

The (f:parameter) shows but the (v:parameter) does not.

Here's the list I'm reading from and as you will see the "ReportTo" shows up but not the Name.

http://isaac.issharepoint.com/examples/Lists/OrgChart/AllItems.aspx

I changed it to "ReportTo" to make more sense.

To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

[asgallant]

Yes, that is correct.  The "f" parameter is for specifying the formatted value of the cell (it specifies what gets displayed to the user).  If you set "f", then "v" will not be displayed - you have to set "f" to whatever you want the user to see.

- Sergey

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/RxjMv-_F0Yc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

--
-Isaac-

http://twitter.com/#!/feedy0urmind
You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you.
- James Allen

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/RxjMv-_F0Yc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

[Isaac Sogunro]

Ahhh....I see now.  That makes a lot of sense.

Got it working now.

Thanks!

To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.