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

  1. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London") + v_TimeZoneOffset; Note(s): This was done in ZohoCreator which was showing a timezone of -0700 or PDT irrespective of the settings in the app being set to GMT.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    { v_CurrentSignature = ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done? //if(v_CurrentSignature.length()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    how I upload the file, this error no longer appears. This error seems to be at the end of a function which has already done a lot of processing. Here's a quick test snippet of code: void fn_UploadTest() { // // selecting a record which has a file upload...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    } } catch (e) { // display exceptions to console watchers console.log(e); } Click on "Save and Close" Done.

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

    Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey. Apparently this will be done in Zoho Analytics. The Brief: We would like the survey data to be generated as a chart and embedded in a PDF brochure we send...

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

    does not affect historical transactions, but deleting the account altogether can affect balances, so that should only be done after Zoho confirms it’s safe. Once the backend team confirmed there was no risk to balances, the correct approach was as...

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

    -- ----------------------------------------------------------------------------- -- II. 13. jos_menu_types (this had to be done before the menus in II. 12.) -- ----------------------------------------------------------------------------- --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    Test by logging into the Joomla Admin Panel > Extensions > Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member...

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

    not overwrite configuration.php !!!) Copy database from LIVE to TEST (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for...

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

    #__assets SET parent_id=1 WHERE parent_id=0 AND id1 AND title'Root Asset' -- where #_ is the Database Tables Prefix value Done phpMyAdmin alternative The gist is simple, you can only have one asset that has a parent_id of zero. Login to your database...

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

    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: *
  13. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    Caveat: If you login to the administrator section on a shared computer, ensure you close the browser (and all tabs) once done or this cookie will remain on the computer and will be readable by other users who access the same computer (this is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    from Legacy to Modern A further option will appear called "Remove IDs from URLs, set to "Yes" Click on "Save" and you are done.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration...

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

    > 5 Close off this if else statement (if time remaining > 5 minutes) here if you are not using the full script below. 8. Done That's it! You have an access token, your service account can connect directly with its Google Drive. To get a file listing,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  17. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    This took me a whole afternoon and involved a lot of hope as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  18. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    the game. I'm trying to remove the first two entries from a news feed from a Google News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do...

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

    SQL Server\100\DTS\PipelineComponents" /Y REM Returning to directory where this BAT is held. CD "C:\Temp" ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project. This results in a setup.exe...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the Flat File Source. Done.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
Results 61 - 80 of 106