Assuming name is required, and value is required, the following 122 results were found.
-
What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
What? An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
What? An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Applies to: Wordpress CMS v4.1.1 What? A note to myself on how to create a development/test version of a production/live Wordpress CMS site. Why? I have a website sitting at a domain (eg. www.myexample.com), and I want to create an exact copy at a...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
What? So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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
-
Hopefully the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open......
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
The Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for their customers to accept or decline a quote. Sure there's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? An article on some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
What? This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *