JSON to CSV file conversion -

-

i have json file

{   "name": "re2",   "count": 1806,   "frequency": "realtime",   "version": 5,   "newdata": true,   "lastrunstatus": "success",   "lastsuccess": "fri may 30 2014 06:02:41 gmt+0000 (utc)",   "results": {     "collection1": [       {         "title": {           "href": "http://www.realestate.com.au/project-spec+property+%e2%80%93+helio+apartments-vic-north+melbourne-600004887",           "text": "93 flemington road, north melbourne, vic 3051"         },         "image": {           "href": "http://www.realestate.com.au/project-spec+property+%e2%80%93+helio+apartments-vic-north+melbourne-600004887",           "alt": "93 flemington road, north melbourne, vic 3051",           "src": "http://i2.au.reastatic.net/345x200/3a7e58fe3aefa7fd373c1b9c9879d648257dc0e7c8d35c6b7a19d261bffeff28/main.jpg"         },         "price": "$700,000 - $770,000",         "title2": {           "href": "http://www.realestate.com.au/project-spec+property+%e2%80%93+helio+apartments-vic-north+melbourne-600004887",           "text": "93 flemington road, north melbourne, vic 3051"         }       },       {         "title": {           "href": "http://www.realestate.com.au/project-redmond+park-vic-carlton+north-600002807",           "text": "300 pigdon street, carlton north, vic 3054"         },         "image": {           "href": "http://www.realestate.com.au/project-redmond+park-vic-carlton+north-600002807",           "alt": "300 pigdon street, carlton north, vic 3054",           "src": "http://i2.au.reastatic.net/345x200/c22712b2c40db6e8017ebc6f677c9835991e3e1ab9431cfe28d0ab8ea0af43e3/main.jpg"         },         "price": "$830,000 - $880,000",         "title2": {           "href": "http://www.realestate.com.au/project-redmond+park-vic-carlton+north-600002807",           "text": "300 pigdon street, carlton north, vic 3054"         }       },       {         "title": {           "href": "http://www.realestate.com.au/property-house-vic-kensington-116973739",           "text": "60 wolseley parade, kensington, vic 3031"         },         "image": {           "href": "http://www.realestate.com.au/property-house-vic-kensington-116973739",           "alt": "60 wolseley parade, kensington, vic 3031",           "src": "http://i4.au.reastatic.net/355x265/e026805577c810c6df722c171a00786f4510cb959390375d589e2d1d90ef2461/main.jpg"         },         "price": "sold $1,360,000",         "title2": {           "href": "http://www.realestate.com.au/property-house-vic-kensington-116973739",           "text": "60 wolseley parade, kensington, vic 3031"         }       },

i tried numerous online json csv converters file, , never converts properly.

i csv file title, href, text, image, href, alt, src, price

due complexity of file, i'm having no luck tutorials online.

generally it's not possible automatically convert json csv, since 1 object graph, , other table. trying convert cube circle.

to further complicate matter json doesn't seem homogenous. first entry doesn't have title2 instance. in order solve problem break down following steps:

  1. convert json proper objectgraph.
  2. collapse object graph flat list. mapping fields necessary.
  3. write out list csv.

it not obvious example json whether practical read memory @ once, or whether need break down, converting 1 item @ time. doubt find online tool you, since json seems incoherent , needs specific.


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more