Google Org Chart not Showing

69 views
Skip to first unread message

Clyde Symonette

unread,
Jan 15, 2018, 9:37:20 AM1/15/18
to Google Visualization API
Hi. I have an org chart that is dynamically created from a java application. I've determined that the chart will display if I delete alot of the datarows. Is there a work around.  Here is an example of my generated code:


<html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {packages:["orgchart"]});
      google.charts.setOnLoadCallback(drawChart);

      function drawChart() {
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Name');
        data.addColumn('string', 'Manager');
        data.addColumn('string', 'ToolTip');

        // For each orgchart box, provide the name, manager, and tooltip to show.
        data.addRows([
['Harrison, Joan, K', '', 'Application Support Officer II'],
['Ogle, Mary, J', 'null', 'Acting Sub-Lieutenant'],
['Wesley, Awilda, T', 'null', 'Administrator, Community Health Services'],
['Arrington, Marta, R', 'null', 'Admissions Officer'],
['Rhodes, Donald, G', 'null', 'Admissions Officer'],
['Wehmeyer, David, M', 'null', 'Advisor for National Events & Cultural Activities'],
['Kircher, Janet, J', 'null', 'Agricultural Trainee'],
['Harkins, Wanita, E', 'null', 'Air Traffic Controller II'],
['Mayo, Tonda, E', 'null', 'Ambulance Attendant'],
['Shultz, Jessica, K', 'null', 'Archives Assistant'],
['Daniels, James, D', 'null', 'Assistant Airport Manager'],
['Cox, Woodrow, Y', 'null', 'Assistant Assessor'],
['Streeter, Richard, L', 'null', 'Assistant Data Administrator'],
['Conkle, Rosa, S', 'null', 'Assistant Director of Labour'],
['Stith, William, K', 'null', 'Assistant Director of Legal Affairs'],
['Robbins, Lena, S', 'null', 'Assistant Director of Statistics'],
['Heid, Ron, B', 'null', 'Assistant Family Island Administrator'],
['McCants, Catherine, G', 'null', 'Assistant Manager, B.T.V.I'],
['Grant, Viola, D', 'null', 'Assistant Port Controller'],
['Drake, Edwin, K', 'null', 'Assistant Teacher'],
['Foster, Edward, H', 'null', 'Assistant Training Officer (Prisons)'],
['Nguyen, Julie, R', 'null', 'Assistant Veterinary Surgeon'],
['Hughes, William, L', 'null', 'Audiologist III'],
['Hillenbrand, Donald, J', 'null', 'Auditor General (w.e.f. 1/7/07)'],
['Barber, Sally, G', 'null', 'Binder 111, Government Printing'],
['Frye, Carolyn, R', 'null', 'Building Inspector'],
['Nicol, Margarita, A', 'null', 'Captain, Defence Force'],
['Donaldson, Terri, M', 'null', 'Chief Clinical Psychologist'],
['Moody, James, P', 'null', 'Chief Customs / Revenue Officer (Replaced Chief Customs Officer w.e.f. 01/11/09)'],
['Caudill, Wesley, S', 'null', 'Chief Dietitian'],
['Swims, Sybil, W', 'null', 'Chief Fire Officer'],
['Young, Patricia, K', 'null', 'Chief Justice'],
['Fry, Michael, A', 'null', 'Clinical Psychologist'],
['Smith, Bernice, K', 'null', 'Clinical Psychologist'],
['Smiley, Katherine, S', 'null', 'Consul'],
['Terry, Orville, P', 'null', 'Consultant (Health)'],
['Smith, Kimberly, R', 'null', 'Consultant (Health)'],
['Soper, Errol, G', 'null', 'Craft Instructor'],
['Harrison, Charles, E', 'null', 'Data Administrator'],
['Alexander, Adrian, M', 'null', 'Dental Technologist'],
['Banister, Donna, S', 'null', 'Dentist Appointed (After to July 1993'],
['Flores, Lilian, S', 'null', 'Deputy Chief Veterinary Surgeon'],
['Moore, Edith, J', 'null', 'Deputy Commodore, Defence Force'],
['Gillman, Paulette, D', 'null', 'Deputy Director of Oral Health'],
['Williams, Gene, B', 'null', 'Director of Agriculture'],
['Shahan, Celia, M', 'null', 'Director of Archives'],
['Craft, Flossie, J', 'null', 'Director of Community Affairs'],
['Emerson, Julie, J', 'null', 'Director of Cooperative Development'],
['Atwood, Mary, R', 'null', 'Director of Immigration'],
['Jones, Iris, L', 'null', 'Director of National HIV / AIDS and Infectious Disease Programme (w.e.f. 11/07/06)'],
['Clements, Wanda, J', 'null', 'Disability Affairs Officer'],
['Schultz, Samuel, T', 'null', 'Driving Examiner II, Road Traffic'],
['Do, Christopher, V', 'null', 'Financial Secretary'],
['Giddens, Carol, W', 'null', 'Flight Information Officer'],
['Wolfe, Sandra, G', 'null', 'Guidance Counselor 11'],
['Roberge, Charles, E', 'null', 'House Officer'],
['Faul, Stephen, J', 'null', 'Job Superintendent, Government Printing'],
['Spoon, Clair, W', 'null', 'Justice'],
['Spillman, Jeffery, N', 'null', 'Leading Fireman'],
['Pautz, Pamela, J', 'null', 'Manager, B.T.V.I'],
['Griffin, John, M', 'null', 'Marine Seaman'],
['Abbate, Kathleen, S', 'null', 'Meteorological Officer IV'],
['Garner, Virgil, N', 'null', 'Meteorological Officer IV'],
['Devine, Jason, E', 'null', 'Midshipman'],
['Oneal, Melissa, M', 'null', 'Nursing Officer 11'],
['Hanson, Heather, F', 'null', 'Nursing Officer 11'],
['Pope, Frank, M', 'null', 'Office Manager III'],
['Winters, Karen, S', 'null', 'Police Corporal'],
['Don, Brett, P', 'null', 'Postmaster'],
['Sanders, Melvin, B', 'null', 'Principal Grade 'A' Secondary'],
['McCoy, Bonnie, M', 'null', 'Principal Nursing Officer'],
['Gale, Lori, A', 'null', 'Senior Audiologist'],
['Tower, Carmen, K', 'null', 'Senior Customs / Revenue Officer (Replaced Senior Customs Officer w.e.f. 01/11/09)'],
['Lee, Lena, C', 'null', 'Senior Disability Affairs Officer'],
['Anderson, Joshua, J', 'null', 'Senior Disability Affairs Officer'],
['Diaz, Shaunta, C', 'null', 'Senior School Inspector'],
['Arrington, Kathleen, J', 'null', 'Senior Trained Clinical Nurse'],
['Villarreal, Gerald, C', 'null', 'Sergeant Fireman'],
['Lee, Guillermina, A', 'null', 'Statistical Assitant Grade I'],
['Turner, Sonya, A', 'null', 'Sub-Lieutenant'],
['Bever, Faye, D', 'null', 'Superintendent of Police']

        ]);

        // Create the chart.
        var chart = new google.visualization.OrgChart(document.getElementById('chart_div'));
        // Draw the chart, setting the allowHtml option to true for the tooltips.
        chart.draw(data, {allowHtml:true});
      }
   </script>
    </head>
  <body>
    <div id="chart_div"></div>
  </body>
