issue in Ajax call while uploading excel file

meenakshi luthra

8y1.6kLearn iOS Programming

Hi,

I have following Jquery in mvc core view:

$(document).ready(function () {

$("#btnUploadSave").click(function () {

var fileUpload = $("#files").get(0);

var files = fileUpload.files;

var data = new FormData();

for (var i = 0; i < files.length; i++) {

data.append(files[i].name, files[i]);

}

$.ajax({

type: "POST",

url: "/Creator/SaveBatchMenbersFromExcel",

contentType: false,

processData: false,

datatype : json,

data: data,

headers: { __RequestVerificationToken: $("input[name=__RequestVerificationToken]").val() },

success: function (message) {

alert(message);

$("#txtExcelFile").val('');

$("#txtExcelFile").attr("placeholder", "Drop a file here!");

$('#ddlBatchCsv').prop('selectedIndex', 0);

error: function () {

alert("There was error uploading files!");

}

});

and below is the html of input

while saving data of excel file I am always getting alert of error function. Please help me where is the mistake??

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

meenakshi luthra8y ago
Failed to load resource: the server responded with a status of 404 (Not Found)
style.css Failed to load resource: the server responded with a status of 404 (Not Found)
https//maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css Failed to load resource: net::ERR_NAME_NOT_RESOLVED
https//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css Failed to load resource: net::ERR_NAME_NOT_RESOLVED
jquery.validate.min.js:4 Uncaught ReferenceError: jQuery is not defined
at jquery.validate.min.js:4
at jquery.validate.min.js:4
(anonymous) @ jquery.validate.min.js:4
(anonymous) @ jquery.validate.min.js:4
jquery.validate.unobtrusive.min.js:5 Uncaught ReferenceError: jQuery is not defined
at jquery.validate.unobtrusive.min.js:5
(anonymous) @ jquery.validate.unobtrusive.min.js:5
7Slow network is detected. See for more details. Fallback font will be used while loading:
localhost/ Failed to load resource: the server responded with a status of 404 (Not Found)
flags.png Failed to load resource: the server responded with a status of 404 (Not Found)
jquery.autocomplete.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
fontawesome-webfont.woff2 Failed to load resource: the server responded with a status of 404 (Not Found)
jquery.autocomplete.min.js Failed to load resource: the server responded with a status of 404 (Not Found)
style.css Failed to load resource: the server responded with a status of 404 (Not Found)
fontawesome-webfont.woff Failed to load resource: the server responded with a status of 404 (Not Found)
fontawesome-webfont.ttf Failed to load resource: the server responded with a status of 404 (Not Found)
https//maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css Failed to load resource: net::ERR_NAME_NOT_RESOLVED
style.css Failed to load resource: the server responded with a status of 404 (Not Found)
3SaveBatchMenbersFromExcel Failed to load resource: the server responded with a status of 400 (Bad Request)
style.css Failed to load resource: the server responded with a status of 404 (Not Found)
style.css Failed to load resource: the server responded with a status of 404 (Not Found)
jquery-2.1.1.min.js:4 POST http://localhost:55881/Creator/SaveBatchMenbersFromExcel 400 (Bad Request)
send @ jquery-2.1.1.min.js:4
ajax @ jquery-2.1.1.min.js:4
(anonymous) @ NewBatchUpload:573
dispatch @ jquery-2.1.1.min.js:3
r.handle @ jquery-2.1.1.min.js:3
Ramesh Palanivel8y ago
Please share the screen shot of that error image.
meenakshi luthra8y ago
Not able to upload image here
Ramesh Palanivel8y ago
Hi Meenakshi,

Click F12 => Go to Console tab => If you received any errors, please send me the screen shot of that error messages
meenakshi luthra8y ago
It is showing blank alert message.
Ramesh Palanivel8y ago
Hi Meenakshi,

In Error function change the below code and see what is the exact issue

error: function (x,y,z) {
alert(x.responseText);
}
meenakshi luthra8y ago
Still same issue :(, even after removing antiforgery token
Ramesh Palanivel8y ago
Hi Meenakshi,

Remove the Aniforgerytoken validation from your controller and as well remove headers attribute from your ajax call and try again.
meenakshi luthra8y ago
This is the controller code, which is not even called by ajax:

[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult SaveBatchMenbersFromExcel()
{
long size = 0;
var files = Request.Form.Files;
var filename = "";
foreach (var file in files)
{
filename = ContentDispositionHeaderValue
.Parse(file.ContentDisposition)
.FileName
.Trim('"');
filename = _environment.WebRootPath + $@"\Uploads\BatchMembers\{filename}";
size += file.Length;
using (FileStream fs = System.IO.File.Create(filename))
{
file.CopyTo(fs);
fs.Flush();
}
}
if (TempData["BatchId"] == null)
return Json("Please select batch!");
if (int.Parse(TempData["BatchId"].ToString()) <= 0)
return Json("Please select batch!");
_saveBatchMembersFromExcelEntity.BatchIds = int.Parse(TempData["BatchId"].ToString());
TempData.Keep("BatchId");
_saveBatchMembersFromExcelEntity.IsActive = true;
_saveBatchMembersFromExcelEntity.CreatedBy = _live.UserId(); ;
GetBatchMemebersFromExcelsheet(filename);
return Action();
}
meenakshi luthra8y ago
still same issue, have already tried!
Please help :(
Ramesh Palanivel8y ago
Hi Meenakshi,

Remove the line datatype:'Json' and try again
meenakshi luthra8y ago
alert("There was error uploading files!");

This alert message is coming from ajax call
Ramesh Palanivel8y ago
Hi Meenakshi,

Please share some screen shot of your error. It will be easy for us to provide valuable solution.