Formatting issue with Excel import

[Darren22]

Good evening,

I am pulling my hair out about this one. I have been asked to update a bulk load of mobile phones from an excel spreadsheet. I have completed imports many times before so its a simple task. We currently record the IMEI against the asset tag which is about 15 character long.

So when I do the import the asset tag is coming out as 1,000,000,000 for every single one. So I check the formatting on the excel spreadsheet and its currently formatting as a number due to it being over 11 characters. I try and change the formatting to general but the field then changes to 338+14e which is a common Excel error.

So can I ask what format does the cell have to be in for ServiceNow to accept it. Has anyone every come up with this before.

Its annoying

Here are some images

[Nithish1]

Hello,

Instead of setting it to general can you try setting it to Number? Not sure if that works but just give a shot.

[Darren22]

Do you know if ServiceNow picks up the format of Number?

I have tried setting this to number and again during the import something is changing and the number comes out as 1,000,000,000

[Nithish1 · Accepted solution]

Hi,

Can you make sure the field type of the import set field is the same as the target field?  If not, make the field type the same as target and you can run the cleanup utility (System Import Sets\Import Set Tables\Cleanup) to delete all the data in the import set table, change the field type, and then re-import the data.

Regards,

Nithish

[Darren22]

I have just checked the field type and they are different. So you might be onto something here,

So when I first did the import and the table is created the type on the source field was different to the target field... You might be onto something there!

Its getting a little late for me to try this now but I will do my best to try it over the next few days and then come back to you with an update.

Thank you so much for taking the time to look at this and help me!!! *high five*