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

28 March 2023 the key here is you'll find them in the settings; so check that your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine...

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

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

29 March 2023 l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 or a company which manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 Technical Information Automations in the background, on update of ticket or attachment webhook, will push some of the details of the ticket and all/any attachments to a Zoho Creator form. The ticket form has the ticket reference, product information,...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 (click on "Home" in top menu if not), // then click on the cog icon "Organization Settings", then click on "Organization Details", // then look at the URL (website address) and take the number directly after "org-details/" v_AnalyticsOrgID =...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 = "Unable to find appropriate action. If this continues please contact support."; } // // get contact record details r_Contact = zoho.crm.getRecordById("Contacts",p_ContactID); // info r_Contact; // // if email exists then create the ZohoSign Document...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details: http://www.webmaster-talk.com/php-forum/19149-_server-http_referer-fails-under-internet-explorer.html

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

SSRS Repeat Headers in PDF Reporthttps://joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 panel (see below screenshot). Click on the "static" row that is the header of the tablix (the data of the tablix is "details"). Set "FixedData" to "True" if you want the headers to scroll with the report when viewed on the Reporting Server or within...

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

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office...

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

MediaWiki: MySQL to extract path to imageshttps://joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...

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

SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 don't display. The answer to this error is your report needs to use a datasource with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server...

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

Zoho Inventory Template Issue: First Page is Blankhttps://joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime = r_Event.get("Event_Time"); v_ThisEventNote = r_Event.get("Event_Details"); // // now lets add double-quotes for Excel in case the event contains commas v_NewCSVline = "\"" +...

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