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

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

    is opened in a new tab/window to trigger downloading. File is deleted from attachments based on its identifying number (allows other attachments to remain intact) Generate the file The code here is a cut down version just to demonstrate generating a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    eBay allows users to request the deletion of their personal data from eBay's own systems, as well as from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. RocketTheme's Affinity July 2009 Releasedhttps://www.joellipman.com/articles/cms/joomla/rocketthemes-affinity-july-2009-released.html

    and popular community products, such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement of modular rows, individual positions and stacks of modules Lorem ipsum dolor sit amet, consectetur...

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

    database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run this themselves. Personally I grant the user who will be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on. Further Post-Joomla 2.5 aides...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    same error, change the site template to a default one and see if that works. Check your cookie policy: Open a browser which allows cookies, and one that does not. Visit your site with both and attempt the password change.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

    I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just...

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

    home broadband users are now assigned these by ISPs so that they can identify their service users). The below also only allows 1 IP address (ie. one location from where an admin user can log in). Create a .htaccess file in your /administrator folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles): export SQL file and amend the insert(s) into the new table `#_content` Import Users: export...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk*...

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

    LEFT JOIN [sourcedb].[dbo].[lookup_ethnicities] f ON x.student_ethnicity_code=f.lookup_ethnicity_code Note this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  14. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your website has been LIVE for a while and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. Some milestones for a website projecthttps://www.joellipman.com/articles/cms/website-development/some-milestones-for-a-website-project.html

    Vertical slice – normally a few sections of the website are produced with many of the website features in and working, this allows reviewers to get a feel for the site, the level of usability, the saleability of the product and technical risk involved...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  17. XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    attribute Defines an attribute attributeGroup Defines an attribute group to be used in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  18. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule created 7 Zoho invoices...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  19. TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/component/content/article/travelport-universal-api-ping-request-with-php-curl.html?catid=109&Itemid=165

    API. This is to be achieved using PHP as the server-side programming language and cURL, a sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client device). Why? Yes there's documentation online that...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  20. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    // prevents JS error where results unmatched column_values = column_values || []; // ignore row if first item is blank (allows for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method...

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