Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your import: You can...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

22 January 2022 fn_eBayQuery_GetItemTransaction() Input: int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 Rule" Choose the layout, this has to be the highest level (I think) as a custom lead layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 tried to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a string is a no go. Set it to an atom time or nice...

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

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

14 March 2024 }); */ /* ************************************ */ /* Some non-Zoho JavaScript */ /* Set Copyright Year */ var today = new Date(); var currentYear = today.getFullYear(); $('footer span.year').text(currentYear); Error(s) Encountered: Error Status 401 Code...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 of products per page l_PaginationParams.add("per_page=" + v_PerPage); // missing products if using default order by as date l_PaginationParams.add("order=asc"); l_PaginationParams.add("order_by=id"); // r_AllProducts = invokeurl [ url...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email = c_Quote.Email; } v_QuoteDate = c_Quote.Modified_Time.toString("dd-MMM-yyyy"); c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy =...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

22 July 2024 = ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?)...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 Stage 1: Add Relevance [Mandatory Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the...

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

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 INSERT INTO my_wordpress_db.wp_posts SELECT id 'ID', 1 'post_author', created 'post_date', created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft'...

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

Windows Live Messenger: Error 80048820https://www.joellipman.com/component/content/article/windows-live-messenger-error-80048820.html?catid=80&Itemid=165

08 March 2010 clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize...

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

Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

05 July 2011 (if installed) acrodist Adobe ImageReady (if installed) imageready Adobe Photoshop (if installed) photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

30 July 2020 Sound ms-settings:sound Storage ms-settings:storagesense Storage Sense ms-settings:storagepolicies Time & Language Date & Time ms-settings:dateandtime Japan IME settings ms-settings:regionlanguage-jpnime Region ms-settings:regionformatting Language...

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

The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

08 August 2011 RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished?...

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

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

11 October 2012 ** ****************************************************************************************************************** ** Date: By: Rev: Desc: ** **...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 ** Change History: ** ************************************************************************************ ** Date: By: Rev: Desc: ** ** ------------------------------------------------------------------------------ ** ** 29/10/2012 Jlipman 1.0 Created...

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

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

08 March 2013 Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot drop database because it is currently in use...

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

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 ** ****************************************************************************************************************** ** Date: By: Rev: Desc: ** **...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 -------------------------------------------------------------------------------- STUDENTID STUDENT_USERNAME STUDENT_CREATION_DATE STUDENT_FILE ---------- ----------------- ---------------------- ---------------------------- 1234567 jsmith2012 08-MAY-12...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these...

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