Stack Overflow
Stack Overflow

Questions tagged [opentbs]

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

You can just create a document using MS Office, LibreOffice, or OpenOffice; you can then use this document as a template for OpenTBS, which helps you to merge data, change parts, and get the result as direct download, a saved file, or a binary string in a variable.

Some supported features :

  • Merges data items, records, blocks, conditionals blocks;
  • Change pictures in documents;
  • Change Charts in DOCX, XLSX;
  • Hide/show sheets in XLSX and ODS;
  • Delete comments;
  • Support native connectivity with MySQL, PostgreSQL, or SQLite, PDO;
  • All features of the TinyButStrong Template Engine

Links :

195 questions
1
vote
1 answer

How to insert a picture in a document template?

I use this tag in an odt or docx template: [var.path;ope=addpic] However, tinybutstrong inserts path to picture, but not picture. Where to paste the tag that would output the picture and not its path?
Fedor
  • 13
  • 3
1
vote
1 answer

OpenTBS / PHP / Excel File Corruption - No attribute name may appear more than once in the same start tag or empty element tag

I have a Excel generation script in PHP that works to generate an Excel file in an original application. With a second application I can not get the Excel file to generate at all. The error I get is: Replaced Part: /xl/worksheets/sheet1.xml part…
Vahe
  • 1,699
  • 3
  • 25
  • 76
1
vote
1 answer

TinyButStrong - OpenTBS

Is it possible to add sections to a .docx template dynamically using OpenTBS plugn? Ex: Assume template has numbering from 1-5, and I want to add 5-n sections dynamically. Is it possible to add images dynamically to a table. I tried as follows but…
Aruna
  • 91
  • 1
  • 9
1
vote
0 answers

generated docx with opentbs converted by unoconv and libreoffice

For some reason I am expecting a strange behaviour. When I am merging my docx template with opentbs, it works all fine and it looks correct in the generated docx. But now I need to convert the docx into a pdf where I am using unoconv and libreoffice…
schurtertom
  • 520
  • 1
  • 9
  • 19
1
vote
1 answer

OpenTBS - hide image when does not exist

I have a list of images filled with url, or empty in some case. I just want to display the images when the url exists, and not display the image when the url is not specified. There is a very similar post here, but not fully answered, so I am…
mokk
  • 916
  • 17
  • 35
1
vote
2 answers

openTBS/PHP - How do I create a stacked bar chart?

I am trying to create a stacked bar chart as shown below embedded on a slide of a PowerPoint template. When I run my script below I am getting an error. TinyButStrong Error OpenTBS Plugin: (ChartChangeSeries) 'chart3' : unable to found series…
Vahe
  • 1,699
  • 3
  • 25
  • 76
1
vote
2 answers

Error on variable with XML tags when parsing ODT files

I'm implementing TinyButStrong / OpenTBS in a system that needs to process ODT documents and I'm facing an issue with a specific template that has tags inside the variable name. The situation is as follows: The template part: The relevant part of…
Luís Cruz
  • 14,780
  • 16
  • 68
  • 100
1
vote
1 answer

openTbs Tag not updating

I need to adjust background cell colors depending on adjacent cells. My template is a word document and I set the cell color to some random color so my xml of interest looks like this: …
Rob Scidmore
  • 75
  • 6
1
vote
1 answer

OpenTBS not working on Ubuntu 14.04 with PHP5.5.9

Am using openTBS version 1.9.4 enter link description here on Ubunto 14.04 with PHP5.5.9. while am using this application I figured out, where the problem occurs. // Include classes include_once('tbs_class.php'); // Load the TinyButStrong template…
Sibi Mani
  • 83
  • 1
  • 9
1
vote
1 answer

OpenTBS / PHP - How can I create a multipage document(docx) in OpenTBS?

Scenario I am trying to create more than one page in OpenTBS (.docx file) from a PHP array with each array element corresponding to a page of data. Question How can I insert new pages for every data element? Any help would be appreciated. PHP Code …
Vahe
  • 1,699
  • 3
  • 25
  • 76
1
vote
1 answer

How to insert euro symbol into Word document with Open TBS?

I am creating a merged word document using the Open TBS plugin for Tinybutstrong, however I cannot get it to display the euro symbol correctly when merging from a php variable. I have tried: Entering the charecter directly as '€' within my…
User787665
  • 237
  • 4
  • 23
1
vote
1 answer

How to get TinyButStrong generated file handler

I would link to send .odt file generated by TinyButStrong using Swiftmailer. This is mu current code ->setSubject('Customer General Email from '. $date->format("m-d-Y H:i")) //->setTo($address) …
Sergei Kutanov
  • 825
  • 6
  • 13
1
vote
1 answer

Can you remove a text line in PHP with OpenTBS if there is nothing merged

I have been using OpenTBS for modifying DOCX files. When I am merging my DB info with the DOCX file it always leave blank data for any info in my DB that is missing. Here is an image of my 'source' document on the left and my merge on the right.…
CGSmith105
  • 490
  • 4
  • 17
1
vote
1 answer

phpdocx generatePDF Unknown image type: ?image=opentbs1

First of all, this is my first question on the site and I just want to thank all of you for helping out newbs like me. I have found so much invaluable information on this site! It has helped me with so much along my programming journey. So here…
theCure
  • 25
  • 5
1
vote
1 answer

OpenTBS Multiple pages of repeated template containing table

Alright, I'm new to XML and OpenTBS so this concept of blocks etc is very confusing for me, and when I thought I had the gist of it, my client asked for even more of me. I've got a table of customers and their items, the client wants one single…
PwnageAtPwn
  • 431
  • 1
  • 6
  • 21
1 2
3
…
12 13