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

  1. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    :: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  2. Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. MediaWiki: MySQL to extract path to imageshttps://joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the...

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

    added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on another computer? What are your...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  5. Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=53&Itemid=165

    it away for free? Could be malicious or could be that I made this for a website, got paid, and I've used it again and again since. I learnt how to do this because someone else taught me for free. Enjoy! Installation Go to your Control Panel > Extensions...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    v_MyString = ""; v_FormattedString = v_MyString.replaceAll(v_MyRegEx,"$1",false); // yields my_real_textual_data Additional Since writing this article I found a Zoho page with some other pretty useful regular expressions at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

    ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this article, this is how to get to them Login to ZohoCRM Go to Setup (cog icon in the top right next to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  10. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter being the Lead...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this...

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

    store the token value so it is reused until it is about to expire. Firstly, we need to check how many minutes are remaining since the access token file was last modified: // check minutes remaining $api['jwt']['token']['minutes']=0;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  13. Unix Date Format Specifiershttps://joellipman.com/component/content/article/unix-date-format-specifiers.html?catid=63&Itemid=165

    case AM or PM (blank in many locales) PM %P locale's lower case am or pm pm Minutes %M MM minutes 20 Seconds %s seconds since 00:00:00 1970-01-01 UTC (Unix epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a leap second) %N...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  14. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    "firebrick", Fields!Status.Value="-1", "#999999") One I did earlier: Design One I did earlier: Preview I have since made the vertical lines white and the top borders a lighter shade to make a sort of bevel effect.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office workstation setup for this is: HP CMT DC7900 E5300 @ 2.60Ghz 2Gb RAM Windows XP Professional SP2 Internet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. MySQL last year week month day trend periodshttps://joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  17. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    SET i = (LENGTH(str)-LENGTH(REPLACE(str, delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  18. Embed an FLV file into a web pagehttps://joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    Thank you to Anna Moors for writing in and asking "how to stop the movie from playing automatically on page load?". Anna has since confirmed that the below code buffers her movie but only starts when clicked, ideal! Changes are: clip{ autobuffering,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  19. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're going to use...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  20. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    Silly. So the suggestion of selecting all cells and then right-clicking and selecting "row height" is beyond us. We have since simplified this so that only the person who knows how to hit the refresh button is the one to save as a PDF file and sends it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 1 - 20 of 23