.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:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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

aptana hidden files 2

  » comments (4)

I love Free Software

2010-02-14 by xpheas
I love Free Software!

  » 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
suicide


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:
1
2
3
4
5
6
7
+--------------------+------------+
| Database           | Size (MiB) |
+--------------------+------------+
| information_schema |     0.0039 | 
| mysql              |     0.5040 | 
| xpheascom          |     8.3756 | 
+--------------------+------------+

  » comments (0)

R.I.P. Michael Jackson

2009-06-27 by xpheas


No doubt one of the greatest singers and performers of all time died.

  » comments (0)

 older Posts »