[Pansophy] Report(s) export to Excel

[Jacob Harris]

Hi David,
Thanks for getting this working. A few comments about the NCR Op/Cl export to excel, which may apply to other excel exports too...

  1.  The SN field appears in excel as a number, which strips the leading zeros. Suggest making it a text string.
  2.  The Date fields are a date:time down to the tenth of a second, which excel doesn't recognize as dates. Fixable using a concatenate/format function, but suggest listing only the dates.
  3.  The NCR Link field in excel doesn't appear to be a url.
  4.  The fields in excel don't match the fields in the presented data table, but it's also not every field being exported. There are some missing, e.g. Final Comment.
  5.  Suggest removing columns such as Max Page and Traveler Open, which are not useful/usable by a user.

Jacob

From: David Parham
Sent: Wednesday, December 8, 2021 2:18 PM
To: Jacob Harris <jharris at jlab.org>; E. Anne McEwen <mcewen at jlab.org>; Tony Reilly <areilly at jlab.org>; Michael Drury <drury at jlab.org>; John Fischer <fischer at jlab.org>; Danny Forehand <forehand at jlab.org>; Ashley Anderson Mitchell <ashleya at jlab.org>; Liang Zhao <lzhao at jlab.org>; Allen Samuels <samuels at jlab.org>; An Nguyen <anguyen at jlab.org>; Enqian Zheng <zheng at jlab.org>
Subject: Report(s) export to Excel

All,

As of 12/8/2021 export to excel is currently working now for NCR and all other reports. However, some of the functionality(front, bold, etc) is still in progress.

Please let me know if there are any questions and/or concerns.

v/r,
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20211208/49470470/attachment-0001.html>