Service Desk Practitioners Forum
cancel

importing telephone numbers into person record....

SOLVED
Go to solution
Highlighted
Isaac Kingsly
Frequent Contributor.

importing telephone numbers into person record....


Hi all,
Iam trying to import the telephone numbers from an excel sheet into the person record, but during the export to xml file the number is exported in scientific form ( to the power of E, type string ). can someone tell me where can I change the related configuration settings or otherwise how can this issue be solved,
Thanks in advance
6 REPLIES
Akies
Outstanding Contributor.

Re: importing telephone numbers into person record....

Hi,

Just right click on the telephone column of in the excel sheet.Go to format cells and choose type as number with decimals as 0 places and format as 1234.1.

hope this helps.

Regards,
Akhil
Isaac Kingsly
Frequent Contributor.

Re: importing telephone numbers into person record....

Hey Akhil,
I had already tried it out, but it's the same thing again.
Jorge Castilla_
Super Contributor.

Re: importing telephone numbers into person record....

Hi Isaac,

Try this utility for excel, is really good to convert all the number to text with predefined macros: http://www.asap-utilities.com/ and very useful dealing with excel files when you are importing information in Service Desk.

Rgds,

Rgds,
David Borojevic
Outstanding Contributor.
Solution

Re: importing telephone numbers into person record....

Hi Isaac,

Yes Excel + ODBC can be strange. Try inserting a new column next to the phone, and use the formula =TEXT(A1,"0") and import those values instead. (A1 of course should be whatever the phone column is).

We use this to correct a serial number import that was behaving as you have described. We also couldn't get Format Cells to help.

Cheers

Isaac Kingsly
Frequent Contributor.

Re: importing telephone numbers into person record....

Thanks a lot david. This works, and that's exactly what I did. though it solves the problem, it seems to be a temporary solution. once again thanks alot....
regds,
Isaac
Isaac Kingsly
Frequent Contributor.

Re: importing telephone numbers into person record....

solved