Problem solve Get help with specific problems with your technologies, process and projects.

Script to import Excel rows as separate Notes documents

How can I write a script to import all of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?

How can I write a script to import all of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?
A script in this case is not necessary; the task can be performed using a less complex data import.
  1. Create a form in Lotus Domino Designer that has all of the fields matching the column names in your Excel spreadsheet. (I am going to call this "ImportForm.").

  2. Create a view where the view columns match the columns in the Excel spreadsheet, where each column's definition in the view uses the field names created in step 1.

  3. Open the Excel spreadsheet, and save the file as a "WK4 (123)" file type, make sure you append the .wk4 extension to the file name.

  4. Open the view created in step 2.

  5. From the "File" menu, choose "Import."

  6. . In the Import dialog box, choose the Lotus 123 (wk4) file saved at step 3.

  7. Choose the following settings, "Import as: Main Documents", "Using Form: ImportForm" (see step 1), "Column Format: Defined by the view", Click [OK].
For each new row in the spreadsheet a new Lotus Notes Document will be created and populated with the Field (NotesItem) names specified in the view definition and values from the spreadsheet.
This was last published in April 2006

Dig Deeper on Lotus Domino Designer

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...