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

green tea bitch

-
let me tell you the story of a green tea bitch and a hamsum with cheater potential.  i work closely with greentea in office. greentea has/had a long term boyfriend if more than 5 years (not sure if they still together, greentea always winces when i ask her about mr i-seriously-think-you-were-cuckolded nowadays). but she also crushes on the now ex-tech lead mr suave. suave probably left to avoid suspicion? i remember seeing her and her mr cuckolded boyfriend, she was cosying, rubbing her body against mr cuckold and leaning into him talking, on the mrt on our way back, from one of our get togethers. also knows he buys her hundreds dollar worth gifts on her birthday. (actually not very expensive i guess, she is into expensive gifts). ms prettii and mr suave ever played accidental touch ( hand brushing as they both reached for the mouse, then longing looks). she sent him a sticker of fingers touching on group chat before. anyway suave decided to teach us newbies coding in chinese (cos he s
Read more

song

-
Image
this just came out. his recent songs are getting better, i'm impressed. metaphors and imagery on point. flying, running barefoot, looking back, blackened nails, tears in sleep, warm bright sunlight, dancing alone, flying free like a bird i relate to this because my life is to be honest, so-so in the friends department and non existent in the romance department.  i don't feel like really sad, or regret, or i need to change it. friends are busy and settled down,  some are less able to provide a listening ear (maybe to them it is childish, immature, or being listened to means you have have to reciprocate so maybe not, they have theirs at home already, they are stressed and have no more bandwidth for anything else).  that is the reality of being an adult. maybe the occasional sympathy and warmth from a colleague or friend or stranger. but that doesn't do it for me. i don't need the superficial. and i feel it is so easy to have values not align one day, or per
Read more

20231104

-
i feel like with whats going on recently.. has healed me.. my emotions all stuck in side.. extreme emotions.. and my masking.. i feel it is better for me not to pretend i am not a nerd..
Read more