Actuate Reports Batch Build at 13:00

Have you ever felt the need to build an amount of reports and didn't want to build each one by hand? ERDPro allows you to build your reports from the command line. This batch process builds all your reports in a specified folder and its subfolders.

@set ERDPRO_HOME=C:\Program Files\Actuate7\ErdPro
@set ERDPRO_EXEC=%ERDPRO_HOME%\BIN\eRDPro
@set COMPILE_FOLDER=%1
@set TEMP_FOLDER=c:\temp\actuate

@mkdir %TEMP_FOLDER%

FOR /R %COMPILE_FOLDER% %%I IN (*.rod) DO "%ERDPRO_EXEC%" -b "%%I" -f %TEMP_FOLDER%\%%~nI.log

For each rod file found an ERDPro will be opened, the rod will be compiled an then the ERDPro will be closed. If a library is missing the process will stop on the report opening screen for that information.

I imagine that this process will work with Actuate 8 (Maximo 6) but have not yet tried it.

Changing Maximo's DB password at 16:27

When changing Maximo's database password there are 4 files where you must modify with the new password. The files are:

• maximo.properties
• rsse_maximo.properties
• actuatei18ntext.properties located at [ACTUATE_HOME]\iServer\bin\com\actuate\ExternalText
• actuatei18ntext.properties located at [MAXIMO_HOME]\applications\activeportal\WEB-INF\classes\com\actuate\ExternalText

If you fail to update one of this files you'll either be unable to start Maximo or unable to run Actuate reports where you'll receive the most infamous Assert statement failed error.

GPS Routes - Hoyo de San Blas at 16:45

Hoyo de San Blas (Spain)

Widget powered by EveryTrail: GPS Geotagging

Prevent Doclinks folder from listing at 10:12

If you're using WebSphere as the application server for your Maximo 6, after configuring Doclinks in Maximo you may notice that you can access the listing of your Doclinks folder if you fetch just the URL of the server. This happens when using Apache (IBM HTTP Server) as web server.

This directory listing is part of Apache standard functionality and you can prevent it by using the IndexIgnore directive in the httpd.conf configuration file.

To block all listings use the following statement:

IndexIgnore *

This way you tell Apache not to list any folders.

For more information on this directive refer to the Apache documentation available in the apache web site.

Configuring Bugzilla E-Mail delivery on Windows Behind Proxy at 18:58

This situation is somewhat unique and maybe it's too much work for to little gain but it was a situation I couldn't solve in a simpler way. Maybe someone will shine some light on me.

Problem
The problem I had was to enable the emailing features of a instance Bugzilla which is installed on a Windows 2000 machine behind a proxy server. I wanted to use a external email account (in this case a gmail account) to send all bug email messages.


Approach
Having not found a piece of software that managed this I' decided for the complex approach which was to devide the problem in two parts, the SMTP Authentication and the Proxy Server.


Sending Email with SMTP Authentication
To send all email I'm using Fake Sendmail. This allows me to use a SMTP account with authentication, something that Bugzilla doesn't provide.

In the sendmail.ini file configure 127.0.0.1 as the SMTP Server defined is so all emails are sent through the SMTP tunnel (seen next).


Pass through the Proxy
To pass through the Proxy Server I'm behind I use the mailFISH: Free HTTP tunnel for POP3 and SMTP.

Conclusion
Sendmail connects to the SMTP proxy providing SMTP authentication information which mailFISH doesn't manage and the latter tunnels the request through the HTTP Proxy.

Hopes this helps someone else.