Avaya Support Forums  

Go Back   Avaya Support Forums > Enterprise PBX Communications Systems

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-09-2015, 06:31 AM
abiurr abiurr is offline
Member
 
Join Date: Jun 2015
Posts: 6
abiurr has 10 reputation points
Default 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.
Reply With Quote
  #2  
Old 06-09-2015, 07:41 AM
lynnt lynnt is offline
Member
 
Join Date: May 2015
Posts: 8
lynnt has 10 reputation points
Default

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
Reply With Quote
  #3  
Old 06-09-2015, 08:04 AM
abiurr abiurr is offline
Member
 
Join Date: Jun 2015
Posts: 6
abiurr has 10 reputation points
Default

Quote:
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.
Reply With Quote
  #4  
Old 06-09-2015, 09:35 AM
lynnt lynnt is offline
Member
 
Join Date: May 2015
Posts: 8
lynnt has 10 reputation points
Default

What version is your ASA? I'll see how it behaves with mine later today.
Reply With Quote
  #5  
Old 06-09-2015, 12:06 PM
lynnt lynnt is offline
Member
 
Join Date: May 2015
Posts: 8
lynnt has 10 reputation points
Default

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
Reply With Quote
  #6  
Old 06-09-2015, 12:21 PM
lynnt lynnt is offline
Member
 
Join Date: May 2015
Posts: 8
lynnt has 10 reputation points
Default

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
Reply With Quote
  #7  
Old 06-10-2015, 01:04 AM
abiurr abiurr is offline
Member
 
Join Date: Jun 2015
Posts: 6
abiurr has 10 reputation points
Default

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.
Reply With Quote
  #8  
Old 06-10-2015, 01:40 AM
abiurr abiurr is offline
Member
 
Join Date: Jun 2015
Posts: 6
abiurr has 10 reputation points
Default

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.
Reply With Quote
  #9  
Old 06-10-2015, 03:53 AM
abiurr abiurr is offline
Member
 
Join Date: Jun 2015
Posts: 6
abiurr has 10 reputation points
Default

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,
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 12:15 AM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.