Search - Joel Lipman .Com

21. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... Required! ZohoCRM.modules.. or ZohoCRM.modules.all Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2. Determine the client datacenter Look at ...; Created on 28 August 2020
22. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... should have something like the following: Click on "Create and Connect" You will get a popup confirming what this app will access and you should click on "Accept": A quick popup will appear ...; Created on 12 August 2020
23. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... it "myconnector". Ensure that as a minimum, the scope ZohoBooks.salesorders.CREATE is ticked. Click on "Authorize" Read the notice saying Creator would like access to bla bla bla and click on "Accept" ...; Created on 15 May 2020
24. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... Tick the applicable Scope(s): for example: "ZohoCRM.settings.fields.READ" Click on "Create" and then on "Accept" in the popup. You should be redirected to a page which lists the "status" as connecte ...; Created on 17 March 2020
25. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts ...; Created on 16 May 2019
26. GDPR Privacy Policy: / Static Items /; ... MYCOMPANY and its associates provide their services to you subject to the following conditions. If you visit or shop within this website, you accept these conditions. Please read them carefully. PRIVACY Please ...; Created on 14 February 2019
27. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...; Created on 11 February 2019
28. 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
29. Accessing Apimo WebService API: / API Miscellaneous /; ... file_get_contents. Just storing this in case. // cURL With SSL via method GET: FAIL $header = array( "Content-Type: text/xml;charset=UTF-8", "Accept: gzip,deflate", "User-Agent: WWPC uAPI Test", "Cache-Control: ...; Created on 29 March 2016
30. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" ...; Created on 25 January 2016
31. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP ...; Created on 24 September 2015
32. 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
33. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string ...; Created on 28 March 2015
34. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
35. Android: Replace return key with done, go, send...: / AndroidOS /; ... a "go" operation to take the user to the target of the text they typed. IME_ACTION_NEXT // the action key performs a "next" operation, taking the user to the next field that will accept text. IME_ACTION_NONE ...; Created on 03 November 2014
36. XML Schema Reference: / Extensible Markup Language /; ... for Datatypes Constraint Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater ...; Created on 13 August 2014
37. Client Services: Website Development Agreement: / Static Items /; ... based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available ...; Created on 15 November 2013
38. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... Method #1: Important! It took me two days to realize that underscores are not accepted in the type name (despite copying "custom_field.php" and wanting to call my type "user_projects")!!! My recommendation ...; Created on 25 October 2013
39. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... int outputColumnIndex, string name, string description) { throw new Exception(string.Format("Outputs cannot be added. The component only accepts inputs", ComponentMetaData.Name), ...; Created on 04 October 2013
40. Basic Oracle Function Structure: / Oracle PL/SQL /; ... I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as ...; Created on 15 January 2012