Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 instance. Right-click the database to change, and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 did not match the requirements (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and...

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

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

15 November 2013 source files available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work. JoelLipman.Com will produce a signed-off...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 update Akeeba (a 3rd party component to do backups) simultaneously or prior to updating the core Joomla CMS. Ticking both options and then updating re-created the error. I restored the files (using a backup to overwrite the existing PHP files), leaving...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 updated. (I did this while the phone was NOT connected to the computer, ie via the Settings > General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into the computer. In iTunes,...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 and scoring key given to you. > Save Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 and scoring key given to you. > Save Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find the value of...

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

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.5 (4)- Enhancement: Restored alignment parameter - Enhancement: Restored colors and new colors given - Enhancement: Compatible with Joomla v2.5.x - Fixed: Backwards compatible parameters updated - Date Uploaded: Fri,...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions3.1.1 Artur- Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 will display folders and their respective sizes." Width := 500 Height := 360 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +ToolWindow -Resize -MaximizeBox -MinimizeBox +OwnDialogs" BaseDir := "C:\Windows\Temp" ;...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 link. The JSON response is that the update was successful but the Creator tables do not update... ZohoCreator/creatorapi option not available to enable: resolved by deleting any existing ones, refreshing the page and trying again.

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 How? A little undocumented this "feature" but the gist is if you want to add tax, it has to be built up in the tax options, if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value. // What I have in CRM: {"My_MultiPicklist":["Option1","Options 2, 3"]} // What Creator...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 v_LineItemTax = 0.99 * 5 * 0.2; m_LineItem.put("Tax",v_LineItemTax); if(v_LineItemTax>0) { l_TaxOptions = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","Sales Tax"); m_TaxOption1.put("value",v_LineItemTax);...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product Update"] JSON Payload [Multi Line] 2. Joel's first Cheat: If your client has...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then aligning these radio options horizontally: v_Css = ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + ".zc-Tabs-group...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optional fields m_ScheduleCall.put("Call_Purpose","Prospecting"); m_ScheduleCall.put("Call_Agenda","A scheduled call to phone " + v_CustomerName + " at...

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