yelyah.nodrog Posted March 5, 2018 Share Posted March 5, 2018 Out of interest do we know when a fix will be out for the brokenyear part of the dates when running reports? Hayley. Link to comment Share on other sites More sharing options...
James Ainsworth Posted March 5, 2018 Share Posted March 5, 2018 Hi Hayley, I have had a look but I've not been able to replicate this. Am I right in thinking that your screen shot is from the CSV export and displayed in Excel? If not, let me know where you are viewing this result. The screen shot below is taken from the Data Preview option which is under the Data Collection Tab when creating a report. I was wondering if you get the YYYY displayed here too? Regards, James Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 7, 2018 Author Share Posted March 7, 2018 Hey James, We don't get the error in Data Preview, however we get it in any form of exported report data preview: CSV: PDF: Thanks Hayley. Link to comment Share on other sites More sharing options...
James Ainsworth Posted March 7, 2018 Share Posted March 7, 2018 Hi Hayley, Could you open up the CSV download in Notepad and let me know the format of the date and if the YYYY exists there too. Excel will do a date format conversion based on your regional settings on you computer. I'm not sure about the PDF. If the Data Preview shows the date in the correct format we need to determine at what point the format is changed. Regards, James Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 8, 2018 Author Share Posted March 8, 2018 Hey James, This is what it is saying in Notepad: Request ID,Created by,Team Name,Service Name,Catalog,Catagory,Priority Name,Summary,Date Logged "IN00030652","AshwoD","BLOCK - Networking Team","Network Support","Report a Network Issue","","P3","Unable to connect to GO-EPIC",03-01-YYYY 12:08:32 "SR00030755","AshwoD","Storage and Backup","Infrastructure Support","Storage and Backup (Service Request)","Folder/File Restore (Over 1 week)","P3","Recover 'Letter to local Authority' from backup",04-01-YYYY 08:32:24 "IN00030770","AshwoD","BLOCK - Networking Team","Network Support","Report a Network Issue","","P3","Guest and sponsor portal not working (GP1: https://10.101.83.103:8443/sponsorportal/LoginCheck.action",04-01-YYYY 09:17:08 "SR00031354","AshwoD","Service Desk","Printing","Xerox Printer's (Service Request)","YH Basement","P4","Please allocate a fixed IP for the following printers which are being moved to SW08",09-01-YYYY 11:05:13 "SR00031865","AshwoD","BLOCK - Networking Team","Network Support","Network Support (Service Request)","IP Activation","P3","Chnage static IP reservations for printers being moved from SW02 to SW05",11-01-YYYY 16:09:43 "SR00031952","AshwoD","BLOCK - Networking Team","Network Support","Network Support (Service Request)","Other","P3","Audit the N7K and 6509 chassis to confirm last hardware support date for linecards",12-01-YYYY 10:35:35 "SR00031961","AshwoD","BLOCK - Networking Team","Network Support","Network Support (Service Request)","Other","P4","Commission LoRA access point for internet connected soap dispensers",12-01-YYYY 10:59:57 "SR00032416","AshwoD","BLOCK - Networking Team","Network Support","Network Support (Service Request)","Other","P4","Provide switchport VLAN details in preparation for the tidy up of YH05 hub room",16-01-YYYY 11:48:11 "IN00032592","AshwoD","BLOCK - Networking Team","Telephony Support","Telephony Support (Incident)","","P3","CUCM is operating with an insufficient number of licenses",17-01-YYYY 10:31:42 "SR00032611","AshwoD","BLOCK - Operations Centre","Telephony Support","Telephony Support (Service Request)","Other","P3","Expressway certificates are expiring on FRIDAY 19th January. They need to be renewed.",17-01-YYYY 11:03:26 "SR00032892","AshwoD","BLOCK - Networking Team","Network Support","Network Support (Service Request)","Other","P3","Allow inteng01/02/03 to access PSINE services on N3",18-01-YYYY 14:37:27 "IN00034554","AshwoD","BLOCK - Networking Team","Network Support","Report a Network Issue","","P4","DMARC is blocking polidoris.com domain emails",31-01-YYYY 08:18:39 "IN00031965","BlazeJ","BLOCK - Operations Centre","Telephony Support","Telephony Support (Incident)","","P4","Link to GOSH ISDX Via GO-PABX-VG30D-01 is down",12-01-YYYY 11:10:22 "SR00032631","BlazeJ","BLOCK - Networking Team","ICT Projects","ICT Projects (Service Request)","","R99 (Outside SLA)","EAP-TLS profile for GO-Red on Centrify",17-01-YYYY 11:41:35 Hayley. Link to comment Share on other sites More sharing options...
TrevorKillick Posted March 9, 2018 Share Posted March 9, 2018 @yelyah.nodrog Can you download the report definition and send it over to me please. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 12, 2018 Author Share Posted March 12, 2018 Hey Trevor, the report definition? How do i do that? Hayley. Link to comment Share on other sites More sharing options...
Dan Munns Posted March 12, 2018 Share Posted March 12, 2018 Hi @yelyah.nodrog Open the report from the list and then click the blue download icon highlighted in the screenshot. Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 12, 2018 Author Share Posted March 12, 2018 whoops ok! Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted April 4, 2018 Author Share Posted April 4, 2018 Afternoon @TrevorKillick, apologies' for not responding to this I thought I had and they was on leave and have only just checked up! Here is what you asked for Hayley scheduled-205am---dashboards---list-of-p2-incidents-by-service-monthly-reports.report.txt Link to comment Share on other sites More sharing options...
TrevorKillick Posted April 4, 2018 Share Posted April 4, 2018 @yelyah.nodrog In Admin -> System -> Settings -> Advanced can you search for the setting system.regionalSettings.dateTimeFormat and change the format as you currently have a format set which is invalid with an uppercase YYYY instead of lowercase yyyy which is causing the dates to get incorrectly formatted. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted April 9, 2018 Author Share Posted April 9, 2018 Thats sorted it! Thanks! 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now