WordPress.org
Get WordPress

Plugin Directory

Changeset 507238


Ignore:
Timestamp:
02/19/2012 08:29:30 AM (14 years ago)
Author:
ankit_sam
Message:

Version 1.0.1

Location:
gdata-importer
Files:
394 added
2 edited

Legend:

Unmodified
Added
Removed

  • gdata-importer/trunk/index.php

    r506562 r507238  
    1616
    1717function gdata_import($attrib) {
    18     if($attrib["sheet"]=="" || $attrib["worksheet"] == ""){
    19         echo('ERROR: SET SHEET AND WORKSHEET ATTRIBUTE ');
     18    if($attrib["sheet"]=="" || $attrib["worksheet"] == "" || $attrib["user"] == "" || $attrib["pass"] == ""){
     19        echo('ERROR: SET ALL ATTRIBUTES i.e sheet, worksheet, user and pass. ');
    2020        return;
    2121    }
    2222    // load Zend Gdata libraries
    23     set_include_path(get_include_path() . PATH_SEPARATOR . WP_PLUGIN_DIR . "//gdata-script//");
     23    set_include_path(get_include_path() . PATH_SEPARATOR . WP_PLUGIN_DIR . "//gdata-importer//");
    2424    require_once 'Zend/Loader.php';
    2525    Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
    … …  
    2727   
    2828    // set credentials for ClientLogin authentication
    29     $user = "";
    30     $pass = "";
     29    $user = $attrib["user"];
     30    $pass = $attrib["pass"];
    3131   
    3232    try { 
    … …  
    5151    $content = <<<HTML
    5252    <table>
    53     <thead>
    54     <tr>
    55     <th scope="col">Datum</th>
    56     <th scope="col">Wedstrijd</th>
    57     <th scope="col">Score</th>
    58     <th scope="col">Competitie</th>
    59     <th scope="col">Stadion</th>
    60     </tr>
    61     </thead>
    6253HTML;
    6354   
    6455    foreach($wsFeed as $wsEntry):
    65         if ($wsEntry->getTitle() == "Sheet1"):
     56        //if ($wsEntry->getTitle() == "Sheet1"):
    6657            $rows = $wsEntry->getContentsAsRows();
    6758            foreach ($rows as $row):
    68                 $content = $content . "<tr itemscope itemtype=\"http://schema.org/SportsEvent\">";
    69                 $content = $content . "<td><meta itemprop=\"startDate\" content=\"". $row["dateiso"]. "\">" . date("d M Y",strtotime($row["datehuman"])) . " </td>";
    70                 $content = $content . "<td itemprop=\"name\"><span class=\"" . cleanClassname($row["home"]) . "\">". $row["home"] . "</span> - <span class=\"". cleanClassname($row["away"]) ."\"> ". $row[away] . "</span></td>";
    71                 $content = $content . "<td>" . $row["score"] . "</td>";
    72                 $content = $content . "<td itemprop=\"description\">". $row["competition"]. "</td>";
    73                 $content = $content . "<td itemprop=\"location\" itemscope itemtype=\"http://schema.org/Place\"><span itemprop=\"name\">" .$row["venue"] ."</span></td>";
    74                 $content = $content . "</tr>";
    75                 //print_r($row);
     59                 $content = $content . "<tr>";
     60                    foreach($row as $key => $value):
     61                    $content = $content . "<td>" .$value . "</td>";
     62                    endforeach;
     63                 $content = $content . "</tr>";
    7664                endforeach;
    77         endif;
     65        //endif;
    7866    endforeach;
    7967   

  • gdata-importer/trunk/readme.txt

    r506575 r507238  
    55Requires at least: 2.0.2
    66Tested up to: 3.3.1
    7 Stable tag: 3.3
     7Stable tag: 1.0.1
    88
    99A plugin imports google spreadsheet data into the wordpress post using shortcode.
    … …  
    1616
    1717Use the short code
    18 [gdata sheet="sheeturl" workbook="workbookname"]
     18[gdata sheet="sheeturl" worksheet="workbookname"]
    1919
    2020Example:
    … …  
    3030== Frequently Asked Questions ==
    3131
    32 Q. Is is neccessary to set username/password in plain text format in the index.php?
    33 A. Yes at the moment, new version will have the option to save it in database with encryption.
     32= Is is neccessary to set username/password in plain text format in the index.php?
     33
     34Yes at the moment, new version will have the option to save it in database with encryption.
    3435
    3536== Screenshots ==
    … …  
    3940== Changelog ==
    4041
    41 = 1.0 =
    42 First version.
     42= 1.0.1 =
     43Bug Fixes.
     44
     45= 1.0.0 =
     46Initial release.
    4347
    4448== Upgrade Notice ==
    45 = 1.0 =
     49= 1.0.1 =
    4650Latest Version
Note: See TracChangeset for help on using the changeset viewer.