search cancel

Date format in CSV varies within the same report

book

Article ID: 201234

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

When viewing an exported report from CAPC in unscaled csv, the date format seems inconsistent.


An example below:

    09/12/2020 17:00    0.481407
    09/12/2020 18:00    0.472109
    09/12/2020 19:00    0.472195
    09/12/2020 20:00    0.473063
    09/12/2020 21:00    0.473435
    09/12/2020 22:00    0.499793
    09/12/2020 23:00    0.485768
9/13/20 0:00    0.476173
9/13/20 1:00    0.474971
9/13/20 2:00    0.371966
9/13/20 3:00    0.472035
9/13/20 4:00    0.510429
9/13/20 5:00    0.469157
9/13/20 6:00    0.472527
9/13/20 7:00    0.475987
9/13/20 8:00    0.476372
9/13/20 9:00    0.473769

Cause

Cell formatting was inconsistent in the rendering tool used, in this case excel.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Open the raw CSV file in a text editor like notepad++ and verify that CAPC is exporting the data in a consistent format.

Adjust or switch the tools you are opening the file with.

Additional Information

Original issue 32266321