Category: Software

Using ScanEZ to modify multiple fields on multiple documents

This is a small tip I would like to share with all users of Ytria’s ScanEZ. Last week I had to modify hundrets of documents in the Domino directory. The domain part of the user’s internet address had to be changed to a new domain.
The old internet mail address should be added to the FullName field to make sure that mail is delivered when the sender does not use the new internet mail address. Here is my formula:

_oldSuffix:="witte-velbert.de";
_newSuffix:="witte-automotive.de";
@If(!@Contains(@LowerCase(InternetAddress);"proepper":"krosta":"witte-automotive");
@Do(
tmp:= @Implode(FullName;"#");
tmp:= tmp + "#"+ @LowerCase(InternetAddress);
@SetField("FullName";@Explode(tmp;"#"));
@SetField("InternetAddress";@ReplaceSubstring( @LowerCase(InternetAddress) ;_oldSuffix ; _newSuffix))
);
"")

I know that ScanEZ can use formulas to modify a field in multiple documents; but I could not find any tip on how to modify multiple fields in multiple documents at a time using formulas (i.e. a formula that will compute with respect to the current document) in ScanEZ. There is a how-to in the FAQ on the Ytria site, but this does not fit my needs

I played around with this awesome tool and here is what I found out.

  • Select the documents to be modified

    Select Documents

  • Choose “Open selected documnet(s) in ScanEZ” from the Actions menue
  • Select one document from the documents collection
  • Leftclick on the collection’ header
  • Click the “Diff” button

    ScanEZ

  • Rightclick an entry in the right window and select “Modify Values” from the context menue

    Modify Values

  • Click the “@” button to use a formula; type the fieldname for a temporary field into the name field ( be sure that the fieldname is not part of the document )

    Temporary Field

  • Type your formula into the field at the buttom of the dialog

    Formula

  • Click the “OK” button

After the changes are done, you can delete the temp field from all documents.


madicon easyMail 1.1 released

Manfred Dillmann today released version 1.1 of his awesome mass mailer “easyMail“. The most valuable feature in this release IMHO is the ability to select contacts for a mailing by selecting a category only.

Please give this tool a try. There is an evaluation copy available for download. Try it and you will love it. easyMail is neither open source nor freeware, but a single copy license is affordable. In Bruce Elgort’s words, this tool can “save time, money … and your hair”


OpenSlice

OpenSliceOpen Slice is an application framework for Lotus Notes applications. It is not an application itself, but rather the bottom layer of any application – the first slice of your application sandwich if you will. Open Slice is designed to provide most of the basic elements that any Notes application requires. This allows developers to skip the basic stuff, and get right to the “meat” of the application.

While there may be some new things, many things within Open Slice will be familiar, particularly to developers who have built up their own repositories of code over the years. So then the question should be asked – what does Open Slice give me that I don’t already have? The answer to this is that Open Slice provides a single consistent approach to all of these common elements, and an easy mechanism for updating these elements across multiple applications. It helps to eliminate variations in coding techniques between different developers, and most importantly it will save you time. Finally, because it is open source, it allows you to see the code and continue to build and use your own code libraries right along side the Open slice framework.

In addition to the basic framework, over time Open Slice will continue to evolve with additional application objects (MS Word reporting, Organisation Hierarchy Processing), and complete applications (document library, discussion database) based on the Open Slice foundation.


Action Check

This is a small utility designed to tell you which actions are not compiled. If, for some reason, an action is not compiled the tool will identify the title of the action and the position in the action bar.
More information about the background of this utility can be found here.

[via Craig Schumann]


Sizer v3.3

Sizer is a freeware utility that allows you to resize any window to an exact, predefined size. This is extremely useful when designing web pages, as it allows you to see how the page will look when viewed at a smaller size. The utility is also handy when compiling screen-shots for documentation, using Sizer allows you to easily maintain the same window size across screen grabs.

Rocky Oliver mentioned it a while ago, and I’m using this great tool for a couple of years. It is my #1 freeware tool. You can download Sizer from here


madicon easyMail

easymalWerbung (nicht im Sinne von SPAM) per eMail ist heute üblich und bietet eine kostengünstige Variante, Kunden oder Interessenten zeitnah mit aktuellen Informationen bzgl. neuer Produkte oder Dienstleistungen zu versorgen.

