Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 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 around the web. This one has two sections, the first part capitalizes any letter after a non-alpha letter. The...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 used as just putting the file name did not work). Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality but nothing...

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

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

03 November 2014 A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still build this over the previous...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Mon, 18th Jul 2011 1.6.4- Added Joomla! Admin Option: Module Content Caching - Added Joomla! Admin Option: Include content based on User Level - Added Joomla! Admin Option: Include Category IDs - Added Joomla! Admin Option: Exclude Category IDs - Added...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• 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 recommended practice, I'm moving these guys first so all -- the objects from the existing site will retain their ownership. Based -- on previous migrations, this tends to help not confuse the system. --...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 from the HTML file launching this function (not from the if external JS)) // add parameters to this function to specify rows based on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array =...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and designing on a per-app basis so I wanted a standard way of doing it and...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 outside) 1. Item 1 1.1 Item 1a 1.2 Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter;...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in...

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

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

23 June 2021 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 and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as...

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

Zoho CRM & Zoho Books: Get SalesPersonshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so trying to get the...

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

ZohoCRM: Deluge: Map a custom field from user profilehttps://www.joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

01 September 2021 A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity record...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 // // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { // get contact record from...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we considered beforehand which still didn't fit the...

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