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

  1. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses m_TranslateStatuses = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone v_XeroTimeZone =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    Ctrl and scroll your mousewheel down. Makes everything on the page smaller. Ctrl+0 Returns everything on the page to normal size. Space bar Scrolls down the web page. Home Goes to the top of the page. End Goes to the bottom of the page. Press Shift and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  4. 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

    a method to set the value of each String type property // Make sure the length of the new value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) { // Only handle ColumnIsNull and NullReference Exceptions if...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  5. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    even cheaper one on Ebay.com (Leather 64Gb@£29.99). In hindsight, the Ebay one was obviously going to fail (faking the disk size). I got badgered by my colleagues to splash out and get a worthwhile pen. Aside from some other failures, I decided to get...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    (eg. Windows XP) > Next Use the recommended RAM > Next Select "A new virtual hard disk" > Next Specify a virtual hard disk size (eg. 10000 MB which is about 10Gb) > Next Check your attributes and click on "Finish" The Virtual PC Console window should...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  7. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    captions ms-settings:easeofaccess-closedcaptioning Color filters ms-settings:easeofaccess-colorfilter Cursor & pointer size ms-settings:easeofaccess-cursorandpointersize Display ms-settings:easeofaccess-display Eye control...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  8. List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has all the icons...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Buttons. - Parameter: Mootools Transitions - None /...specific... / Random. - Parameters: Module Width / Height / Font-size Override. - Parameters: Show Descriptions / Images/ Dates / Hits. - Parameters: Get Titles + Descriptions (Local / Remote) -...

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

    : new XMLHttpRequest(); // open the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  11. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  13. Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    and visual settings to restore after troubleshoot Run Task Manager and display “Performance” tab. Check user profile size. Recommended quarter of physical RAM (eg. x Accessories > System Tools > Disk drive cleanup tool. Check Windows Eventviewer for all...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  14. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-template-issue-first-page-is-blank.html

    print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  15. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    // if(!isnull(input.myLookup)) { // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each v_SelectedLookup in input.myLookup { l_RememberLookup.add(v_SelectedLookup); } } } // // clear lookup clear...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  16. Advanced RokStories Stylinghttps://www.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

    has been overhauled to provide the spectacular display that you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features are also...

    • Type: Article
    • Author: Webmaster
    • Category: Joomla
    • Language: *
  17. Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

    not the other - we had over 2000 articles... I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL query to show me these.

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
Results 61 - 77 of 77