Author Topic: Export Speed Dial Lists  (Read 5647 times)

Offline colcoleman

  • New Member
  • *
  • Posts: 3
  • Country: us
  • Karma: +0/-0
    • View Profile
Export Speed Dial Lists
« on: March 14, 2013, 09:42:27 AM »
Mitel 5000_5_0 SP2.

We have several hundred numbers in the Speed Dial listing.    When I export Speed Dial List to CSV and then pull into Excel, some of the phone numbers import in scientific format (e.g., 1.14962E+12).  When I reformat the cells to NUMBER with "0" decimal places, many of the numbers are incorrect.

Is there a way to change the export format?



Offline DND ON

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 908
  • Country: us
  • Karma: +23/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #1 on: March 14, 2013, 09:52:18 AM »
Make the column wider, so all the numbers appear.

Offline colcoleman

  • New Member
  • *
  • Posts: 3
  • Country: us
  • Karma: +0/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #2 on: March 14, 2013, 10:09:09 AM »
It doesn't matter how wide i make the column (before changing cell format to NUMBER w/"0" decimal places) - it still shows in scientific format (see attached).  And after I change format, many of the numbers are wrong - only the last several digits. 

Offline DND ON

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 908
  • Country: us
  • Karma: +23/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #3 on: March 14, 2013, 10:51:48 AM »
Did you try exporting as text file instead of CSV?

Offline colcoleman

  • New Member
  • *
  • Posts: 3
  • Country: us
  • Karma: +0/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #4 on: March 14, 2013, 11:19:53 AM »
The only choice in the drop-down when I "export" is CSV - no option for TXT (see attached)

Offline DND ON

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 908
  • Country: us
  • Karma: +23/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #5 on: March 14, 2013, 12:17:23 PM »
I guess the .txt option was added in version 5.1; never noticed before. However, I was able to export a version 5.0 speed dial list to CSV and open it with no problem in Excel.

Offline mattybrownuk

  • Jr. Member
  • **
  • Posts: 41
  • Country: england
  • Karma: +0/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #6 on: March 14, 2013, 05:17:00 PM »
Hi

Have you tried formatting the phone number to text?  A "number" does not have leading zeros or multiple decimals, which is why in a database or an excel spread sheet, a phone number can only be stored as a string (text).

Matty Brown

Offline acejavelin

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4099
  • Country: us
  • Karma: +133/-0
  • High-tech, heavy metal redneck!
    • View Profile
    • Like what I do and wanna help out? Send me a donation!
Re: Export Speed Dial Lists
« Reply #7 on: March 14, 2013, 05:46:16 PM »
This is an Excel issue, and not a CSV or 5000 issue. I would bet if you take the raw CSV file and open it in Notepad, the numbers are correct. Some versions of Excel will take long numbers and put them into scientific notation by default. You might have to highlight that column and change the type of field to something else.

Offline sarond

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1404
  • Country: au
  • Karma: +73/-0
    • View Profile
Re: Export Speed Dial Lists
« Reply #8 on: March 14, 2013, 08:05:58 PM »
This is an excel issue.
Basically you need to import the text, not just open it.
Check this out for a step by step.

http://www.howtogeek.com/howto/microsoft-office/how-to-import-a-csv-file-containing-a-column-with-a-leading-0-into-excel/


 

Sitemap 1 2 3 4 5 6 7 8 9 10