Menu

09.13.2016

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 1.2.0.4005 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.

image

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!).


01.17.2016

How to create Notes Import Export Library Toolbar with buttons for export to Excel

Category Import Export Library

You know how to launch the Import Export Library from the File Import and Export menus. How about creating a toolbar where you can instantly export all or just the selected documents to Excel? Learn how to create a nice toolbar like this:

image


Read More

01.17.2016

New Import Export Library release - now with much better format-control on import

Category Import Export Library

January 17th, 2016 was the date for a new release of Notes Import Export Library. This release has much better control on the import formats when you import from Excel to IBM Notes.

image

Why does this matter? In previous releases IEL did just fine when you imported Excel numbers and dates to different corresponding data types such as numbers and dates in the IBM Notes documents. Note the stress on the target field type in IBM Notes. If you import Excel numbers and dates into Notes number- and date fields, IEL will first and foremost import the raw number or date into Notes, and then Notes will control how you actually display the data with the field’s display properties.

Unfortunately it had some issues when you imported Excel numbers and dates into text fields in IBM Notes. Then IEL didn’t care as much . Then you see that number data was suffixed with many decimals. For example could the number “2” become “2.0000000” when imported into a text field. Why all the decimals?! Because IEL want all the precision it can get when importing the raw numbers Smile

The new release fix this so almost all standard Excel number formats are now imported into Notes text fields according to the locale settings on your computer. In the screen shot above you see for example that the Excel number 0,350000 is imported as 35% according to the Excel percent format. In the screen shot below you see that the Excel account number with currency is imported as such;

image

Note how your locale’s currency is automatically added.

Hopefully this will make you import to Notes text fields less frustrating!

The new release also fixes a couple of bugs, where the most important is found the Preview dialog box as shown above. If you changed target field formulas, the Preview dialog didn’t take into account the formula-changes. Another bug was trapped regarding import from other locales, and where blank columns occurred. Garbage data was the result. Now you have correct, blank, data in Notes Smile

Finally a small enhancement. When you work with saved import or export specification files (vci or vce file types), it was kind of annoying that IEL kept insisting to open the file where you last saved it. It now also store the location from where you open your vci or vce files. Makes it a tad easier to work with more mappings.

Head over to the product page to download the new version.


12.15.2015

If List Fields fails on Windows 10 64-bit, then try to re-register two DLLs

Category List Fields

Do List Fields crash on your Windows 10 x64 machine as soon as you try to start it? Perhaps you need to re-register a couple of DLLs again?


Read More

08.31.2015

Notes Import Export Library and List Fields runs fine on Windows 10

Category Announcement

It has just been verified that both Notes Import Export Library and List Fields runs fine on Windows 10.


11.10.2014

New version of Import Export Library ready

Category Import Export Library

The Notes Import Export Library (IEL) has been updated with some requested features.

  • You can now double click on any saved import- or export files (file types .vci or .vce respectively) to launch the import- or export job directly. This is nice if you have a persistent job that you want to perform regularly. Note that this version launches the job instantly without pausing. Future versions may have optional parameters so you for example can override input- and output of the job, or see a small description before you start the job.
  • Choose which Excel sheet you want to import from. In previous versions you needed to always have all data in the first sheet. Now you can choose!
    SNAGHTML1a9940d
    The chosen sheet name is also stored in saved job files.
  • Have a lot of fields to map, and tired of manually locating the corresponding fields in the field maps? Now you can easily right click any field name in either field map and choose “Locate similar field”;
    SNAGHTML1ab5401
    This feature will then locate the matching field, either by exact name match or by soundex-similarity. Hopefully this makes it easier to locate fields in huge field lists.

This version also contain several small bug fixes, and now Unicode strings won’t be prematurely chopped off anymore! Happy importing/exporting!


10.16.2014

II2LN bug-fix release 1.8.0.926

Category Import Image 2 Lotus Notes

A new update to Import Image 2 Lotus Notes (II2LN) has been released today. A crash occured on 64-bit Windows when the command line interface (II2LN.EXE) tried to load the II2LN DLL. Sorry for the inconvenience!


10.10.2014

List Fields updated to fix the "An unsupported operation was attempted" problem on 64-bit platforms

Category List Fields

Some customers has reported that List Fields crashed with the error message “An unsupported operation was attempted”. Unfortunately, the crash also took the Notes client down into the abyss!

It turns out that the installer I am using had some problems registering the underlying OLE controls correctly and thus List Fields could not find necessary components! The new version 1.4.0.92 attempt to fix this!

Sorry for any inconvenience!

Click here to goto the List Fields homepage and download the updated version!


03.01.2014

Notes Import Export Library bug fix ready

Category Import Export Library

The Notes Import Export Library has been updated with some bug fixes.

03.22.2013

List Fields, Import Image 2 Lotus Notes and Notes Import Export Library all works on the brand new IBM Notes 9 client

Category

Happy to report that the all major products from Voith’s CODE both install and work as intended on the brand new IBM Notes 9 client. Below you see the installer screenshots from all 3 products;

SNAGHTML1042372b

SNAGHTML104254f7

SNAGHTML10426f5a


Welcome!

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

News Tags