"Onvoldoende bronnen om taak te voltooien" - Excel 2010 - Preview pane problem

Submitted by Jochus on Fri, 29/04/2011 - 10:28 | Posted in: Windows
Posted in

From time to time, one of our colleagues was getting this error:


(sorry, this error message is in Dutch, but I think it must be something as "unsufficient resources to complete this task" in English)

We have spent hours searching for this problem. Reinstalling Office, enabling/disabling plugins, Windows safe-mode, etc, etc, ...

We findly found the cause of this stupid error message ...Windows Explorer Preview Pane! This pane provides a quick preview on Excel documents in Windows Explorer. Our colleagues were using this option, but as of very large Excel files, Excel seems to be crashing on this issue.

Conclusion:
It's very import to hide this pane :-)

Changing the time/clock in a Citroen C3 (2006)

Submitted by Jochus on Sun, 24/04/2011 - 20:07 | Posted in: Lifetime
Posted in

My girlfriend always asks me: how to change the clock in my Citroen C3 car?

I must say, the user interface is so complicated, that even with a manual, I still don't succeed to do it myself.

This is the trick;

  • Press Menu
  • Use the up/down button and look for Reg. weergeven - I'm sorry, I have no idea what this is an English car
  • Press OK
  • Use the up/down button and look for Uren (hours) or Minuten (minutes), but do NOT press left/right arrow key or NOT the OK button, as this action will leave the configuration menu
  • Wait 2 seconds, and you will be able to change hours and minutes (separately) by using the left/right arrow keys
  • Press OK to confirm

Happy to have written this down for myself! :-). Hopefully, I can help somebody else with this stupid problem!

Adding DYMO LabelWriter 400 as network printer on DYMO Label 8.3

Submitted by Jochus on Thu, 21/04/2011 - 10:06 | Posted in: Windows
Posted in


So, we have been using the LabelWriter 400 for a long time as network printer in combination of DYMO Label 7.6. But as of version 8.3, we were not able to connect to the network printer. When I installed the latest version, it never asked me where my network printer was (it asked me in the 7.6 version!).

When I started the DYMO Label software, I was getting this error:

This program requires a Dymo Printer. Please reinstall your printer driver.

After clicking OK, the program immediately shutted down, so I was not able to configure a network printer.

The trick is ...

  • browse to the computer which has the LabelWriter shared using Windows Explorer. It's very important to use the Netbios name. Don't use the IP as this will not work! E.g.: \\192.168.1.2\DYMO will not work -- \\SERVER\DYMO will work
  • find your DYMO printer in the list
  • right click on it, and select Connect...

Building Debian (.deb package) APE-server from GIT on Ubuntu Maverick 10.10

Submitted by Jochus on Tue, 08/02/2011 - 12:14 | Posted in: Linux
Posted in

Init build structure

<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp $ sudo aptitude install libmysqlclient-dev debhelper
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp $ mkdir git_ape
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp $ cd git_ape/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape $ mkdir orig
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape $ mkdir deb
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape $ cd deb/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/deb $ git clone git://github.com/sanchi/APE_Server.git 
Initialized empty Git repository in /tmp/git_ape/deb/APE_Server/.git/
remote: Counting objects: 10645, done.
remote: Compressing objects: 100% (4041/4041), done.
remote: Total 10645 (delta 6445), reused 10191 (delta 6269)
Receiving objects: 100% (10645/10645), 21.40 MiB | 3.14 MiB/s, done.
Resolving deltas: 100% (6445/6445), done.
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/deb $ cd ../orig/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig $ git clone git://github.com/APE-Project/APE_Server.git
Initialized empty Git repository in /tmp/git_ape/orig/APE_Server/.git/
remote: Counting objects: 15624, done.
remote: Compressing objects: 100% (5222/5222), done.
remote: Total 15624 (delta 10010), reused 15472 (delta 9900)
Receiving objects: 100% (15624/15624), 24.38 MiB | 181 KiB/s, done.
Resolving deltas: 100% (10010/10010), done.
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig $ cp -R ../deb/APE_Server/pkg/ APE_Server/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig $ cd APE_Server/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ ls -al
total 80
drwxr-xr-x 10 jochen jochen  4096 2011-02-08 12:13 .
drwxr-xr-x  3 jochen jochen  4096 2011-02-08 12:12 ..
-rwxr-xr-x  1 jochen jochen   166 2011-02-08 12:12 AUTHORS
drwxr-xr-x  2 jochen jochen  4096 2011-02-08 12:12 bin
-rwxr-xr-x  1 jochen jochen   817 2011-02-08 12:12 build.sh
-rwxr-xr-x  1 jochen jochen 18009 2011-02-08 12:12 COPYING
drwxr-xr-x  4 jochen jochen  4096 2011-02-08 12:12 deps
drwxr-xr-x  2 jochen jochen  4096 2011-02-08 12:12 doc
drwxr-xr-x  8 jochen jochen  4096 2011-02-08 12:12 .git
-rw-r--r--  1 jochen jochen   694 2011-02-08 12:12 .gitignore
-rw-r--r--  1 jochen jochen   802 2011-02-08 12:12 Makefile
drwxr-xr-x  5 jochen jochen  4096 2011-02-08 12:12 modules
drwxr-xr-x  3 jochen jochen  4096 2011-02-08 12:13 pkg
-rwxr-xr-x  1 jochen jochen    28 2011-02-08 12:12 README
drwxr-xr-x  6 jochen jochen  4096 2011-02-08 12:12 scripts
drwxr-xr-x  2 jochen jochen  4096 2011-02-08 12:12 src

