Search - Joel Lipman .Com

1. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to ...; Created on 12 February 2010
2. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
3. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... eg. "fn_Validation_LeadStatusChange", a display name, eg. "Fn - Validation - Lead Status Change", and a description... You will be presented with a deluge IDE editor. I'm putting in the following code: /* ...; Created on 11 February 2022
4. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... "Send 'Intent to receive'" You should get an OK status: Go back into your CRM function and edit the function to do what you need it to (eg. update a contact or invoice), I'm putting what I usually ...; Created on 10 January 2022
5. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings ...; Created on 26 August 2021
6. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Other timewasting activities but good code Putting this code here on this article as it was the path I initially went down. Send mail attachment: creator file upload field value as attached ...; Created on 15 May 2020
7. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download ...; Created on 28 January 2019
8. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... // TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close ...; Created on 28 March 2015
9. Excel: convert degrees minutes seconds to decimal: / Excel /; ... You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1, ...; Created on 06 November 2014
10. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings ...; Created on 18 August 2014
11. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... this means the full path is used as just putting the file name did not work). Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 ...; Created on 13 June 2014
12. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; ... "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors ...; Created on 15 April 2014
13. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... 24 minutes (our working day). // 4 days times 7:30 and 1 day of 7:00 will result in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your ...; Created on 27 April 2012
14. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... but not -- mentioned in the above OUT variables: DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); -- putting a begin within otherwise I get warning errors ...; Created on 19 January 2012
15. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... » Default Values - "Get values from a query" = Select the dataset of dropdown options, pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this ...; Created on 14 December 2011
16. Strip HTML in MySQL: / MySQL /; Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? ...; Created on 06 December 2011
17. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... would be checked at the database level, and returned in a dataset for SSRS to complete the check. Instead of outputting the error code to our end-users, we decided to store the error code in the audit ...; Created on 04 November 2011
18. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname, ...; Created on 24 August 2011
19. Increase Recent Documents Number in Windows XP: / Windows OS /; ... what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name ...; Created on 28 July 2011
20. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... after the report was run. End-Users were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares ...; Created on 19 July 2011