Month: July 2015

Installing LAMP

Tux and Foss adventures

Install Apache

1. Open up the Terminal.

2. Copy/Paste the following line of code into Terminal and then press enter:

sudo apt-get install apache2

3. The Terminal will then ask you for you’re password, type it and then press enter.

Testing Apache
To make sure everything installed correctly we will now test Apache to ensure it is working properly.

1. Open up any web browser and then enter the following into the web address:


Install PHP

In this part we will install PHP 5.

1. Open up the Terminal.

Step 2. Copy/Paste the following line into Terminal and press enter:
sudo apt-get install php5 libapache2-mod-php5

Step 3. In order for PHP to work and be compatible with Apache we must restart it. Type the following code in Terminal to do this:
sudo /etc/init.d/apache2 restart

Test PHP
To ensure there are no issues with PHP let’s…

View original post 266 more words

Copy/Paste Excel data into SharePoint list

Blog site René van Duren

​I was asked to create a simple list which could be initially filled with data available in a Excel sheet. It was said that this could be done by the good old copy/past routine.

So when had created the content type and the list (based on the content type) I was was ready to copy/paste the data in the list. And guess what…it didn’t work because it said that there were columns that require data but these are not included in the view.

And I was sure that all my columns were not required, they we’re all optional.


So, I started looking around and after a while I found the solution why this error happened to me. To fix this you need to go to your Advanced Settings of your list and set the ‘Allow management of content types‘ to NO.


When you save the settings and return to the previous screen…

View original post 78 more words

Visualizing Your Data With Heat Maps

Work Smarter Not Harder

If you subscribe to these tips, you should already know that people can interpret visual information faster and more easily than text and numbers. Even if you’re dealing with a table of numbers there are ways to present them visually. Depending on your context, charts are often a great option. For those times when seeing all the data and actual numbers is important you might want to consider a heat map.

A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colors.

Fortunately, Excel’s conditional formatting feature makes this super quick and easy. (We love that!)

Let’s take a look at how easy this is by starting with a typical table of Excel data:


To turn this into a heat map, select the range of data and go to the Conditional Formatting button on the Home Ribbon. From there, find the

View original post 127 more words

Ensuring Columns Are Always Present In A Table Returned By Power Query

Chris Webb's BI Blog

Disappearing or renamed columns in your data source can cause all kinds of problems when you’re importing data using Power Query: errors when you try to refresh the query, broken calculations in Power Pivot, PivotTables that reformat themselves and then need to be manually recreated. As a result, it can be a very good idea to build some logic into your Power Query queries that ensures that a table always contains the columns you’re expecting.

Consider the following csv file:


In Power Query, if you connect to it and create a query you’ll end up with something like this:

Let’s assume that this query is called GetSourceData. Let’s also assume that your output from Power Query should always be a table that has the three columns Product, Month and Sales, and that Product and Month should be text columns and Sales should be numeric. The basic steps to take to…

View original post 416 more words

ICD 10 code hierarchy, over-helpful Excel, and

Dane Weber Log

I recently generated the parent-child and ancestor-progeny data for the ICD-10 diagnostic codes. You can find them on the GitHub repo I set up.

While generating the codes was a pretty straightforward matter of =vlookup() and =left(), I discovered only after exporting from Excel 2010 to a tab-separated text format that Excel or Word had converted my ASCII dash (-) and ellipses (…) into special dash (–) and ellipses (…) characters somewhere along the way.

I was using Notepad++ to review the file generated and I decided to determine just what characters existed in the CDC-provided data. I built up the following PCRE regex one piece at a time until I had the exact list (case insensitive):

[^-0-9A-Z trn.,[]/()'%<>=+%]

Of course, upon reflection, I just realized that J has a great way to find the characters:

Right after the command is the result, which starts with a…

View original post 59 more words

Find Content File Spreadsheet

dm_misc: Miscellaneous Documentum Information

Sometime ago I wrote a blog post detailing how to find an object’s content file on the Content Server’s file store using a data ticket.  Recently I had the opportunity to do that a lot.  To make life a little easier, I created an Excel spreadsheet to do the math.  I cleaned up the spreadsheet and made it available for more general use here if your are interested.


View original post

Check File Size & Extension Before Uploading Using jQuery

HTML CSS PHP Tutorials

One of the most common validation which you may need to implement is to check the file size and file extension before upload the file, i made this simple tutorial to validate the image file size (MAX 1 MB)  and file extension, i used here (JPG, JPEG, PNG or GIF) extensions are valid for our image file using jQuery. Submit button will remain disable until valid input is not provided.

Note: Don’t forget to include the jQuery library in the header or footer.





Add the above JavaScript in your footer or header but recommended in footer.

Complete Webpage

Leave your comments if you find this tutorial helpful.

View original post