Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 -- previous steps will match up, anonymous users (non-registered members) -- will be migrated without association (retain UserID=0). The article IDs -- should also match up. -- ********************************************************************* --...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source, source_id,...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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-using-a-function-for-validation-rules.html

11 February 2022 or not ******************************************************************************* */ // // declare m_Output = Map(); v_UserID = 0; v_UserProfile = ""; l_DisallowedProfiles = List({"Agent"}); l_DisallowedOptions = List({"New Lead","Appointment...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 to this specific callback URL notification.data.username this string is the publicly known eBay user ID notification.data.userId this string is the immutable identifier of the eBay user notification.data.eiasToken this string is the eBay user's EIAS...

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month,...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 // single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek =...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy FROM StaffActivities s INNER JOIN Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User = zoho.crm.getRecordById("users", v_UserID) but here's the old way of doing this: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers"); r_Response...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 for each d in dd.keys() { c_Params= Collection(); c_Params.insert("date":d); c_Params.insert("type":"3"); c_Params.insert("userId":empid); r_ApiResponse= invokeurl [ url :"https://people.zoho.com/people/api/leave/getEmployeesOnLeave" type :POST...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 + v_DealID + ")"); Find records relevant to this user: v_SearchCriteria = "(field0:equals:" + v_UserID + ")"; l_SearchResults = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): //...

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