How can I import an IMEI from an Excel text field to an ServiceNow String field without errors?

[Community Alums]

I am trying to get 15 character IMEI values from Excel into ServiceNow. The Excel source field is text and appears correctly prior to import. The ServiceNow field is a 40 character string field. If I keep the Excel source as text, all values convert to 100000000000 in ServiceNow. If I change the Excel format to number or general, the values change to exponential notation on the Excel spreadsheet. (Example: 351288743564375 becomes 3.51289E+14) and do not convert back on import. I can put a ' at the beginning of the IMEI but that creates audit issues as integration sources provide the IMEI without the marker. (Example: '351288743564375) The integration source does not recognize the existing records that have the marker. I looked in the Community and found information on matching the data source field type to the ServiceNow table field type. That did not work.  

[Community Alums]

I am answering my own question because I just figured out the solution. 

(1) Set up the IMEI as Text field in the Excel data source spreadsheet

I created a copy of the spreadsheet data source with Serial number and IMEI. I copied the IMEI values to a new column and pasted using "Paste special" then selected "Value and numbers format".

(2) I went to the Import Set Tables through the Navigation Pane and opened the Import Set Table that I used for the transform. 

(3) From the Import Set table list view- I went to the submenu Configure>Table

(4) This opened the Import Set Table view of Tables and Columns

(5) I reviewed the IMEI field. ServiceNow changed the field type on the Import Set table to "Floating Decimal Point".

(6) I deleted the existing IMEI field 

(7) I created a new IMEI field of Type = String and Max Length = 40

(8) I selected Save then Update which brought me back to the Import Set list view. 

(9) I closed the Import Set by putting Load Data in the Navigation Pane

(10) I loaded the data again, used the Import Set and Transform Map. The IMEI remained in the correct format. 

There may be shorter ways to do this. Also, I may need to check the Import Set on a regular basis to see if ServiceNow converts the field again. 

[RaphaelNardelli]

Eu tive exatamente o mesmo problema e a sua solução me salvou, muito obrigado!