Office Word: Update cross reference when using Mendeley

I'm using a lot of cross reference in my word document. There is a need to update those cross references when tables/figures have been inserted (in case of before existing ones).

Usually, you only need to select all text (Ctrl+A), right click, and select "Update Fields" for the pop-out menu. But after I installed Mendeley (a reference tool, like Endnote) plug-in, this method could not work because the option of "Update Fields" went grey and you cannot choose it. I guess this is because the word does not know how to update those Mendeley references as they are using the same function of the built-in cross reference.

Recently, I found a trick from my friends to walk around this. All you need to do is select "Print" and the word will bring you the print preview page. Simply close the preview page and you will find all the cross reference have been updated automatically. I think the mechanism behind this is the word try to update all the reference fields before print and it just ignores those it cannot update (not like in the previous situation, it will prevent you to do so).

In a sum, this solution is:


Select "Print" -> Exit the print preview -> All the fields updated automatically.

[Collaboration Workshop 12] The future of scientific software developer (researcher developer) in academia

Collaboration Workshop 12, Oxford

During 21st and 22nd March, the Collaboration Workshop 12 was taking place at Queen’s College of Oxford University.  The workshop mainly focused on the software development in academic projects and attracted more than fifteen researchers and developers. Thirty two topics were raised and discussed during the two day event and more than twenty lightning talks were presented.

Among these discussions and topics, I was enjoying the ones that were related to the collaboration between scientific researchers and software developers and a possible new specie for academic research projects - scientific software developer, who acts between the two or plays a dual role in the research.

Who / What is Scientific Software Developer

Alongside the rapid development of computer and computer technology, most of the recently scientific researches will be involved computer software or software development (In the workshop, someone(somewhere) mentioned 40% of research projects were linked to software but I forgot where I found it). We had topic about “Teaching programming to scientist” and “Successful collaboration with computer scientists”, which provided some nice suggestions. There are some natural limitation with above approaches. For example, the strength of a scientist lays on his/her research ability and if he/she starts to cars about programming he/she may lost focus. The computer scientists (it was changed to software developer for clarification during the discussion) usually cares about the quality of the software and cannot aware the research process.

So we need someone who can act the both roles and carry a software project toward success. Someone knows the natural of research and also is familiar with principles of software development.

Currently status of Scientific Software Developer

It is quite common that the researchers do the programming themselves and as we known this usually result in a poor, non-reusable, non-maintainable software.

EPSRC only invested £9 million per annum in software during the past five years. Comparing to the budget of £950M for the year 2012/2013, the software seems definitely ignored.

Similar role does exists but unfortunately there is a lack of identification and the person who does this job has usually not been recognised properly. Such person may be treated as a RA or RF, although he/she does a different job. There are some groups (Scientific Software Development and Management, Computational Science, and Computational Scientists and Engineers) in LinkedIn but we still lack a formal name for this whatever we called new specie.

Gorissen from University of Southampton mentioned they now started to have some posts specialised for scientific software developer. There is one from Imperial University who has similar job. But the we have not heard much of these from other universities. Henji from Microsoft also mentioned Microsoft Research (Cambridge) has “Research Software Development Engineers”, although it is no a academic position.

Where does Scientific Software Developer go?

The main problem with scientific software developer is not a proper name but the lack of career track and path. There isn’t any senior position for such a role. Eventually, you have to follow the route of Research Assistant –> (Research Fellow) –> Lecturer –> Senior Lecturer –> (Reader) –> Professor if you want to develop your career further. But as a scientific software developer you may lack of publications or project grants, which is essential in climbing the ladder in academic (If you decided opting to industry, they may consider you has no practical experience). So basically, you have wasted your time doing this role as it cannot provide your a strong portfolio.

Another problem is in a bid of academic research project, the labour of software developer is usually under-estimated. So there may not exist enough funding for another developer. And from the university point of view, having a pure scientific software developer not subject to any project is a waste and risk in finance, especially in the currently situation of government cutting findings.

What is the future of Scientific Software Developer?

Now, and in the near future, scientific software developer will still be a minority in academia. But things are getting better as Dan Emmerson from EPSRC introduced the Action Plan of “Software as an Infrastructure”. We will expect more funding and job posts in the coming years.

Acknowledgement

First, I would like to thanks all the attends in the workshop and give credit to those who have contributed in the discussion (without them, I cannot write such a topic).

Secondly, I would like to express my special thanks to DevCSI for sponsoring me.

Lastly, Thanks to all the organisers for their hard work and communications.

Disclaimer

