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

  1. PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    why you would need to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your own running PHP 8. The following PHP script was only tested using PHP version 8.x so I can't say whether it will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  2. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    = standalone.fn_Xero_MapTaxRates(); m_ZohoTaxRates = r_ZohoTaxRates.toMap(); if(b_Debug) { info m_ZohoTaxRates; } // // server timezones v_XeroTimeZone = "Europe/London"; v_ZohoTimeZone = "Europe/London"; // // enter the CRM record ID of your...

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

    becomes stuck and cannot be refreshed or disabled from within Zoho Books. Pre-amble: I had to check ZohoBooks Downtime Server Incidents: US Zoho Services Availability or Zoho EU Services Availability Permission Issue: Are we logged in to Zoho Books as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile - JoelLipman.Com...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    Manager (eg. phpMyAdmin) Recommended if you are working remotely as these tend to let you carry out the actions on the server itself. (ie. Fast & Reliable) Compress/backup LIVE files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and...

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

    is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables Prefix It should be a short alphanumeric value with a trailing underscore (eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    the access token, store it off the web but where this script can access it (read/write). // Location of private key on your server (JSON downloadable from Google) $api['keys']['private']['file'] = '.json'; // Location to store access token (needs be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. List all cron jobs for all usershttps://joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab file and cron job...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  11. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    library or list Copy the URL/web address from your browser which has the datasheet open (eg. "http://your_sharepoint_server_name/Lists/your_list_name/Allitemsg.aspx") Select the name of your list (I know I thought we already did this but hey ho) Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  12. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I created one...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    dmy returns the date in European format irrespective of the regional settings of either the client or the reporting server. Removed @GivenDate datetime, from the SQL script Removed @GivenCampus varchar(100) from the SQL script

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

    is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. SSRS Zero Paddinghttps://joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors....

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

    to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to use...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    lowercase name with no spaces). tick the checkbox Run with highest privileges. set "Configure For" to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

    this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportID uniqueidentifier NULL The ID of the report...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  20. Error during processing - Converting Date/Timehttps://joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface are very similar when...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 81 - 100 of 132