Importing CSV Files to MongoDB using php
Aweza
I am in the process of creating an application and I need your support as I have never used Mongodb before! In my application users will be uploading CSV files of open data.
The data in the csv file must be uploaded on to a database and then need to be retrieved back on to the applications for users to view and filter the data. So I am wondering whether I should be creating a new table every time a csv file is uploaded or just create one table for users to upload the data on to?
I don't know what kind of data type people will be uploading? so they could be uploading anything but what I am looking for in the csv file is location columns such as Address, Longitude, Latitude, Easting and Northing. Plus I don't have to keep a copy of the data the user is uploading.
So any ideas how this system could be implemented using Mongodb to store the data?
Thank you very much in advance!