This blog does not represent the view of Collaboration Workshop 12. All the opinions are subject to the author.

Tutorial: Use FileStream on SQL server 2008

I've found two good guides to FileStream on SQL server 2008.

1:
Enabling FILESTREAM In The Database, Enabling FILESTREAM on SQL Server 2008.

2:
QL Server 2008 FILESTREAM , LINQ to SQL and FILESTREAM

温格换了5万次人？？

我以前一直觉得国内很多新闻媒体都是标题和内容不符，而且很多时候不加思考胡乱转载。最近看到的一则新闻，让我尤为气愤。真的想大骂，你们转新闻时是不是不经过大脑的？！

事情缘于：上周阿森纳坐阵酋长球场迎战曼联，最终以1-2败北。赛后，教授温格的一次换人引起的媒体的普遍质疑，甚者连当时场上球员都有不解。那是比赛下半场，张伯伦刚刚助攻范佩西攻入扳平的一球，温格做出了一次让人大跌眼镜的换人：用近期表现低迷的阿沙文换下场上表现出色的张伯伦。此时，队长范佩西的表情是：

赛后，天空体育采访温格时，他也承认自己犯了一个战术失误（虽然在记者的追问下，他也不肯明说是什么失误）。采访视频可以才天空体育的官方网站看到：这里。


在这个新闻里，引用了一句话来表示温格坚持自己换人是正确的："I've been a manager for 30 years and have made 50,000 substitutions. I do not have to justify every decision I make to you (the Press). I stand up for it." 翻译成中文就是：我当了30年的教练，换了5万次人。我不需要向你们（媒体）解释我为什么换人。我相信我的决定。

于是，这句话成了事后被引用得最多的，媒体（特别是国内）用来炒作温格自我辩解的噱头。国内相关新闻：
6万阿森纳死忠狂嘘温格 教授:嘘我?我换过5万次人!，espnstar，搜狐， goal.com。
腾讯就更搞笑了，直接改成是范佩西说了：范佩西亲撰文否认与温格矛盾。

或许普通人看了不觉得什么，我在这里就是想说明一下，50000次换人，稍有足球知识的人就知道不可能。为什么呢，我来分析下：

温格1984年开始当主教练，到现在一共大概执教了1300多场比赛（按wikipedia是到2012.01.22一共有1317场）。一场比赛可以换3个人，一个最大就是1300×3=3900. 如果多算一些，算温格有1500场比赛，那就是4500次换人（如果外加什么友谊赛，换人不受限制的，算1万也不够5万啊）。

看网易的相关新闻：温格换人遭球迷狂嘘不认错 辩解称有5000次经验]，就感觉比较实际了。但是5000次，远远没有5万次有震撼力啊。

那么，来考察到底是谁出的错。每次英超比赛结束，天空体育是有对主教练的专访的，因此，天空体育应该可以算是消息发源地。专访的视频是在电视上及时（应该是有剪辑）播出的（上面天空体育网站的链接也有这个视频）。在视频中，我没有听到温格具体提到关于换人次数的解释，他只是说想换人做些改变。不过天空体育网站在相关新闻里面是引用了这么一段的：
"I've been a manager for 30 years and have made 50,000 substitutions. I do not have to justify every decision I make to you (the Press). I stand up for it."。
因为是放在引号里，所以可以认为是温格的原话。但是因为视频里面没有出现相关语句，可以认为有可能是温格口误（个人认为可能性地），或是说5000次，而网站编辑手误写成了50000。

不管是温格口误还是编辑手误，这都应该是一个错误。不少外媒在转载时就把50000换成了many（很多），而且一般都是用“温格辩解自己如何换人”这类标题的。因此，可以感觉到，其他媒体也觉得这个50000不合理，所以没有突出或者干脆换成很多次。反观国内，”五万次换人“成了绝好的新闻标题，特别是球场观众才6万人。估计再下次，标题该改成“6万阿森纳死忠狂嘘温格 教授:嘘我?我能换6万次人!”.

其他新闻领域我不清楚，但是足球这块，在我呆在国外这几年，通过对比国内和国外新闻，深深感受到某些新闻写稿人的知识之匮乏，网站编辑文平之底（我还常在体育新闻里看到错别字的）。我就不禁奇怪了，我们中华文化如此深厚，有见识有底蕴的知识分子是应该大有人在，为什么诸多新闻网站就充斥着如此多了垃圾新闻，标题新闻呢？别说深度评论，就是中肯准确的新闻都难得一见啊。如果没有相关知识，那读者们岂不是容易受误导，以讹传讹？