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

SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 on the “People and Groups” link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your...

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

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

23 September 2015 number / product key from my Windows 7 Professional 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?...

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

Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 // get date field day abbreviation Day_Abbreviation = My_Date.toString("E"); // find in array and return same index from first array Day_Name = Day_Names.get(Day_Abbreviations.indexOf(Day_Abbreviation)); Reducing the code lines but using the same...

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

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

15 November 2018 help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to...

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

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

14 March 2020 setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the file htaccess.txt and rename it to .htaccess All GUI Now login to your Joomla Administrator section Browse to System >...

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

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

16 June 2021 // // send via Email v_Subject = "From your friendly neighborhood developer"; v_Message = "Please find attached the Audit Log for the events dated " + v_ThisEventTime.toString("yyyy-MM"); sendmail [ from: zoho.loginuserid to: zoho.adminuserid subject:...

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