Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am at the...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal...

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

Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6. Turn Register Globals Emulation OFF 7. Check for extension...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 final script for the events table (DO NOT USE THE BELOW: this works for me and the timetabling system I have, you need to adjust how you get the values from your events database). First get the events from your database and then get the rooms: ), Events...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 development project. The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 your CSS with regard to referring to elements by ID, so for example, if my subform is called "Item Details", then I would adjust the code to something like the following: // // CSS overrides v_CssNotes = ""; v_CssNotes = v_CssNotes + ".subformRow...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 within the same function to return a map. Note that this is for fixedpriceitems only. For auction ones, you would need to adjust the parsing code below to capture auction details. This includes a split for any multi-line item orders: // // declare...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 (Joel Lipman) - Resolved fix of incorrect customer (Use Email rather than StaticAlias) - Resolved fix of inventory adjustment level (Error:9205:Insufficient Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 = r_UpdateBooksInvoice.get("invoice").get("invoice_number") + ": " + r_UpdateBooksInvoice.get("message"); // // adjustments if(r_UpdateBooksInvoice.get("invoice").get("total") != v_Crm_Invoice_GrandTotal) { v_TotalAdjustments = v_Crm_Invoice_GrandTotal...

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