Search - Joel Lipman .Com

1. SQL Server Reporting Services: / Category /; Created on 05 March 2020
2. SQL Server Integration Services: / Category /; Created on 05 March 2020
3. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; What? This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world ...; Created on 31 March 2022
4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
5. Accessing Apimo WebService API: / API Miscellaneous /; Applies to: Apimo Webservice 2.0 (apimo.com) PHP v5.5 What? This is an article on how I connected to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a ...; Created on 29 March 2016
6. Client Services: Website Development Agreement: / Static Items /; ... this month is included in the initial development. Service Transition will happen over the course of 1 month where the client's team should be made available to receive manuals and training on how to ...; Created on 15 November 2013
7. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011
8. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... &rs:Format=PDF&rc:MarginTop=0.1in&rc:MarginRight=0.1in&rc:MarginBottom=0.1in&rc:MarginLeft=0.1in Further rendering options: MS Reporting Services Device Information Settings To specify the zoom ...; Created on 11 February 2011
9. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL ...; Created on 04 February 2011
10. Converting SQL date in PHP to European date format and vice-versa: / Personal Home Page /; ... ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa: $posted_datetime=$_POST['this_datetime']; $posted_datetime_array=explode(" ...; Created on 17 September 2009
11. Google Event Ilustrations aka Flairs: / Google /; ... massage, back rub, backrub, massages newyear: new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, ...; Created on 05 December 2024
12. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
13. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
14. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...; Created on 25 July 2024
15. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the ...; Created on 23 May 2024
16. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; What? A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want ...; Created on 14 March 2024
17. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... / Zoho One / Using Zoho One Zoho Community / Zoho Creator / Application Development Zoho Deluge / Integrations > Pre-defined integrations with Zoho services > Zoho Creator Integration Tasks > Get Record ...; Created on 04 October 2023
18. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
19. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a name, I'm calling mine "ChatGPT CRM" Untick "Use Credentials of Login User" Under ...; Created on 06 March 2023
20. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023