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

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

    daily at 1am starting from tomorrow (3-Jul-2024) Purpose: To warn system managers if a sync started failing. Inputs: None Outputs: Emails system manager if any failures. Date Created: 2024-07-02 (JoelLipman.com - Joel Lipman) - Initial release Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    } } Ta daa! Source(s): I would mention a few community forum pages I went through which showed me how not to do it, but as none were the solution, I'm not sure putting them here would make this easier for you. Zoho Books API Documentation: Create...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. 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

    Zoho Analytics > Under Controls / Configurations you should see Logo Rebrand. Set the "Powered by Logo" setting to either "None" or upload your logo and select "Display your own logo". I had to amend the code above a fair bit specific to the client but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  4. Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

    last few lines with the original code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to center...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    with Demo Content (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note on its contents or embedded code specific to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified actionNone actionGo actionSearch actionSend actionNext actionDone actionPrevious IME_ACTION(s) IME_ACTION_DONE // the action key...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  8. 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

    "\n", ""). Feedback This solution took me two days to solve despite following an innumerable number of sites advising but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know of...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. 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

    ReinitializeMetaData(); } // This method blocks the addition of new output column from Advanced Editor as none are permitted. Called during Design Time public override IDTSOutputColumn100 InsertOutputColumnAt(int outputID, int outputColumnIndex, string...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    #efefef, , , White, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Black", "LightGray") BorderStyle: None, , , Solid, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Double", "Solid") BorderWidth: 1pt, , , ,...

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

    in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next textbox moves to fill up the space... There are some...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    How? For Windows XP: Open an instance of Windows Explorer and click on "Tools" Select "Folder Options..." Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    this would be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff we have elevated privileges but not absolute...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  15. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    Can be null ** ** ** ** Outputs: ** ** The Data in @ColumnName column will be scrambled ** ** ** ** Return Values: ** ** None ** ** ** ** Before: ** ** ID Name DateOfBirth ** ** --------- ------------ ----------- ** ** 1 John Smith 1988-06-24 ** ** 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  16. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li { counter-increment: myCounter;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  17. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    = htmlentities($my_description); $my_description = htmlspecialchars($my_description); Did I miss anything? So none of the above worked. If there is another solution out there, I didn't find one that worked otherwise I'd have included it in this article....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Mode (by Ryan Florence v2.1) or Grid Mode. - Parameter: Enable Navigation Buttons. - Parameter: Mootools Transitions - None /...specific... / Random. - Parameters: Module Width / Height / Font-size Override. - Parameters: Show Descriptions / Images/...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  19. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  20. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 21 - 40 of 42