insert json array into mongodb php

Question

I converted my old mysql data into csv, then csv to json. Now I want to insert in my mongodb

here's the json

       $json =[
   ["(2"," 'Kea'"," 'Sand'"," '[email protected]'"," '2013-07-28'"," ''"," '0000-00-00'"," 0)",0];

there are hundreds of these records.

Here's what I've tried

 $j=json_decode($json,true);
 foreach($j as row){
     $todo=array('email'=>$row[4], //email address row
                 'name'=>$row[2],
     );
     $collection->insert($todo);
 }

In theory I thought it would work but negative. All the other codes of tried have been variations of for each. How can I do this right?

Neil Lunn · Accepted Answer · 2014-03-17 02:59:59Z

2

The problem is that what you have generated is not valid JSON and that is why it does not parse. You need something like:

{ "name": "Kea", "email": "[email protected]" }

Probably your best option is to go back to your csv file and use mongoimport in order to transfer the data. There is an option for --type where you can specify csv.

Depending on format of your csv file, if you have emitted a header line with the field names you can use the --headerline option. If not, then you will need to specify names for your fields via --fields.

There are several usage examples in the document.

That should allow you import the data and then get to work on the code.

Alternately, then look into ways of forming your JSON properly from a CSV in your code. But there is this utility already.

answered Mar 17, 2014 at 2:59

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3052997 Over a year ago

Getting nothing but unexpected identifier error when I copy the import code. monogimport -h ds00000.mogolab.com:3344 -d hidle - c (just this 1st part of the code throws the unexpected identifier error.)

Collectives™ on Stack Overflow

insert json array into mongodb php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related