Search - Joel Lipman .Com

1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... every day until an end date. We then carry out the last bit of the brief with a separate workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name ...; Created on 14 May 2024
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
3. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won ...; Created on 15 July 2021
4. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" ...; Created on 11 June 2019
5. Joes Google Map for Joomla (JGM): / Product Documentation /; ... loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays a google map in a module using the Google Maps API v3 styling features which include ...; Created on 13 April 2015
6. Joes Search Module (JSM): / Product Documentation /; ... 3.3.1. It simply displays a search module form (same as the default install) only with the additional hidden fields: limit, search phrase (all, any, exact), ordering, and areas (set to doc_indexer by ...; Created on 09 March 2015
7. Copy a Wordpress Site for Development: / Wordpress /; ... www.myexample.com), and I want to create an exact copy at a subdomain entitled "dev1" (eg. dev1.myexample.com). How? A quick copy from copy 1 (LIVE) to copy 2 (DEV): Backup all files in LIVE environment ...; Created on 08 March 2015
8. XML Schema Reference: / Extensible Markup Language /; ... than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value ...; Created on 13 August 2014
9. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will ...; Created on 05 August 2014
10. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
11. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; ... only ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers ...; Created on 08 April 2014
12. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... it isn't. This is one of those rare situations when the Microsoft error is describing the exact problem. If you include linked images in the report (as in images not in the report itself but referring ...; Created on 22 November 2013
13. Regular Expression Basic Usage Examples: / Web-Development /; ... 'c'--use the regular expression: ab*c This expression matches all of the following sequences: ac abc abbc abbbbc The expression does not match: adc Interval — Exact Count ...; Created on 28 October 2013
14. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; ... to Global Configuration > Site > Site Settings > Feed Email = Site Email (check this is “Site Email”) Then go under Global Configuration > Server > Mail Settings > From email (has to be the exact sender ...; Created on 09 May 2013
15. Setup a copy of your Joomla website: / Joomla /; ... QA - for clients who need to test enhancements that you've developed. (referred to with the customers as TEST). BACKUP - an exact copy of LIVE (preferably from a daily refresh - and inaccessible to ...; Created on 19 December 2012
16. Copy a table with structure and data into a temporary table: / Transact-SQL /; Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...; Created on 03 August 2012
17. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... the "Refresh fields..." button so that you can define the query parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in ...; Created on 19 January 2012
18. T-SQL Record Separator: / Transact-SQL /; 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 ...; Created on 11 October 2011
19. First and Last Entry on a Page using Modulus Remainder: / Personal Home Page /; So I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what ...; Created on 26 September 2011
20. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... just go to each website and press the print screen key and save this as an image for FREE. I don't get it. So I wrote a program that does exactly that: visits each website in a list, takes a picture, ...; Created on 28 June 2011