Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 // yields my_real_textual_data Additional Since writing this article I found a Zoho page with some other pretty useful regular expressions at https://zoholic.blogspot.com/2015/04/some-usefull-regex-in-zoho.html: Convert a string of characters to a list:...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 from the system. Overall, cookies help us provide you with a better website by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 maintain copyright information where credit is due. The scripts and programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 from the system. Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 windows will minimize, simply shake the window again and all the other windows will restore. Aero Snap: One of the most useful features I use in Windows 7, If you click and drag a window up to the top of the screen it will automatically maximise itself....

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is being used...

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

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

05 July 2011 Windows Version (to show which version of windows) winver Windows XP Tour Wizard tourstart Wordpad write Source: 156 Useful Run Commands @ MyPCHell.com

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 JavaScript is not the primary aim of this tutorial, but it will prove valuable because you should be able to find plenty of useful JavaScript examples online. This will be helpful because in my opinion, the simplest way to start using COM is to learn...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the...

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

Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 = preg_replace( '/[a-z_ -]+\ \(/i','$0', $string_original); Anymore? Please leave a comment if I've missed some useful ones out.

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

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable country by IP...

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

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef -------------------------------- 001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create a...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 from a template and depending on if you are using MS Internet Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my...

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

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

23 February 2014 (equivalent to /COPY:DATS). /COPYALL :: COPY ALL file info (equivalent to /COPY:DATSOU). /NOCOPY :: COPY NO file info (useful with /PURGE). /SECFIX :: FIX file SECurity on all files, even skipped files. /TIMFIX :: FIX file TIMes on all files, even...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Format" for the format name Under Exchange type select "XML Exchange". Store/Save Testing: Monitoring the monitors Some useful tools: Stu-Talk Monitor Details (SMD): The SITS application audit giving details on each process. Stu-Talk Monitor Process...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 here is to specify the date/time format: On the Review screen it tells you how many fields were mapped. Amazing but not as useful as it is interesting: Then you're into the penultimate step of the migration where you watch another but different progress...

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