Which meant one node per document, field names as attributes (with exceptions I've omitted), and having response documents' nodes within their parent documents' nodes. Your needs might be completely different from mine, but my goal was to take a database of Company, Product, and Factory documents and get a data structure like: However, if you learn XSL, you can do quite a bit. There isn't a way to get only specific fields from the exporter. or if they aren't parent/response documents, whatever other logic that says "here's the starter document, add related documents." Then you can export the collection. If you want to export a document and all of its descendants, I recommend making a subroutine that, given a document and a collection, adds the document's children to the collection and then loops through each of it's children and calls said function recursively. Error message is: " & Error$, MB_ICONSTOP, "Error"Īnyone willing to help will be much appreciated. Set OneDoc = SelectedDocs.GetNextDocument(OneDoc) 'Write the name of the XML file into the document.Ĭall OneDoc.ReplaceItemValue (XML_FILE_FIELD, XmlFilePath) 'Associate the XML output stream with the output file. XmlFilePath = XML_OUTPUT_DIR + XML_OUTPUT_ROOT1 + RepID + XML_OUTPUT_ROOT2 + NoteID+ XML_OUTPUT_SUFFIX 'Make this document the input to the XML exporter. Set OneDoc = SelectedDocs.GetFirstDocument 'Create a loop that will process all the selected documents. 'Attach the stream as the output of the XML exporter. 'Create an output stream that will receive XML. Set SelectedDocs = ThisDb.UnprocessedDocuments 'Get the collection of documents that were selected by the user when this agent is invoked. 'Get the current database and its replica ID.
'Get a Notes session, which we will use throughout this code. Therfore, we can find the XML file later for each doc.Ĭonst XML_FILE_FIELD = "XmlDocRenderFile"Ĭonst XML_OUTPUT_DIR = "C:\Users\Administrator\Documents\Archive\"ĭim SelectedDocs As NotesDocumentCollectionĭim XmlFilePath As String, NoteID As String, RepID As String The name of each XML file is the RepID of the database, 'This function creates XML files from Notes documents.
What I will be needing is to export records from Lotus Notes to xml file where I can choose which fields should be included from both Parent and Response forms.
#SOHO NOTES DATABASE FILE HOW TO#
Anybody here knows how to export the parent and response forms to xml file? I got this code wherein it gets all the objects in the parent form and exports it to xml but it doesn't access the response records.
0 kommentar(er)
