.xlsm Internet Explorer

2011-06-08 by xpheas

My "favorite Browser" doesn't download the new Office extensions (open XML file format) correctly. Internet Explorer is turning them into ZIP files.

If you use an Apache Webserver you can fix that issue by adding the following mime-types into your .htaccess

BASH-Code:

AddType application/vnd.ms-word.document.macroEnabled.12 .docm
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx
AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm
AddType application/vnd.openxmlformats-officedocument.presentationml.template potx
AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam
AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm
AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx
AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm
AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx
AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam
AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb
AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx
AddType application/vnd.ms-excel.template.macroEnabled.12 xltm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx

» comments (0)

Firefox 4 - save tabs on close

2011-05-04 by xpheas

Firefox 3.6 ask if you want to save your session if you have multiple tabs open and close the browser. For some reason Firefox 4 doesen't. I fixed the issue by changing the value of browser.showQuitWarning from false to true in about:config

» comments (0)

MySQL FROM_UNIXTIME() with negative timestamp

2011-04-01 by xpheas

The MySQL FROM_UNIXTIME() function does not support negative epoch timestamps, it returns NULL.

I used the DATE_ADD function to work with negative timestamps:

BASH-Code:

`1`	SELECT DATE_ADD(FROM_UNIXTIME(0), INTERVAL <timestamp> SECOND) FROM <table>

» comments (0)

Gimp save all layers

2011-01-06 by xpheas

I needed to export multipe layers to separate JPG files. Gimp does not support that by default but i found a nice script that can export each layer.

Download the script

Source: http://flashingtwelve.brickfilms.com/GIMP/Scripts/sg-save-all-layers.scm

» comments (0)

Aptana FTP show hidden (dot) files

2010-09-24 by xpheas

The . files are filtered by default. To make them visible, use the drop-down arrow on the File view toolbar, select "Customize View", and then uncheck Filters->. files.

aptana hidden files 1

» comments (4)

I love Free Software

2010-02-14 by xpheas

» comments (0)

How to cancel XING

2010-02-07 by xpheas

XING is not supported by the suicide machine. If you want to cancel your membership login to XING and use the following link:
https://www.xing.com/app/user?op=cancel

Cheers!

» comments (1)

Social Suicide

2009-12-22 by xpheas

You want your actual life back?

Wanna meet your real neighbours again?

You can do it. It's so easy!

suicide machine

» comments (0)

List all MySQL Databases and show their sizes

2009-12-09 by xpheas

BASH-Code:

`1`	mysql -u root -p -e 'SELECT table_schema "Database", ROUND(SUM(data_length + index_length)/1024/1024, 4) "Size (MiB)" from information_schema.tables GROUP BY table_schema;'

BASH-Code:

+--------------------+------------+
| Database           | Size (MiB) |
+--------------------+------------+
| information_schema |     0.0039 | 
| mysql              |     0.5040 | 
| xpheascom          |     8.3756 | 
+--------------------+------------+

» comments (0)