Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 Data Protection Regulation (GDPR) On May 25, 2018, the European Union's General Data Protection Regulation (GDPR) went into effect across all European Union markets. We believe this presents a new opportunity for marketers to strengthen their brand...

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

View your available module positionshttp://mail.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 url (ie. http://www.yourdomain.com/?tp=1) If this doesn't work for you try this: Log in to the backend of your website (into the Joomla Admin Panel) Go to Extensions > Template Manager > select your template Click on the big Preview button in the top...

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

Keyboard and mouse shortcuts in Google Chromehttp://mail.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 the link in a new tab. Drag a tab out of the tab strip. Opens the tab in a new window. Drag a tab out of the tab strip and into an existing window. Opens the tab in the existing window. Press Esc while dragging a tab. Returns the tab to its orginal...

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

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML and JS file in the...

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

Community Builder in Joomla Vulnerabilityhttp://mail.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more detail as I test each one (11.11.09): administrator/components/com_comprofiler/plugin.class.php variable...

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

Joe's Unduplicater (JUD)http://mail.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 of media files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the files into MP3 format and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check...

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

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

18 May 2010 priority Press "Enter" on the first boot device Select "CDROM" Press "F10" to save and exit the BIOS. Load your ISO or CD into your CDROM Go to "Action" in the menubar and select "Reset..." Additional Information Taming your multiple IE standalones...

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

Joe's CSV Chart Generator (JCG)http://mail.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive...

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

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find...

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

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 marketing. Section 508 Section 508 is an amendment to the United States Workforce Rehabilitation Act of 1973. Signed into law in 1998, this legislation requires that electronic and information technology developed or purchased by the US Federal...

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

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

15 November 2010 client’s network simply drops loads of free nice USB flash drives in the parking 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....

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

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Server. Ensure you name them the same thing as you did in the report. I am looking at ways of doing this without logging into the reporting server or making any changes to it. If anyone knows of a way, please feel free to comment!

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that...

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

What's the problem? Amusing computer issueshttp://mail.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 it a networked printer, I mean is there a cable that directly connects the printer to your computer or does the printer plug into the wall? Ok could you please follow the cable from the computer to the printer and tell me.". "Hang on its on the other...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 Windows Applications. This tutorial is going to be high level, but will provide links to those who want to dig deeper into these concepts. You don't need to have much programming experience, but I will assume you feel comfortable writing and executing...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• 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 need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each...

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

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

05 September 2011 from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field back into "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product...

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

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

19 September 2011 share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to...

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