Search - Joel Lipman .Com

21. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... this article for you which we tried to use but only helped us out about half-way, the rest we guessed on our own: Our use case, is that we are developing a Zoho Creator app that will help staff log ...; Created on 30 April 2021
22. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...; Created on 10 December 2020
23. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave ...; Created on 28 June 2019
24. 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
25. Display Feeds to major Social Networks: / Web-Development /; What? A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff ...; Created on 16 May 2016
26. SITS: XET format for Export not available: / Extensible Markup Language /; What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...; Created on 08 August 2014
27. AHK Countdown Tooltip: / AutoHotkey /; ... ; Background image to change to during the running of this program DesktopBackgroundImage1:="\\bournemouth.ac.uk\data\Staff\Home\jlipman\My Pictures\byeBU\byeBU_byPChristopher.bmp" ...; Created on 17 July 2014
28. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; ... "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, ...; Created on 03 June 2014
29. T-SQL: Parse an XML value: / Transact-SQL /; ... AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or -- Using .value() SELECT CAST(Event_XML ...; Created on 27 March 2014
30. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" ...; Created on 05 December 2013
31. Client Services: Website Development Agreement: / Static Items /; ... (GUI based for non-technical staff. Web-based for remote working.) JoelLipman.Com will create 2 development sites ("play" sites) which the project manager and his/her team can use to experiment and ...; Created on 15 November 2013
32. Convert Decimal (Person Days) to Time in Excel: / Excel /; What? We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...; Created on 13 February 2013
33. Set up Desktop SlideShow in Windows 7: / Windows OS /; ... be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff ...; Created on 22 January 2013
34. Delete related records from multiple tables: / MySQL /; ... s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- ...; Created on 11 January 2013
35. Generate Academic Calendar using MySQL: / MySQL /; What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article ...; Created on 27 November 2012
36. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...; Created on 27 April 2012
37. Reminder on SSRS row separator: / SQL Server Reporting Services /; ... row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main ...; Created on 26 October 2011
38. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... only authorised personnel could refresh the data on the Excel spreadsheet and they would then save as PDF and send to appropriate staff. Other Issues I usually felt that CHAR(13) goes hand in hand ...; Created on 30 September 2011
39. Excel PivotTable Filter List Ordering: / Excel /; ... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...; Created on 05 September 2011
40. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... Setup Windows XP Workstation ...needs to open... Excel 2007 SP2 ...with ODBC to... MySQL v5+ ...hosting database... ActivityLog ...contains activity, staffID, resourceID, ...; Created on 24 August 2011