</html>

Daniel LaLiberte

unread,
Jan 15, 2018, 11:37:31 AM1/15/18
to Google Visualization API
You probably have a syntax error due to: "'Principal Grade 'A' Secondary'".  The single quotes inside single quoted strings will not parse as you might hope.  You should probably escape the single quotes (with a preceding '\') or encode them, or use double quotes to wrap the string if you know you won't have double quotes in the content.

--
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-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/3c2a9c2e-9fb6-4f58-b8ca-1c702e362040%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Clyde Symonette

unread,
Jan 23, 2018, 12:39:04 PM1/23/18
to Google Visualization API
Daniel  Thank you!  That works.  What can I do to show errors? As it, it just displays nothing

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



--

Daniel LaLiberte

unread,
Jan 23, 2018, 12:54:46 PM1/23/18
to Google Visualization API
When you visit the page, open the JavaScript developer console, debugger, or whatever it is called in your browser.  You should see errors displayed in the console there.  Syntax errors are typically fatal in a messy way, so there is nothing Google Charts can do about showing the errors in the page.

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



--

--
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-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.

Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/6b275593-5bab-430f-a96f-5ed2336473be%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--

Clyde Symonette

unread,
Jan 23, 2018, 1:31:31 PM1/23/18
to Google Visualization API
Daniel:  Again. Thank you VERY MUCH!

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



--

--
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-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.



--
Reply all
Reply to author
Forward
0 new messages