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

07 July 2011 on lowest rated --- Report on highest rated --- Report on development per project (GANTT?) --- Report on server bandwidth (security concerns) --- Use flash charts --- Publish to URL (for public/registered access) --- Export to Excel (Joomla! admins...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 may want to tidy this up but the more basic the receiving data the better. In my example, I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The...

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system...

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

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 it to the root of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO...

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

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

24 October 2014 before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details. • By default, every item is private. Account Management: Visit www.joellipman.com/account/member-access...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 text/xml')); // specify content type of what we're sending curl_setopt($ch, CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!! curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS,...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 "name": "my_video.mp4", "mimeType": "video/mp4" } Additional: Why not? Let's add a description and some security where we disable download, sharing, etc. to the viewers (except the owner). In other words, ticking the owner settings under the advanced...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 you can then put the email of the user the service account will be impersonating. Browse to https://admin.google.com Go to Security > Show More > Advanced Settings > Manage API Client Access Enter the Client ID in the field Client Name (eg....

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 node –v npm –v You should get a version number for each of these as a response. Failing this you should check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET)...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 // // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) {...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 open scopes just to get a working example; I can then reduce the scopes permissions afterwards when locking it down for security: Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels...

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

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

06 March 2023 will not be accessible by external sources unless you choose to make it publicly available. OpenAI takes data privacy and security very seriously, and they have implemented several measures to protect the data and models that are used by their services....

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 image URLs (see Zoho Creator API 2.1: Download File). Refused to connect to because it violates the following Content Security Policy directive: "connect-src don't bother. You're probably on an external server. Create your own web app on another server...

• 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 to in this solution; namely the webhook response needs to have a header and a body. The 2nd caveat is a concern around security. It is difficult to guess a customer's Zoho ID; some might say almost impossible. To use other fields that could be sent via...

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

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