Are you using !!HELP!! ?

then please subscribe to the list below and let us know, how many user are working with !!HELP!!. If you like to give us a feedback, feel free to do so ­čÖé

Atelier Goldner Schnitt GmbH, Versandhandel, 600 User contact: Entwickler

Sanyko Pharma GmbH, Pharmaindustrie, 300 User

Pickenpack – Hussmann & Hahn Seafood GmbH, Lebensmittelherst., 150 User Kontakt

WITTE Velbert GmbH & Co.KG, Automobilzulieferer.

Mainland Information Systems IT Company, 30 User

MDK in Bayern,Dienstleistungsunternehmen, 1000 User

ELVIA Travel Insurance Austria Insurance, 80 User, contact: IT Manager

Plenexis Satellitenkommunikation Kommunikationsunternehmen, 100 User

pharma mall Gesellschaft f├╝r E-Commerce mbH, 20 User

Stahl-Zentrum Duesseldorf Stahl-Zentrum Duesseldorf

Universit├Ątsklinikum Bonn Universit├Ątsklinikum Bonn KIS-Support, 2500 User, Kontakt

Hermann Maier Spedition KG, Transport und Logistik, Singen, 120 User

DKSH Schweiz AG, Zuerich, 150 User


Visual Studio 2005 gratis zum Download

Microsoft bietet ab sofort die speziell auf Privatanwender zugeschnittenen Express-Versionen von Visual Studio 2005 und SQL Server 2005 zum kostenlosen Download an.
Angeboten werden die englischsprachigen Versionen von Visual Web Developer 2005, SQL Server 2005 Express Edition, Visual Basic 2005 Express Edition, Visual C# 2005 Express Edition, Visual C++ 2005 Express Edition und Visual J# 2005 Express Edition.
Die Anwendungen k├Ânnen bis zum 6. November 2006 kostenlos heruntergeladen werden k├Ânnen.

[ via atnotes.de]


WWW SQL Designer

Der WWW SQL Designer bietet die M├Âglichkeit, die SQL Statements zur Erzeugung einer MySQL Datenbank mittels grafischer Oberfl├Ąche im Web zu erzeugen. Tabellen und Felder lassen sich einfach mit ein paar Mausklicks am Bildschirm erstellen. Ebenso einfach gestaltet sich die Definition von Relationen ├╝ber Drag und Drop.

Informationen zur Bedienung finden sich im FAQ. Eine Demo gibt es hier. Und wer ├╝ber einen eigenen Webserver verf├╝gt, kann sich die aktuelle Version des WWW SQL Designer hier herunterladen.

[ via Axel Janssen, atnotes.de ]


How to migrate mail messages and contacts from Outlook Express to ND 6.x and later

How can you migrate mail messages and contacts from Microsoft Outlook Express to Notes?

You can use the Upgrade Wizard (Nupgrade.exe) release 6 or later to convert messages and contacts from Outlook Express to Notes. This can be accomplished by following the steps detailed in each of the following sections:

Launch the Upgrade Wizard to create an account for your Notes mail file in Outlook Express.
Transfer messages from Outlook Express to your Notes mail file.
Transfer contacts from Outlook Express to your Notes Personal Address Book.

Launch the Upgrade Wizard to create an account for your Notes mail file in Outlook Express:

1. Open a Command Prompt window by selecting Start -> Run and then type:

cmd.exe

2. Change to the Notes Client program directory. For example:

cd Program Files\Lotus\Notes

3. Enter the following command to launch the Upgrade Wizard:

Nupgrade.exe 4

4. Click “Next” to continue past the Welcome Screen.
5. Click “Finish” to begin the conversion.
6. When prompted, enter the password for your Notes ID file.
7. Specify the following information to create an account for your Notes mail file in Outlook Express:

Account Name: (For example: Lotus Notes)
User Name: (Your Notes shortname)

IMAP Server: (Your Domino mail server)

8. Click “OK” and “Exit”.

Transfer messages from Outlook Express to your Notes mail file:

NOTE: In order to complete the steps in this section, the IMAP task must be running on the Domino server. Otherwise, users will receive the error “The connection to the server has failed” when attempting to transfer messages.

1. Launch Outlook Express.
2. Open any folder in the Local Folders mail account.
3. Perform one of the following steps to transfer messages to your Notes mail account:

Drag and drop messages into your Notes mail account folders, or
Copy messages to the Notes mail account folders, or
Move messages to the Notes mail account folders.

Transfer contacts from Outlook Express to your Notes Personal Address Book:

The Upgrade Wizard adds a “Lotus Notes Personal Address Book” option to the Outlook Express Address Book Export Tool dialog box. Perform the following steps to export your Outlook Express contacts into your Notes Personal Address Book:

1. Launch Outlook Express.
2. Select File -> Export -> Address Book.
3. Select “Lotus Notes Personal Address Book”.
4. Click “Export”.
5. Select your Notes Personal Address Book.
6. Click “Migrate”.

Lotus Notes Knowledgebase #196232


Excel Report Class

Christian Gorni today released his Excel Report Class on OpenNTF.

Just use the database. It includes the complete ExcelReport class and two agent examples. As a teaser, the following is all you need to export a view to excel in LotusScript:

Set view = ws.CurrentView.View
Set report = New ExcelReport(excelfilepath, False)
Call report.exportNotesView(view, Sheet, OffsetX, OffsetY, isWithHeader, includeIcons, includeColors, includeHidden)
Call report.setVisibility(True)

