- #Hide column headings scriptcase how to
- #Hide column headings scriptcase pdf
- #Hide column headings scriptcase install
- #Hide column headings scriptcase full
- #Hide column headings scriptcase download
If it still doesn’t work, try to run the export command directly on your server to find out the exact error message. For example, if the deployed URL is, enter into the “PDF Server IP” field.
![hide column headings scriptcase hide column headings scriptcase](https://forum.scriptcase.net/uploads/default/original/2X/b/b4a2eaf120e0ec61fe9fcd5d7f1c1739fc08d7a1.jpeg)
Contrary to what the name of the field may tell you, this has to be the root address of the server where the site is deployed, which can be an IP address (for test servers), or a domain name (for production servers). If the URL is not correct, check the “PDF Server IP” field in the Scriptcase configuration settings.
#Hide column headings scriptcase download
) and make sure that you can download from it. If it doesn’t, check the URL that was passed in to pd4ml.jar (e.g.
#Hide column headings scriptcase pdf
Once installation is completed, try again – PDF export should work.
#Hide column headings scriptcase install
We proceed by installing the default Java package that comes with the OS: sudo yum install java In our case, just the JRE is needed to execute the Scriptcase jar program.
#Hide column headings scriptcase full
Take note that the following command is just an example, you might need to customize it based on your further needs, for example which version of Java needs to be installed and whether you will just need the Java Runtime Environment (JRE) or the full development kit (JDK). The conversion failed simply because Java was not installed on the server. When the user requests to export a grid to PDF, Scriptcase first generates the corresponding HTML document for the grid, then executes pd4ml.jar with the help of Java to convert the HTML file to PDF. home/example/_lib/tmp/sc_pdf_20151208170941_771_grid.pdfĮxecuting this command by connecting to the web host via SSH, which is a CentOS 6 VPS, result in the following error: -bash: java: command not foundĪt this point it is clear what caused the issue. LETTER -orientation PORTRAIT -permissions 2076 > Filenames and related information have been removed for security reasons. log file contains the following command, which presumably was used to generate the PDF file. The following is the screenshot of the configuration settings for Scriptcase v6:Ĭhecking the temporary folder reveals the following files: The full path to the log folder is also indicated in the “Configure production environment” menu after you log in to the Scriptcase production environment, by appending /_lib/prod to the site address. To investigate this problem, I checked the Scriptcase temporary folder, which is usually at the /_lib/tmp subdirectory. The web user interface did not show any useful messages, other than “PDF generation finished.”, and exporting to all other formats still worked well. However, recently in one of my projects, I came across an issue where the exported PDF file was either empty or had very small size such as 37 bytes which contained only the PDF header and was therefore corrupted. When executed inside the events of a grid (e.g.If you often use Scriptcase to quickly develop CRUD applications in PHP, you must definitely have used the Export feature from a Grid application, and most likely find it very useful as it can export in many different formats such as Office, PDF or event XML:įor most users, the export usually works out of the box and requires little configuration. And, as I said, ScriptCase also uses $_SESSION to store the state of the applications. Solutionįor better or for worse, ScriptCase is heavily dependant on PHP’s $_SESSION global, using it to store a lot (and I mean it!) of information: general and database settings, states of applications, dictionary of (language) strings, errors status, and even HTML content for things such as buttons.
#Hide column headings scriptcase how to
With that in mind, I had to find out for myself a way to present a different content for that column when exporting to XLS.Īfter some time analysing the code generated by ScriptCase I found out how to detect what triggered the onRecord event - and it also works for PDF, CSV, XML and RTF. To this day, ScriptCase (latest is v9.0.029) doesn’t provide any macro or documented steps to check if onRecord event is running for a “normal grid webpage” or for an exportation. Besides not working as expected, that image/icon wasn’t really desired inside the XLS file and for this case a simple text would be much better: it would allow the status to be used in formulas, functions, searches, etc. When exported to XLS using ScriptCase’s exporting option, the status column showed just an empty cell - and no images at all.
![hide column headings scriptcase hide column headings scriptcase](https://i.stack.imgur.com/IRdRt.jpg)
In the onRecord event I checked the status and set the content of that column - an IMG tag, i.e., plain HTML - and everything worked fine, except when exporting that grid to XLS (or PDF). A while ago I created a grid application using ScriptCase to list all not-completed orders, and because each order could have different status, I added a column to show an image/icon based on its status: