Knowledge in a Blog

MailMerge If field for ,- behind the currency when there are no decimals

2011-04-13T11:57:00.000+02:00

This might be something dutch, but there where no standard solutions on this one yet on the internet.

the problem was in word (when mailmerging a database) we have a currency field.
This field will be filled with an ammount (ex. 10.00, 125.25 or 50.50)

What we wanted to do is make the decimals dissapear for .00 and replace it with ,- and for .25 it would be ,25.

So i tried to do this and it worked with an IF field:
{ IF { MERGEFIELD CURRENCY } ="{ MERGEFIELD CURRENCY \# 0 }" "{ MERGEFIELD "CURRENCY" },-""{ MERGEFIELD CURRENCY \# 0,00 }" }

Might come in handy sometime.

DDE link to access or excel not working for DOCX (word 2007)

2011-04-07T12:00:00.001+02:00

Hi everyone,

Microsoft did it again.
We tried to use DDE link to ACCESS from WORD (2007) and everything was working fine when you use it the first time. but after saving the documents the document gives an error message: "Word could not re-establish the DDE connection to Microsoft Access to complete the current task".

This was for a project that was allready in production, so no time to waste. After a lot of research with my good friend Google I found out that there are a lot of problems with DDE but i could not find a solution for my problem.

I tried everything including using older versions of word, but therefore i needed to save the documents to .doc instead of .docx and it worked in the older versions.

So we tried the .doc documents in word 2007 and it worked.

Please microsoft next time update error messages.

Problem:
With a .docx document trying to DDE link to an Acces or Excel file i get the error "Word could not re-establish the DDE connection to Microsoft Access to complete the current task".

Solution:
Save the document as .doc

exec() in PHP (unable to fork error)

2010-04-22T13:49:00.002+02:00

Dealing with webapplications that can actually run programs in the background you will run into the exec() command in php very easily. Running commands like this on a windows server is a bit tricky as you want to be as secure as you can.

I'm going to explain a bit how we got it as secure as possible.

