Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 month. Microsoft's Bing has added itself to the fray pretending to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota:...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s). You may not...

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

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

25 February 2010 Audience implications (Internally Centered? / Customer Focused?) Explain Domain Registration process (for client to do so they retain overall control of the company) Who will be working on this project? (supply contact details) Rates (usually £9/hour...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 open, and want to view them side by side. Click and drag one to the right edge of the screen and the other to the left. They will both resize automatically to fit the screen Aero Flip: Aero Flip 3D This Aero effect was in Windows Vista but not in XP....

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Right-click any of the fields, click Size, and then select Same Width. This widens all the fields in the column until they are the same width as the widest object in the column. Export the report to Excel and on extra blank columns will appear in the...

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 acronyms myself). permission-based marketing An opt-in policy requires a potential customer to self-select the services they wish to subscribe to, and how any information they provide may be used. Also referred to as permission-based marketing. Section...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 services like Western Union or MoneyGram. These services are not meant for transactions between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by sending money to a friend or...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as staff or student. Number of total hits aggregated by...

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

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 the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script...

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

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

07 July 2011 stylesheet and my 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...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 database though we are still considering it; so this article is more about just getting external images to display when they are provided over an authenticated URL (You shouldn't be having any issues with this if the image is available to anonymous...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie....

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 or clicks on it. In this specific case, if the value is "Name:", then clear the field and change the color to black (so when they type they can see what they're typing). onBlur() - happens when the user clicks outside of the field or moves the cursor to...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My...

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

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 of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME folder - only check the subfolders. If they are, you've lost the Joomla CMS and you'll...

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

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 doesn't exist in our upgraded system because we may have a user with that ID in the old system who might inherit privileges they shouldn't have. This script has been adapted to change the Admin ID to a number that hasn't been taken yet or to use the...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 The fix is a PHP one and has to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the product_details field of an...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 Partner Support (partner-support@zohocreator.com // Zoho Cares) you have done this and thank them for their help. Wait till they confirm they have setup the SSL certificate on their side, test by visiting the portal in an incognito/inprivate window and...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 workflows triggered from many deltas/changes. Why? Some clients have referred to this as the "spinning circle of death": they load up a Creator application or change a field and there will be a spinning icon indicating that the field has triggered an...

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