Author Archives: Israel Lopez

Adventures in SSL : TLS 1.2 & Klipfolio

SSL is the web technology that enables secure communication between computers. Its an intricate system with many different components that all work to prevent eavesdropping on communication.  It is technology used to enable secure banking, eCommerce, and regular communication. The basic idea is that you must trust both conversation participants to communicate securely, and if […]

Preparing for Fishbowl 2017

Preparing for Fishbowl 2017 Every new “year” release of Fishbowl has included some massive changes. This year is no different, and we have a big change to talk about: MySQL. Here is what is changing, in the following areas Infrastructure, Fixes, and Features. Changes Infrastructure Database Engine Changing from Firebird SQL to MySQL. See “What […]

Fishbowl 2017 Audit Table List

As of 2/6/2017 this is the Fishbowl Audit Table List, audit tables are suffixed with “_AUD” . For example, the Sales Order table is “SO” its Audit Table is “SO_AUD”.  When we have more information about using Audit Tables we will update this post with new information. Example Query: select * from so_aud Tables TABLE_NAME […]

Automate Paper Invoicing with Lob

Back in 2008-2009 I worked for a medium sized business and one of the things that surprised me was they had a huge envelope stuffing machine. This machine would take in a stack of printed letters, read a unique code on the top left of the page and stuff the envelope and close the flap. […]