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

  1. Country Lookup by IP address CSVhttps://joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    a given IP address, this is what I use. The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we...

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

    by commas (not within quotes) - Sorts the final array by a object label function populate_array_from_csv(this_file){ // using deprecated XMLHttpRequest to read file // (works at time of print (2015-10-05)) var xhr = !window.XMLHttpRequest ? new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    index from first array Day_Name = Day_Names.get(Day_Abbreviations.indexOf(Day_Abbreviation)); Reducing the code lines but using the same technique as above: Day_Names =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Disable User Registration in Joomla 1.5 - Configuration Filehttps://joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

    A quick reminder on how to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    What? A short article explaining how Zoho Deluge allows a variable assignment to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    What? A quick article on how to upload an image to the product/item listing in Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Write a Calendar in Autohotkeyhttps://joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    rid of the problems you cause. The following rules are also important: No Advertising - You are not permitted to make money using TEU. You are not allowed to use the member list to obtain Instant Messenging screennames to harrass people to purchase a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  10. Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    option but you need to select an user group with higher privileges like "Super User". Installation: Install this module ZIP using your Joomla! CMS extension manager. Go to "Content" > "Media Manager" > Create a folder for your thumbnails. Go to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Joes Password Analyzer (JPA)https://joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=53&Itemid=165

    is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack of cards, I came up with a function that will take a list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    = v_XeroTime.subString(v_XeroTime.indexOf("(")+1, v_XeroTime.indexOf("+")).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key. Let's make it even more interesting: I'm going to use a subform with the file upload field type so our...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  15. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    you need to do in your respective Domain Manager system (website where you registered your domain): Setup your subdomain using the registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    the Status, there are "Pending", "Cancelled" (UK spelling), "Approval Not Enabled" and I think "Approved", "Rejected". We're using the !="Cancelled" and probably !="Rejected" because we want pending ones to also be taken into account (first come first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  18. Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

    A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    File upload) Create a connection in the Creator app with the scope: ZohoCRM.modules.ALL (potentially you could try just using ZohoCRM.modules.Attachments.READ but at this point I couldn't be asked). Then publish the report of this form (eg. "Download...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. 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

    "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request using the invokeUrl() function, the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 101 - 120 of 332