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

  1. Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    We need to delete this file from the attachments as well as from the system as it contains bank details. You can skip this step if you're not bothered about storing this file on the system. Note that if you use the endpoint to delete the attachment from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    Analytics Workspace" as the data source type. Select the relevant workspace and click on "Next" Select "Custom Query" in step 2 and paste your Zoho SQL query in here. Give it a name, set the schedule and then wait for it to finish building the table. If...

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

    tal/en/kb/writer/automation-guide/zoho-crm/articles/how-to-merge-subform-fields-and-image-field-via-zoho-writer-s-merge-apis#Step_5_Pass_Image_Field_Values_in_Merge_API ******************************************************************************* */...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  4. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    to 2.5.x). Don't overwrite any existing core files with this one, it's completely unnecessary as this is a 3.24Kb file. Step #1 of 1: Create and include the following PHP file, I've named this file "article.php" (thanks to my amazing imagination). The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    existing menu item alias from "about-us" to "about-us2" as well as any similar `path` value. Change the item you created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this will generate your URL. Done

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

    in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new administrator URL. Caveat: If you login to the administrator section on a shared computer,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    ----------- ----------- ----------- ----------- -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you...

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

    open window dialogs TEST: Open an instance of Windows Explorer, Right-click on a folder and select the action you named in step 6. For Windows 7: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    that task: Open the Task Scheduler (Start > Run... > Type taskschd.msc > OK) - You will need administrator rights for this step. Click on Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. Hide a Drive per User in Windows 7https://joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    The value you enter for NoDrives depends on the drive(s) you want to restrict (Refer to the list above) CRITICAL STEP: Once you've saved this value, navigate back up to HKEY_USERS, select the Foo key you loaded, and then click File > Unload Hive > Yes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Apple Magic Trackpad with Windows 11 Intelhttps://joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    it up again but bear in mind to give it a few seconds to reconnect. If it still doesn't work, I had to repeat the preivous step of installing the driver and wait a few seconds for the settings page to show the green light / connected status. Done

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  16. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    to the guideline. When the corners are highlighted in red, this indicates the field is snapped to the guideline. Repeat step 2 until all the fields in the section are snapped to the vertical guideline(s). Set the object’s size and position by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  17. Excel: convert degrees minutes seconds to decimalhttps://joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    will work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  18. GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article. How? I...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  19. Sir James Dyson explains his bladeless fanhttps://joellipman.com/component/content/article/sir-james-dyson-explains-his-bladeless-fan.html?catid=96&Itemid=165

    the energy of normal fans. In the UK, we may not need air conditioning as much as other countries but this is definitely a step in the right direction. {youtube}6A3IM06xgr0{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
Results 41 - 59 of 59