Create API for Importing Excel or CSV File Data in MongoDB using Node JS - Import CSV Mongo Node JS

[@rajupatel-js1qd]

Thik hay👍🤣 nice work brother,

[@ProgrammingExperience]

Thik hein brother 😄 👍

[@monirhrabby]

Thanks for sharing this video. very helpfull

[@ProgrammingExperience]

Your welcome brother 👍

[@Deepaksingh-yf9ik]

Thanks it helped me in my live project

[@ProgrammingExperience]

Your welcome brother 👍

[@goku2685]

V impressive ❤

[@ProgrammingExperience]

Thanks brother 👍🤗

[@ajaykharat9267]

Thanks For The Video !!

[@ProgrammingExperience]

Your welcome brother 👍

[@yogu99]

Badiya

[@ProgrammingExperience]

Hmm 👍

[@rakeshmohantarai1462]

Thanks for the video

[@ProgrammingExperience]

Your welcome brother 👍

[@haneenthi]

आपका बहुत-बहुत धन्यवाद

[@ProgrammingExperience]

Apka bahut bahut sukriya 👍

[@awaphics]

Bro I was Wait fro you to Connet the Previous Issue

[@ProgrammingExperience]

Ohh okay okay, sorry, can we connect on this weekend?

[@sufyan_rasheed]

Nice video 👍 Sir React frontend ka bhi video banaye I need to upload CSV file from frontend with proper validation

[@ProgrammingExperience]

Okay brother 👍

[@juangarciaveas8888]

nice video!

[@ProgrammingExperience]

Thanks dear 👍

[@surajprogrammer4600]

Love you sir 💖💕

[@ProgrammingExperience]

Love you too dear ❣️

[@RakeshAhire-ze4jy]

If I have a multiple models , and I want to use csv file upload in all models? then how can I get the latest uploaded file and how can I know which file is for each particular model

[@ProgrammingExperience]

In all model's, that will take more loading time, then you need to use bulk operation to insert the data in to all models.

[@MemeAndShortsReview]

what if one of the data in csv is wrong? I want wrong data error to be stored and data after that to work as it should create users in db... how to handle that error?

[@ProgrammingExperience]

You need to add validation in import time.

[@MHPavel-p3c]

Thanks man

[@ProgrammingExperience]

Your welcome brother 👍

[@kelangirajkiran6133]

Thank you very much

[@ProgrammingExperience]

Your welcome dear 👍

[@bhartendusingh3061]

Sir agar me mongoose compass use karta hu agar mujhe system change karna pade to me us pehle bale system bale compass ko apne new system me kaise open karu

[@ProgrammingExperience]

Download kar lo new bale mein or old bale se export karo and new mein import kar lo data ko.

[@bhartendusingh3061]

@@ProgrammingExperience ok thank u sir

[@production4th]

how to do in button click please also share frontend part

[@ProgrammingExperience]

Okay i will share soon, don't worry.

[@vishnuvijayan1372]

How to this project share in client

[@ProgrammingExperience]

Client side?

[@umarjamil9941]

But how to use it for xlsx file? It is working only for csv files

[@ProgrammingExperience]

I think i am using csv-parser package in this lecture, you can use xlsx package for both files csv and xls.

[@in-san9]

i'm getting "cannot post/upload" request. How to resolve this error?

[@ProgrammingExperience]

Pls check request method or url.

[@jaydeepmane7845]

Can someone help me to perform this operation through UI

[@53_siddhimhatre84]

It shows user.insertMany as error. Says it is undefined

[@ProgrammingExperience]

Because, insertMany method will be work with model, i think your user is not a model please confirm this one.

[@105mohd.haarisamin3]

sir ab api ko front-end se connect kese karu? mtlb ek front-end form jo csv file accept kre aur submit pe click hone pe mongodb pe store krde?

[@ProgrammingExperience]

Bhai yaar itna to simple hein, ek input type file create karo csv select karo or formData mein append karke bhej do backend ko, ho jayega apka kaam

[@AsadAli-be4hc]

@@ProgrammingExperience bhai yeh apko lag raha h simple h lakin real time project ma or b kafi issue hoty h tw kindly

[@ProgrammingExperience]

@@AsadAli-be4hc 😀 bhai kuch mushkil nahi hota hein, us problem se ladna sikho sab easy lagega, log lagao or 100 baar check karo kahan issue ho raha hein. Log god ne bahut badiya chij banai heim agar yeh na hota to mere liye bhej kadi mushkil hota.

