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 of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl [ url:...

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

Calculating Percentagehttps://www.joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 = +25% ie. selling an $8 product at $10 is an increase of 25%...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 and am going to pretend the server path is /home/user/var/public_html/ These are the instructions for our usual setup: A working website in Joomla CMS v1.5.14 Applied RocketTheme's Affinity template to our website We have all the necessary files: RokBB3...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Thumbnails will first appear blue as the service downloads/queues them. Adding a weblink: Add your Joomla! weblink as per usual Switch "STOP Thumbnail Service" to "NO" Login to the front-end of your website as an authorized service group user (as...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to your usual method of connecting to a data source, I just added this section to say that my data source is type "Oracle" and NOT ODBC or...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 to the first file in the folder to loop through and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis Under Property, select...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official documentation but...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 and none reported the fix... If you only want Internet Explorer versions 7 & 8 First install Internet Explorer 8 as per usual (from Microsoft's site) Then download and install IE7 Standalone (from http://ie7-standalone.en.softonic.com/) Your IE7...

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

Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

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

Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to see if it...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 I've googled, yahood and binged, but still can't find a good way to upgrade my site from Joomla version 1.5 to 1.6 so as usual I find myself writing the first migration script. Why use a script? Well apps like jUpgrade didn't work for me. This is how to...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 to pictures and shiny objects. Studies show people more likely to click on an image to an external website then the usual http://theothercompany.com textual link. Question Something wrong? Troubleshooting? Answer: The program is built with what I call...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

02 September 2011 This page itself contains a basic dataset query just to check with the end-user: Note that this an ordinary report as per usual. It will act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 are on a network that frequently loses connection or simply forgets what intranet site you were trying to access and your usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 $db_connect = mysqli_connect($db_host,$db_user,$db_pass); $content_count = 0; // CONNECTED! so run a SQL query as per usual if (!mysqli_connect_errno()) { $query='SELECT COUNT(*) as ArticleCount FROM `'.$db_prefix.'content` WHERE...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 Public users should not be able to use this search or see the restricted documents. I've googled far and wide but as usual, I find myself to be the first to address this. How? The module I have made is very basic and not in an MVC structure but it has...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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 or on properties "On Successful Submission" > "Direct To", or my favorite, Deluge "openUrl()"). Standard as for any usual form without a redirect. Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as...

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

Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 as the part I struggled on was uploading it to CRM. I want to update the photo in the CRM record. How? So we have to do the usual which is download the photo using invokeUrl then we set the paramname not to attachment but to file. We then use another...

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