Zoho Deluge: Zoho Bookings Get Available Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

23 June 2021 This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration...

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

T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different,...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 a computer or modifying a private copy. Propagation includes copying, distribution (with or without modification), making available to the public, and in some countries other activities as well. To “convey” a work means any kind of propagation that...

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

View your available module positionshttps://joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 Update for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You...

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

SITS: XET format for Export not availablehttps://joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to...

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 It is the port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used. Multiple servers Use this to connect to a server in a replicated server configuration...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter...

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

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

30 May 2009 The term 'Joel Lipman .Com', 'I', 'myself', 'us' or 'we' refers to the owner of the website whose registered office is available to those who contact Joel Lipman .Com. The term 'you' refers to the user or viewer of our website. The use of this website...

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

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 side in "Module Parameters" "Show Quick Modules To" choose - 'non-logged in users only' then scroll down to the list of available modules and find the "ID" number for your "pubmenu" item and then input that number in the "Quick Module ID Include" field....

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 other. -- -- The instructions below uses 2 databases: LIVE and UPGRADE -- -- Do not run this if you only have 1 database available! -- -- References to J15 indicate a Joomla version 1.5.x instance. -- -- References to J30 indicate a Joomla version 1.6.x...

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

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

28 June 2011 a bunch of online websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available...

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

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

29 September 2011 traffic, and therefore is a much 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...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should go through the database and...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. How? Well,...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 to train it on ZohoCRM data with statistics and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be accessed by external...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 PATH="/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users//Library/Python/3.9/bin"' > ~/.zshrc RuntimeError: Numpy is not available: Which Python Whisper Uses head -n 1 $(which whisper) Note the result for the next command, eg....

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against...

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