How to use download managers with Google Chromehttps://joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 Apparently everyone knows how to download FLV videos from web addresses which use the Youtube syntax: http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my...

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

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently this has a 9 in 10 chance of working. Possibly the most notable in 2008 being the US Pentagon.

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 your Internet connection was free as well :c) Question Why would I want preview screenshots of sites I link to? Answer: Apparently it's big business but I fail to see why any business specialising in website thumbnail generator services, puts all its...

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

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

19 July 2011 Parameters!StudentReference.Value, First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note:...

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

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

19 September 2011 of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Can apparently be solved by adding this to the top of your web.config file. Searches that got me nowhere ssrs check if file exists ssrs...

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

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

23 April 2013 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 column numbers. My solution below will also fix this. How?...

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

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when viewing a table structure... Though maybe this is derived from a template and depending on if you are using MS Internet...

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

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

31 October 2014 but here are some red herrings I found when debugging this issue: Download from the Play Store: The google maps api will apparently NOT work if you downloaded the APK from another location. This wasn't the issue, once I had the right SHA1 registered in...

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

Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand, apparently if(hasSystemFeature(PackageManager.FEATURE_CAMERA)) is a way to go. I haven't tested yet as I need a tablet/phone that...

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

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

17 March 2020 month. How? First you have to get all the applicable fields from the settings API. In API v2, you have to do it this way apparently. So setup a Zoho Oauth connector (see the end of this article if you don't know how), I'm going to call mine...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 download_Url value and prepend the CRM base URL such as https://crm.zoho.com + v_download_Url... But that is incorrect, apparently you have to treat the field of type "File Upload" as an attachment despite it not being an attachment (or at least not...

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

Xero API: Send Multiple Invoiceshttps://joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

15 August 2021 schedule created 7 Zoho invoices but only 5 Xero invoices). Our solution: Send all Zoho invoices in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" and...

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

Zoho Deluge: Generate a loop or list of any sizehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: we'll generate the CSV rows and then a file; then we'll use invokeURL to...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 function querying tags on a contact record which needed to be copied to a deal record. I wanted to copy over the tag but apparently, the ID of the tag is not allowed to be copied over. The official documentation says to use remove() to remove a key from...

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