You can proceed with the import, but if you don't address the warnings the data might include errors. - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
IPC Admin ConsultingIPC Admin Consulting 

You can proceed with the import, but if you don't address the warnings the data might include errors.

Hi Sir,

Requesting your assistance, I am trying to upload my data using csv file then error has been encountered when mapping api. please see see screenshot below or the attached file as for your reference. Hope you can help me for this problem. Thank you

User-added image
Sourav DuttaSourav Dutta
As per the error message, there is a field "Route Name" whose data value is too large.
So, you need to increase the Length of the text.

Set Up> Create> Objects> from the object list choose the object.
Then edit the field and increase the length.

Hope it helps!

Kind Regards,
Pruthvi Raj KankunthalaPruthvi Raj Kankunthala
The error is because of the long "Route Name" . Thecommon issue when importing is that addresses often have commas in them which screw up CSV files; that can often cause what seem to be corrupt rows.  The fix for this is to export the CSV with text qualifiers like quotes, so that each entry is quoted.  Data Loader can handle this so it considers commas inside quotes to be different than commas outside quotes. 

So my suggestion is to upload using Dataloader as it is a little more robust than web based import tools such as import wizard  . Data Loader outputs a log which will actually tell you which rows are good and which are bad, so if you're using that, have a look at the logs and then check your file for unclean rows.

You can download Apex Data Loader from within the Setup pages.
User-added image

Let me know if you need any more information / help .
Atul GuptaAtul Gupta
The data you are trying to import is too long, shorten it or make Route Name field's length longer.
Even if you import this data, Salesforce will truncate the

if this field is a standard name field, then you can't increase its length to more than 80 characters
Sandeep Kumar GaddamSandeep Kumar Gaddam
Hello IPC Admin,

I think the problem is with the lenght of Route Name field. it seems that its exceding thing lenght. check the lenght of the field. 

Pritam ShekhawatPritam Shekhawat
++Atul, The data you are trying to import is too long. So Salesforce will take first 80 character of that field. If this is Standard Name field then you can't increase the length of this field.
IPC Admin ConsultingIPC Admin Consulting
Yes Sir Pritam Sherhawat, Route Name is a standar field, is there any possible solution that can edit or maximize the length of this field? as per checking it's only 80 character
Atul GuptaAtul Gupta
No you can't increase the Standard Name field's size beyong 80 characters.
You can vote on the idea (
Pritam ShekhawatPritam Shekhawat
++ No, You can't increase the Standard Name field character size. You can promote and upvote this idea here Increase Name field length from 80 to 255