I want to export data from my mongoDB database to CSV files on a scheduled basis , the timestamp field in the tables is in unix format , so I want to export from the table every 2 hours so it needs to be able to change the value of the time criteria using a script then export the data and FTP it to another server , there will be about 7 exports
for instance the query would be
{ "SiteId": NumberInt(203), "Date": { $gte: NumberLong(1532268000) } }
To export all the data with a time stamp 2pm on 22/07/2018
Then it would change on the next run to
{ "SiteId": NumberInt(203), "Date": { $gte: NumberLong(1532275200) } }
To export all the data with a time stamp 4pm on 22/07/2018
The scripts need to be run by the windows task manger
Hi,
I am MongoDB expert and architect and aware of all terminologies involved
Expert in writing automation scripts for backing up and restoring to another server.
Expert in writing scripts for exporting data to CSV files and importing to another server.
Let me know please.
Thank you.