Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming also is required, the following 136 results were found.

  1. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    exception, Invalid statement found Line:(20) However, I'm not bad at producing errors so here's another snippet that will also cause the error: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    being ideal. Instead, let's use a CRM function to store the conversation between ChatGPT and the CRM User. This way, we can also ensure that the data shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

    I had this formula which seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week (this is in ZohoCreator; I'm aware that some of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    } } } } // // email the invoice (using template and updating comments/history) - also marks as sent m_Params = Map(); // recipients is a list of emails unlike contact persons in invoice request m_Params.put("to_mail_ids",l_ZB_InvoiceRecipients);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  5. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    function that will work on any CRM and possibly be quick to adapt to a module other than products. This function will also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration. Also note that the question number comes from it prefixing the question per page that the client did when setting up her survey...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  7. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    are the database and login credentials. $ftp_user and $ftp_pass are the ftp credentials. $log_path and $tmp_path should also be updated. $robots - set this to 'noindex, nofollow' (we don't want google to index our test site). Disable new user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. 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

    the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get complaints (from my server not from humans) that my Joomla version needs updating... I'm writing this in case I ever...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    To view these or output to screen: print_r($credentials); Worthwhile Note(s) Allowing the scope to access the user profile also sends through a JSON Web Token (JWT) under the variable "id_token". This will be included in the response from the Google...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    that's what Microsoft people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    the purpose of having anything there. I want my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I want the report to either return the correct value or say "No data found". My end-users would otherwise...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this also works with tabs in Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date))...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  16. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  17. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    use of this website may give rise to a claim for damages and/or be a criminal offence. From time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    which we think you may find interesting using the email address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  19. Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code....

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  20. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    /G Allows the copying of encrypted files to destination that does not support encryption. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy files. Does not include empty directories...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
Results 21 - 40 of 136