Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

22 January 2022 m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

27 January 2022 l_HtmlEntityChars = v_HtmlEntityChars.toList(); // // add these exceptions (quotes) which wouldn't convert to a list l_HtmlEntityNames.add("quo"); l_HtmlEntityNames.add("apos"); l_HtmlEntityChars.add("\""); l_HtmlEntityChars.add("'"); // // build a map...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• Type: Article
• Author: Joel Lipman
• Category: Ebay
• Language: *

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how to convert the CRM record into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

01 March 2023 m_ActiveList.put("Pagination",m_Pagination); // m_Params.put("ActiveList",m_ActiveList); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 = Map(); m_OrderID.put("OrderID",p_eBayOrderRef); l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Inventory
• Language: *

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

13 July 2023 a letter in their name while the other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended to work using Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString + "12-34-56,012345678,Joel Lipman"; // // convert to a TXT file (not a CSV...) f_BillsExport = v_CSVString.tofile("PaymentRun.txt"); Attach the file Attach this to any record....

• Type: Article
• Author: Joel Lipman
• Category: Zoho Books
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page to PDF - Used more for links to open the PDF renderer in a new tab. Zoho Creator - Developer Guide - Customize Layout of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

14 October 2024 in the button: Source(s): Joel Lipman - Zoho Creator: Radio group into Calendar Carousel Joel Lipman - Zoho Deluge: Convert Hex to RGB

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

01 October 2025 be parsed by a Zoho CRM REST API function. How? First, I'll go through the steps of setting up the Zoho CRM function, we'll convert it to a REST API function which will give us a URL and then we'll configure the Zoho Survey to trigger a webhook when...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

05 August 2014 takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

11 February 2011 on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in (height) Switch width's for height to convert these to landscape.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

01 August 2012 2 - LEN(@RandSeconds))) + '.' + STUFF(@RandMSeconds, 1, 0, REPLICATE('0', 3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED IF @TimeMatch=1 AND @DateMatch=0 SET @NewVal = @TimeVal;...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *