Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Json file format?  
Posted: 18 July 2014 01:07 AM —  
Total Posts:  9
Joined  2013-09-10

Hi, I am trying to import some json content exported by EXPORT it - ee addon.
I am trying to build a json file and I dont know why, it gives me error on both files, the addon exported one ( for test purpose) and the one that I’m trying to create,

the error is : Error: Cannot open file/url:

Why does it gives this error, how can i fix it, how should a json compatible file look like ?

Posted: 28 July 2014 09:30 AM —   [ # 1 ]  
Total Posts:  13
Joined  2010-11-20

from experience, Export It doesn’t output a JSON file you can use with Datagrab.

Here’s an example of a JSON feed I created in EE manually


{exp:query sql="SELECT
  cd.field_id_311 AS long_title,
  cd.field_id_304 AS cat,
  cd.field_id_287 AS issue,
  cd.field_id_288 AS author,
  cd.field_id_289 AS bio,
  cd.field_id_293 AS summary,
  cd.field_id_290 AS body,
  cd.field_id_291 AS footnotes,
  cd.field_id_292 AS image,
  cd.field_id_460 AS themelios_order
  exp_channel_titles ct
JOIN exp_channel_data cd ON cd.entry_id = ct.entry_id
  cd.channel_id = 36;" backspace="1"
}    { "entry_id": "{entry_id}",
      "title": {exp:json_encode}{title}{/exp:json_encode},
      "url": {exp:json_encode}{url_title}{/exp:json_encode},
      "long_title": {exp:json_encode}{long_title}{/exp:json_encode},
      "category":  {exp:json_encode}{cat}{/exp:json_encode},
      "issue": {exp:json_encode}{issue}{/exp:json_encode},
      "author": {exp:json_encode}{author}{/exp:json_encode},
      "bio": {exp:json_encode}{bio}{/exp:json_encode},
   "summary": {exp:json_encode}{summary}{/exp:json_encode},
   "body": {exp:json_encode}{body}{/exp:json_encode},
   "footnotes": {exp:json_encode}{footnotes}{/exp:json_encode},
   "image": {exp:json_encode}{image}{/exp:json_encode},
   "order": {exp:json_encode}{themelios_order}{/exp:json_encode}
Posted: 25 November 2019 12:07 PM —   [ # 2 ]  
Total Posts:  1
Joined  2019-11-25

The brand box is issued for the argument for the parts. The dynamics of the best assignment writing service are inducted for future themes. The margin is improved for the necessity of the reforms. The illustration is improved for humans. Dynamics are inquired for the approval of the terms for all skills and management of the medium range for the simple and frugal themes for people.


‹‹ Flickr import stopped working      DataGrab Import DB Error (Error Number: 1118 Row size too large) ››

Select A Theme