TinyButStrong Forum

Re: Displaying chart data as numerical rather than percentage values

2017-05-02 12:47:49

So I run the following code:

$subFile = 'word/embeddings/Microsoft_Excel_Worksheet3.xlsx';
$TBS->PlugIn(OPENTBS_SELECT_FILE, $subFile);
str_replace('$CLIENT_NAME$', 'Test String', $TBS->Source);
$TBS->LoadTemplate(false);

'$CLIENT_NAME$' is still there as the chart title. Am I doing it correctly? I have tried unzipping the docx file first. I'm obviously targeting the Microsoft_Excel_Worksheet3.xlsx file which contains the data for the chart I am targeting.

Am I missing something?

Thanks

Re: ope action show right n characters possible ?

2017-04-01 01:23:50

Hi,

There is not such a feature in TBS, but you can do it using a custom onformat function.
See http://www.tinybutstrong.com/manual.php#html_field_prm_onformat

Re: I need help retrieving 3 dimensional arrays through subblocks of subblocks while referencing by array keys

2017-03-13 22:53:16

Hi,

I'm sorry but I'm a bit lost with your question.

For the desired result A, the template could be:
[code]

Our guest speakers:
[LIST2.BIO2.0.IMAGE;strconv=no;block=tr]	Please welcome [LIST2.BIO2.0.NAME], a.k.a. [LIST2.BIO2.0.TITLE] [LIST2.BIO2.0.LINES]

[/code]

Of course this can be a bit complicated if such a template has to be designed by "Someone that is not expected to know anything more than HTML".
Bu for such cases, I usually give to the user a simple syntax for fields (for example "[IMAGE]", "[TITLE]", ....) and when I load the template, just before doing the MergeBlock(), I do a str_replace()
to convert "[IMAGE]" into "[LIST2.BIO2.0.IMAGE]", and the same for other fields.
It's also simple to insert ";block=tr" for only one field when necessary.
And you can of course use the explicit syntax instead. For example: [BIO_START] will be replaced with "[LIST2;block=begin]", and "[BIO_END]" with "[LIST2;block=end]"

For the desired result B, the template could be:
[code]

[LIST2.BIO2.0.TITLE]

[LIST2.BIO2.0.PARAGRAPHS]

[/code]

Re: Header on docx

2017-03-11 23:42:49

> How can i open an header?

In Ms Word, you can see and edit the header directly within the application. But in backstage the main content of the document is saved in a sub-file and the header is saved in another sub-file.
OpenTBS can merge data in one sub-file at a time. By default, the main sub-file is loaded.

> I have headers in the pages, how can i attach these headers to the blocks?

In the template, enter a block definition as usual.
At The Php side, use the command OPENTBS_SELECT_HEADER in order to load the header sub-file as current.
See
http://www.tinybutstrong.com/opentbs.php?doc#opentbs_select_header

Re: Display as Tags

2017-02-27 22:54:55

Some Db Engines have an aggregate function that concatenates strings. Like GROUP_CONCAT() in MySQL.
With such a function the solution is in your query.

Otherwise you can use TBS sub-blocks.

Re: Nested blocks?

2017-02-27 22:23:52

I think there is no need to have a sub block.
You simply have to merge BB first, then AA. So BB will be repeated for each row of AA.

For selecting the correct items in the combo-boxes, I can use 2 technical:
First is a dedicated plugins: http://www.tinybutstrong.com/plugins.php?help#plugin_html
The second is using JavaScript.

Re: catch error messages before it reaches client

2017-02-17 08:46:42

Hi,

TBS has no common error handler for now because of history reasons.
BUt there a solution: if you set « TBS->SetOptions('noerr', true) », then no error message is displayed, the number of error is given by « $TBS->ErrCount » and the errors messages are given by « $TBS->ErrMsg ».
So you can check at the end of the merge if there is any error.