csv - TecHighness

Nodejs Script to Add Rows in CSV File Through Terminal

Last Updated July 10, 2021 | 3 minutes | 440 words | Talha Awan

Filling out a CSV file through Office Excel or LibreOffice Calc is easy enough, but you may find it quicker to type in fields on a terminal, particularly when you want to process the data before entry, use defaults, or keep the entry process totally mouse-free. [Read More]

csv script

Export MongoDB Collection Data In CSV From Node Express Mongoose Application

Last Updated August 4, 2021 | 2 minutes | 371 words | Talha Awan

Suppose a student collection in mongoDB have some data that we want to export in a CSV file from a Mongoose, Node, and Express app. For simplicity, let us assume only two fields in Mongoose schema: lastName and firstName. To export a CSV file, install moment, json2csv, and mongo-date-query (optional) npm packages: [Read More]

nodejs expressjs mongodb mongoose csv

Validate Uploaded CSV Data in Node Express

Confirm existence and data type of all columns within each row.

Last Updated July 10, 2021 | 3 minutes | 564 words | Talha Awan

Continuing from earlier post Node Express Endpoint to Upload and Process CSV File, in this post we will add validation to the uploaded CSV data. With the same index.js file and settings as the earlier post, we only need to add moment library for date validation. [Read More]

nodejs expressjs csv

Node Express Endpoint to Upload and Process CSV File

Last Updated December 26, 2021 | 5 minutes | 923 words | Talha Awan

It is quite common in Node Express backend development to come across a requirement of parsing and processing CSV files. Usually, it is to store the content in the database after processing. In this post, we will upload a CSV file, store it temporarily in the server directory to fetch all rows in JSON form, push all rows in an array, and remove the temporary file. [Read More]

nodejs expressjs csv