Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 still come across clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of their website. Why? In my...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 ISNULL(ContributionValue) || (LTRIM(ContributionValue) == "") ? "0.0000" : TRIM(REPLACE(ContributionValue,",","")) My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date column will have a string of 8...

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

Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter...

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

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

22 July 2013 is derived from a template and depending on if you are using MS Internet Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 prior to any 3rd-party extensions If you didn't have a backup, then I would simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy over the core files. Get that working and then begin...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 How? So the main bulk came from the JoomlaTune website but as it was a forum post that may get moved/deleted, I've copied most of it and put it here with my minor revisions/adjustments to get it actually working. STEP #1: Check ReCaptcha API Check your...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 to write to a mounted external SD card so they can share data but for the time being they are on the internal storage (like most apps). If you want to backup the files for the hangar, they are stored in this apps files folder:...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 offline mode or incompatibility with the device). How? In this example, I'm going to add the map as a fragment. This is the most rudimentary example (display map, move camera and display marker) and can be run from any other activity: MapFragment.java...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 address. We're going to use a PHP script with the cURL function to receive and send the data. cURL is a standard feature on most LAMP setups. If not you can install it from here: http://curl.haxx.se/download.html I'm demonstrating this with 3 scripts on...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Admin Panel option: Cache-mode - Date Uploaded: Mon, 20th Sep 2010 1.0.0- Created according to brief (automated, using most frequent words) - Added Joomla Admin Panel option: Scan Joomla! articles - Added Joomla Admin Panel option: Scan K2 articles -...

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

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 -- Our task here is to insert the new comments, correctly associated to -- their respective articles and users. Most of the users as per -- previous steps will match up, anonymous users (non-registered members) -- will be migrated without association...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also output any of...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) order by id desc, Stage asc"; // returns 200 deals in most recently created order Regular expression reminder (do not use): v_SearchName =...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 "attachment_Id": "234567890123456789", "file_Size": "13.26 KB", "creator_Id": 987654321098765432, "link_Docs": 0 } ], The most logical thinkers would say that you simply need the download_Url value and prepend the CRM base URL such as...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link....

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and...

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