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

24 October 2014 actually incurred) on account of death or injury to any person or damage to any property or product arising from or in connection with any products sold or supplied by JoelLipman.com. This indemnity shall apply without regard to whether the claim,...

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

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 true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 r_Associate = invokeUrl [ url: "https://www.zohoapis.eu/books/v3/invoices/mapwithorder" type: POST parameters: m_Params connection: "zbooks" ] m_Params = Map(); m_Params.put("line_items", ); m_Params.put("organization_id", ); r_Associate = invokeUrl [...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 = List(); r_Fields = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type :GET connection:"myzohoconnector" ]; if(!isnull(r_Fields.get("fields"))) { for each r_Field in r_Fields.get("fields") {...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 + input.CRM_Quote_ID; r_CreateCrmQuote = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ]; or l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes);...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 m_ShippingAddress.put("is_update_customer",false); // send the request via API (change connection name to your own) r_UpdateSO = invokeurl [ url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 + "/messages?fromtime=" + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 = invokeurl [ url :"https://www.zohoapis.com/books/v3/settings/paymentterms?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; info r_PaymentTerms; } Deprecated pre domain change: void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID =...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the...

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

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

22 April 2024 r_CreateRecord = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash =...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 r_CoqlUniqueProducts = invokeurl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product in l_UniqueProducts {...

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

Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 // app specific (retrieving from a ZohoCreator record that stores all these credentials) r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API"]; // // client id from the shopify admin and registering a custom app // eg....

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 is what the official Kunena documentation says: Installing another Template Download the Template package. Open your FTP Connection and go to \components\com_kunena\template\ Extract the folder "Template Name" into this directory ^ If in the package the...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are able to link to other websites which are not under the...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but...

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

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

25 February 2010 Webmail or do you have standalone clients (eg. Outlook, Thunderbird, Eudora) For Joellipman.com to do: Submit connection instructions (SMTP, POP3 - incoming, outgoing servers) Send Webmail URL Allocate space for mailbox(es) Assign passwords and...

• 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 eBay, PayPal or another company and offers buyer protection or an online payment system. This could be directly in connection with a transaction through someone you’ve met online. Or perhaps the buyer or seller suggests you use a payment or protection...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 to the administrator of this site. Check you can send email from that server ERROR: Message not sent. Server replied: Connection refused 111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a list of...

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