Solche Mails sollten eine individuelle Anrede aufweisen und ggf. im Text der Mail weitere, dem Empfänger der Mail zugeordnete Details enthalten. Kurz – eine solche Mail sollte personalisiert sein.

Zusätzlich sollen wichtige Textstellen optisch hervorgehoben werden können und somit auch eine (heute übliche) Zeichen- bzgl. Absatzformatierung möglich sein. Auch die Unterstützung von Dateianhängen sollte eine Selbstverständlichkeit sein.

Manfred Dillmann hat nach dem madicon RSS reader mit madicon easymail wieder einmal ein hervorragendes Programm veröffentlicht.


Team Mailbox v2.11

In jedem Unternehmen gibt es Mail-In Datenbanken wie info@acme.com oder sales@acme.com. In den meisten Fällen liegt diesen Datenbanken das Design der Standard Mailschablone zugrunde.

Diese Datenbanken werden zumeist nicht nur von einer einzigen Person genutzt, sondern von einem Team. Die Standardschablone hat aber den Nachteil, daÃ? man keine Gruppe als Datenbankeigentümer in die Vorgaben eintragen kann.

Brian Green stellt hier seine Team Mailbox v2.11 zum kostenlosen Download zur Verfügung.

[via Bruce Elgort]


Wink

Wink is a Tutorial and Presentation creation software, primarily aimed at creating tutorials on how to use software (like a tutor for MS-Word/Excel etc). Using Wink you can capture screenshots, add explanations boxes, buttons, titles etc and generate a highly effective tutorial for your users.

Wink is distributed as freeware for business or personal use.

[via Julian Robichaux, Jumpstart Session Sneak Peek]


Domiclipse

Das Project Domiclipse von Keith Smillie und Wes Gilster hat zum Ziel, Eclipse als Entwicklungswerkzeug für Java und Lotusscript unter Lotus Notes Domino zur Verfügung zu stellen. Domiclipse Java steht bereits in einer Alpha Version zur Verfügung; zu Domiclipse LS gibt es noch keinen Download auf der Seite. Informationen zur Verfügbarkeit und evtl. Kosten findet man in den FAQ

Domiclipse lets you write better Domino applications more quickly!
Use the full power of the worlds most advanced Java IDE to write Domino agents.
The advanced Java editor in Eclipse provides a level of functionality unseen in the Domino world.

  • Intelligent editor checks your code as you type and offers corrections.
  • Code completion for all Java methods, including Domino classes.
  • Online help shows you what every Java method does as you type.
  • Powerful macro language makes writing repetitive code as simple as filling in the blanks.
  • Use JavaDoc to write self documenting applications.
  • Integrated TODO list shows outstanding tasks.
  • Advanced search can find and replace across multiple agents and databases.
  • Much more…

[via ChadSmiley Blog]


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 ]


madicon NotesKiller 1.0 (English) – Freeware

Manfred Dillmann stellt ein kleines Programm zum Download bereit, welches das Eintippen des NSD Aufrufs von der Kommandozeile in eine anwenderfreundliche GUI verlagert.

A Windows 32 tool to clean up (kill) any leftover processes after a Crash of your Notes Client – your running Notes Client will be killed, too… 😉

UPDATE 1.2.0

– Now stores all settings in the file noteskiller.ini
– Delete the file Cache.DSK or Cache.NDK (optional)
– Calls NLNOTES.EXE instead of NOTES.EXE during the restart (optional)
– Runs in “silent mode”. Use the command line switch -s

madicon NotesKiller 1.2.0


How many times have you double clicked the right mouse button or pressed the ESCape key on your keyboard and expected the window of a non Notes application to close?

ICODEX ARC is a FREE tool which empowers Windows with this cool feature across all applications


TaskSwitchXP Pro 2.0

TaskSwitchXP “is an advanced task management utility that picks up where the standard Windows Alt+Tab switcher leaves off. It provides the same functionality, and adds visual styles to the dialog and also enhances it by displaying thumbnail preview of the application that will be switched to. TaskSwitchXP also has a powerful process and window management capability that allows you quickly to close/minimize applications and their groups. The unique capabilities of TaskSwitchXP make it useful for tracking down multitudinous windows, and provide insight into the way Windows and applications work”