Assuming all is required, the following 342 results were found.
-
What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Apologies for copying and pasting this but this is information that is worth NOT losing. Tutorial on how to use COM objects in AutoHotkey. Source: Jethrow @ Autohotkey Forums Basic Webpage Controls with JavaScript / COM This tutorial requires one of the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
GNU GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
What? This is an article to show you how to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has a rather rich HTML email signature with a profile photo...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance of Zoho Inventory. In this task, we are simply getting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Really Important Note This module has been somewhat popular and the services that offer FREE thumbnail screenshots are getting stricter with their terms of use. You should only enable thumbnail refreshes at the time of install. Also note, this module...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Amazing little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
What? A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
What? A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
So I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
"OK this should take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB