Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 Gui, Add, Edit, x45 y40 w520 r1 vSearchTextInput Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use...

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

Security Checklistshttps://joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6. Turn Register Globals Emulation OFF 7. Check for extension vulnerabilities 8. Remove junk files Source:...

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

Pancakeshttps://joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 the pan, using a wodge of kitchen paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're using the correct amount of batter. I find 2...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 report to the server, configure the web application to use the newly uploaded report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The...

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 :: CREATE directory tree and zero-length files only. /FAT :: create destination files using 8.3 FAT file names only. /256 :: turn off very long path (> 256 characters) support. /MON:n :: MONitor source; run again when more than n changes seen. /MOT:m ::...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 JComments: This will be a copy of 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 be done as the last step of this...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 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 very different to my code for OAuth when attended: Google...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttps://joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 how to configure triggers when using createRecord or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the...

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

Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How?...

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

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

15 July 2021 = zoho.creator.createRecord("my_owner","my_app","Shopify_Webhook_Payloads",m_CreateRecord,m_Blank,"joels_creator"); // // return Zoho response to Shopify return {"crmAPIResponse":m_Response}; Save the function Return to the functions list and hover your...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained...

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

Zoho Creator: Receive eBay Notification and Create Shopify Orderhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-notification-and-create-shopify-order.html

21 January 2022 is to have an eBay notification be sent to Zoho CRM (can receive webhooks) which forwards it to Zoho Creator, which in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want...

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