Search - Joel Lipman .Com

1. ZohoCRM: Import Attachments: / Zoho /; What? An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? ...; Created on 16 January 2023
2. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; What? An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow ...; Created on 20 July 2022
3. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... get the information from Shopify and your scripts found further below in this article): Give it a Connection Name (eg. "Shopify API Oauth") Enter the Shop ID (eg. "example-store.myshopify.com") Give ...; Created on 14 February 2022
4. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ; ...; Created on 08 July 2020
5. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... long sentence; let me try this:When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the ...; Created on 06 May 2019
6. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder. Move the Excel file ...; Created on 11 February 2019
7. 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
8. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... you will have completed once copying the below scripts). Let's start with the first PHP file which I will call functions.php. Note that you will need to edit the global vars to be used by the functions ...; Created on 30 January 2019
9. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... and compatibility with future AutoHotkey releases. #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir ...; Created on 28 January 2019
10. Make bootstrap carousel responsive to swipe: / Bootstrap /; ... think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a ...; Created on 14 December 2016
11. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... two systems running JComments version 3.x The MySQL scripts will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should ...; Created on 12 September 2015
12. Submit form as a server and not the client with cURL: / API Miscellaneous /; ... it from here: http://curl.haxx.se/download.html I'm demonstrating this with 3 scripts on the intermediary server: 1. to display the HTML form (usually handled by the mobile app) 2. to send the ...; Created on 20 February 2015
13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which ...; Created on 28 July 2014
14. AHK Countdown Tooltip: / AutoHotkey /; ... running and overwrites this one with a fresh instance of this program SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir ...; Created on 17 July 2014
15. Client Services: Website Development Agreement: / Static Items /; ... scripts which have sped up development on similar projects, I have bespoke project management systems which manage my work accurately (eg. my Project Analysis Manager - dubbed PAM - can tell me how long ...; Created on 15 November 2013
16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft ...; Created on 04 October 2013
17. Joes Syntax Styler (JSS): / Product Documentation /; ... and MooTools) conflicting with other scripts but do I really need a complex solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the ...; Created on 06 April 2013
18. AwStats Data Parser (ADP): / Product Documentation /; ... as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract ...; Created on 03 April 2013
19. Country Lookup by IP address CSV: / MySQL /; ... License.txt: Released under GNU/GPL ReadMe.txt What is it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address, this is what I use. The scripts ...; Created on 17 March 2013
20. Preg_Replace all strings between two tags: / Personal Home Page /; ... shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to ...; Created on 07 February 2013