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 do ...; Created on 12 February 2010
2. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = v_RelatedListXML + "No records found"; v_RelatedListXML = v_RelatedListXML + ""; } // // output return v_RelatedListXML; in Zoho Books // // find all related quotes l_DataRows = List(); v_QuoteRefID ...; Created on 30 July 2021
3. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... no error if not: To return an error (I know we set the function to return "Map" and are using a "Collection" but a Collection is either a list or a map): // return response as error popup v_OutputMessage ...; Created on 10 December 2020
4. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... = "https://books.zoho.eu/api/v3"; // // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails = zoho.books.getRecordsByID("Salesorders",v_BooksOrgID,v_BooksSoID.toString()); for ...; Created on 15 May 2020
5. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
6. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ...; Created on 07 January 2020
7. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... v_Center:= v_x1 a_MyArray[1,0] := v_x1 a_MyArray[1,1] := v_y1 a_MyArray[1,2] := v_x2 a_MyArray[1,3] := v_y2 } } ; output ...; Created on 18 July 2019
8. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... Joe Remove block comments: v_MyRegEx = "(\/\*([^*]|(\*+[^*\/]))*\*+\/)"; v_MyString = "String to output: /* this is a comment */"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); // ...; Created on 31 May 2019
9. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function getTimeAgo($p_Date) { ...; Created on 16 May 2019
10. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... generateRetrievalCode() { // init v_Output = ""; l_Output = List:String(); l_Alphabet = ; v_StrLength = 5; // everyday I'm shufflin l_OutputShuffled = List(); ...; Created on 09 May 2019
11. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore ...; Created on 06 May 2019
12. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... floating over it at the center of the page as well as a logo fixed to the header of every page. The logo image was quite a big image at 2501x805 pixels. By resizing it to the final output size (464x99 ...; Created on 22 February 2019
13. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two ...; Created on 11 February 2019
14. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... arrays. I can also output any of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify ...; Created on 02 February 2019
15. 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
16. Zoho Deluge: Loop through List: / Zoho /; ... returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which populates as: 08:00, 08:30, 09:00, 09:30 ... 19:30, 20:00. ...; Created on 30 November 2018
17. Zoho Deluge - Get English Ordinal: / Zoho /; ... method 2 & 3, we can reduce getting the ordinal to 2 lines plus the output: // Type Here v_NextRenewalDate = '2018-11-06'; v_ThisDayDate = v_NextRenewalDate.toString("d").toLong(); v_ThisDayDateLastChar ...; Created on 08 November 2018
18. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... = storeCredentials($STORE_PATH, $credentials); return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials ...; Created on 31 October 2018
19. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output = $response; } // close ...; Created on 29 October 2018
20. Accessing Apimo WebService API: / API Miscellaneous /; ... ID $company_id_1_agency_id = ''; $company_id_1_brand_id = ''; // specify target url and version $apimo_url = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method ...; Created on 29 March 2016