Modify some settings

/bin/ape.conf

10c10
< 	daemon = no
---
> 	daemon = yes
31,32c31,32
< 	modules = ../modules/lib/
< 	modules_conf = ../modules/conf/
---
>       modules = ../../usr/lib/ape/
> 	modules_conf = ../../etc/ape/modules/

/modules/conf/javascript.conf

1c1
< scripts_path = ../scripts/
---
> scripts_path = /usr/lib/ape/scripts/

Build mysac

<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ cd modules/deps/mysac/
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server/modules/deps/mysac $ make
make lib
make[1]: Entering directory `/tmp/git_ape/orig/APE_Server/modules/deps/mysac'
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac.o mysac.c
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac_net.o mysac_net.c
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac_decode_field.o mysac_decode_field.c
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac_decode_row.o mysac_decode_row.c
mysac_decode_row.c: In function ‘mysac_decode_string_row’:
mysac_decode_row.c:277: warning: unused variable ‘error’
mysac_decode_row.c:276: warning: unused variable ‘mem’
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac_encode_values.o mysac_encode_values.c
cc -DBUILDVER=0.4b -I/usr/include/mysql -O0 -g -Wall -fPIC   -c -o mysac_errors.o mysac_errors.c
ar -rcv libmysac.a mysac.o mysac_net.o mysac_decode_field.o mysac_decode_row.o mysac_encode_values.o mysac_errors.o
a - mysac.o
a - mysac_net.o
a - mysac_decode_field.o
a - mysac_decode_row.o
a - mysac_encode_values.o
a - mysac_errors.o
make[1]: Leaving directory `/tmp/git_ape/orig/APE_Server/modules/deps/mysac'

Build APE server

<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ ./build.sh 

Build Debian package

<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ ln -s pkg/debian .
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ dpkg-buildpackage -rfakeroot -us -uc 
 
<a href="mailto:jochen@DESKTOP">jochen@DESKTOP</a>-JOCHEN /tmp/git_ape/orig/APE_Server $ ls -al ../
total 33076
drwxr-xr-x  3 jochen jochen     4096 2011-02-08 12:33 .
drwxr-xr-x  4 jochen jochen     4096 2011-02-08 12:09 ..
-rw-r--r--  1 jochen jochen      488 2011-02-08 12:31 aped_1.0-54-g2a021e2.dsc
-rw-r--r--  1 jochen jochen     1222 2011-02-08 12:33 aped_1.0-54-g2a021e2_i386.changes
-rw-r--r--  1 jochen jochen  3097124 2011-02-08 12:33 aped_1.0-54-g2a021e2_i386.deb
-rw-r--r--  1 jochen jochen 30704934 2011-02-08 12:31 aped_1.0-54-g2a021e2.tar.gz
drwxr-xr-x 10 jochen jochen     4096 2011-02-08 12:32 APE_Server