Greetings and happy V-Day,I have searched extensively on the forum, but have not yet found a resolution (if one exists). I have a requirement to extract all fields (sample data) from a database that consists of couple od hundred fields. This is due to the fact that the client may develop a non Notes web application and needs to review all fields in the current system. Is there a quicker method of:
Creating an All Fields view without adding columns one at a time to view.
Is there a way to add the field name to the column heading programmatically, instead of copying and pasting each field name to the column heading.
Subject: RE: Why not just use the design synopsis tool?
Thanks for the suggestion,…I have tried that but that only provides field information without any sample data, the best solution for me is to created a view to show sample data which can also be exported to a spreadsheet. Please let me know if you can think of anything else.
Subject: RE: Why not just use the design synopsis tool?
It’s mighty expensive (in terms of performance) to have a view with hundreds of columns. If all you need is sample data, then you don’t really need a view that displays all the documents. You can just use rich text to create a report with data from a few documents. The Domino Designer 6 redbook shows how to create a rich text report. Put a table on the report, list the field name in column 1, and in subsequent columns show sample data accumulated from documents that all have the same form (all sample values from one form in one column, another form in the next column, etc.).
I’d probably write an agent to get a list of fields by going through the forms (NotesForm.Fields) and put it wherever in whatever format you might need(profile doc maybe? create a CSV file?)
Then, if you need data, extract some by going through the documents and putting it in the same place. The view option sounds big and slow.
Is this something that needs to be updated often? Schedule the agent…
Yes, in R6 you can create a view on the fly and add columns dynamically using the new method called “createColumn” in notes view class. To get all the field names of a particular form, there is a property called “field” in the notesform class.read the designer help for more info and examples.