Categories > OpenTBS with PPTX >

howto from mysql query to pptx

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: mpol
Date: 2013-09-02
Time: 11:51

howto from mysql query to pptx

Hello
Could someone  please help me to transfer the following sql query in a form to use in .pptx template? I want to use the field "Kommentar" as content of cloud or bubble at the third slide "it's quite...".  The rest of the fields are for series in my_cahrt.

SELECT `Vortrag`, `Betraege`, `Leistungen`,`Anlagen`,`Endbestand`, `Kommentar` >   FROM `gs_liqmittel` WHERE `Datum` <= '2013-09-03'

I will appriciate to have some hints how to do this to use the pptx template.

mpol_ch
By: Skrol29
Date: 2013-09-03
Time: 00:07

Re: howto from mysql query to pptx

Hi Mpol,

I'm sorry to say I don't understand well what you're trying to do.
Is it about a chart in slide ?
By: mpol
Date: 2013-09-03
Time: 09:19

Re: howto from mysql query to pptx

Hello Skrol29

thanks a lot for your response. Yes, I want to create a pptx presentation with chart. I do not see regarding example on my level to realize a similar processing.
How can I transfer my sql query into required array for chart? And can I use the sql query fiel as source for bubble on the pptx?
Or do you have an example where can I get this information?

thanks
mpol_ch

By: Skrol29
Date: 2013-09-05
Time: 00:20

Re: howto from mysql query to pptx

Hi Mpol,

You question is about how to retrieve data from MySQL, or how to build a new array from another one (with a different structure).
This is all about PHP, not TBS or OpenTBS.
By: mpol
Date: 2013-09-05
Time: 09:35

Re: howto from mysql query to pptx

Hello
I managed the part of sql. Could you please advice where to check or see how to create or manage the contet of bubble on the slide with chart?
Where can I find the content of pptx file that can be adjusted?

thanks
mpol
By: Skrol29
Date: 2013-09-07
Time: 00:12

Re: howto from mysql query to pptx

Hi Mpol,

Here here how to merge a Bubble chart in Powerpoint or Word:

1) Create new Bubble Chart using with the Chart wizard.
    Do now use linked data, use the wizard and let the default data sample submitted by the wizard.
2) Put the string 'my_bubble_chart' in the property "Title" of the frame that embeds the chart.

3) At the PHP side, adjust the following snippet:

$NewValues = array(
array($x1, $y1, $size1),
array($x2, $y2, $size2),
array($x3, $y3, $size3),
...
);

$TBS->PlugIn(OPENTBS_CHART, 'my_bubble_chart', 1, $NewValues);