Search - Joel Lipman .Com

1. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
2. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side ...; Created on 13 February 2023
3. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Type Type the parameters you want as default Press /settings Settings will default some settings although, again, I wouldn't recommend these if you're just starting off. Leaving these on ...; Created on 11 February 2023
4. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...; Created on 19 October 2022
5. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream ...; Created on 12 March 2022
6. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... to change by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies ...; Created on 07 October 2021
7. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
8. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... for this and although there are some solutions that deal with loading UTF16 content into SimpleXMLElement or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL resul ...; Created on 28 March 2015
9. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." ...; Created on 13 June 2014
10. SSIS Convert a string into a date: / SQL Server Integration Services /; ... + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) ...; Created on 14 March 2013
11. Basic Joomla 2.5 Mootools Form: / Joomla /; ... your webpage that this form will be on). Does not use JQuery - Although most of the sites I work for use JQuery as well as MooTools, I needed this for a component that I was building and only wanted ...; Created on 20 August 2012
12. Convert seconds to total time in PHP: / Personal Home Page /; What? This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know ...; Created on 31 January 2012
13. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... enough and always saying 0 seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many ...; Created on 17 November 2011
14. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. ...; Created on 26 October 2011
15. Migrate Joomla Users to WordPress: / Wordpress /; ... do for passwords Joomla: MD5( password + salt ) Wordpress: MD5( password ) _ Salt Although one way, is it possible to extract the md5 of the Joomla password and process using wordpress script ...; Created on 03 October 2011
16. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... with CHAR(10) and although it displayed and printed properly, when saving as a PDF, CHAR(13) would return weird question mark symbols instead. Bonus All rows with this would be about 3 lines of ...; Created on 30 September 2011
17. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile ...; Created on 29 March 2011
18. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; ... a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away ...; Created on 22 October 2010
19. Invalid arguments passed in router.php on line 325: / Joomla /; ... writing a component, then ask yourself if you really need the router.php file. Mine was generated by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although ...; Created on 03 August 2010
20. Windows 7: System Clock is constantly going out of sync: / Windows OS /; The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and ...; Created on 28 January 2010