{"id":1730,"date":"2013-07-25T20:13:42","date_gmt":"2013-07-25T20:13:42","guid":{"rendered":"https:\/\/notebooks.dataone.org\/?p=1730"},"modified":"2013-07-25T20:13:42","modified_gmt":"2013-07-25T20:13:42","slug":"ons-email-to-sharepoint","status":"publish","type":"post","link":"https:\/\/notebooks.dataone.org\/data-science\/ons-email-to-sharepoint\/","title":{"rendered":"Open Notebook Science – E-mailing Attachments to Sharepoint"},"content":{"rendered":"

Interested in possibility of forwarding e-mail to both open notebook and sharepoint site.<\/p>\n

This would streamline the process of archiving documents on the UT Sharepoint site.<\/p>\n

Looking at:<\/p>\n

DataONE > UT DataONE > Documents > Network Analysis > All Documents<\/p>\n

Google Search:<\/p>\n

Sharepoint AND e-mail AND upload<\/p>\n

Found this:<\/p>\n

http:\/\/sharepoint.stackexchange.com\/questions\/13589\/how-to-upload-documents-by-sending-an-email<\/a><\/p>\n

Led me to this:<\/a><\/p>\n

http:\/\/office.microsoft.com\/en-us\/windows-sharepoint-services-help\/add-content-to-sites-by-sending-e-mail-HA010086730.aspx<\/a><\/p>\n

Also this:
\nhttp:\/\/office.microsoft.com\/en-us\/windows-sharepoint-services-help\/add-content-to-sites-by-sending-e-mail-HA010086730.aspx<\/p>\n

“Suppose you want to send a document to your team and add it to your team’s document library.”<\/p>\n

Why yes, yes I do want to do that.<\/p>\n

Apparently, by default, Windows SharePoint Services 3.0 can be set up to receive e-mail:
\n1. Discussion Boards
\n2. Announcements
\n3. Calendars
\n4. Document libraries
\n5. Picture libraries
\n6. Form libraries
\n7. Blogs<\/p>\n

It instructs me to find out which of your lists are enabled to receive email, or to obtain the email addresses of the lists, “see site owner or administrator.”<\/p>\n

I am obviously interested in “Document Libraries.”<\/p>\n

Picture Libraries might also be interesting for archiving images (e.g. screen captures) generated during research efforts – and could be a way to deal with the problem I’ve encountered in that my images are not archived when I use the “Press this” feature.<\/p>\n

Required:
\n1. Learn if a library is set up to receive e-mail
\n2. Obtain the address from the person who set up the list or library<\/p>\n

Could be in the description (probably not for the network analysis library)<\/p>\n

Go to settings menu.
\nGo to “list settings” or settings for the type of library<\/p>\n

If enabled to receive e-mail, address will appear under “List Information”<\/p>\n

There also may be a “SharePoint group” enabling members to e-mail each other.<\/p>\n

This will contain the addresses of the libraries.<\/p>\n

If not, then I need to contact the site owner.<\/p>\n

The second link from above might have some details for setting up “mail enabled document libraries”
\n
https:\/\/www.nothingbutsharepoint.com\/sites\/itpro\/Pages\/How-to-Setup-Mail-Enabled-Document-Libraries-in-SharePoint-2010-Part-4.aspx<\/a><\/p>\n

I am going to check that out right now.<\/p>\n

Another stackoverflow discussion on the topic, “Submit a document to sharepoint by e-mail” here:
\n
http:\/\/stackoverflow.com\/questions\/11019117\/submit-a-document-to-sharepoint-by-email<\/a><\/p>\n

This might be for a more advanced administrator:
\n
http:\/\/technet.microsoft.com\/en-us\/library\/cc262947.aspx<\/a><\/p>\n

Library Tools, Library Settings<\/p>\n

Communications<\/p>\n

Incoming e-mail settings
\n(note: rss settings also looks interesting)<\/p>\n

Use this page to change the e-mail settings of this document library. You can set the e-mail address for this document library, choose to save or discard e-mail attachments, and set e-mail security policy.<\/p>\n

name @ sharepoint domain<\/p>\n

E-mail attachments – save all attachments grouped by e-mail sender (although I’d rather have them grouped by e-mail subject, but I don’t think this would make sense for the open notebook workflow).<\/p>\n

E-mail security policy<\/p>\n

Caution: If you allow e-mail from any sender, you are bypassing the security settings for the document library. This means that anyone could send an e-mail to the document library’s address and their item would be added. With this option turned on, you are opening your document library to spam or other unwanted e-mail messages.<\/p>\n

Now that that’s set up, next step is to attempt to send an e-mail with attachment.<\/p>\n

The first one I’ll send is entitled “document info” and contains three .docx word documents.<\/p>\n

I’ll forward the e-mail to the sharepoint site and see what happens.<\/p>\n

Also, I’m deleting everything above the horizontal rule in the outlook web app.<\/p>\n

Sent at 3:23 pm<\/p>\n

Check UT dataone sharepoint site<\/p>\n

https:\/\/utworks.tennessee.edu\/cics\/dataone\/Shared%20Documents\/Forms\/AllItems.aspx<\/a><\/p>\n

Looking at all documents.<\/p>\n

I’m expecting a new folder to be created, something like tjessel.<\/p>\n

Nothing at 3:24.<\/p>\n

Refreshing.<\/p>\n

Nothing.<\/p>\n

Clicking “Home”<\/p>\n

1 – 15 with an arrow for more.<\/p>\n

There is a new folder called ‘Jessel, Tanner Monroe’ with my e-mail in parenthesis. Created 7\/25 at 3:25 pm.<\/p>\n

https:\/\/utworks.tennessee.edu\/cics\/dataone\/SitePages\/Home.aspx<\/p>\n

I will need to let Dr. Davis know I modified this.<\/p>\n

Now, I would like to move items in my folder to the “Network Analysis” folder.<\/p>\n

Can I create a rule to do that automatically?<\/p>\n

Unfortunately “library settings” takes me to the overall page.<\/p>\n

When selecting all three,<\/p>\n

Key features are disabled for my level of user settings:<\/p>\n

E-mail a link
\nSend-to<\/p>\n

Even “Download a copy” is disabled.<\/p>\n

Doesn’t seem right?<\/p>\n

Perhaps click only one?<\/p>\n

Try that.<\/p>\n

Ah, “Send to” is enabled!<\/p>\n

“Download a copy” is enabled!<\/p>\n

How dumb though, that you cannot “send to” en massed.<\/p>\n

Could I send an entire folder?<\/p>\n

Destination document library or folder –<\/p>\n

https:\/\/utworks.tennessee.edu\/cics\/dataone\/Network Analysis\/<\/p>\n

I have to type this in. Annoying.<\/p>\n

Also – the “test” did not work<\/p>\n

https:\/\/utworks.tennessee.edu\/cics\/dataone\/Network%20Analysis\/<\/p>\n

I clicked the check box next to it to see if I can get a link.<\/p>\n

Not possible, “e-mail a link” is disabled.<\/p>\n

Click “Network Analysis” and “View Properties”<\/p>\n

Clicked “edit item”<\/p>\n

Only option is “Name”<\/p>\n

Not really useful.<\/p>\n

Clicked “copy”
\nNetwork Analysis<\/p>\n

Trying “send to” again – this time
\nhttps:\/\/utworks.tennessee.edu\/cics\/dataone\/network analysis<\/p>\n

“Status errors”
\nCould not find the destination item or folder on this server<\/p>\n

I think the best option will be to e-mail Dr. Davis to see if she has some info on how to move the document from my “tjessel” folder to the “network analysis” folder.<\/p>\n

Tried this:\u00a0https:\/\/utworks.tennessee.edu\/cics\/dataone\/Shared%20Documents\/Network%20Analysis<\/p>\n

Wow, this was successful!<\/p>\n

But why can’t I move all three at the same time?<\/p>\n

…\/cics\/dataone\/Shared%20Documents\/Network%20Analysis\/DataONE_Annual_Report_Year3_v3.docx
\n\u00a0<\/span>\u00a0The copy completed successfully.<\/p>\n

Now to confirm:<\/p>\n

Note: it is still in the original folder, but a copy<\/p>\n

Also tried to create sub-folder, “Annual Reports,” but apparently it is not possible to move a folder. \u00a0This could be a frustrating bottle-neck in the workflow. \u00a0I still think I should ask Dr. Davis if she knows how to move multiple documents, or if she has a contact who can explain a better way.<\/p>\n","protected":false},"excerpt":{"rendered":"

Interested in possibility of forwarding e-mail to both open notebook and sharepoint site. This would streamline the process of archiving documents on the UT Sharepoint site. Looking at: DataONE > UT DataONE > Documents > Network Analysis > All Documents Google Search: Sharepoint AND e-mail AND upload Found this: http:\/\/sharepoint.stackexchange.com\/questions\/13589\/how-to-upload-documents-by-sending-an-email Continue reading Open Notebook Science – E-mailing Attachments to Sharepoint<\/span>→<\/span><\/a><\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[54,188,187,168,186,185,169],"_links":{"self":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/1730"}],"collection":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/comments?post=1730"}],"version-history":[{"count":3,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/1730\/revisions"}],"predecessor-version":[{"id":1733,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/1730\/revisions\/1733"}],"wp:attachment":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/media?parent=1730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/categories?post=1730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/tags?post=1730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}