This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SUPPORT Q&A - How to save comments from MS Office on save and close

Bill.Beaton - Friday, September 18, 2015 1:39 AM:

I'm having a problem setting the office connector.  I want to save the comments field on save and close.   The comments need to be against the version of the file saved so that with each save we build up a history of comments.  The Admin guide gives me the $MSO_VersionComment but doesn't tell me what property it gets used against.  I'm assuming somehow it needs to go against the document file comments property.  But don't know how to do that. Any help greatly appreciated.



John Sperling - Tuesday, September 22, 2015 9:22 AM:

Hi Bill, the answer is that it can be any property you want.  Just create a String or Text property on the ItemType you're using, and then use this property in the Property Mapping tab for the Document Type.  For example, let's say you create a String property called "version_comment".  Then the mapping would look like this:

$MSO_VersionComment        version_comment      From Office File to Aras



Bill.Beaton - Tuesday, September 22, 2015 5:44 PM:

Thanks John, that makes sense, I’ll test it out.  The problem I’ve got (I think) is we need to track comments against the file linked to the document object rather than a comment against the document object.  The idea being that since several people will update the file over time prior to release we need to capture the comments from each person as they save the file.     The Document file relationship already has a property for comments and I would think that would the perfect place, but I can’t see how to get the comment from the close and save box in the office connector to that property field.   Of course if I could get everyone here to accept and user the secure collaboration that would probably achieve the same end result.


John Sperling - Wednesday, September 23, 2015 11:44 AM:

Office Connector establishes a one-to-one relationship between an Aras Document and an Office file.  So the Aras Document holds all the metadata about the Office file, including properties and comments (including for visual collaboration).  So even if multiple people make changes to the file, they would just be adding their comments to the Document itself.  So no need to be concerned with the Document File relationship.