Direct posts to OLCCFAC trigger an message saying the email was delivered, because OLCCFAC was subscribed to OLCCFAC. This was because OLCCFAC is a closed list, and only emails subscribed to OLCCFAC could post to OLCCFAC, and I thought that when OLCCFAC subcribed to comments on a paper, the email was coming from OLCCFAC. But I think I was wrong, and it was coming from the site, OLCC.Divched.org.
So I just unsubscribed OLCCFAC from OLCCFAC, and am now logged in as OLCCFAC, and seeing if OLCCFAC can post a comment to a paper that OLCCFAC is subscribed to. IF this works, then a direct post to OLCCFACT (in contrast to a comment on a paper OLCCFAC is subscribed to), should [hopefully] stop sending an email. If this does not work, there is no problem, and you will not get this email.
Cheers,
Bob
We did not properly vet this method before sharing. It worked on one person's device but we have since not been able to repeat it on any others. We are looking into it further and will update.
I just checked your spreadsheet in Excel 2010 32-bit on a Windows 7 virtual machine and it does not work for me (as expected). In the screenshot, you can see the error that result when the WEBSERVICE function is calculated there. Last rows have not been recalculated.
So, the original indent was that CAS #'s were unique. However, as the list of chemicals given a CAS # grew (its now over 101 million) and the complexity of molecules got larger so chemicals (actually quite a few) were given additional CAS #'s. So, they are not unique but the InChI is...but more about that later in the course.
In a general sense the CIR site is the best and the only site that is specifically a chemical identifier converter (resolver). Other sites you can use to do the same process are <a href="http://pubchem.ncbi.nlm.nih.gov">http://pubchem.ncbi.nlm.nih.gov</a> and <a href="http://chemspider.com">http://chemspider.com</a>.
Absolutely, we should be able to get one by Thursday. We found that when opening files created in excel 2013, the functions still worked. We believe that the script for the function must be saved within the sheet itself.
Although I am not be able to check your approach right now (I will report back as soon as I have a virtual machine set up), it doesn't make sense to me. Could you post a screencast video showing us how you tested it?
In any case, I see two elements that may provoke a misinterpretation there: (1) an older file type is not the same as an older version of Excel (WEBSERVICE will work in Excel 2013 even if you save your file in an earlier format), (2) when you open a file that have some functions that not available in your current Excel version, the software may keep the values that were saved with Excel 2013; a manual calculation of the whole worksheet (F9) should make clear whether the function is working or not.
We have figured out a way to get the webservice function to work in older excel versions. I have uploaded a file created in 2013 excel. If using an older version, all you have to do is open my file with your version, clear all of the contents on my sheet, and paste your table. You will now be able to use the webservice function. Likewise, you can copy and paste my table into an older version and get the same results.
In the module above, it discuss the creation of "Group Libraries" - once you create a group library and invite others in your group (Groups -> "Manage Members"), all resources that you put into that folder will automatically be shared with everyone in your group. This is what we call "The cloud" - things are all shared on Zotero's servers and your own Zotero will sync automatically. Thus, if a partner saves some reference into your group's folder, it will show up next time you log in or sync your Zotero standalone (happens automatically, or you can force it using the icon that looks like two arrows going in a circle). Once you set up the group, you shouldn't have to actually go to the Zotero website again.
I hope this helps! Ask another question after playing around with the Groups on Zotero if you need to!
TEST
We did not properly vet this
Enabling webservice function... - not working in Excel 2010
I just checked your spreadsheet in Excel 2010 32-bit on a Windows 7 virtual machine and it does not work for me (as expected). In the screenshot, you can see the error that result when the WEBSERVICE function is calculated there. Last rows have not been recalculated.
Citations
CAS #'s not unique?
Resolvers
Absolutely, we should be able
Enabling webservice function... - please check again
Dear John,
Although I am not be able to check your approach right now (I will report back as soon as I have a virtual machine set up), it doesn't make sense to me. Could you post a screencast video showing us how you tested it?
In any case, I see two elements that may provoke a misinterpretation there: (1) an older file type is not the same as an older version of Excel (WEBSERVICE will work in Excel 2013 even if you save your file in an earlier format), (2) when you open a file that have some functions that not available in your current Excel version, the software may keep the values that were saved with Excel 2013; a manual calculation of the whole worksheet (F9) should make clear whether the function is working or not.
Enabling webservice function in older excel versions
Shared Group Libraries
Thanks for the comment, Kendia!
In the module above, it discuss the creation of "Group Libraries" - once you create a group library and invite others in your group (Groups -> "Manage Members"), all resources that you put into that folder will automatically be shared with everyone in your group. This is what we call "The cloud" - things are all shared on Zotero's servers and your own Zotero will sync automatically. Thus, if a partner saves some reference into your group's folder, it will show up next time you log in or sync your Zotero standalone (happens automatically, or you can force it using the icon that looks like two arrows going in a circle). Once you set up the group, you shouldn't have to actually go to the Zotero website again.
I hope this helps! Ask another question after playing around with the Groups on Zotero if you need to!