group_concat - MySQL
http://mahmudahsan.wordpress.com/2008/08/27/mysql-the-group_concat-function/This seems like it will be super useful.
If you're using "group by" and you still want to get data out of the grouped rows, then you can use this to combine multiple rows into a single row.
Looping Through Associative Array - PHP
http://stackoverflow.com/questions/1951690/php-how-to-loop-through-a-associative-array-and-get-the-key-nameThis was totally not very intuitive. I was expecting something like this:
foreach($array as $sub) {
echo(key($sub));
}
Instead, it's this:
foreach ($decodedOutput as $key => $value) {
echo $key;
}
Search Directory For String - Linux
grep -rl "search_for_this_string" /var/wwwPHPExcel Convert Excel Serial Date To MM/DD/YY
PHPExcel_Shared_Date::ExcelToPHPObject($value)->format("m/d/y")Easiest Way To Consume .Net Web Services - Python
http://www.jansipke.nl/python-soap-client-with-suds/That article was very helpful for learning to use Python's SUDS library for consuming soap web services.
Here's an example of my simple client:
from suds.client import Client
client = Client("http://xxx.xxx.xxx.xxx/API/Info.asmx?WSDL")
client.service.getInfo("05/12/2013","05/12/2013")
"05/12/2013" and "05/12/2013" are both parameters
New Vocabulary Word
CRUD-Create
-Read
-Update
-Delete
An example of a CRUD application would be something that tracks orders in a database. All 4 actions are going to be necessary to track those orders. CRUD: The basic database operations.
Dynamically Import Data From Other Workbooks - Google Spreadsheet
I made a google spreadsheet which pulls data from two other workbooks using "importRange" and QUERY function. You can use either one if you just want to pull a few columns from another spreadsheet. QUERY provides more flexibility by allowing you to use a SQL statement. Here is an example of a query which pulls 2 columns from another workbook and filters out the blank rows in column 41:=QUERY(importRange("yourSpreadsheetKeyHere", "Donations!A3:BB200000"), "select Col41, Col2 WHERE Col41!='' ", 1)
One of the biggest pains during the entire process was google spreadsheet's vlookup. I learned the vlookup function only searches for a value in the first column in the Array. It's also helpful if you format the results of your vlookup as "Plain Text" under the numbers format drop-down. Of course, something formatted as a number won't match something formatted as plain text.
You could use this technique if you have a list of customer id's with names, and a separate spreadsheet with more customer information. With this, you could combine that information.
Javascript Excel Parser
http://niggler.github.io/js-xlsx/That's an impressive project that allows parsing excel files in the browser.
Green Mountain Energy's B2B Site
Green Mountain Energy has the worst B2B portal I’ve seen in my life. The worst parts:
- It only works in IE (barely, and switching between browser versions in the F12 menu doesn’t help)
- The page only takes up ~30% of the browser window (see the picture)
- Nothing is functional, I can’t change my automated billing agreement because there’s no submit button.
- If you have more than one address on your account, just give up.
Picture: http://i.imgur.com/cP4CLTl.png
Update: They sent a letter saying they made a new business portal site. www.businessportal.greenmountain.com My first visit gives me an “Our site is currently down as we upgrade our systems.” error message.
