USB install problem:
http://www.runpcrun.com/cant-install-usb
http://support.microsoft.com/kb/892050
USB Devices not installed automatically anymore
May 13th, 2009Download complete website freeware
April 17th, 2009This tool is freeware and works great. It lets you save/download a complete website to your local harddisk.
http://www.httrack.com/
Virtuemart product pictures size
March 30th, 2009Forgot to create thumbnails of your product pictures?
Change:
define(’PSHOP_IMG_RESIZE_ENABLE’, ”);
To:
define(’PSHOP_IMG_RESIZE_ENABLE’, ‘1′);
In file: /administrator/components/com_virtuemart/virtuemart.cfg.php
And all your pictures are resized in the view.
Outlook signature ActiveX Error
March 18th, 2009When Outlook gives you a activex security error when opening a new email try this:
Reset the restricted access websites in IE to the default.
http://forums.windowsitpro.com/web/forum/messageview.aspx?catid=40&threadid=45944&enterthread=y
AVI to DVD convert Open source!
January 22nd, 2009Check out this very nice app. It was the only one, who converted my avi correctly without any errors.
Also it’s optimized for dual or quad cores!
http://www.dvdflick.net/
Freeware, open source
Windows and Office serials recovery
November 28th, 2008Ever tried to make a good list of all Windows and Office license keys on your network computers?
This can be a h*ll of a job.
Try this app to recovery every Windows and Office serials from the PC’s on your network. (You need domain admin rights).
http://www.nirsoft.net/utils/product_cd_key_viewer.html
Open the app in the command prompt (cmd) with the parameters for scanning the whole network.
Takes a little time, but works perfect!
PERL input and output files
November 17th, 2008To read an input file, edit your data and put it to an output file try this:
#! /usr/bin/perl -w
use strict;
my $file = “in.csv”;
my $outfile = “out.csv”;
open(IN, “<$file”) or die “Could not open $file\n”;
open(OUT, “>$outfile”) or die “Could not open $outfile\n”;
while (<IN>)
{
chomp;
my @line = split(”,”); # this char is the separation sign.
# Your data will now be in a array called line[ ].
# Do whatever you want, access the data with the varable $line[FIELDNUMBER]
# Example: $line[3] = ‘blablbla’ #edit the 4th value from the input file.
print OUT “$line[0],$line[3],$line[2]“\n”; # write back to output file
}
# close the both files (importend! else the writing will not take place due caching!)
close(IN);
close(OUT);
PERL connect to SQL server
November 17th, 2008To connect you PERL application to an SQL server is pretty easy.
First you need the driver for supporting SQL connections.
Install driver:
- Open command prompt
- Typ: ppm install DBD-mysql
After a correct installation of the driver your SQL connection can be made as follow:
#!/usr/local/bin/perl
print "Content-type:text/html\n\n";
use DBI;
$username = '';
$password = '';
$database = '';
$hostname = '';
$dbh = DBI->connect("dbi:mysql:database=$database;" .
"host=$hostname;port=3306", $username, $password);
This is all you need to connect to your server.
If you don’t know your server ip, try connecting to your website address.
A very good website about this subject is:
http://www.codeproject.com/KB/perl/perldbi.aspx
TNT zone shipping module in Joomla Virtuemart
November 14th, 2008After lots and lots of googling i couldn’t find any shipping module for Virtuemart that was suiteble for our situation.
There is some kind of module for TNT but its for TGP Post and I didn’t get it working.
So there is no other option then write a module myself.
The first steps:
(1) Shipping Zone importing
I’ve imported all country zone codes by downloading the zone PDF from TNT, copied the in Excel and wrote a PERL script for the importing.
To make it more simple to you just download the SQL file here and just run the code in phpmyadmin.
It will update zone information (zone_id) for all countries in the jos_vm_country table.
If you prefer just international country codes with shipping zone information find it here. (same data, other format)
Beware this zone data is only from the Dutch point of view 
This will be different for your country!
(2) Writing the module itself:
The problem is, there is a default Zone Shipping module in Virtuemart, but here in the Netherlands the shipping costs are calculated different.
For example, in the default module you can ship a product sized 30cm * 30cm * 30cm with the weight of 50 Kg for just the zone price. There’s no difference in shipping a very large/small/heavy package. Only the destination matters.
TNT caculates the weight and the volume weight. You pay the highest value.
Weight is just the weight in Kilogram.
Volume weight is the size of the package length*width*hight / 6000.
Source: http://members.ziggo.nl/mfleur/maten.html
I’m writing the PHP code for the shipping module at the moment, so hold on a week or two.
Update 19 november 2008:
I had success with writing the module. There is a working alpha version. My deadline is 31 december 2008, so working hard to make this happen. I will make it more configurable, some parameters are hardcoded at the moment.
Update 9 january 2009:
I can report the shipping module is working fine 
It still has the be tested some more, but it working.
There is one practical problem I”m facing, the volume weight calculation.
When you have some products, you can calulate their volume. But not in witch box they will fit.
At the moment i’m tweaking this calculation for the most optimal box.
If someone has a good solution for this, please write a comment below
Update 14 Juni
Thanks all for waiting! I can report this module is working fine in production now. At the moment i’m VERY busy with school (tomorrow I’ll have my final exam!).
Within a short time I’ll set the code online for testing. Anyone interested in this testing?
Unable to install DVD/CD Driver Windows
November 3rd, 2008If your having problems installing your DVD or CD drive check this instructions:
Check in “Device Manager” if your drive is shown with a “yellow !”. If not, this is no solution for you.
Solution for following errors:
| Error message 1
The device is not working properly because Windows cannot load the drivers required for this device (Code 31).
Error message 2 A driver for this device was not required, and has been disabled (Code 32 or Code 31).
Error message 3 Your registry might be corrupted. (Code 19)
|
||||
|
||||
Step 1: Start Registry Editor
Start Registry Editor.
Step 2: Delete the UpperFilters registry entry
| 1. | In Registry Editor, expand My Computer, and then expand HKEY_LOCAL_MACHINE. | ||||
| 2. | Expand SYSTEM, and then expand CurrentControlSet. | ||||
| 3. | Expand Control, and then expand Class. | ||||
| 4. | Under Class, click {4D36E965-E325-11CE-BFC1-08002BE10318}. | ||||
| 5. | In the details pane of Registry Editor, on the right side, click UpperFilters.
Note You may also see an UpperFilters.bak registry entry. You do not have to remove that entry. Click UpperFilters only.
|
||||
| 6. | On the Edit menu, click Delete. | ||||
| 7. | Click Yes when you receive the following message: |
The UpperFilters registry entry is removed.
Step 3: Delete the LowerFilters registry entry
| 1. | In the details pane of Registry Editor, on the right side, click LowerFilters.
Note You might see a LowerFilters.bak registry entry. You do not have to remove that entry. Click LowerFilters only. If you do not see the LowerFilters registry entry, unfortunately this content is unable to help you any more. Go to the “Next Steps” section for information about how you can find more solutions or more help on the Microsoft Web site. |
| 2. | On the Edit menu, click Delete. |
| 3. | Click Yes when you receive the following message:
The LowerFilters registry entry is removed. |
| 4. | Exit Registry Editor. |
Step 4: Restart your computer
Source:
http://support.microsoft.com/kb/314060