Search - Joel Lipman .Com

1. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; 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. ...; Created on 15 December 2021
2. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; What? I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? ...; Created on 07 October 2021
3. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; What? An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think ...; Created on 22 September 2021
4. Country Lookup by IP address CSV: / MySQL /; ... allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love ...; Created on 17 March 2013
5. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using ...; Created on 25 January 2022
6. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order ...; Created on 21 January 2022
7. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... you may need on your quest to setup Zoho Analytics FTP Data Sources: Zoho Analytics IP Addresses to whitelist (if necessary): // EU Data Centers 31.186.226.0 - 31.186.226.255 185.20.209.0 - 185.20.209.255 87.252.213.0 ...; Created on 12 January 2022
8. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; v_APICallName = "SetNotificationPreferences"; // // specify the URL of the CRM REST API Function here (can be a mailto:email@address) v_CrmRestFunction ...; Created on 20 September 2021
9. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge ...; Created on 26 August 2021
10. Zoho Creator: Add a subform while creating a record: / Zoho /; ... v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip"); ...; Created on 14 July 2021
11. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... ping both creator.cs.zohohost.com and the subdomain example.joellipman.com. These should both respond with the same IP address. 3. Get Zoho to setup authorize As a Zoho Partner, you now need to ...; Created on 17 November 2020
12. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is the top level domain (TLD) and will be either .COM, .EU or as per your region. If the first part of your URL ...; Created on 28 August 2020
13. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; Applies to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // ...; Created on 14 March 2020
14. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a valid user preferably other than the super-admin. ,"message":"body","status":"error"}: ...; Created on 17 July 2019
15. Zoho Deluge - Get distance between two coordinates: / Zoho /; What? A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution ...; Created on 11 June 2019
16. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below ...; Created on 03 June 2019
17. Zoho Deluge - Update Creator from CRM: / Zoho /; ... where you enter your own email address and zoho password. Determine the EndPoint: Following the syntax: https://creator.zoho.com/api////form//record/update where ownername is the owner, format is ...; Created on 18 February 2019
18. GDPR Privacy Policy: / Static Items /; ... political campaigning, commercial solicitation, chain letters, mass mailings, or any form of "spam." You may not use a false e-mail address, impersonate any person or entity, or otherwise mislead as to ...; Created on 14 February 2019
19. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... WorkRng = Application.InputBox("Specify Data Range", xTitleId, WorkRng.Address, Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent ...; Created on 11 February 2019
20. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it ...; Created on 02 August 2016