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

28 June 2011 but these can sometimes confuse the program) Rant It's flimsy, crude but does what it has to do. The program itself took only about 6 days to make, it was a quick solution to a service that could not be obtained for free or without a lot of work...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content,...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 report. At least this article should have got you to the part where you're simply specifying what data displays where. It took me 4 days to figure this out then document it. Here's to hoping that this saves you some time!

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Performance Average - Run against a database of circa 30'000 students and their details (incl. courses ~ 700'000 records) took just under 2 minutes (found over 7 million occurrences similar to "DNYA").

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

14 March 2013 Also, my data flow imports two dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long time to figure this and it was only by trawling through columns that someone mentioned that maybe all the data in...

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

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

23 April 2013 line and carriage return symbols!!! Use the Replace(String, "\r", "") and Replace(String, "\n", ""). Feedback This solution took me two days to solve despite following an innumerable number of sites advising but none of them having my issue of rows...

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 new system, the destination wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system. What we have: SELECT EmployeeNo ,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 I'm going to create a dropdown which selects all projects associated with a particular user. Method #1: Important! It took me two days to realize that underscores are not accepted in the type name (despite copying "custom_field.php" and wanting to call...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 management systems which manage my work accurately (eg. my Project Analysis Manager - dubbed PAM - can tell me how long it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

17 September 2014 up with the cars. Keep as much space as possible between our marshall. Not Near People: I could not risk flying low so I took a measure of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I...

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

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

31 October 2014 article below serves as a checklist 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...

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

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

31 October 2018 a script which accesses a Google Drive 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...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing...

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

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

02 February 2019 this one doesn't prompt for a user. Again this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 couldn't find any search result via Google or DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion...

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