Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 on what my Zoho Creator form looks like for API Integrations and the fields I refer to: Note the Dev ID field and the Session ID fields that we didn't use in my previous article but are going to use now. You get the Dev ID from your application keys...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my article on how to download videos from a session on TrainerCentralSite.com. How? OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files...

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

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

30 January 2011 Part 2 is dedicated to content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 with the official student record system and timetabling system (done via file upload). It included it's own timesheet / session management / invoicing system. The website was held on a virtual host running PHP and MySQL. There was no documentation,...

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

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

17 August 2012 vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click on "Environment...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 a SQL Database Backup Using SQL Server Management Studio Unable to restore database "..because it is in use by this session." determine who is connected to sql database Sources Microsoft Developer's Network

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 (or re-issuing) their password which implies there was an issue with pre 4.1.1 passwords and the hashing algorithm: SET session old_passwords = 0; SET PASSWORD for 'youruser' = PASSWORD('yourpassword'); Method #2 (useless fix - unlikely to change...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 own component - Factory: download equipment data - Factory: rate equipment / quality - Factory: view photos (cached for session only) - Factory: item specification - Factory: - name, weight, dimensions, power consumption, - Factory: - cost, features,...

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

Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Voice activation ms-settings:privacy-voiceactivation Surface Hub Accounts ms-settings:surfacehub-accounts Session cleanup ms-settings:surfacehub-sessioncleanup Team Conferencing ms-settings:surfacehub-calling Team device management...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Line) Location Code (Origin) (Single Line) Authorize Endpoint (Single Line) Grant URL (Url) Token Endpoint (Single Line) Session ID (Single Line) Redirect URI (Single Line) Scope(s) (Multi Line) Access Token (Multi Line) Access Token Expiry (Date-Time)...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 Still to do: Need to train it on ZohoCRM data with statistics and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 registrar, then they need to sign in to their domain registrar's website and need to be assisted, perhaps via a remote session, on setting these up. If they have someone or a company which manages their domain, then they can give the following...

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

Code Troubleshooting Checklisthttps://joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 by functions, classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the error in understandable and diagnosable parts?...

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

Convert seconds to total time in PHPhttps://joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and...

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