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

  1. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    when exporting to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent fields from appearing in different rows, horizontally...

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

    version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and...

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

    article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  4. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    For example, if you distribute copies of such a program, whether gratis or for a fee, you must pass on to the recipients the same freedoms that you received. You must make sure that they, too, receive or can get the source code. And you must show them...

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

    DBAs to run this themselves. Personally I grant the user who will be executing the script full privileges or at least the same as needed to install Joomla CMS. Cross your fingers and use your DB management tool to run the SQL file (or copy the contents...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over...

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

    so this counts as a violation of this rule. No Double Posting or Spamming - You may not post more than once in a row in the same thread. Posting lots of times in a row reduces the quality of the board, is a waste of the board's memory, and provides the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    of yours (it will look at it like MS Windows Internet Explorer) it should be ok. Output names for the thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If there is nothing specified, it will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    To close the dialog on the receiving page, you can add the following code: openUrl("#Script:dialog.close","same window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have...

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

    as system user rather than default crm connection - Reminder cannot be set for task creation time so create task at the same time as lead and set reminders daily 24 hours after until end date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  13. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    to the server. Setup FTP Accounts (just one username/password). Setup automated backup system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  14. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    and create the rules on changes to the relevant fields Run DOR from the menu system Enter a DOR code (we kept this the same as the the XET and EOR codes) Specify the Message Group that the monitors will run. In our demo, the link value uses all three...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  15. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones that appear in the ruler as little arrows). So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    Off ToolTip return } Search: Return GuiClose: ExitApp The images I used in this GUI are: and . These have to be saved in the same folder as the AHK script. It took me a while to get the tooltip to show until I realised you have to specify the tooltip...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  17. AHK Countdown Tooltiphttps://www.joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to when you leave, compile the code...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  18. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    /XN /XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in the source directory. -- /XO...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  19. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    maybe your CSV contains multi-line fields; eg. where address street is on a different line to address city but in the same column... The following regex will replace new lines found in between 2 double-quotes and not at the end of the line:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with the filename appended. Because of MS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 20 of 183