Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to the end user, and when they finish...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 directory on your server (for example, public_html/api/thumbnailer.php). It will be called as a JSON API over GET and does not render a webpage. Create Storage Folders In the same directory, create two writable subfolders: _origs/ — stores the original...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 - Page Responses Query This is a second query which queries the first query... Well it's for the radar chart and what it does is group all the responses per page (per survey attempt) so that given a survey reference, it will give me the sums per page....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 plus icon next to Sales Order (creates a new sales order) on the quote record, the fields auto-map. The client script below does the same for invoice as the quote lookup is a custom field on the invoice. How? First, we'll setup a client script...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get access token (does not need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" &&...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Attempts to make the account inactive failed with the message that it was “linked with an integration.” This message doesn’t necessarily mean a third-party app; it usually means the existing bank feed integration is still registered within Zoho’s...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Ubuntu as a media serverhttp://mail.joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for doing this so the LMCE UI is never...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

How to put MediaWiki into Debug modehttp://mail.joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

22 October 2009 By adding the following line to your LocalSettings.php file, you will be able to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Search and Replace in a MySQL Databasehttp://mail.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Repeat Headers in PDF Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 will output all files including subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the command to output to a local file. Type dir . temp.txt to...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Joes WebGL Experimenthttp://mail.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=40

06 April 2013 stable beta version is demo'd at http://demo.joellipman.com/joomla16/index.php/joes-infographic-for-joomla Limitations Does not work in MS Internet Explorer Is not working on iOS and certain smartphones Advantages No copyright, watermarks and as...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Disable User Registration in Joomla 1.5 - Configuration Filehttp://mail.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Joomla Development: Possible XML Filtershttp://mail.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 three special characters _ (underscore) . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

SSIS: Add Reference Microsoft.SqlServer.TxScripthttp://mail.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 Select the dll and click on "Add" Related Error(s): The type or namespace name 'SSISScriptComponentEntryPointAttribute' does not exist in the namespace 'Microsoft.SqlServer.Dts.Pipeline'

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Make bootstrap carousel responsive to swipehttp://mail.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a JS: /*! Bootstrap Carousel...

• Type: Article
• Author: Joel Lipman
• Category: Bootstrap
• Language: *

Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://mail.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 // What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding......

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *