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 whether is required, the following 34 results were found.

  1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - Only generate invoice if payment received - Distinguish whether composite based on ebay item specific - Add stock in order to authorize payment creation Date Modified: 2023-02-02 (Joel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  2. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    you modify it: responsibilities to respect the freedom of others. For example, if you distribute copies of such a program, whether gratis or for a fee, you must pass on to the recipients the same freedoms that you received. You must make sure that they,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  3. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  4. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    in the stats (unless you were using it). Leaving this unchecked means that the crackers/hackers will get through ultimately whether it be by brute-force, DoS, Injection, etc. I'm not saying these are silver bullets, but they will slow down some people....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Run the Python Script to Transcribe python3 transcribe_vosk.py I left the script running overnight so I'm not sure whether it simply played it for 5.5 hours and transcribed it or whether it did it in a shorter amount of time; but the next morning I had...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    {0}. Inputs must be DT_STR or DT_WSTR"; string errorMsg2 = "Invalid usage type for {0}. Inputs must be READWRITE"; // Check whether each column type is DT_STR/DT_WSTR for (int x = 0; x...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

    --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890 597890 I want the third column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value...

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

    • Type: Article
    • Category: Static Items
    • Language: *
  10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    motherboard BIOS allows you to enable this. It's just a setting in the BIOS if your motherboard supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  11. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    ; the clever bit: loop while incrementing checking if the value is not already in the list ; also check whether proposed file name matches the original file exists and is an exception for renaming. v_Increment := 1 b_KeepLooping := true while (...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    from or in connection with any products sold or supplied by JoelLipman.com. This indemnity shall apply without regard to whether the claim, damage, liability or expense is based on breach of contract, breach of warranty, negligence, strict liability, or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    info v_Url; openUrl( v_Url , "new window"); This will open a page for you with a Zoho Consent form where you confirm whether your app is allowed to access the data within the specified scope(s). If you run this as a standalone, then this will simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  14. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    field is different. Checking the Zoho documentation for an example showing how you can get all results irrespective of whether they are converted or approved: response = zoho.crm.searchRecords("Quotes",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    Get Currencies Remember to replace the v_BooksOrgID with your client's Organization ID for Zoho Books and check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  16. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

    a description and then enter in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  18. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://www.joellipman.com/component/content/article/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html?catid=129&Itemid=165

    instead of clicking on the "Enable". Documented below is how to get this to prompt you again. How? This largely depends on whether you are using the Google Chrome web browser. In this case version 100 and is correct at time of print. Open Chrome Web...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    the following function: void fn_SignDataAndAttach(int v_RequestId, int v_DocumentId) { // // TLD as com or eu depending on whether you access zoho.com or zoho.eu v_TLD = "com"; // // enter client ID, secret and refresh token as noted from above steps...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    debugging purposes info "Page #" + v_Page + "::" + v_CountTotal + "::" + v_VariantSKU + "::" + v_Cursor; } // // capture whether to continue the loop or not b_HasNextPage =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 1 - 20 of 34