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 googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Hopefully the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open......

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Affinity phpBB3 template (rt_affinity_phpbb3.zip) [ the template we're using in this example ] Install phpBB3: Hopefully you already have a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release....

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak below will stop any of your pages submitting content containing your...

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

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 find that the Rokdownloads manager would not list any of my files!?! I am in the middle of writing a component that will hopefully comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this will save you time. I spent a whole morning following someone else's complicated connection using SQL Server...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 only makes a request when you enable it to refresh all thumbnails (and login as admin). If you have a million links then hopefully, you can switch to each service as it becomes available and do them all for FREE!

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 environment that will be released for public use. This allows for a good test bed and stable releases, error and hopefully risk-free. How? Here's one method I used based on the services available to my client: Copy all files of your main website to...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 // sends index.php?myFolder=blog/videos/2010/january&myFiles=21 Which, hopefully, the PHP file will handle as: var $site_structure_string = $_GET['myFolder']; $site_structure_string = preg_replace('/[^a-zA-Z0-9_\\/]/', '', $site_structure_string); var...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the Google APIs...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 + v_BooksOrgID; // saw this in the documentation example so will hopefully do what it says m_ShippingAddress.put("is_one_off_address",true); m_ShippingAddress.put("is_update_customer",false); // send the request via API (change connection name to your...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 // // with a reminder 10 minutes before m_ScheduleCall.put("Reminder","10 mins"); // not sure if this does anything. hopefully notifies the staff user m_ScheduleCall.put("send_notification",true); r_ScheduleCall = zoho.crm.createRecord("Calls",...

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

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 links and icons by running the program, right-clicking on the icon in the system tray and select "Edit Configuration...". Hopefully this will be of some use to you. Unduplicater v1.1 is a basic tool to compare two folders and remove duplicates (ignoring...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 all the packages and then making them suitable for our new SQL Server 2012 instances. How? This applies to a workstation (hopefully you're not doing development directly on the server). I re-installed sql server setup, re-ran the repair to no avail. A...

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