AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 := SelectedDir "\" Loop, % LV_GetCount() { LV_GetText( v_OldFileName, A_Index, 1) LV_GetText( v_NewFileName, A_Index, 2) v_Source := v_FolderPath v_OldFileName v_Target := v_FolderPath v_NewFileName ; MsgBox %v_Source%`rto`r%v_Target% FileMove,...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly? How? It may be that when...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 to a base64 or an SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible...

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

Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 For you to discuss: Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed) ac3filter.cpl Outlook Express msimn Paint...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 it and select "Drop-down List Box Properties" Under "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data Select SharePoint library or list Copy...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no installation/setup (can run off USB). Source files included for you to check. No signups, etc required, have...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 avail. How? The way to change this was: Connect to your Team Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS should...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor T-SQL Source: http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 - Sorna Kumar IF...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by 'c'--you use the following regular expression:...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don't worry about knowing anything about nodejs, as long as you know JavaScript and...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 and my subform is called "Line_Items": // initialize variables //... this is a demo so... do your own... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record...

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

Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 to remind me and to keep reminding me of how to do this. Why? My use-case is that I have a photo in Zoho Creator but the source doesn't really matter as the part I struggled on was uploading it to CRM. I want to update the photo in the CRM record. How?...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- -------------- Joel Google Ads...

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

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookLog = zoho.crm.createRecord("Webhook_Payloads",m_WebhookLog); */...

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