ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 as the business days are given in the correct order m_ShiftRow = Map(); m_ShiftRow.put("open","00:00"); m_ShiftRow.put("close","00:00"); m_ShiftBuildUp = Map(); l_DaysCorrectOrder = m_OrgDetails.get("business_days"); for each v_Day in l_DaysCorrectOrder...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output = $response; } // close first request handler curl_close($ch1); // now let's get the ID of the file we just created // and submit the file metadata...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as a "Save & Close" button. The "Save" button would submit the form but keep the user on the record form. The "Save & Close" button would...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close connection curl_close($ch); // convert the response to xml $xml_result = simplexml_load_string($ch_result) or die("Error:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 ID" if already set). Call them something easy to remember such as "Tab_SalesPipeline" and "Tab_HirePipeline". Save and close the edit mode of the Canvas. Function to return pipeline Login as a ZohoCRM Administrator and go to Setup > Developer Hub >...

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

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 Basically you need to check that the time on your windows clock is accurate or close to real Internet time: Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 rounded corners */ .popupboxOuter{background:none;border:0;} .zc-pb-tile-card{padding: 0px 20px 10px;} /* optional: move the close button to the top right of the modal */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 optional windows update that fixed my issue. check that this issue isn't being caused by any Windows 7 desktop gadgets. Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $000B Const WM_SETTEXT = $000C Const WM_GETTEXT = $000D Const WM_GETTEXTLENGTH = $000E Const WM_PAINT = $000F Const WM_CLOSE = $0010 Const WM_QUERYENDSESSION = $0011 Const WM_QUIT = $0012 Const WM_QUERYOPEN = $0013 Const WM_ERASEBKGND = $0014 Const...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 simple_replacement_text, pattern, -- replacement_html, replacement_text, button_acl, button_open_tag, button_close_tag, -- button_title, button_prompt, button_image, button_css, button_enabled, ordering, -- published -- ) -- SELECT -- id, `name`,...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor T-SQL Source: http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 -...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $data = curl_exec($ch); curl_close($ch); return $data; } $file_content = get_data( "http://joellipman.com/xml_feeds/my_XML_url.xml" ); $file_xml = simplexml_load_string(...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 http_build_query($data)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls", FileFormat:=-4143 Application.ActiveWorkbook.Close False Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Press F5 to run the code. A separate...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 "Manage Fields" Add a picklist field type called "Department" with the options "Hire Team", and "Sales Team". Save and Close Setup: Specify Pipeline Options Login to ZohoCRM as a system administrator > Go to Setup > Pipelines Using the "Standard"...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 All > Tick to select all > Rebuild [does not work] Using the administrator panel, go into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 where all the values are going to go. [Time] into "Columns", [Room] into "Rows", and [Status] into "Details". 5. Save and close the report wizard Pretty much there you should have the following 6. Preview the report Ta daa! Ok it needs a lot more work...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 and then browse the dropdown for the name of your stored procedure (should be listed if datasource is correct): Before you close this box, click on "Parameters" in the right and specify your parameters in the order that they are accepted by your stored...

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