Export to CSV

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • abiurr
    Member
    • Jun 2015
    • 6
    #1

    Export to CSV

    Hello Everybody.

    I’m trying to export to CSV file two columns (Called Number and Insert) from the inc-call-handling-trmt. Well, the CSV file doesn’t come in columns, instead, the CSV come with two lines with all the data. The first one with the Titles (Good), the other line has all the data separately by commas; I will give you an example:

    Caller Number (*),Insert (*)
    123456789,987654321,123654987,123456987,765765234, ,,,87654,87651,54321,97542,12345

    The Right CSV has to be something like this:

    Caller Number (*),Insert (*)
    123456789, 87654
    987654321, 87651
    123654987, 54321
    123456987, 97542
    765765234,12345

    I that a really need is a CSV with Telephone Number, Name and Extension.
    The Avaya admin told me that I have to export the telephone and the name from Station report and the telephone and extension from inc-call-handling-trmt. Then I will do a Powershell that match all the data in one.

    How can I do?

    Thanks in advance and have a nice week,

    Angel Biurrun.
    Tags: None
  • lynnt
    Member
    • May 2015
    • 8
    #2
    Are you using ASA? I assume so. Are you using the report item or are you exporting? Or are you exporting once you have the data in view using GEDI?

    If exporting (shortcut key CTRL+t), you can certainly limit your data to two columns using the field chooser in the 2nd page of the wizard.

    Then, as previously stated, if you have the Name and Extension number exported, you can match them up as the Avaya engineer said or use a VLOOKUP() function in Excel.

    Tom

    Comment

    • abiurr
      Member
      • Jun 2015
      • 6
      #3
      Originally posted by lynnt View Post
      Are you using ASA? I assume so. Are you using the report item or are you exporting? Or are you exporting once you have the data in view using GEDI?

      If exporting (shortcut key CTRL+t), you can certainly limit your data to two columns using the field chooser in the 2nd page of the wizard.

      Then, as previously stated, if you have the Name and Extension number exported, you can match them up as the Avaya engineer said or use a VLOOKUP() function in Excel.

      Tom
      Hello lynnt.

      I'm using ASA, Advanced Tap/Export Data Wizard.
      Exactly, in the second page I choosed two fields, but the csv is as I explained in my first example:
      EX1 (Bad CSV):
      Caller Number (*),Insert (*)
      123456789,987654321,123654987,123456987,765765234, ,,,87654,87651,54321,97542,12345

      It Should be:
      Caller Number (*),Insert (*)
      123456789, 87654
      987654321, 87651
      123654987, 54321
      123456987, 97542
      765765234, 12345

      How can I resolve the problem?

      Thanks in Advance.

      Have a nice week.

      Angel Biurrun.

      Comment

      • lynnt
        Member
        • May 2015
        • 8
        #4
        What version is your ASA? I'll see how it behaves with mine later today.

        Comment

        • lynnt
          Member
          • May 2015
          • 8
          #5
          Well, I'm here to tell you that I get no usable data using ASA to export incoming call handling treatment. If I export all fields, I notice that I get the trunk group number, a service type, but all other fields are empty. The tool attempts to put the entire table for each trunk group on a single line. Presumably, you're supposed to then split each line for each field and line them up, which might be doable if the actual values were present, but I just get empty values where I know there should be data.

          I think it's completely broken. Good luck w/remediation because Avaya isn't doing new development on ASA as far as I can see.

          The Systems Management Web Service (SMS) in AES does return valid data, but this route requires some scripting skills outside of using the test request page.

          Tom Lynn

          Comment

          • lynnt
            Member
            • May 2015
            • 8
            #6
            Having looked at all the options, I think you're better off using the advanced/report tool to print a screen capture to file. Then put it into excel and split the lines using fixed columns. I think it involves less effort than struggling with a broken export interface. Good luck.

            Tom Lynn

            Comment

            • abiurr
              Member
              • Jun 2015
              • 6
              #7
              Many thanks for all your help lynnt.

              The versión that I'm use is 5.0.11.
              I have to create an automatic task that generate the reports, that means that I will use the reports an I will fix the CVS with Powershell.

              Have a nice week.

              Angel Biurrun.

              Comment

              • abiurr
                Member
                • Jun 2015
                • 6
                #8
                Hello Lynnt

                I cannot find a screen report that give t me the Number and the Extension as export_inc-call-handling-trmt advanced export data report.

                Have a nice week,

                Angel Biurrun.

                Comment

                • abiurr
                  Member
                  • Jun 2015
                  • 6
                  #9
                  Who know another way to list number and the extensión, named in report "export_inc-call-handling-trmt" called number and insert?

                  Many Thanks to all and have a nice week,

                  Comment

                  Previous template Next
                  Loading