Of course the obvious (getting and setting cells, saving, …) is also included. Be careful, because error handling is not yet implemented.

Here are the implemented methods:

Sub new (xlFilename As String, isVisible As Boolean)
Sub delete ()
Function save ()
Function saveAs (filename as String)
Function quit ()
Function setCell ( Sheet As Variant , row As Integer , column As Variant , value As String )
Function getCell ( Sheet As Variant , row As Integer , column As Variant ) As String
Function setVisibility (isVisible As Boolean)
Function setCellColor ( Sheet As Variant , row As Integer , column As Variant, innercolor As Variant )
Function setCellFont ( Sheet As Variant , row As Integer , column As Variant, style As Variant, size As Variant, color As Variant )
Function getVersion () As String
Function exportNotesView (view As NotesView, Sheet As Variant, OffsetRow As Integer, OffsetCol As Integer, isWithHeader as Boolean, includeIcons As Boolean, includeColors As Boolean, includeHidden As Boolean)

Lichtbildbelehrung

epassWozu die B├╝rokraten in diesem unserem Lande f├Ąhig sind, zeigt sich bei der Einf├╝hrung der neuen Reisep├Ąsse ab dem 01.11.2005. Auf einem Chip in dem Dokument werden biometrische Daten erfasst.
Grunds├Ątzlich kann es einem Chip herzlich egal sein, ob meine Nase schief oder meine Ohren zum Segeln neigen. Nicht aber so den deutschen Beh├Ârden.

Damit die Technik nicht zusammenbricht und beim Vergleich des dem Reisepass beigef├╝gten Foto des Inhabers nicht zu viele Varianten ber├╝cksichtigen zu m├╝ssen, hat man eine sog. Foto-Mustertafel erstellt.

Wer diesem Idealbild nicht entspricht muss bei der Beantragung des Reisepasses folgende Erkl├Ąrung unterschreiben:

“Hiermit best├Ątige ich, dass ich von der Ausweisbeh├Ârde ├╝ber die Qualit├Ąt/Beschaffenheit meines vorgelegten Lichtbildes belehrt wurde.

Ich bestehe auf Annahme dieses Lichtbildes durch die Passbeh├Ârde.

Entstehende Schadensersatzanspr├╝che, wegen Abweisung an einer Landesgrenze oder auf Grund polizeilicher Identit├Ątsvorstellungen, kann ich gegen├╝ber der Passbeh├Ârde nicht geltend machen. Die Kosten f├╝r einen neuen Ausweis habe ich voll zu tragen.”

Quelle: heise online


How to use a list to get around the Array size limit

In LotusScript, arrays have a upper boundary limit of 32,767. Specifically, the subscript range may be from -32787 to 32,767. If you try declare a larger Array size, you receive the following error when saving the code:

Illegal array bound for

If you attempt to use ReDim to redimension an Array beyond the bounds, the following error will occur:

Overflow

Depending on how the bound value is set, the above error can occur when saving the code or when executing the code.

You may use a List variable to work around the Array size limits in LotusScript. Lists are automatically resized as elements are added or removed. Lists differ from Arrays in that they are not categorized by an integer value, but instead by a List tag. The List tag can be any string.

In cases where you are converting from using an Array to a List, it may be easiest to use a string representation of a integer value for the List tag. This can easily be done using the Cstr function.

For example, if you used the following construction with an Array:

Dim i As Long
Dim arraytest() As String
For i = 0 To 100000
    Redim Preserve arraytest(i)
    arraytest(i) = ...
Next

The List equivalent usage would be:

Dim i As Long
Dim mylist List As String
For i = 0 To 100000
    mylist(Cstr(i)) = ...
Next

Lists only allow unique List tag values. This can be beneficial in some application designs.
For example, if you want to have a unique List entry for each part number, you could use the part number as the List tag. You could note how much inventory you had of particular parts by using the part number as the List tag and the number of parts as the List entry value:

Dim parts List as Integer
parts("N001")=10
parts("N002")=12

The IsElements function can be used to determine if a List contains a List tag:

If (Iselement(parts("N003")) = False) Then
      'Returns False if there is no list tag "N003"
End If

NOTE: The following usage is allowed even if the List tag did not previously exist. The result is that the List entry for “N004” in the parts List will have a value of 1.

parts("N004")=parts("N004")+1

The above construction would be useful when decrementing a List value by a certain amount. For example, if you wanted to decrement the number of parts by an order size:

If ordersize>parts("N004") Then
      'Not enough parts on hand...
Else
     'Have enough parts, decrement inventory by ordersize
      parts("N004")=parts("N004")-ordersize
End If

Lotus Notes KnowledgeBase document #1221020


Neuwahlen im März 2006 ?

H├Âre ich mir so die Nachrichten an, sieht es fast so aus … was juckt es mich; da gehe ICH nicht hin.
“M├╝nte” hat seinen Kandidaten f├╝r den Vorstand nicht durchgebracht und schmollt nun; Stoiber zieht es nunmehr wieder in die W├Ąlder ( “Schickt den Stoiber in die W├Ąlder wegen der Semestergelder hallte es 1979 durch M├╝nchens Stra├â?en ).
Und “Angie”; blass und farblos, sieht sie sich nun mit einer “neuen Linken” konfrontiert, die sie bei den Koalitionsverhandlungen mit der “alten Garde” gar nich ber├╝cksichtigt hatte.