Category: ICT

Informatie -en communicatietechnologie, (web)ontwikkeling, software, …

CSS use EM as a relative font-size, instead of PX

It goes back to Internet Explorer 3.0, but EMs are still the better way to define font-sizes. It takes a small learning curve to get the hang of it, but when it comes to quick changes in overall font-size, this is the way to go. Default font-size for most common browsers is 16 pixels. There are only three articles you need to read to tame that size with relative ems.

1em = 12pt = 16px = 100%

Useful reads

The EM formula

Child pixels / Parent pixels = Size in EM

Not good at calculating? Use the EM calculator

Still targeting Internet Explorer 6?

While Internet Explorer handles EM, it does so only when the base font is set to a percentage!

body { font-size: 62.5%; }
body wrapper { font-size: 1em; }

Audio noise reduction in Adobe Premiere Pro CS5

So you have bought ‘Adobe Premiere Pro CS5: classroom in a book’ and you are searching for a way to remove noise from an audio file? Your frustration might be skyrocketing when you find out on page 256 you need Adobe Soundboouth to do that and you don’t have an Adobe Master Collection license. Don’t despair, you won’t need Soundbooth to do that or any other third party software like Audacity .

Unfortunately, the book doesn’t mention this trivial solution for such a common problem.

Here’s how you can remove noise from an audio clip in Adobe Premiere itself. The benefit of this procedure is that it doesn’t change the audio-file in any way.

– Make sure you have an audio clip on your timeline
– In the effects panel (normally to the left of the timeline), look for ‘DeNoiser’ (Audio Effects 5.1 (or Audio Effects stereo / Audio Effects mono) > DeNoiser)
– Drag and drop this effect onto the audioclip in the timeline
– Double click the audio clip and it will be loaded into the source monitor (by default the ‘monitor’ to the left)
– Go to the effects control tab/panel: you will notice that the ‘DeNoiser’ has been added here)
– Play around with the settings (I prefer using the custom setting and set the Reduction button to -5Db or anything around that area). Start playing the video in the ‘program monitor’ and listen to the effect on the fly (while changing the settings to your liking)

Clipping Mask: a crop tool for Illustrator CS5

Looking for a crop tool in Illustrator CS5? Try a clipping mask instead! This way all your outside canvas drawings won’t be lost.

  1. Draw a rectangle above the area to be ‘cropped’
  2. Select all layers that need ‘cropping’
  3. Select Object > Clipping mask > Make

Still looking for cropping ways? Here are two examples:

Multiline regular expression problem in PHP 5.3.3

Recently I came across a very strange behaviour in a regular expression I wrote years ago.

The webserver upgraded to PHP 5.3.3 and it suddenly stopped working.

Case as follows: I use PHP to read a text-file and with the aid of PCRE (preg_match & preg_split) I look for certain matches in that text-file. The program splits different paragraphs into seperate records. But suddenly preg_split stopped working:

<?php
$paragraphs = preg_split("/\n\n/",$contents_of_file);
?>

Multiple newlines could not be detected, whereas

<?php
$lines = preg_split("/\n/",$contents_of_file);
?>

generated no problem at all. At first I thought I had to use the multiline modifier /m but that didn’t work out either.

Although a HEX editor didn’t indicate any carriage returns in the text-file I managed to get things working by doing this:

<?php
$paragrapgs = preg_split("/\r?\n\r?\n/",$contents_of_file);
?>

Curious thing: previous and newer versions of PHP (e.g. 5.3.8 in a XAMPP test environment) did not require to look for possible occurrences of carriage returns (\r).

How to import large sql files in XAMPP?

XAMPP is a very easy to use local webserver. Can be slow sometimes, but hey! it’s for testing purposes.

Ever tried to import a large SQL file? Doing so with phpMyAdmin will cause you headaches when tweaking php.ini to accept large data sets: memory_limit, post_max_size, etc…

Ever considered using the shell option? Once you have started your Apache and mySql module in the control panel, click “Shell”.

A command prompt will open and all you need to do is use this command line:

mysql -u root -p <DB_NAME> < <location of your large sql file

Example:

mysql -u root -p test < "d:\sql exports\file.sql"

Use -v to output the import process to screen

mysql -u root -p -v test < "d:\sql exports\file.sql"

Alternative method (no quotations in source command location!)

mysql -u root -p;
use <db-name>;
source C:\Temp\filename.sql;

SQL indexes

Disable indexes before you start importing, re-enable them when completed.

ALTER TABLE `table_name` DISABLE KEYS;

ALTER TABLE `table_name` ENABLE KEYS;

Further reading: https://support.tigertech.net/mysql-large-inserts

ERROR 2006 (HY000) at line 9999: MySQL server has gone away

It’s possible that this error occurs in XAMPP. It’s easily resolved by changing

  • my.ini at “\xampp\mysql\bin\”.
  • change “max_allowed_packet” to a higher value than the default 1M. E.g. 10 MB
  • restart mysql service

Print directly from Adobe Illustrator (CS4+)

I’ve used these settings on a Lexmark X4650, but it will do fine on other printers too, if you want to make sure all measurements resemble on paper.

Lexmark print dialog

  • Check off ‘print last page first’ (when using artboards things can get tricky)
  • Choose print quality

Illustrator print dialog

  • Media size: A4 borderless (do not use borderless printing in the Lexmark print dialog, it uses a slight resize)
  • Do not scale (make sure you use correct size on design, artboards can be resized easily with the artboard tool Shift + O)

Aan de slag met Mercury mail voor XAMPP

Om lokaal wat programmeerwerk als voorbereiding op een live omgeving te verrichten, is XAMPP de ideale omgeving. XAMPP komt pas echt tot zijn recht met de opstelling van een eigen mailserver (Mercury Mail) waarmee je lokaal het verzenden van mails kan testen.

De uitgebreide versie van XAMPP bevat zo’n SMTP service. Bij een eerste kennismaking word je overstelpt door een hele reeks vensters die kris kras op het scherm staan. Om hierin wat wegwijs te raken, is er een uitstekende videotutorial op YouTube:

Een van de belangrijkste zaken die je moet weten bij dit programma is dat voor quasi elke aanpassing het programma opnieuw moet opstarten omdat Mercury Mail in XAMPP geen service is!

De basisinstellingen

  • Configuration: volgende protocul modules aanvinken:
    • Mercury S SMTP server
    • Mercury P POP3 server
    • Mercury E, SMTP end to end client delivery client
    • Mercury D Distributing POP3 client,
    • Mercury I Iamp4 server
  • Configuration
    • Core module
    • Local domains > add local domain
      • Localhost
      • mydomain.com
  • Configuration
    • Mercury S
    • Connection control
    • Uncheck “do not permit SMTP relaying of non-local mail”
  • Configuration
    • Mercury E
    • DNS Servers (open DNS): 208.67.222.222,208.67.220.220
  • Configuration
    • Manage local users: een testgebruik definiëren
      Het is best dat je geen gebruik maakt van postmaster@localhost, omdat deze standaard alle foutberichten opvangt.
    • Username: root
      Personal name: root
      Password: pass

Het enige wat je nu nog moet doen is de configuratie van deze local mail account in je favoriete e-mailprogramma. Daarin volg je dezelfde werkwijze alsof je een remote mailserver zou aanspreken, maar bij de serversettings plaats je gewoon ‘localhost’.

De vooraf gedefinieerde accounts hebben volgende paswoorden:

  • Postmaster: Postmaster (postmaster@localhost)
  • Administrator: Admin (admin@localhost)

User: newuser
Password: wampp