how to creat json (postmeta) from excel?

  • how to creat json (postmeta) from excel?

    I have 400 excel datas and I need to put convert to json for importing to postmeta table.

    how can I do that?

    the excel looks like this.

    PK : ID number

    Name: ……..
    Address: …………
    Tel :……………
    website :………..

    etc.

    All of them (except PK) need to be converted to json to put aaa_meta on postmeta table. PK will be needed for matching ID values.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter freeace00

    (@freeace00)

    any help?

    this is Json. right? is it only json?

    [ Moderator Note: Please post code or markup snippets between backticks or use the code button. ]

    a:19:{s:7:"address";s:69:"address.. etc";s:11:"gpsLatitude";s:8:"37.57358";s:12:"gpsLongitude";s:11:"126.9865059";s:18:"streetViewLatitude";s:9:"37.573433";s:19:"streetViewLongitude";s:18:"126.98645099999999";s:17:"streetViewHeading";s:1:"0";s:15:"streetViewPitch";s:1:"0";s:14:"streetViewZoom";s:1:"0";s:9:"telephone";s:19:"02 – 736 – 2233";s:5:"email";s:0:"";s:3:"web";s:11:"sanneri.com";s:11:"hoursMonday";s:17:"11:30am ~ 22:00pm";s:12:"hoursTuesday";s:17:"11:30am ~ 22:00pm";s:14:"hoursWednesday";s:17:"11:30am ~ 22:00pm";s:13:"hoursThursday";s:17:"11:30am ~ 22:00pm";s:11:"hoursFriday";s:17:"11:30am ~ 22:00pm";s:13:"hoursSaturday";s:17:"11:30am ~ 22:00pm";s:11:"hoursSunday";s:17:"11:30am ~ 22:00pm";s:18:"alternativeContent";s:0:"";}
    Andrew Nevins

    (@anevins)

    WCLDN 2018 Contributor | Volunteer support

    If you have a query regarding WordPress, let us know.

    Thread Starter freeace00

    (@freeace00)

    Hello Andrew,

    What do you mean query?
    I am not sure how I can find queries. where I can find it?

    Thread Starter freeace00

    (@freeace00)

    $output = json_encode($items);
 	// response output
    header( "Content-Type: application/json" );
    echo $output;
    exit;

    is this what you need? I found it function file.
    I really need it. please let me know as much as you know. it will be a big help.

    Andrew Nevins

    (@anevins)

    WCLDN 2018 Contributor | Volunteer support

    Closing this thread as it is unrelated to WordPress.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘how to creat json (postmeta) from excel?’ is closed to new replies.