Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 The equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but as you may know, Oracle has a funny way of working...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on the workstation, they error incessantly and...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ using System; using...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 of this app is expected to hold a lot more. Hangar Tip: Both the free and paid version of this app are being developed to write to a mounted external SD card so they can share data but for the time being they are on the internal storage (like most...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 but as I couldn't find anything using Google regarding these errors or how to set up a basic ping request, I thought I'd write this article. How? Using PHP and cURL, here is the full script for a standard ping request. Before you say it doesn't work, it...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 actual editing of the feed would be done on the respective social network's site. How: This simply displays the feed... (no write back) Facebook Replace https://www.facebook.com/myfacebookpage with your facebook URL and replace My Facebook Page with the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 example does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords()...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You should...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 webhook. One alternative that is proposed below is that we are going to use a CRM REST API function which arguably could write directly to the Creator record, parsing the JSON webhook response beforehand. 1. Set up the Creator form Log-in to your Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already been...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 is an article for training purposes. I'm pretty sure there is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 and ask them to enable it once you've run the above function. For me, I didn't have this patience and find it more fun to write another function that will generate the Auth'n'auth token. Here is a reminder on what my Zoho Creator form looks like for API...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *