Tutorial: How to import data into Lotus Notes -- without programming

There have been several tips recently on SearchDomino.com related to data import for Lotus Notes:

• Importing data from files
• Exporting to and from Microsoft Excel
• Importing data from a text file into a Lotus Notes calendar

These tips are useful and show ways to write LotusScript code that help with many import scenarios. Suppose, however, that you want to import data to Lotus Notes, but you're not a programmer. Or maybe you're a programmer, but want an import method that is faster to set up. In this tutorial, I present three such techniques.

The first works quickly for up to 8,000 records. The second takes a little more time to set up (but still no programming) and works for up to 65,000 records. The third has no apparent limit.

Before starting, let me issue one caveat: I will describe how to perform static data import, not real-time data import. By "static" I mean a set of data items that is fixed while you are doing the import. The static information might be cells in a spreadsheet, the contents of another software application, or a relational database file.

Real-time data import relates to items that are constantly changing, such ...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Lotus Notes Domino Database Management Domino Domain Monitoring hints and gotchas LotusScript code rebuilds corrupted busytime.nsf file LotusScript agent automates selective mail file replication Configuring Domino Domain Monitoring (DDM) How to move Notes databases off Domino 8 servers and save disk space What is Notes 8.5's DAOS (Domino Attachment and Object Storage) feature? LotusScript agent indexes Lotus Notes/Domino databases An introduction to Domino Domain Monitoring (DDM) 'Customize this view' options are disabled in Lotus Notes databases LotusScript button saves time searching large Lotus Notes databases Database LotusScript code rebuilds corrupted busytime.nsf file How to move Notes databases off Domino 8 servers and save disk space Top 10 Lotus Notes/Domino administration tips of 2008 Batch file runs scheduled Lotus Notes database maintenance tasks Fix and update Lotus Notes documents with limited access Programmatically replace the design of Lotus Notes databases Add a program doc to compact Lotus Notes databases automatically More efficient local Lotus Notes database replication Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete' Detect and fix 'Manager' access control list settings in Lotus Notes Domino

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

as stock market prices, airline reservations -- or IBM Lotus's marketing message about Lotus Notes and WebSphere. For these situations, see Lotus Enterprise Integrator. Of course, you can transform any real-time data import problem into a static case by just capturing the data at one point in time.

[IMAGE]
[IMAGE]TUTORIAL: HOW TO IMPORT DATA INTO NOTES -- WITHOUT PROGRAMMING
[IMAGE]
[IMAGE] Home: Introduction
[IMAGE] Part 1: How to import up to 8,000 data records into Lotus Notes
[IMAGE] Part 2: How to import up to 65,000 data records into Lotus Notes
[IMAGE] Part 3: How to import an unlimited number of data records into Lotus Notes

ABOUT THE AUTHOR:   

[IMAGE]Chuck Connell, Consultant
Chuck Connell is president of CHC-3 Consulting, which helps organizations with all aspects of Lotus Notes and Domino.