Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... is incorrect in Zoho Analytics, and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees who may have been paid incorrectly. As such this system has to be reliable ...; Created on 02 July 2024
2. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
3. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. ...; Created on 17 November 2021
4. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... loop through each row for each r_Data in l_FileRows { // initialize record m_Record = Map(); m_Record.put("EmployeeID",""); m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // ...; Created on 26 August 2021
5. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; What? This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee ...; Created on 10 December 2020
6. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... sold by JoelLipman.com. JoelLipman.com agents, representatives and employees are to be held harmless from any and all claims, liabilities, damages, and expenses (including attorneys’ fees actually incurred) ...; Created on 24 October 2014
7. AHK Countdown Tooltip: / AutoHotkey /; ... would get change." Joke6:="The gates are down, the lights are flashing, but the train ain't coming." Joke7:="This employee is depriving a village somewhere of an idiot." Joke8:="Th ...; Created on 17 July 2014
8. Convert to Proper Case in T-SQL: / Transact-SQL /; ... Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in ...; Created on 04 June 2014
9. T-SQL: Parse an XML value: / Transact-SQL /; ... an attribute value SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS INT(4)) AS FinancialYear FROM [dbo].[XML_EVENTS] -- Returns attribute "financialyear" ...; Created on 27 March 2014
10. Split a row into multiple rows based on a column value: / Transact-SQL /; ... has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per ...; Created on 23 August 2013
11. T-SQL concatenate an incremental row number: / Transact-SQL /; What? This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID ...; Created on 24 May 2013
12. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
13. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID ...; Created on 14 May 2013
14. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows ...; Created on 23 April 2013
15. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ...; Created on 27 April 2012
16. Passwords: Did-you-know: / IT Support /; ... network simply drops loads of free nice USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently ...; Created on 15 November 2010