[@tamannakhoushi3446]

while saving the data of the file to mongodb , an error is coming : user.insertMany is not a fucntion , kindly tell how to resolev the error

[@ProgrammingExperience]

Have you checked user is variable of model?

[@tamannakhoushi3446]

yes its done the code worked thanks@@ProgrammingExperience

[@ProgrammingExperience]

@tamannakhoushi3446 your welcome 👍

[@tamannakhoushi3446]

the file is not getting upload instead error is displaying how can i configure this?

[@ProgrammingExperience]

Please use console on backend.

[@tamannakhoushi3446]

please explain how to do it@@ProgrammingExperience

[@ProgrammingExperience]

pls follow below steps:- 1:- Pls check have you using multipart/form-data in your request, because it's a must. 2:- Pls add the console.log(obj)//file obj in multer. 3:- if you got your file obj in multer, then pls add console.log(req.file) in your controller method. If you still see an error then, pls mail me.

[@tamannakhoushi3446]

thankyou the file has been uploaded@@ProgrammingExperience

[@ProgrammingExperience]

Okay 👍

[@rohittechstrock]

with image upload bhi bta do sir..

[@ProgrammingExperience]

Image ka bhai url hoga csv file mein kaise rakhoge. Url direct dal do itna tension kyun le rahe ho.

[@shrikrushnapatil2341]

How to upload Excel file to database in laravel

[@ProgrammingExperience]

Already this lecture available on my channel.

[@bhartendusingh3061]

Thank u sir

[@ProgrammingExperience]

Welcome dear 👍

[@smeetcoder9021]

I have a system where we can fill a form and data gets added to the Mongodb atlas . Now I need a feature of CSV upload also that you did it's Great but I need to merge the CSV and the existing data so can we do it by further putting logic in your code?

[@ProgrammingExperience]

Yes you can do.

[@smeetcoder9021]

@@ProgrammingExperience any reference would help me ?

[@ProgrammingExperience]

You can use google.

[@Comman.c]

Create Online examination system in nodejs

[@ProgrammingExperience]

In mern or simple node js?

[@Comman.c]

Simple

[@Comman.c]

Thanks for reply

[@ProgrammingExperience]

@@Comman.c but brother i want create this project in mern and it's very useful for all developers, i will create APIs in node js then i will connect API to React.

[@Comman.c]

Okk

[@sougatasingha9587]

does not properly work with excel files please update your video title, when ever we try to log the excel file value it gives us some random characters and encoded value

[@ProgrammingExperience]

Hmm yeh issue apko date ke liye aa raha hoga na ya kisi or type ki values ke liye bhi aa raha hein.

[@sandeepmishra1390]

Brother make a rest api on mysql

[@ProgrammingExperience]

Hmm okay 👍

[@peddintibhargavi2906]

i need code for this

[@ProgrammingExperience]

I think code is available on Website.

[@AsadAli-be4hc]

bhai iska frontend b bana dy yrr isko hit kaha sy krna upload kdr sy krna ? half kaam kr k chor diya yrr

[@ProgrammingExperience]

😀 hmm okay bana dunga

[@AsadAli-be4hc]

Bhai yrr abi google meet py a sakta 2 mnt k liya aik problem solve krde please

[@ProgrammingExperience]

@@AsadAli-be4hc bhai abhi to mein company mein kaam kar raha hu, aap mere ko mail kar do apni problem, hum Saturday ko connect ho sakte hein.

[@AsadAli-be4hc]

@@ProgrammingExperience Saturday bht late ho jaye ga yrr agr possible h tw tonight connect ho skta?

[@AsadAli-be4hc]

@@ProgrammingExperience bhai apni mail share krde

[@tarunsharma-xw4pv]

I have problem in uploading file can anyone help me

[@tarunsharma-xw4pv]

file is not upload and save in upload folder and code is not giving any error too

[@ProgrammingExperience]

@@tarunsharma-xw4pv have you integrate this api in your frontend side?

[@tarunsharma-xw4pv]

@@ProgrammingExperience no i am using postman as you do it in your video

[@ProgrammingExperience]

@@tarunsharma-xw4pv have you using the form data in postman or not

[@tarunsharma-xw4pv]

@@ProgrammingExperience yes I used it please help me via Google meet