Sometimes such a simple thing makes the difference when you’re staring at a lot of data in Excel. I always set this just in case I’ve got some duplicate records that were missed on a data dump.
You output 5000 rows of data into Excel for a client to review and need to make them all HREFs. The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article. We have this: ArticleID URL 456 And… Continue reading Automatically create a URL/HREF in an Excel field
http://www.princexml.com/ http://html2pdf.fr/en/default http://sourceforge.net/projects/phphtml2pdf/ https://docraptor.com http://www.pdfreactor.com/ http://wkhtmltopdf.org/
Quick reference: For Schemas: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “schemaname”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = “schemaname” AND T.table_name = “tablename”; For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` C WHERE table_schema = “schemaname” AND table_name = “tablename” AND column_name = “columnname”; Thanks, as… Continue reading View MySQL Char Set encoding for your database
Here are a few of my selection criteria for using WordPress Plugins for myself and for clients. You may occasionally see strange things on this site as I frequently test plugins and themes. What is the latest version of WordPress it supports? Does it have market penetration? Is it consistently updated? How long has it… Continue reading WordPress Plugin Selection Criteria
Google Chrome is great for easily managing credentials for the various sights you visit. For convenience, these passwords are stored in local file that you access through Chrome itself. Copy & Paste this into your Chrome URI: chrome://settings/passwords You will see a list of credentials which you can search. To view the password, click on the… Continue reading Retrieving website credentials stored by Chrome password manager
Looking for a handy list of Linux monitoring tools? Go here: http://www.tecmint.com/command-line-tools-to-monitor-linux-performance/ This looks really good: http://www.tecmint.com/monitorix-a-lightweight-system-and-network-monitoring-tool-for-linux/
While developing a fairly list heavy website using Drupal 7 we reached a point where the common AJAX interface was breaking with an unknown error. The error suggested it was the AJAX function itself that it was breaking. Foolishly, we spent untold hours trying different version of JQUERY and looking into client side code to… Continue reading Drupal, AJAX, PHP and max_input_vars
There can be many reasons a 404 error is generated when combining Windows, IIS, PHP, and WordPress. Many of you/us out there use our Windows machines exclusively for a variety of reasons ( most often because gaming is where it’s at on Windows and consoles are for the strange). Because of this, we also develop on these… Continue reading WordPress on IIS 7.x 404 Error
I love this kind of stuff. Find your region and zoom in. Go here if you want to add it to your site.