Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 think about tax and probably manage it in Zoho Books leaving it to their finance team. This is a quick run-through for a standard setup to include UK tax/vat. How? Here's a quick step-by-step to follow: Login to ZohoCRM as an Administrator Go to Setup >...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 Give it a description, I'm giving it the one I have in the function header below Category is "Module" Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This...

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

Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html

13 September 2010 zh-cn Chinese (PRC) zh-hk Chinese (Hong Kong SAR) zh-sg Chinese (Singapore) hr Croatian cs Czech da Danish nl Dutch (Standard) nl-be Dutch (Belgium) en English en-us English (United States) en-gb English (United Kingdom) en-au English (Australia) en-ca...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 / COM This tutorial requires one of the following: AutoHotkey_L - has built-in COM Support (recommended) the COM Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK user how to start using COM...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 Karachi (GMT+5:00) Tashkent (GMT+5:00) Russia - Yekaterinburg (GMT+5:00) Kerguelen (GMT+5:00) Maldives (GMT+5:30) India Standard Time (GMT+5:30) Colombo (GMT+5:45) Kathmandu (GMT+5:00) Mawson (GMT+6:00) Vostok (GMT+6:00) Almaty (GMT+6:00) Bishkek...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 How? Through the wonders of Zoho CRM Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order...

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

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

07 July 2011 RocketTheme template. RokDownloads by commercial Joomla! template and extension providers, RocketTheme. They don't use the standard Joomla! admin component tools and instead have built a back-end Joomla! administration component that only works in MS...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 means the preferred form of the work for making modifications to it. “Object code” means any non-source form of a work. A “Standard Interface” means an interface that either is an official standard defined by a recognized standards body, or, in the case...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• 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 -- Set to your v2.5.x admin ID to NOT migrate as per standard users SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla 2.5.x -- Standard Users: INSERT INTO `v34_db`.`v34_users` ( `id`, `name`, `username`, `email`, `password`,...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have a Refresh token we will generate an...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 grey one) Give the client script a name, I'm calling mine "Extra Confidential" Keep Category=Module, set Page=Detail Page (Standard), set Module=Contacts and set the layout if you want. Under Event Details, set Type=Page Event; Event=onLoad Click on...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons. I installed the standard 1.5 installation package. I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Similar looking websites where layouts/colour schemes can be adapted Explain accessibility and usability industry standards. (includes iPhone compatibility and disabled access) Explain balance of scope, quality, time and cost. (focusing on one element...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing your website up to standard with all issues addressed and sporting the latest version of the Joomla CMS! UPDATE 2012 - Valid for Joomla 2.5.x but only...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via three usb extension cables. The middle one wasn't connected to anything on either end....

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *