New release of Import Export Library (IEL): Ready for HCL Notes Version 11

Category Import Export Library
January 2nd, 2020: A new release of Notes Import Library (IEL) has been released. At December 20th, 2019, HCL made the new Notes and Domino version 11 available. Welcome HCL!

A picture named M2

This version of IEL should install fine with the new HCL Notes Client Version 11.


New year - and new version of Import Image 2 Lotus Notes

Category Import Image 2 Lotus Notes
January 2nd, 2020: Release of Import Image 2 Lotus Notes (II2LN) is out. The II2LN Command Line Client has been revamped to accept parameters in a bit more streamlined fashion. No need to remember the different switches such as -targetpath and -target, unless you want to! This means that the command sequence is now:

ii2ln.exe <sourcefile or wildcard> [optional targetfile] [optional import options] [optional switches]

This makes it extremely easy to convert an image file from one format to another. For example you can convert a jpg to png with this command:

ii2ln MysourceImage.jpg MyTargetImage.png

The rotateexif-switch has also been fixed, so it first check the EXIF Orientation on your image and then "normalizes the orientation". II2LN also set the EXIF Orientation correctly if image is rotated. This way you will never have issues with orientation again. The following command normalizes the orientation for all images in the current folder.

ii2ln *.* -rotateexif

ii2ln *.* -re (do the same thing as above, with the abbreviated switch for rotateexif)

Remember that you can add the -recursive switch to process images in all subfolders too.

II2LN's ability to grab web-pages has also been updated to accept https.Simply use and URL instead of a source file, such as:

ii2ln vcode.jpg

... to grab the complete content of the specified n to the target file vcode.jpg. Remember, you can combine this will other import options too, to grab for example, just a piece of the web page. The command below grabs the logo-part from the previous web page:

ii2ln vcode.jpg "SetWebGrabClipRect:420,860,300,250"


Import Image 2 Lotus Notes - prepared for HCL Notes 11

Category Import Image 2 Lotus Notes
December 5th, 2019: Today a new version of II2LN has been released. First and foremost, it has been prepared for the upcoming new version of Notes, the HCL Notes version 11. Note that II2LN will not run on HCL Domino 11 as it will only be shipped as a 64-bit application. In addition a bug has been fixed regarding the import-option AddVariable, meaning that you now can use your own variables fully with ReplaceWithVariable.


New release of Import Image 2 Lotus Notes - running better on Windows 10 with a updated DXL-processor

Category Import Image 2 Lotus Notes

September 3rd, 2018: Release of Import Image 2 Lotus Notes (II2LN) is out. First of all is every file in the package signed with updated certificates, meaning that Windows 10’s SmartScreen won’t make II2LN stumble on Windows 10. In addition a new and updated internal DXL-processor works even faster behind the scenes. Happy image importing.


New release of Import Export Library (IEL) - a small bug fix

Category Import Export Library
March, 23rd. 2018: Today a new bug-fix version of IEL was released. Another bug with key-updates were discovered. Thanks Larry B!. Head over to the IEL product page for more details!


New release of Import Export Library (IEL). Better formula editor, bud fixes and enhancements

Category Import Export Library
March, 17th. 2018: Today a new version of IEL went out the door. Head over to the IEL product page for more details!


Try this if List Fields crash on your system!

Category List Fields

List Fields – as most other software – loves to be installed with Administrator rights on your computer. Why? Because it need to deploy a couple of COM files, register them correctly in Windows, and update the registry amongst other things. If you do install with Administrator rights (remember, right click on the installer file and choose “Run as Administrator”"), most issues should never surface in your case Smile

Another thing to bear in mind is that Windows gets more and more security from version to version. The latest Windows 10 does a fair amount of “sandboxing” to try to keep evil code out of harms way. This may lead to problems that we must know how to fix.

Read on to see some extra tricks you can try out if List Fields bail out on you! Note that these tricks may work on Windows 7 too.

Read More


New release of Import Export Library - only a little bugfix this time

Category Import Export Library

January 6th, 2017; Today a new version of Notes Import Export Library was released. Only a little bug has been fixed since the last major version from December 2016. The bug occured during export to Excel if you had a formula field exported without a mapping.


New release of Import Export Library. Now you can update your target Notes documents via key lookup!

Category Announcement Import Export Library

December 26th, 2016; Today a new release of Notes Import Export Library (IEL) has been released. You can download from the product page. Besides a lot of small bug fixes and some cool enhancements, the biggest news is the ability to update you existing Notes target documents with a key.

You can simply specify any target field as a key by right-clicking on it and choose Set as key...


IEL will enumerate all the views in the target database and then let you choose what view to use as a lookup view during import;


This means that IEL for each imported Excel or CSV record, will check if the value in the key-field is found in the lookup-view. If found, IEL will update the existing document instead of creating a new one.

As for formulas, IEL will show you that a field has been designated as a key;


If you combine this new possibility with the ability to save import and export options (as *.vci or *.vce files), you can now pretty quickly have a scenario where you can quickly import - and update - any Excel or CSV file with a predefined option file. Remember, you can simply double-click on the option file to launch it directly witout the need to do any mapping first too.


New Import Export Library release - now support import/export of Comma Separated Files (CSV)

Category Import Export Library Announcement

September 13th, 2016. Today you can download release of Notes Import Export Library!

Amongst a bunch of fixes and other enhancements, the biggest news is that IEL now support import and export of Comma Separated Files (CSV) with the same ease and power as for the Excel files.


With simple alternatives you can control both the format of the input file (and yes, IEL can read and write almost anything. Got EBCDIC for System i? No problem. Of course you can use “auto” to let IEL guess the input format for you!).


Welcome to this site! Please click here to read more about Voith's CODE!

News Tags