Search - Joel Lipman .Com

1. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... ", "0"); v_HoursHHmm = v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm); m_CreateTimeLog.put("start_time",v_StartTime.toString("hh:m ...; Created on 30 April 2021
2. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" ...; Created on 10 December 2020
3. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:nfctransactions Proxy ms-settings:network-proxy Status ms-settings:network-status ms-settings:network VPN ms-settings:network-vpn Wi-Fi ms-settings:network-wifi Wi-Fi Calling ms-settings:network-wificalling ...; Created on 30 July 2020
4. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: ...; Created on 08 July 2020
5. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); // ...; Created on 17 March 2020
6. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... value is "2020-02-10T11:49:12+0100" // yields ,"message":"invalid data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: ...; Created on 06 February 2020
7. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; ... Map(); m_UserType.put("type","ActiveUsers"); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Users ...; Created on 23 January 2020
8. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... "Sort") ; sort the second column (profile names) Gui, Font, s8, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; ...; Created on 07 January 2020
9. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a valid user preferably other than the super-admin. ,"message":"body","status":"error"}: ...; Created on 17 July 2019
10. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": ...; Created on 03 June 2019
11. Zoho Deluge - Update Creator from CRM: / Zoho /; ... "criteria": "ID==1234567890123456789", "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } Method #2: Using API v1 (using JSON not XML) Generate ...; Created on 18 February 2019
12. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
13. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Add, TreeView, x2 y25 w496 h310 vMyFolderTree ImageList%ImageListID% Gui, Add, StatusBar, v_StatusBar Gui, Show, w%Width% h%Height% xCenter yCenter SB_SetText("Ready.") Return ; -------------------------------------------------------------------------------------- ; ...; Created on 28 January 2019
14. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration ...; Created on 12 September 2015
15. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... status v1.6.x [5 Nov 2014] - [1.6.2] Map: return zones within 15km radius (was 111km) - [1.6.2] Map: return up to 100 zones (was 20) - [1.6.2] Map: tooltip with categorized zones - [1.6.2] Map: ...; Created on 24 October 2014
16. Convert to Proper Case in T-SQL: / Transact-SQL /; ... John Smith-Jones HEAD OF IT SERVICES Head of IT Services FLAT 123A Flat 123A MRS. O'CONNOR-MCDONALD Mrs. O'Connor-McDonald ORG_DEPT_STATUS Org_Dept_Status SEND.HELP.NOW Send.Help.Now PO BOX 1234 PO ...; Created on 04 June 2014
17. SSRS Change Background Color of Image: / SQL Server Reporting Services /; ... Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the ...; Created on 08 April 2014
18. Registered Users Cannot Login - Super Users Can: / Joomla /; ... users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test ...; Created on 26 February 2014
19. Client Services: Website Development Agreement: / Static Items /; ... rate). Note that my servers are based in Houston, Texas, USA (due to their traffic [when europe is active, these are not and vice-versa] and resilience [99.99% uptime] status compared to European ...; Created on 15 November 2013
20. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... when the component is added to the data flow public override DTSValidationStatus Validate() { bool pbCancel = false; IDTSInput100 input = ComponentMetaData.InputCollection[0]; ...; Created on 04 October 2013