importing an excel spreadsheet into a form to generate documents in database. 1 row per document
Posted on 2012-09-18
I have a functionality form defined with approx. 40 fields. I have a 1 time import needed from a spreadhseet that contains all the data I want in each document. therefore I would be able to establish views on how to show all the new documents created from the import and of course new ones can be created going forward. but this first part is a 1 time conversion as I indicated. My questions is: What is the best way to do this.?? I believe I need to create a view that contains all the fields in the form in sequential order. then I need to ensure the excel spreadsheet contains column by column match to the view and required fields in the view would have to have data in that column of the spreadhseet. Each row of the spreadsheet would be a saved document in notes. 500 excel rows would equal 500 documents in notes. so do I open the view in notes and then perform a file import ??? or do I have to convert the excel to a structured text, etc ??
Thank You !