Better collaboration for better solutions

Excel Export Option for Vehicles List

In AVL, a user currently has the ability to export vehicle history reports to an Excel file. I would like to suggest adding similar functionality to the vehicle tab. This would allow myself, the current site admin, to query out different vehicles and filter for devices not reporting to the server in Excel. I would also be able to send comprehensive or specific vehicle group lists to others within within the organization. This would also be a useful tool, as it would allow me to not have to export out the vehicle list from SQL. The drawback of pulling out vehicle lists from the database, is often times particular fields are represented by IDs rather than name. An example of this would be BusinessGroupID and VehicleTypeID. It would be much more useful to myself, to see the actual name of those fields in lieu aliases. 

  • Guest
  • Jun 26 2017
  • Accepted for Roadmap
  • Attach files
  • Guest commented
    27 Jul, 2017 05:19pm

    Hi Lily,

    Thank you so much for checking into this issue for me. I look forward to seeing such functionality being implemented into the AVL platform. It will allow me to use vehicle information so much more convenient and effectively.

    Let me know if you need anything else from my end.

    Bryan Haikin

  • Admin
    Lily Ligocki commented
    27 Jul, 2017 05:13pm


    Thank you for sharing your suggestion with us.  The CCB (Change Control Board) has reviewed this, and we see no reason why the Vehicle view could not be made exportable also.  We have added this to our product enhancement backlog.  Holly from Product Design will also connect with you, to learn more about the queries you hope to make from this list, as we would like to improve the filtering and searching capabilities within WorkSpace, to minimize the need to export to answer the questions you may have.  Feel free to also add any more thoughts you have, to this idea ticket.

           Lily L