19/06/2020 - mongoimport

-
  • hi its the snail /shameful unemployed procrastinator here again
  • today i discovered another thing new
  • how to use mongoimport to import a .tsv file into mongodb
  • go google sheet online >create some columns with data and the a header row>export the file as tsv file
  • go mongodb and download the server app (just to get mongod aka mongo daemon) and the database tools (just to get mongoimport)
  • download and install the file
  • go into the bin folder and copy the url
  • start>search>views advanced settings>env variables > find "path" variable>edit>paste the url
  • go to the downloads folder, unzip the file, go to /bin and right click run command prompt OR powershell OR bash
  • go mongodb atlas>create a cluster if none > create a database if none>create a collection if none>go back to the dashboard>connect>get the connection string> open up windows notepad and store the url>edit the fields for password, database name
  • mongo atkad>account>cluster>database>collection>data entry>data field
  • i only know how to use mongoatlas which lets me ignore complicated file paths and command lines, user rights etc
  • mongo lets you skip a lot of database set up vs sql
  • wish there was a file import button somewhere on mongo cloud atlas
  • craft the command line in your notepad
  • mongo import --uri <connection string+password+databasename>  --collection <collection name> --type tsv --file <file name+.tsv> --headerline
  • use mongoimport --help to learn more about the flags
  • and theres two more steps i did, i copied the import file to the /bin, /data , /data/db
  • not sure which folder mongoimport recognises
  • please go or test which one is the recognised folder. i am not sure if the command line accepts file path instead
  • copy and paste the line into the CLI, use right click paste
  • i cannot guarantee its successful, but you can use the --help flag or go stackoverflow
  • go mongo atlas check the data
  • if it works, as in you see the file data appearing in your collection, you can delete the data from the cloud and add in your actual data

Comments

Post a Comment

Popular posts from this blog

08/06/2020 - scoped css with sass + react

-
css is not modular modular css like javascript - want to have local scope want to make react components with scoped css css-in-js  writing the css inside the js / component file css-in-js libraries: jss, react-jss, styled components, emotions how the libraries work - at precompile they tag on a class name so the scope is more limited cons : they dont seem to allow cascading and need to tack on a class name to every single element, tedious i tried naming my files [component].modules.css, but it doesn't work. maybe it needs webpack? i am not familiar with webpack. solution sass: use node-sass and sass in the react/node project i decided to use sass and its nested feature, with a classname at the top level selector features: variables, @use, nesting, mixins (not tried), partial scss is a sass file type that uses css syntax preserves the cascading feature of css steps in my react component, add a top level div with class name   top level div f...
Read more

11/02/2021 - git commands for remote repo

-
git commands inital upload: git init --create github repo, copy the url create .gitignore, add in /node_modules, .env etc git commit . -m '<msg>' git remote add origin <url> git checkout -b <branch> git push origin <branch> deleting folder: (in case you added node module by accident) git checkout <branch> git rm -r <folder> git commit . -m '<msg>' git push origin <branch> adding/deleting/checking remote: git remote add origin <url> git remote -v git remote remove origin updating file: git commit . -m "<msg>" git push origin <branch> cloning from remote to local, updating changes from local to remote: --within working folder git init git clone <url> --> you get a subfolder with the cloned repo cd into the cloned folder git commit . -m "<msg>" git add remote origin <url> git fetch origin git push origin <branch> amend single file: git commit <file> -m ...
Read more

29/11/2021 - time flies

-
time flies. i have been working at a local tech start up since tis apr, and tomorrow's time for my mid review. recently, i have been dealing with anxiety. fears that i am not enough. my emotion is not very good. i do think about plan b. this shit is so hard. to me. so let's take stock things i have done react native set up mac - android studio + android phone (emulator wont work), xcode + ios phone / emulator windows - android, phone (emulator sucks) for some reason i have to build bundle somewhere else cos my internet wont point correct mac os quirks - m1 chip rosetta mode for xcode OR exclude arm64 architecture arch commands for pod on cli learnt along the way graphql+apollo little sql+hasura react native
Read more