This is a public Discussion Forum  public

Topic

    Michael Calder
    Inventory Report Sort
    Topic posted February 13, 2014 by Michael CalderNovice, tagged how-to 
    551 Views, 6 Comments
    Title:
    Inventory Report Sort
    Shure Hardware:
    WW6 6.9.0.45
    Description:

    How do I sort the Inventory Report? I've looked everywhere in the program and can't find an answer in the forums.

    Answer

     

    • buhmanb

      Currently the Inventory Report viewer (and PDF export) are hard coded to sort by:

      1. Zones, then within each zone:
        1. Group of all "Active Channels"
          1. Model Name 
          2. Band
          3. Channel Name 
          4. Frequency
        2. Group of all "Backup Frequencies"
          1. "Type"  - e.g. Axient, PSM1000, etc.
          2. Band
          3. Frequency

      One way you could accomplish some kind of sorting is to Export the inventory report as "CSV" 

      Then open that ".csv" file in a spreadsheet application, select the desired sections and use the spreadsheet for your custom sorting.

      Yes - it takes some extra work to remove the undesired fields from spreadsheet before sorting, but maybe this can help you short term.

      We'll put in a feature request to be able to sort the reports directly in WWB.

       

    • Maggus

      that would be a nice feature. Actually I have the same problem with many different kinds of receivers at one single location. sort-options would be fine!

       

    • johnlandsman

      Sorting of the Report would really be nice.  Simply put, if the formatting followed the Inventory page, that would be enough.  :)

      Thanks!!

    • roba

      Could the alphabetical sorting of names be extended to recognise numbers please? Currently a list of ten mics numbered 1-10 is sorted:

      Mic 1, Mic 10, Mic 2, ....., Mic 9

       

    • Dom Eve

      Really need this feature, it seems to sort things seemingly randomly most of the time. If it follows the rules as you say it should sort items of a similar type, model and range purely by frequency. However it does not, which can be frustrating when trying to list frequencies numerically.

    • mikekahrs

      You can write a macro in Excel that takes the CSV file and formats it to your liking. I do it when I export IAS to Excel.  (Easier on a PC)  Then you can sort as you need.   If I can do it you can : )

      I number mics A1, B2, C3, D4...  PITA but it works, for me.

     

    © 2009-2014 Shure Incorporated All rights reserved.
    • Privacy
    • Powered by RightNow