First of all we use IIS.
Create a subdomain for IIS and only give it rights to a subdirectory with the executable you would like to run with the php script (make sure the php script is also in the same directory.
After that give it security rights with a newly created user, creating a user is very straight forward. as long as you start the lusrmgr.msc command.
When the user is created give it read and execute rights on the executable you wish to run. and what is easily overseen give it read and execute rights at cmd.exe.When the user has no right to cmd.exe you will get the error:

Unable to fork [executable.exe] in C:\Inetpub\wwwroot\subdomain\script.php

It's simple as that.

Now you can run the script by calling http:\\subdomain.domain.com\script.php and everything should work for you now.

How To Make a Custom Google Buzz Button 1.4

2010-02-23T13:28:00.018+01:00

Quote from Noonski.nl:
I was looking for a ready made Google Buzz Button that would dynamicly generate the correct information to post to Google Buzz through Google Reader. There where a few but they either required using a service or a hand made link. I needed a button that would stay dynamic on all pages made from the main template page. So off course i had to dust of the old Javascript brain cells and make one myself. It's pretty easy and basic.
Eventually i needed some good help from scinor with the extra scripting.

Updated on 23.02.2010 to Version 1.4
- Added detection of Emtpy Meta Description, Some Bloggers Don't Learn ;).

Updated on 23.02.2010 to Version 1.3
- Image is not pulled from Google Servers anymore, but uses a 16x16 blob.
- Button now also grabs description to post to Google Reader/Buzz.
-Script parses and replaces single quotes ' with ' from the desciption.

Updated Version 1.1
- does not need you to change anything to the script, it uses Google's own Buzz Graphic.

CODE: download here

How To Make a Custom Google Buzz Button version 1.1

2010-02-15T17:06:00.003+01:00

Version 1.3 available here

Revision of the previous post on scinor.blogspot.com that can be found here but cannot be used anymore!

This is the version that can be used. I worked together with Noonski for this update. So credits to www.noonski.nl. The code to paste on your blog/page:

How To Make a Custom Google Buzz Button by Noonski

2010-02-15T16:07:00.002+01:00

Today not a message from me but from a friend of mine Noonski (A big name in the windows mobile developers community) about google buzz buttons:

Version 1.3 available click here

Full message can be found here: http://blog.noonski.nl/2010/20100214-Custom_Google_Buzz_Button.html

I was looking for a ready made Google Buzz Button that would dynamicly generate the correct information to post to Google Buzz through Google Reader. There where a few but they either required using a service or a hand made link. I needed a button that would stay dynamic on all pages made from the main template page. So off course i had to dust of the old Javascript brain cells and make one myself. It's pretty easy and basic.
You need to edit the image source to one on your own domain
(Leechers will be shot in the Head, I'm not a millionaire)
And you will need to Edit the variablesbelow:
srcUrl=http://www.MyDomain.com
&
srcTitle=My+Domain+Title
Be sure to use the Plus + in the srcTitle Variable instead of spaces.

 <script language="javascript" type="text/javascript"> var buzzlink = document.location; var buzztitle = document.title; document.write("<a href='http://www.google.com/reader/link?url="+buzzlink+"&srcUrl=http://www.MyDomain.com/&srcTitle=My+Domain+Title&title="+buzztitle+"'>"); </script> <img src="http://www.mydomain.com/images/buzz.png" border="0" title="Buzz It" alt="Buzz It" width="16" height="16" /> Buzz It</a>

Get files from FTP and mail them "batch" and VBS

2010-02-11T11:53:00.000+01:00

The "why" of this script is not to be explained this time unfortunately. besides that i lost the website I got all the pieces of code from, but I did not want to keep this from the public to know.
What does this script do?

1.This script gets particular files from an FTP account.
2.It puts them in an directory locally
3.It mails them to multiple addresses
4.It deletes the files form the FTP account.
5.It creates an log file.

Please feel free to copy.

FTP.bat

::@echo off

SET SERVER=ftp5.****.nl
SET USERNAME=*****
SET PASSWORD=*****
SET LOCALFILE=C:\New
SET REMOTEPATH=/bin/ls
SET REMOTEFILE=omzet_*.xls
SET LOGFILE=c:\FTP\ftplog.txt
SET TEMPFILE=$temp.txt

cd %LOCALFILE%

echo open %SERVER% >%TEMPFILE%
echo %USERNAME%>>%TEMPFILE%
echo %PASSWORD%>>%TEMPFILE%
echo bin >>%TEMPFILE%
echo cd %REMOTEPATH% >>%TEMPFILE%
echo prompt >>%TEMPFILE%
echo mget %REMOTEFILE% >>%TEMPFILE%
echo mdelete %REMOTEFILE% >>%TEMPFILE%
echo quit >>%TEMPFILE%

echo. >>%LOGFILE%
echo. >>%LOGFILE%
echo Transfering %REMOTEFILE% to %LOCALFILE% at %DATE% %TIME% >>%LOGFILE%

REM Execute FTP script
REM ------------------

ftp -s:%TEMPFILE% >>%LOGFILE%

REM Clean up
REM --------
del %TEMPFILE%

c:\ftp\mail.vbs
echo Mail send >>%LOGFILE%

for /F "tokens=2-4 delims=/- " %%A in ('date/T') do set var=%%A%%B%%C
md "c:\NEw\%var%"
move c:\NEW\*.* C:\NEW\%var%
:: DONE
echo files archived >>%LOGFILE%

mail.vbs:

'Email the files
strFolder = "C:\NEW"
strFileExt = "xls"

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder(strFolder)

Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Omzet bestanden van vandaag!"
objMessage.From = "*******"
objMessage.To = "*******; *******"
objMessage.TextBody = "Hi Everyone, this is the message."
For Each objFile In objFolder.Files
strFileExt = objFSO.GetExtensionName(objFile.Path)
objMessage.AddAttachment objFile.Path
Next
'Configuration Info
objMessage.Configuration.Fields.Item _
("http://schemas.Microsoft.Com/cdo/configuration/smtpauthenticate") = 1
objMessage.Configuration.Fields.Item _
("http://schemas.Microsoft.Com/cdo/configuration/sendusername") = "*****"
objMessage.Configuration.Fields.Item _
("http://schemas.Microsoft.Com/cdo/configuration/sendpassword") = "*****"
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of Remote SMTP Server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.****.com"
'Server port (typically 25)
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMessage.Configuration.Fields.Update
'==End remote SMTP server configuration section==
objMessage.Send

Testing GPS applications without GPS

2010-02-11T11:07:00.000+01:00

Problem:
Being busy to create the new VaarAtlas Desktop application I faced the challenge that the bluetooth GPS device I have here for testing was not working with the GPS module of the application. So the question became: Is it 1. the bluetooth device does not work. 2. The device is not compatible with the module or 3. The module is not working.

Solution:
To test this I have tried the software "Avandardo GPS generator PRO" This software creates a comport where it send NMEA data to. like a virtual GPS reciever. The conclusion was that the module needed some adjustments and the device was incompatible.

Screen AND MOUSE rotator

2010-01-26T14:45:00.000+01:00

Today one of the designers came up to me to request a tool for rotating the screen. As we all know there are loads of these programs over the internet. to give some examples: irotate and eeerotate. What these programs do is rotate your screen orientation. If you use your mouse you will see that left is up and down is left, so you will not be able to design normally when your screen is in landscape but the rotation (software) is in portrait.

The solution: A screen and mouse rotator! it was kind of a search but i found one created by Kenrick Mock the tool can be found here. Kenrick even shares his code (C#) with us. Thank you Kenrick!