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.
- 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.").
- 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.
- 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.
- Open the view created in step 2.
- From the "File" menu, choose "Import."
- . In the Import dialog box, choose the Lotus 123 (wk4) file saved at step 3.
- Choose the following settings, "Import as: Main Documents", "Using Form: ImportForm" (see step 1), "Column Format: Defined by the view", Click [OK].
