Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

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

List MediaWiki Articleshttp://mail.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 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, Category...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 AS VARCHAR(30)))), 1, LEN(@OrigVal)); END ELSE BEGIN -- Loop through the characters passed WHILE @LoopCt

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the structure and data. Thinking inside of the box I think everyone suggests the following (or at least the idea...

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

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 $_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj = $result->fetch_object()){ $content_count = $obj->ArticleCount; } } } echo $content_count; mysqli_free_result( $db_connect ); Clear as mud? Feel free to use...

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

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter =...

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

Stored Procedure to List Distinct Values and Countshttp://mail.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ',...

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

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' + @TableToProcess + ''',...

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

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

20 November 2012 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 would...

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

DataTumble - Randomize Data Rowshttp://mail.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()* CONVERT(VARCHAR(MAX),@NumberLeft) ) SELECT @ChosenID =...

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

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 1, LEN(@OrigVal)); END ELSE BEGIN IF ISNUMERIC(@OrigVal)=1 BEGIN SET @NewVal = ''; -- Loop through the characters passed WHILE @LoopCt

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

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

04 October 2013 TextInfo textInfo = cultureInfo.TextInfo; if (!buffer.EndOfRowset) { // loop through each row while (buffer.NextRow()) { rowCount++; // loop through each column for (int x = 0; x...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings > General > Software > Update option) Right-click on your...

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

T-SQL: Parse an XML valuehttp://mail.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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttp://mail.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 null, "rss"); String title = null; String link = null; String date = null; String desc = null; List items = new ArrayList(); while (parser.next() != XmlPullParser.END_DOCUMENT) { if (parser.getEventType() != XmlPullParser.START_TAG) { continue; } String...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 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 allowed...

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

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

13 April 2015 access to the Google Map API v3 in JavaScript is a doddle... And incredible fun! I've added the options to style the map while trying to keep it simple enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made...

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

Windows Live Mail Error ID: 0x8DE00005http://mail.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 complete as per the image below (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find empty folders. Doing a 'send/receive' will bring up the dialog showing its progress. Source:...

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

Zoho Deluge: Loop through 30 Minute Slotshttp://mail.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: *