[Pansophy] Datamine export

[Mike Dickey]

Hi Tiffany,

I have been looking into ways to encourage Excel to not auto format serial numbers in general.  Many of the serial numbers have leading zeros, which disappear when exported to Excel.

Per your options below.

1.  Pretty much everywhere there is an Excel button, we would have to add code to those pages to generate the CSV files.  There are a lot of pages that would need modified.

2.  The serial numbers are recorded in many database tables.  Generally 2 tables for inventory, and any travelers where the corresponding acronym is used (INV, INSP, ASSY, NCR, and any process travelers that may be needed).  This would be a cumbersome task, as it would be hand edited.

As I mentioned, I have been looking into a fix for this problem and have a couple of possible solutions to try.  It may be sometime in October before I have something working, but I am working on it as time permits.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Pansophy <pansophy-bounces at mailman.jlab.org> On Behalf Of Tiffany Ganey
Sent: Thursday, September 23, 2021 1:06 PM
To: pansophy at jlab.org
Subject: [Pansophy] Datamine export

Mircea forwarded me an email asking for help preserving the SN format for SNSPPU FPCs during the datamine export to excel.  Some of the FPCSN's have a ##E### format, which excel seems to auto interpret as scientific notation.  I cannot find a way to have excel not change the value to scientific notation if it the pansophy automatically opens in excel.  Can Pansophy datamine do one of the following?
Option 1: export as a txt (or csv) file.  Then when the file is opened in excel, you have the option to format the column as text.  This allows the current data to stay as-is.
Option 2: change the FPCSN to "FPC-##?###" (as an example - just adding something ahead of the SN that changes it enough that it doesn't look like a scientific notation number) This may require that the data already entered has to be updated to match.

Thanks,

Tiffany Ganey

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210923/47c3726a/attachment.html>