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

26 August 2021 m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); }...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 SID you obtained in the steps above v_Account_SID = "ABCDEFabcdef0123456789ABCDEFabcdef"; // // set this to the authtoken value obtained earlier v_Auth_Token = "1234567890aaaabbbbccccddddeeeeff"; // // set this to your Twilio number (dialing/texting...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 field payment mode m_MiniCustomField = Map(); m_MiniCustomField.put("api_name","cf_payment_method"); m_MiniCustomField.put("value",v_PaymentMode); l_NewCustomFields.add(m_MiniCustomField); // // add custom field payment date m_MiniCustomField = Map();...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script,...

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

DBMS Random Referencehttps://joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets)...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Convert a delimited string to tablehttps://joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE....

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

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an...

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

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

18 December 2024 update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject"));...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution...

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

Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste the same height value as the one that worked...

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the font color of days that are in the given month (where "Gainsboro" is a type of light grey): =IIf(Month(First(Fields!Date.Value))=Month(Parameters!GivenDate.Value), "Black", "Gainsboro") Right-click on the Date textbox and select Font then for color,...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " & First(Fields!PhotoURL.Value, "PhotoDetails") & IIF(Code.ImageExists(First(Fields!PhotoURL.Value, "PhotoDetails")), " exists!", " does NOT exist.")...

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

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 DECLARE done INT DEFAULT 0; DECLARE COUNTER INT; DECLARE table_cur CURSOR FOR SELECT concat('SELECT COUNT(*) INTO @CNT_VALUE FROM `',table_schema,'`.`',table_name,'` WHERE `', column_name,'` REGEXP "',in_search,'"') ,table_schema,table_name,column_name...

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

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

10 October 2012 variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick...

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

Copy a Wordpress Site for Developmenthttps://joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 Backup the database in LIVE environment Clear the database in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 (or "JSM"). Other Areas: One of the parameters is entitled "Search Area". This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search...

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

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 alias (eg. for "about" give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is...

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

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Update server added (for when Joomla supports this) - Date Uploaded: Wed, 15th Jan 2014 3.0- Enhancement: Hardcoded DS value for Joomla 3.x compatibility. - Date Uploaded: Mon, 16th Sep 2013 2.2- Enhancement: Parameter: If viewing an article, scan...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which...

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