Scheduling data import into Mongodb Weekly from Excel

53 views

Skip to first unread message

ramkak...@gmail.com

unread,

Nov 14, 2016, 11:06:38 AM11/14/16

to mongodb-user

i need to import data from csv automatically by every week,

How can schedule data import from one location(local machine or remote) to mongodb.

Can we do with that MMS( mongodb monitoring service)...? or it only use for monitoring and backup process...?

Lungang Fang

unread,

Nov 18, 2016, 1:08:21 AM11/18/16

to mongodb-user

Hi there,

i need to import data from csv automatically by every week, How can schedule data import from one location(local machine or remote) to mongodb.

You will want to schedule a repeat task to do this from outside MongoDB. For example, if you are using a Unix-based OS, you may want to set up a cron job

By the way, in case you are not aware, mongoimport can import contents from CSV files created by mongoexport or other third-party tools following the same CSV format.

Can we do with that MMS( mongodb monitoring service)…? or it only use for monitoring and backup process…?

MongoDB Cloud Manager (formerly MMS) is a service for managing, monitoring and backing up a MongoDB infrastructure. That is, in addition to monitoring and backing up, you may also provision, configure, upgrade, and scale your MongoDB infrastructure through Cloud Manager Automation.