Forgotten Super User Password in Joomla 2.5.x - 3.xhttp://mail.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 is reliant on having access to the database of your Joomla website. Method #1: Quickest way I know This is based on if you have another user account (registered or administrator, any) with a password known to you (create a new joomla user if necessary)....

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

Error 404 Component Not Found when enabling SEF URLshttp://mail.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 an out-of-date bookmark/favourite - a mistyped address - a search engine that has an out-of-date listing for this site - you have no access to this page If difficulties persist, please contact the System Administrator of this site and report the error...

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

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself don't put any copyright information on the end product. I needed a program to: + Group all...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my university one). How? I'm going to use my trusty notepad program, copy the...

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

MySQL Transactions in PHPhttp://mail.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts'...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Make bootstrap carousel responsive to swipehttp://mail.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up...

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

Change div height to fit contenthttp://mail.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

15 November 2018 on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit...

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

PHP - Remove newlines and spaces from StyleSheethttp://mail.joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want: #copyright...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Zoho Deluge - Pad with leading Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may...

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

Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 In Reverse To have the reverse effect of converting a URL into a map, I'm using the following: v_ReturnedUrl = "https://api.joellipman.com/myapi?isAuthSuccessful=true&code=my_own_code&expires_in=299"; l_ReturnedUrlParts =...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://mail.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // With URL rewriting enabled...

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

COVID-19: Working from Homehttp://mail.joellipman.com/covid-19-work-from-home.html

05 July 2020 terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

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

Zoho Deluge: Generate and Send a CSV via Emailhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List();...

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

Zoho Projects: Deluge to Submit Custom Fieldshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 that are required in the request but not a sample request packaged to be sent. How? Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet,...

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

Zoho Deluge: Push a value to a datetime field in CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...

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