Search - Joel Lipman .Com

1. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... to display on their estimates in Zoho Books; such as product image, product name, product description. Granted that in some cases, the design should go in the other direction, as in enter the products ...; Created on 15 April 2024
2. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8"); f_CSVFile.setFileType("csv"); ...; Created on 01 March 2023
5. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... ZDK.Apps.CRM but my syntax highlighter lowercases this) var r_ContactDetails = ZDK.Apps.CRM.Contacts.fetchById(v_VendorContactID); // get the email on this contact record var v_ContactEmail ...; Created on 20 July 2022
6. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create ...; Created on 19 September 2021
7. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup ...; Created on 06 November 2020
8. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... value is "2020-02-10T11:49:12+01:00" // OR in some cases v_TimeZone = "Europe/London"; v_InsertDateTime = zoho.currenttime.toString("yyyy-MM-dd HH:mm:ss",v_TimeZone); Problem: ERROR_Invalid_Redirect_URI ...; Created on 06 February 2020
9. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
10. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description = html_entity_decode(htmlentities($my_description, ENT_COMPAT, 'ISO-8859-1', ...; Created on 25 January 2016
11. Android: Replace return key with done, go, send...: / AndroidOS /; ... Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress ...; Created on 03 November 2014
12. Convert to Proper Case in T-SQL: / Transact-SQL /; ... the examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: - ...; Created on 04 June 2014
13. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection ...; Created on 22 November 2013
14. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation ...; Created on 04 October 2013
15. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar ...; Created on 14 May 2013
16. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... with any empty rows. The best way I've seen that has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: ...; Created on 23 April 2013
17. Setup a copy of your Joomla website: / Joomla /; ... clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies ...; Created on 19 December 2012
18. Error 1065: Query was Empty: / MySQL /; ... been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. ...; Created on 13 December 2012
19. 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
20. SSRS External Images don't displa: / SQL Server Reporting Services /; ... does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. ...; Created on 19 September 2011