Import csv tsv file into MongDB

-
When the csv or tsv file has headerline
csv
$ mongoimport -d <database> -u <username> -c <collection> --type csv --headerline --file <filename>

tsv
$ mongoimport -d <database> -u <username> -c <collection> --type tsv --headerline --file <filename>



When the csv or tsv file doesn't have headerline and set field type

$ mongoimport -d <database> -u <username> -c <collection> --type tsv --columnsHaveTypes --fields "name.string(),register.boolean(),phone.int32()"  --file <filename>


https://docs.mongodb.com/manual/reference/program/mongoimport/

댓글

댓글 쓰기

이 블로그의 인기 게시물

mongoDB admin 권한 설정방법 How to enable access control for mongo DB

-
** WARNING: Access control is not enabled for the database. ** Read and write access to data and configuration is unrestricted. 해결방법 Solution 요약 : mongoDB를 설치하면 기본적으로 admin이라는 db가 생성됩니다. 이 admin db에 앞으로 생성할 db와 user를 관리할 수 있는 administrator 계정을 생성합니다. 그리고 나서 administrator 계정을 통해 작업할 db와 그 db에 접근 가능한 user 계정을 만듭니다. 이후 user 계정으로 접속해 db 작업을 진행합니다. // How to enable access control for  mongo DB $ mongo connecting to: mongodb://127.0.0.1:27017 MongoDB server version: 3.4.10 Server has startup warnings: 2018-01-12T09:03:22.199+0900 I CONTROL  [initandlisten] 2018-01-12T09:03:22.199+0900 I CONTROL  [initandlisten] ** WARNING: Access control is not enabled for the database. 2018-01-12T09:03:22.199+0900 I CONTROL  [initandlisten] **          Read and write access to data and configuration is unrestricted. 2018-01-12T09:03:22.199+0900 I CONTROL  [initandlisten] // db list > show dbs admin 0.000GB local 0.000GB // Create the User Administrator &
자세한 내용 보기

Install pm2 via yarn globally

-
$ sudo yarn global add pm2 $ pm2 --version PM2 is a Production Process Manager for Node.js applications                      with a built-in Load Balancer.                 Start and Daemonize any application:                 $ pm2 start app.js                 Load Balance 4 instances of api.js:                 $ pm2 start api.js -i 4                 Monitor in production:                 $ pm2 monitor                 Make pm2 auto-boot at server restart:                 $ pm2 startup                 To go further checkout:                 http://pm2.io/
자세한 내용 보기

Install node and yarn on Linux

-
Install nodejs v8.x curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash - sudo apt-get install -y nodejs sudo apt-get install -y build-essential node --version Install yarn curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add - echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list sudo apt-get update && sudo apt-get install yarn yarn --version Update yarn sudo apt-get update && sudo apt-get install yarn
자세한 내용 보기