Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Bug/Issue/Development Request title --- Bug/Issue/Development Request description --- Bug/Issue/Development Request category type (see dropdown options) --- Assigned to developer Name --- Originator/Source (Self, Email, Phone, System) --- Customer Name...

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

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

19 July 2011 table2.studentUsername = :StudentADAccount ) Now searching on the ID parameter ("@StudentReference") still works but when I type a Username ("@StudentADAccount"), it populates only the first dataset with results; the remaining datasets that need to use...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 NULL Windows authenticated username and domain of the person running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the...

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

SSRS External Images don't displayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 as the problem was down to not having a "unattended user account" who could access the images. Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Can...

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

Fun with DllCall in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...

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

Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love automation and...

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "/" + SUBSTRING(This_Date,7,4)) Known Issues [Convert Date [4228]] Error: An error occurred while attempting to perform a type cast. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Convert Date"...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 on the “Overrides” label Click on “New” (but don’t create a new one – we’re just checking something) In the right pane, type “COM_USERS_EMAIL_PASSWORD_RESET_BODY” without the quotes and tick the “Constant” radio box and click on the “Search” button....

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

Export Joomla Users scripthttp://mail.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following...

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

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

03 November 2014 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 the data. I tried replacing the new lines but just...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type: text/javascript');...

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

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

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

02 February 2019 with fewer commands than unsetting specific variables. Let's specify the output page to be in JSON format: // set content type of this page header('Content-Type: application/json'); // init $api = array(); $access_token = ''; 2a. Specify the location of...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 Want to start a built-in app in Windows 10 (not found in your program files etc) like Windows Mail? Open a run command and type: shell:appsfolder This will open your applications in explorer (much like MacOS). You can then create shortcuts from these...

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

Zoho Deluge: Duplicate/Clone a Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 API l_FieldApiNames = List(); r_Fields = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type :GET connection:"myzohoconnector" ]; if(!isnull(r_Fields.get("fields"))) { for each r_Field in r_Fields.get("fields") {...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 Normalize to +HH:MM offset = "+0530"; offset = offset.replaceAll("([+-]\d{2})(:?)(\d{2})", "$1:$3", false); Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date. Source(s) toTime() function | Help...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 below (not the "Name" just the "CNAME" value) Name will be something like .mydomain.com. and www..mydomain.com. TTL = 300 Type = CNAME CNAME = creator.cs.zohohost.com or creator.cs.zohohost.eu depending on the value obtained step 1c above. Add another...

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

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

06 December 2020 first? Well when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what datatype of a parameter I'm sending to the function. So in "Edit this application" > go to Workflow > Functions > New Function: give...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; The receiving PHP script did however understand this hack as: $v_Key = "aaabbbbccccddddeeeeffff11112222"; $v_Secret =...

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