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

28 February 2023 Getting the Orders in XML format: /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool:...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 = ""; l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { // init v_DateTill= "-"; v_QuoteTotalDisp= "-"; v_Index = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve v_CreatorQuoteID =...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 m_CreateEstimate.put("date",r_QuoteDetails.get("Created_Time").subString(0,10)); if(!isnull(r_QuoteDetails.get("Valid_Till"))) { m_CreateEstimate.put("expiry_date",r_QuoteDetails.get("Valid_Till").subString(0,10)); } // // ---------------------- QUOTE...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 v_Pages; Call with 2 criteria: v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") + ")AND(Valid_Till:greater_than:" + encodeUrl("2023-11-01") + "))"; v_Endpoint =...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 HH:mm:ss",v_XeroTimeZone); m_UpsertCrmQuote.put("Valid_Till",d_XeroQuoteDueDate.toString("yyyy-MM-dd")); } else { m_UpsertCrmQuote.put("Valid_Till",d_XeroQuoteDate.addDay(30).toString("yyyy-MM-dd")); }...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 folder 3. Login to your admin panel 4. Go to Extensions > Install/Uninstall 5. Install com_comprofiler.zip (remember to wait till it confirms it says "Installation finished") 6. Go back to Extensions > Install/Uninstall 7. Install mod_cblogin.zip 8....

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website and in most...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 Partner Support (partner-support@zohocreator.com // Zoho Cares) you have done this and thank them for their help. Wait till they confirm they have setup the SSL certificate on their side, test by visiting the portal in an incognito/inprivate window and...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 when the form was loaded. Then I would tell Audit_Change to only trigger the workflow if it had waited about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields and if your workflows only trigger...

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

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

29 March 2023 All, Active, Cancelled, CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from and till v_OrdersFrom = v_Year + "-01-01T00:00:00.000Z"; v_OrdersTill = v_Year + "-12-31T23:59:59.000Z"; // // now let's generate the page...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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