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

  1. Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

    it will have in Zoho Analytics, 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

    As mentioned, we're going to update several fields called: Number of Candidates This Graduation Year Number of Candidates Next Graduation Year Candidates Graduated in the Past Candidates Graduating in the Future Total Number of Candidates I'll flesh...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  3. Zoho Books: Get Invoice Payment Terms via APIhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    of the month" }, { "payment_terms_id": "", "is_mandatory": true, "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  5. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    Client Script Configuration: Login to ZohoCRM as a system administrator and go to the Setup page (cog icon in the top right next to the profile image) Under "Developer Hub" go to "Client Script" Click on "New Script" button (the blue one - not the "Add...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM: Make either Mobile or Email mandatoryhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    Select the Email field as the primary field to control this rule Set the condition that the email "is empty" > click on the "Next" button Set Mandatory FIelds > and select "Mobile" Repeat these steps to add another rule: Call it "If Mobile Blank then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button). Reconnect Token There are a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Uninstalling AEC Central and installing Community Builderhttps://joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    Community Builder 11. Click on the Tools link and click on Synchronize Users 12. Go to Extensions > Module Manager 13. Tick next to CB Login, CB Workflows, CB Online and click Enable 14. Return to Components > Community Builder > Configuration 15. Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    to the name of your new Joomla 3.0 database (don't change the table prefix for the new Joomla and instead do this as the next step). Rename any instance of "my_new_database.my_prefix_" to the name of your new Joomla 3.0 database (note that we're...

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

    ~/.zshrc RuntimeError: Numpy is not available: Which Python Whisper Uses head -n 1 $(which whisper) Note the result for the next command, eg. #!/Library/Developer/CommandLineTools/usr/bin/python3 Install NumPy for That Exact Python...

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

    // tranformation exceptions: McDonalds, O'Reilly, D'Artagnan, I'Annon // Match with case a multi-character combo, append the next letter in UPPERCASE and then append the remainder. // NOTE: This will work with "MacDonalds" as well (specify "Mac") but...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored procedure) So this is the 3rd page which will actually execute our stored procedure. Here we...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Windows Live Messenger: Error 80048820https://joellipman.com/component/content/article/windows-live-messenger-error-80048820.html?catid=80&Itemid=165

    Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  15. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  16. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    MIN(t1.column_source) AS Source, COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  19. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    @UpdateSqlStatement, N'@UpdateCursor CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 21 - 40 of 109