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

28 September 2009 Call to a member function acl_get() on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this seems to be related to some Virtuemart modules we had installed (well all virtuemart modules)......

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 the SWF files are by your server. We changed ours to 20Mb to accommodate for 5 minute SWF videos... If the screen just goes blank when you've uploaded a file, then you'll need to debug. Put the following code at the beginning of your LocalSettings.php...

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

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 DaysInMonth, `, DaysInThisMonth:=DaysPerMonth%ThisMonthNum% ; get the first day-of-week of this month FormatTime, firstDayBlankNum, %A_YYYY%%A_MM%1, WDay ; add blank spaces in front of this first day dateToDisplay:=1 If (firstDayBlankNum

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Select 'Dataset Properties' Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name]...

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

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 So I should end up with the following file/directory structure: ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to...

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

Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 clock) zero padded 01 %k hour (24 hour clock) 13 %H hour (24 hour clock) zero padded 13 %p locale's upper case AM or PM (blank in many locales) PM %P locale's lower case am or pm pm Minutes %M MM minutes 20 Seconds %s seconds since 00:00:00 1970-01-01...

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

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

24 August 2011 Tools > Data Sources (ODBC) > System DSN (get technical help if you don't know how to do this)... Open Excel 2007 > New > "Blank" Connect to data source: > Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: >...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in the database @SearchStr -- Provide the search string. Use the '%' to coin the...

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 "VisualStudio2010" "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" for Start In..., I leave this blank but you could specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 SUCCESSFUL Transform: Column: {0} - Value Before: {1} - Value After: {2}", x, inputValue, outputValue); debugString = ""; // blanking because I only need to know when it fails // set input value to transformed value...

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

Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more....

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

SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 Note this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows with neither sequence nor student reference will not come through the system. Lookups that failed will...

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

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

25 November 2014 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 example (as I...

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

Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 main marker (HQ?) Set the HTML InfoWindow content (the popup of the marker) Swith the appropriate Overrides to "Yes" Leave blank what you don't want to change. Style away! More Information Google Developers: Adding a Google Map

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 messages you could get the "Notify" page to read from a form/report: Click on the plus icon to create a new form Select a blank form, let's call it "Notifications". Drag a single-line field and a multi-line field onto the form called "Title" and...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 it keeps spinning and doesn't stop. The app page will ultimately timeout and when reloading the form it simply displays a blank page. Their only workaround is wait about 30 seconds or more for the loop to automatically cut out and then they can use the...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 { v_CustomerTimeZone = r_TimeZone.get("display_value"); break; } } } } } } // // if not blank then we found the correct timezone picklist option if(v_CustomerTimeZone != "") { m_UpdateLead.put("Customer_s_Timezone",v_CustomerTimeZone); } // // if not...

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

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

10 January 2022 // Parse body of Xero webhook and update respective CRM record // m_Body = ifnull(m_Payload.get("body"),m_Blank); // // check if events was in the payload if(!isnull(m_Body.get("events"))) { // // parse events out of the webhook (a list) l_Events =...

• 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://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 } } // // return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel"); if(l_Disallowed.contains("")) { info "Yay"; }...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 it an API version (eg. "2022-01" - or whichever is the latest stable version) Location ID if you know it, otherwise leave blank (eg. "123456789") Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to the...

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