Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 -1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and...

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

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

19 July 2011 "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available...

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a)...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

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

12 September 2015 (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note on its contents or embedded code specific to the template. Copy over Users:...

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

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

02 February 2019 Applies to: Google Drive REST API v3 Google OAuth 2.0 v4 Google Cloud Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each section of the code to go through the logic and highlight any changes you may need to make. 1. First: the...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the...

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

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

15 May 2020 in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. How? So the trick is, go...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• 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 so that I can easily create a stylesheet and javascript file specific to this app: Adding third-party frameworks: I’m going to use my favorite third-party extensions (Bootstrap & jQuery) which I’m referring to over the web (Content Delivery Network –...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes")....

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 such as position: absolute. Because I'm doing this inline and via code, Zoho automatically removes these. So instead, I am going to use negative/positive margins to move the tabs group up/down along with the form wrapper (so all the form is below the...

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

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

25 January 2022 when editing the template, they couldn't put the cursor in there or even delete the box the address was in. How? So you're going to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other...

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

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

16 January 2023 while as our own documentation is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv"...

• 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 number of pages as well as the number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query:...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 map with the ID removed back into a list. The map itself was null. How? We are using an API action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color...

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