AGE Computer Consultancy
AGE Computer Consultancy
Notes / Domino data migration experts
Menu Marker
Import Utility for Notes
   
blank
tab-left Product Information tab-right blank tab-left Requirements tab-right blank tab-left Release Information tab-right blank tab-left Licensing tab-right blank tab-left Evaluation tab-right blank tab-left Purchasing tab-right  

Product Information
Please see the announcement from AGECOM regarding the discontinuation of the products produced by AGECOM after November 27th 2020. The Import Utility can still be downloaded so that existing customers can ensure they're using the most recent version. If you have an urgent requirement to use this product and would like a license please contact us for assistance.

The Import Utility for Notes enables you to import data from the following file formats directly into Notes:
  • Comma Delimited (CSV)
  • Microsoft Excel
  • Microsoft Access
  • Microsoft Outlook (Contacts only)
  • Oracle
  • SQL
  • XML
  • Fixed Width
  • dBase
  • Filesystem files (imported as file attachments)
  • Notes Structured Text
  • Other Character Delimited files

The Import utility includes the following features:
  • Existing documents can be found and updated with imported data (using view lookup or database search).
  • Options available for handling import of duplicate records.
  • Starting record number and maximum number of records to import can be specified.
  • Import can be performed directly from a specified file on filesystem or import can be performed from file attached to import profile document.
  • Imports can be run in the background on the Notes client enabling you to continue working while the import runs.
  • Imports can be scheduled to run at pre-defined times either as a once-off scheduled import or on a regular basis.
  • You can specify the field mapping so that imported data is put into the correct fields. Auto-populate field mapping option is also available.
  • Computed field mapping enables you to specify hard-coded or evaluated values (using Notes Formula) to be calculated and put into fields during importing.
  • The import can be previewed prior to running the import to ensure the expected data and field mappings are correct.
  • You can create your own customized scripts to be executed before the import begins, after each record is imported, and/or after the import has completed.
  • Pre-defined LotusScript objects are available for use in customized scripts.
  • ComputeWithForm method can be called after each record has been imported.
  • Full help documentation.
  • Full error logging and online debugging to help with troubleshooting of problems. Any error logs can be easily sent to our customer support team automatically at the click of a button.
  • Intuitive user interface.
  • A full update history is available in the Help - About document of the application.


Acknowledgements
IBM, Lotus Notes, Domino, and LotusScript are registered trademarks of International Business Machines Corporation.