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: Import Attachments: / Zoho /; What? An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? ...; Created on 16 January 2023
6. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... Invoice [Alt]: https://books.zoho.com/api/v3/invoices/?accept=pdf&organization_id= Bill: https://books.zoho.com/api/v3/bills/?accept=pdf&organization_id= Caveat(s): The "From" email address ...; Created on 18 August 2022
7. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle ...; Created on 29 June 2022
8. 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
9. 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 ...; Created on 21 January 2022
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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