Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 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: *

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 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: *

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 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
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 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: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 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: *

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 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

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 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: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 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: *

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 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: *

Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 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: *

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 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: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 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
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 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
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons. I installed the standard 1.5 installation package. I have uninstalled and...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /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

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 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: *

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB