1000121 - Manually downloading & installing Java Libraries for the Import Utility

Manually downloading & installing Java Libraries for the Import Utility - release 4.x

Product:	Import Utility for Notes > Java Libraries > Version 4.x
Platform(s):	All
Edition(s):	All
Doc Number:	1000121

Published 02-Jul-2012
Last Updated: 03-Feb-2020

General Information

My installed copy of the Import Utility is unable to successfully download the Java library files required for importing from Microsoft Excel files. Can I manually download and install the libraries?

Solution

Java library files can be manually downloaded from the AGECOM website and installed into the Import Utility. These instructions apply to Release 4.x of the Import Utility and you must be using Notes / Domino version 8.5.2 or later.

Step 1 - Download the Java library files
Click here to download the java libraries.

Step 2 - Extract all files to a folder on your computer
All files in the downloaded zip file should be extracted to a folder on your computer. The file should be extracted to a temporary folder and NOT to any of the Notes or Domino folders or subfolders.

Step 3 - Import the Java Libraries into the Import Utility
Open the Import Utility application. After it has opened select 'Actions' from the Notes menu then select 'Tools' and then 'Java Libraries - Import'. You will be required to select the location of the 'filelist.txt' file which should be found in the folder where you extracted the downloaded java library files to.

The success or failure of the importing of the Java libraries will be advised.

Step 4 - Install the Java Libraries
If you haven't already done so you can now install the Java libraries to your Notes client or Domino server so that you can perform imports of Microsoft Excel files. To install the libraries open the Import Utility then select 'Actions' from the Notes menu, then select 'Install' and then 'Java Libraries - Install'.

If you have previously installed the Java libraries and are now installing updated libraries you may first need to un-install the older libraries. This is because the newer libraries cannot be installed while the existing libraries are in use. To un-install existing libraries open the Import Utility then select 'Actions' from the Notes menu, then select 'Install' and then 'Java Libraries - Uninstall'. The Notes Client may need to be restarted during the un-installation process if existing files are locked and cannot be immediately removed.

Once the Java libraries have been installed restart your Notes Client to activate them.

Step 5 - Update the Configuration Settings
The method which the Import Utility should use for importing Microsoft Excel files must be specified in the Configuration Settings of the application. Open the Import Utility and select the Configuration Settings option from the left-hand navigation pane. Select the Import Options tab then specify the MS-Excel import option - it should be set to 'Use Apache POI'.

That's it! You should now be able to perform imports of Microsoft Excel files using the java libraries.

More information regarding the installation and removal of the Java libraries can found in the Import Utility Installation and User Guides.