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

12 September 2015 FROM `v34_db`.`v34_contact_details` WHERE `v34_contact_details`.`id` >= 1 -- ALTER TABLE `v34_db`.`v34_contact_details` AUTO_INCREMENT = 1 -- Content: UPDATE `v34_db`.`v34_content` SET `created_by` = @v25_admin_id, `created_by_alias` = @v25_admin_alias...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) )...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically pre-selected based on the user. How? So there's a bit of a pre-amble for setting up the fields, we'll then use a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 same as the image and positioning the div. This causes a scrollbar at the bottom. Tried different techniques of CSS overflow auto hidden etc. all to no avail. What I didn't want when I resize the web browser, a scrollbar! What worked for me: Specify the...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, add to the "" tag under "OrderedItems" class the code: style="page-break-inside:avoid;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to center readon-wrap1 Original Code: New Code:

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 This is the CSS though: #container { position: relative; } #content { position: relative; top: 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image: url("../images/bg_contentbox.png"); /*...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Minimal typing (for click-happy people like me). Currently only allows for back-end Joomla! administration. Automatic version control Automatic changelogs based on support tickets/development requests. INSTALLATION Download the ZIP file from my website....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

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

10 December 2020 other Zoho apps, it would stand to reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 #my-line-items thead tr th:first-child{ width: 50%; text-align:left; } #my-line-items tbody tr td img{ width: 75px; height: auto; max-height: 75px; max-width: 75px; margin-right: 15px; float:left; } #my-line-items tbody tr td{ font-weight:400;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *