Controllerless Networks

last person joined: 20 hours ago 

Instant Mode - the controllerless Wi-Fi solution that's easy to set up, is loaded with security and smarts, and won't break your budget
Back to discussions
Expand all | Collapse all

Date format error on Airwave while generating Reports

This thread has been viewed 0 times

  • 1.  Date format error on Airwave while generating Reports

    Posted Feb 06, 2014 05:44 AM
      |   view attached

    Hi All ,

     

    Please go through the attached screen shot and let me know why the date format is varying from each other on the same report.

     

    Thanks in advance

    Nithin 



  • 2.  RE: Date format error on Airwave while generating Reports

    EMPLOYEE
    Posted Feb 06, 2014 07:48 AM

    Is that a CSV in Excel?



  • 3.  RE: Date format error on Airwave while generating Reports

    Posted Feb 06, 2014 08:12 AM

    yes its CSV  in Excel



  • 4.  RE: Date format error on Airwave while generating Reports

    EMPLOYEE
    Posted Feb 06, 2014 08:17 AM

    Could you post a screenshot of the same file but opened up in a text editor like Notepad? It could be that Excel is autoformatting the data.



  • 5.  RE: Date format error on Airwave while generating Reports

    Posted Feb 06, 2014 08:34 AM
      |   view attached

    please find the attached file.

    Attachment(s)

    txt
    sessions_notepad.txt   353 KB 1 version


  • 6.  RE: Date format error on Airwave while generating Reports

    EMPLOYEE
    Posted Feb 06, 2014 08:37 AM

    OK, it looks like the CSV data is consistent but Excel is reformatting some of it. The easiest thing to do would be to select the column header and change the format for the entire column to the one you want.



  • 7.  RE: Date format error on Airwave while generating Reports

    EMPLOYEE
    Posted Feb 06, 2014 02:08 PM

    Yeah, it looks like Excel is formatting the dates differently.  I typically format the cells as category: text (highlight column, right click, format cell) to avoid any interference from Excel trying to predict the data format.



  • 8.  RE: Date format error on Airwave while generating Reports

    Posted Feb 19, 2014 01:10 AM

    we got following reply from Aruba support.

     

    Tested few reports in our lab, the date and time values in “Connect Time” and “Disconnect Time” are getting shuffled. When we run the report to export that to a CSV file, the information is fetched from Airwave Database and the transfer of data to the csv file is based on how the data is stored in database. It is the expected behavior that the values can get shuffled based on how it is stored in Airwave Database. Once we have the complete data available on the csv file, the only option to sort this is from csv file in ascending or descending order.

     

    Nithin