Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 to increase advertising revenue or as a form of parody/social criticism. initialism An initialism is a phrase or multi-word name that has been abbreviated to the first letter of each word, and is pronounced as a series of individual letters. For example...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 been renamed). Save the SQL file, this is now unique to your website and this process. It does not contain usernames or passwords but has the real database names and all website content, so do not redistribute without taking security measures. Run the...

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

URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rs:Format=XML Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0 So to export to PDF in landscape...

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

Checklist for the local computer repairshttps://joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 Can you print from any other applications to that printer? When did you last print successfully? How/where to advertise: Word of mouth Yellow pages Local business directories Local newspapers Local colleges/universities Local community organisations and...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 screenshots taken every second of every day or your affiliates will jump down your throat because they changed the "Welcome" word to "Hello" on their site and with extreme squinting, you can distinguish between the two, then this may not be your...

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

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

05 July 2011 frontpg Microsoft Movie Maker moviemk Microsoft Paint mspaint Microsoft Powerpoint (if installed) powerpnt Microsoft Word (if installed)/td> winword Microsoft Syncronization Tool mobsync Minesweeper Game winmine Mouse Properties control mouse Mouse...

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

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

05 July 2011 Const DT_CENTER = $00000001 Const DT_RIGHT = $00000002 Const DT_VCENTER = $00000004 Const DT_BOTTOM = $00000008 Const DT_WORDBREAK = $00000010 Const DT_SINGLELINE = $00000020 Const DT_EXPANDTABS = $00000040 Const DT_TABSTOP = $00000080 Const DT_NOCLIP =...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left of that column and type the word "TimeStamp". Right-click on the left grey margin of this and select "Insert Row" then "Below". Repeat with all values you...

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

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

08 October 2012 using PHP, I need standalone SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Google Chrome icon in your taskbar Right-click on Google Chrome option in the context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4,...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms....

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

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

21 August 2014 v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an...

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

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 If you are not prompted, you should see some of your code go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 event) { boolean handled = false; if (actionId == EditorInfo.IME_ACTION_GO) { openMap(v); // do function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 Notes: As this was for a client who arranged outdoor activities for kids, I need to add a filter which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { //... refer to above functions } string...

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

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

31 May 2019 World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields Hello World! Remove consecutive duplicate words: // replace consecutive duplicates v_MyString = "Hello Hello Joe"; v_FormattedString = v_MyString.replaceAll(("([A-Za-z]+)...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 parameter with a value in it? Don't. The full code example above will work. Currently this only appears to accept Microsoft Word Documents and Adobe PDF files! Applicable to Zoho Books. If the user attaches text files (TXT) these will only attach to the...

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

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 URL, paste the URL for your CRM REST API function from the steps above. Under Webhook API version I specify the one with the word Latest in the parentheses. Click on Save Let's TEST So wait patiently until you get an order.... just joe-king! In the...

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

ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the days of getting an MS Word document to behave?). Best thing to do if you mess it up, is just start again with a clone of the original erroring template....

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

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

16 January 2023 the Attachments.zip This needs to be a ZIP / compressed file of a folder called "Attachments" (uppercase A and the word Attachments - no other option). The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you...

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