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

24 October 2014 without needing to redistribute or update this app. {youtube}fQD0xVEYDks{/youtube} Location: For location, type a city name, post code, zip code or any value that is understood by the api.openweathermap.org website. There are plans to shift this to...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have:...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID = r_QuoteDetails.get("Account_Name").get("id"); r_SearchResults =...

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

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

11 October 2012 ** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value (Maximum) ** ** ** ** Additional: ** ** - For performance, restrict this by schema otherwise...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 I'm sending to the function. So in "Edit this application" > go to Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return...

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

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

08 November 2018 This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As simple as this sounds, this...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file...

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

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

20 September 2021 { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else { r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; //info "Production Mode";...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 use "equals" with a single condition and search for a field (mentioned in point #3 of the Note on this page), like Campaign_Name:equals:CRM, the response will contain only those records whose Campaign_Name is "CRM" and not records with "Best CRM" or...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 the lookup value: -- What I have: no export format 5826 -- What I could have: export format set to get lookup value -- &GCOD_NAME.COD.SRS England -- What I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 each row for each r_Data in l_FileRows { // initialize record m_Record = Map(); m_Record.put("EmployeeID",""); m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // split values by commas l_FieldValues =...

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