EBMS Tickets

As we discussed verbally, we may want to do this version of the report in Excel, to get around the login problems ("Edit with Microsoft Word" won't work) and the garbling of the formats that Word is prone to.

Here's the best I was able to do with copy/paste into Word (without changing the links). See attachment. We can do better with Excel.

While I'm waiting for you and your colleagues to discuss the options for this request, I'm going to see what I can do to make the Word solution better. The approach I'm going to try will involve rendering a custom page which has just the table, dropping all of the web headers, sidebars, footers, request form, etc., so that it's feasible to select the entire page and copy it. Otherwise, for long reports it would be clumsy (to put it politely) to try and select just the parts you want. I suspect, based on similar efforts we've undertaken recently, that using Chrome will produce the most satisfactory results, but we'll experiment to see. In the meantime, if you have any specific requirements that aren't captured in the original request, it would be useful to know about them up front.

If we end up using the approach I described in the previous comment (create a page with a stripped-down version of the report, without the rest of the page shown to the board manager), it would probably be a good idea if the report opened in a new tab, so you wouldn't lose the current options or your menus (the back button wouldn't work here). In order to do that, it would be necessary to use a link instead of another option on the request form (it's not possible to have the form's request submission create both the report and the board manager's request page in two separate tabs at once). In other words, you would generate the report as you currently do, and a link would be present above the table allowing you to ask for the board member version to open in a separate tab. That's probably not a bad workflow model, anyway, as it involves running the report until you're satisfied that it has the information you want in the Word version for the board member, then clicking the link for that version. Does this make sense?

... a link would be present above the table ...

Something along the lines of the [attached screen shot|^2014-08-13 09_21_28-EBMS.jpg], perhaps?

While working on this request, I noticed what may be a bug, but I can't be 100% certain. We're showing (appended to the title in parentheses) the total number of article/packet combinations which don't have any reviews for the packet. However, as we walk through the query results, we suppress the display of articles which have moved on to a stage down-stream from the review process for that packet's topic. Is the total being displayed correct (including the unreviewed articles which moved on in spite of lack of board member review)? Or should it match the number of rows in the report?

The approach I've been working on looks promising, as seen in the attached [example|^Articles Without Responses.docx]. Basically, I ran the report using Chrome, clicked the "Member Version" link, then Select All, Copy, and Paste into a blank Microsoft Word document which had been pre-set to landscape orientation. What do you think?

This does look promising! I'm sending it around to the group to take a look at. We reviewed the earlier Word version you posted in our meeting this afternoon, and I think this update addresses most of our comments.

A couple of requests:

1. Could you please remove the link to the full citation page and from the PMID?
2. Could you please add the links to view the abstract and download the full text of the article? (We would like these to appear beneath each citation in all caps as they are on the search results page, for example.)

As for your question about a possible bug, I am not sure. Adding the number in parenthetical notes is a new enhancement that hasn't been tested (OCEEBMS-206). I will take a look at that and post a comment in that issue.

Another request:

3. Could you please left-justify the headings?

Thanks.

One more:

4. We're concerned that an article with many reviewers may bleed into the reviewers for the following article. Would it be possible to single-space the reviewers' names?

Thanks.

I've made the last two changes:

Before I make the other two changes, let's make sure we're talking about the same links. What I gave you already has links to the abstract and the full text of the article. I replaced the link from the article title to the "Full Citation" page with a link to the article's full text and the link from the PMID connects to the abstract (as it always has for this report). Your comment makes me think it's possible that I don't really understand what you want the targets of these links to be.

This looks good and the links are fine. As we discussed today, please add the number in parentheses from the report output once the logic has been updated as I just requested in OCEEBMS-206. Thanks.

Ready for user review on DEV.

As Bob stated, this works best in Chrome. Verified on DEV.

I almost thought there was a problem with this report because some of the articles did not have links (i.e., their titles were not clickable). Then I realized that these were older articles that do not have full text in the EBMS. Just adding this comment on the off-chance that it might be useful at some point.

Verified on QA.

Verified on PROD.