Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 many might be aware Amazon allots an email address to every Kindle owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 this is the SHA1 of your computer but add it anyway to the Google APIs console for testing purposes. To get it again: Finding your computer's Certificate Fingerprint SHA1 Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 synchronized... You can opt to untick the checkbox next to Synchronize with an Internet time server to prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK Leave your computer for a...

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

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 synchronized... You can opt to untick the checkbox next to Synchronize with an Internet time server to prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• 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 Joomla randomly selects an ID for the installing admin, I -- have changed the script to determine what this ID is by finding out what -- user_id is the first user created in the upgrade site. This is the ID -- used when installing Joomla CMS. It is...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...

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

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 A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 headers:m_Header ]; } } return r_ShopifyWebhooks; The REST API endpoints If you are having difficulty finding these, go to your CRM > Settings/Setup > Functions: then hover your mouse over the function and select "REST API". Enable the API Key option...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 sent via the URL as a verification to be checked at the webhook endpoint would be good as well; but I couldn't spend time finding fields that can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So...

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