SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying...

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

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

05 September 2013 Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if you need to convert them back later (eg. 034, 039). Do NOT allow any punctuation you don't use in your site structure. Slashes and underscores /_...

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

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

11 November 2013 types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown...

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

Call to a member function mark() on a non-object in Joomla CMShttp://mail.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 Excluding the HOME folder - only check the subfolders. If they are, you've lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected in our case and could be left as they...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun). The Apple...

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

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

05 December 2013 morning and afternoon slots. All days and time slots must be listed irrespective of whether any time has been associated to them. We need to be able to specify any date, and the system returns the timesheet for the week that date occurs in. How? The...

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

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 to work here, work pretends to pay me." Joke2:="He sets low personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He has two brain cells, one is lost the other...

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

DJI Phantom FC40 - Fun at the raceshttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 next time if the wind allows. Do NOT break Line-of-Sight (LoS) for any participants Not distract the drivers or fly between them and their vehicle. Avoid flying over track Especially if there is a vehicle underneath... Um, so I'm sharing the marshall's...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 any equipment, photo or detail to change it. I have pre-loaded it with my own Quadcopter's details but feel free to change them to match your configuration. Tap on a photo to change it's picture. Tap on equipment photo to change its weight. (A future...

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

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

31 October 2014 using a different key The Play store will tell you there's a mismatch on the SHA1 fingerprints used and will display both of them to you. Using the keytool you can reverse engineer this and work out which certificates were used for which APK listed in...

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

Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 alias "about" and "about-us": Login to the Joomla Admin Panel and ensure any similar menu items are accounted for. Remove them if they are not used. Create the menu item that caused the warning but give it a temporary alias (eg. for "about" give it the...

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

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

31 October 2018 using a Service Account (unattended). 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...

• 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 in explorer (much like MacOS). You can then create shortcuts from these and more importantly see the command to open them. Note that the MS Windows 10 Mail shortcut will be something like target:...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its...

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

Windows 10: Shortcut Apps to Settingshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice. Why? I needed a command that can be run from the command-line in an AutoHotkey app to open the...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 This is an article to show you how to use triggers but also how to stop them. We only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord or updateRecord. Why? We had a Creator app updating...

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

Zoho CRM: Standard Setup for Tax Rateshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the applicable tax rates: Browse to a CRM product record (you can do mass edit on a listview of products but for demo...

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

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

19 September 2021 this article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied and pasted for each field, especially if they're...

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

Zoho CRM: Get Unique Values of a Text Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, { "Currency": "EUR", "id": "123456789000000002" }, { "Currency":...

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs around the world. US (Except Arizona,...

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