Thanks Ross and Jesus. Shafqat Ayaz
From: "Mitcham, Ross" <ross_mitc...@bmc.com> To: arslist@ARSLIST.ORG Sent: Tuesday, June 16, 2015 9:33 PM Subject: Re: Data Management Job Another Problem **#yiv5712843592 #yiv5712843592 -- _filtered #yiv5712843592 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv5712843592 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5712843592 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5712843592 {panose-1:2 11 6 9 4 5 4 2 2 4;} _filtered #yiv5712843592 {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv5712843592 #yiv5712843592 p.yiv5712843592MsoNormal, #yiv5712843592 li.yiv5712843592MsoNormal, #yiv5712843592 div.yiv5712843592MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv5712843592 a:link, #yiv5712843592 span.yiv5712843592MsoHyperlink {color:blue;text-decoration:underline;}#yiv5712843592 a:visited, #yiv5712843592 span.yiv5712843592MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv5712843592 p.yiv5712843592msonormal, #yiv5712843592 li.yiv5712843592msonormal, #yiv5712843592 div.yiv5712843592msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5712843592 p.yiv5712843592msochpdefault, #yiv5712843592 li.yiv5712843592msochpdefault, #yiv5712843592 div.yiv5712843592msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5712843592 span.yiv5712843592msohyperlink {}#yiv5712843592 span.yiv5712843592msohyperlinkfollowed {}#yiv5712843592 span.yiv5712843592emailstyle17 {}#yiv5712843592 p.yiv5712843592msonormal1, #yiv5712843592 li.yiv5712843592msonormal1, #yiv5712843592 div.yiv5712843592msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv5712843592 span.yiv5712843592msohyperlink1 {color:#0563C1;text-decoration:underline;}#yiv5712843592 span.yiv5712843592msohyperlinkfollowed1 {color:#954F72;text-decoration:underline;}#yiv5712843592 span.yiv5712843592emailstyle171 {color:#1F497D;}#yiv5712843592 p.yiv5712843592msochpdefault1, #yiv5712843592 li.yiv5712843592msochpdefault1, #yiv5712843592 div.yiv5712843592msochpdefault1 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv5712843592 span.yiv5712843592EmailStyle27 {color:#1F497D;}#yiv5712843592 .yiv5712843592MsoChpDefault {font-size:10.0pt;} _filtered #yiv5712843592 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv5712843592 div.yiv5712843592WordSection1 {}#yiv5712843592 Make sure in your spreadsheet that this column (and others like it) are text format, you should see this below. In later versions of ITSM, macros are provided with the spreadsheets to automatically fix the formatting | | | | | Ross Mitcham | | Lead Product Developer | | | Direct | | +1 905.707.3534 | | | 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada | | | | | | | | | | | | | | | From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Shafqat Ayaz Sent: Tuesday, June 16, 2015 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Data Management Job Another Problem ** Hi All Another issue coming up. While loading People data using BMC templates the telephone number is being imported as a decimal value, for example a phone number of 01913558976 is showing up as 01913558976.0 Any help would be appreciated. Shafqat Ayaz _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"