{"id":16964,"date":"2012-02-17T14:56:13","date_gmt":"2012-02-17T14:56:13","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/gdata-importer\/"},"modified":"2014-05-23T12:08:53","modified_gmt":"2014-05-23T12:08:53","slug":"gdata-importer","status":"publish","type":"plugin","link":"https:\/\/szl.wordpress.org\/plugins\/gdata-importer\/","author":7801348,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.2","stable_tag":"trunk","tested":"3.9.40","requires":"2.2","requires_php":"","requires_plugins":"","header_name":"GData Importer","header_author":"Ankit Sharma","header_description":"","assets_banners_color":"","last_updated":"2014-05-23 12:08:53","external_support_url":"","external_repository_url":"","donate_link":"http:\/\/www.ankitsharma.info\/buy-ankit-a-beer","header_plugin_uri":"http:\/\/www.ankitsharma.info","header_author_uri":"http:\/\/wwww.ankitsharma.info","rating":1,"author_block_rating":0,"active_installs":10,"downloads":2975,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"1.0.1":"

Latest Version<\/p>"},"ratings":{"1":"1","2":0,"3":0,"4":0,"5":0},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0"],"block_files":[],"assets_screenshots":{"screenshot-1.jpg":{"filename":"screenshot-1.jpg","revision":"919927","resolution":"1","location":"assets"},"screenshot-2.jpg":{"filename":"screenshot-2.jpg","revision":"919927","resolution":"2","location":"assets"},"screenshot-3.jpg":{"filename":"screenshot-3.jpg","revision":"919927","resolution":"3","location":"assets"},"screenshot-4.jpg":{"filename":"screenshot-4.jpg","revision":"919927","resolution":"4","location":"assets"}},"screenshots":{"1":"Spreadsheet Key","2":"Worksheet Name","3":"Data in Spreadsheet","4":"Imported Data in wordpress"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[3524,10611,150,87,9471],"plugin_category":[],"plugin_contributors":[92118],"plugin_business_model":[],"class_list":["post-16964","plugin","type-plugin","status-publish","hentry","plugin_tags-data","plugin_tags-docs","plugin_tags-google","plugin_tags-import","plugin_tags-spreadsheet","plugin_contributors-ankit_sam","plugin_committers-ankit_sam"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/gdata-importer.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/gdata-importer\/assets\/screenshot-1.jpg?rev=919927","caption":"Spreadsheet Key"},{"src":"https:\/\/ps.w.org\/gdata-importer\/assets\/screenshot-2.jpg?rev=919927","caption":"Worksheet Name"},{"src":"https:\/\/ps.w.org\/gdata-importer\/assets\/screenshot-3.jpg?rev=919927","caption":"Data in Spreadsheet"},{"src":"https:\/\/ps.w.org\/gdata-importer\/assets\/screenshot-4.jpg?rev=919927","caption":"Imported Data in wordpress"}],"raw_content":"\n

A wordpress plugin which imports Google Spreadsheet Data into the Wordpress Page\/Post using shortcode.\nYou have to provide Sheet Key, Worksheet Name, Username and Password in shortcode.<\/p>\n\n

Usage:\n[gdata_import key=\"spreadsheet_key\" worksheet=\"worksheet_name\" user=\"your_username\" pass=\"your_password\"]<\/p>\n\n

Example:\n[gdata_import key=\"0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV\"\nworksheet=\"Sheet1\" user=\"your_username\" pass=\"your_password\"]<\/p>\n\n\n

    \n
  1. Upload gdata-importer<\/code> to the \/wp-content\/plugins\/<\/code> directory<\/li>\n
  2. Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n
  3. Place shortcode [gdata_import key=\"spreadsheet_key\"\nworksheet=\"worksheet_name\" user=\"yourusername\" pass=\"yourpassword\"] in your post<\/li>\n<\/ol>\n\n\n
    \n
    Where to get spreadsheet key?<\/dt>\n

    You can get the spreadsheet key from the Spreadsheet URL.<\/p>\n\n

    Example Spreadsheet URL: https:\/\/docs.google.com\/spreadsheet\/ccc?key=0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV#gid=0<\/p>\n\n

    Then your Spreadsheet key is: 0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV<\/p><\/dd>\n

    Where to get worksheet parameter?<\/dt>\n

    The worksheet parameter refers to the worksheet name.<\/p>\n\n

    Example: Sheet1<\/p><\/dd>\n

    I am getting error \"ERROR: Unable to Connect to ssl:\/\/docs.google.com:443. Error #110: Connection timed out\"<\/dt>\n

    Some hosting providers do not allow https connections to be made from their servers, Contact your Hosting to assist & solve the problem.<\/p>\n\n

    Refer: https:\/\/developers.google.com\/gdata\/articles\/php_client_lib#appendix_issues_proxy<\/p><\/dd>\n\n<\/dl>\n\n\n

    1.0.2<\/h4>\n\n

    Bug Fixes.\nAdded Title for Sheets.<\/p>\n\n

    1.0.1<\/h4>\n\n

    Bug Fixes.<\/p>\n\n

    1.0.0<\/h4>\n\n

    Initial Release.<\/p>","raw_excerpt":"A plugin imports Google Spreadsheet Data into the Wordpress Page\/Post using shortcode.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/16964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=16964"}],"author":[{"embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/ankit_sam"}],"wp:attachment":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=16964"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=16964"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=16964"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=16964"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=16964"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=16964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}