Vue.js (v1.0.x) quick start guide NOTE: We plan to update this guide to Vue 2.0 when the final release is out Like most software companies which create web applications, we develop frontends with HTML and Javascript. Having mostly used jQuery on our applications, we felt there...
Read More
Something that now and then are always needed, the SQL queries to get the list of table names from a database, or the column names for a table. Below are the queries for MySQL, PostgreSQL and Microsoft SQL server. MySQL To get the table list: show tables; To get the...
Read More
To add an image to an already existing PDF file is a relatively simple task, using iText. On this example, we will add a smile image to the bottom of the PDF first page. We start by loading the PDF we want to modify, and getting the reference for the...
Read More
Today we're going to show how to read a XML file and convert it's entries to lines on an excel file. The XML file is located at https://github.com/jbaysolutions/xml-to-excel/blob/master/Publication1.xml?raw=true. The XML file's main nodes are "Substances", each one has a few...
Read More
On one of our projects, we were asked to implement a process that updates a database with values from an Excel file on a daily basis. The file is located at https://github.com/jbaysolutions/excel-xml-reader/raw/master/ActiveSubstance.xls. The problem with this file is its format. It's an...
Read More
Recently I had to write some code to generate excel files using Apache POI. One of the files was fairly complex and used formulas in a few cells. I found myself spending a few hours searching for a way to translate the indexed column numbers that POI uses to the...
Read More
The default glassfish app. server installation comes with local JMX connections enabled by default. To enable JMX connections from remote hosts all that's needed is to add -Djava.rmi.server.hostname=<hostname> in the JVM Options of the instance of GlassFish, where <hostname> is the external...
Read More
