Search - Joel Lipman .Com

1. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify the name field to be an Auto-Number (I'm prefixing mine with CHAT- Add a pick list called ...; Created on 06 March 2023
2. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... r_Delivered; } } } } Error(s) Encountered : Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a package slip for it. The invoic ...; Created on 14 July 2022
3. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip > /full-path-to/backups/my_db/backup_`date +"\%Y-\%m-\%d"`.sql.gz Additional ...; Created on 20 March 2019
4. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
5. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
6. MS Excel - Sort pivottable column headings by date: / Excel /; ... "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded ...; Created on 12 April 2013
7. Search a database with SOUNDEX: / Databases /; ... need to add "COLLATE Latin1_General_CS_AS" after the column this affects. More collations can be found by going to MSDN's SQL Server Collation Name page. Limitations Trailing spaces or prefixing ...; Created on 11 October 2012
8. Connect to Joomla database in standalone script: / Joomla /; ... prefix (may be empty) // Database prefix (if empty then remove prefixing double underscore) $db_prefix = (trim($db_prefix)=="") ? "":$db_prefix; $db_connect = mysqli_connect($db_host,$db_user,$db_pass); ...; Created on 17 August 2012
9. Prefix Line Numbers in a Text File: / MS-DOS /; Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number ...; Created on 18 July 2012
10. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, ...; Created on 19 January 2012
11. SSRS Zero Padding: / SQL Server Reporting Services /; ... & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing ...; Created on 10 November 2011
12. Remove write-protect from USB pen in Windows: / Windows OS /; ... I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and ...; Created on 13 April 2010
13. Creating a Top 10 chart with less code: / Personal Home Page /; ... FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing ...; Created on 18 February 2010