<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>DataGrid[ Search for &quot;&quot;]</title>
        <description></description>
        <link>http://xataface.com/wiki/index.php?-action=single_record_search&amp;-table=wiki&amp;page_id=%3D32&amp;-cursor=0&amp;-skip=0&amp;-limit=30&amp;-mode=list&amp;--subsearch=</link>
        <lastBuildDate>Mon, 06 Sep 2010 08:17:43 +0100</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>DataGrid</title>
            <link>http://xataface.com/wiki/index.php?-table=wiki&amp;-action=browse&amp;page_id=%3D32</link>
            <description>&lt;table&gt;&lt;thead&gt;&lt;tr&gt;&lt;th&gt;Field&lt;/th&gt;&lt;th&gt;Value&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page name&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;DataGrid&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page id&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;32&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page title&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;DataGrid&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Content&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;
&lt;h2 id=&quot;toc0&quot;&gt;Xataface DataGrid Module&lt;/h2&gt;
&lt;p&gt;Created by Steve Hannah, &lt;a href=&quot;http://weblite.ca&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;Web Lite Solutions Corp.&lt;/a&gt;&lt;/p&gt;


&lt;h3 id=&quot;toc1&quot;&gt;Synopsis&lt;/h3&gt;
&lt;p&gt;The Xataface DataGrid module uses the Ext DataGrid component (&lt;a href=&quot;http://extjs.com&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://extjs.com&lt;/a&gt;) to add an editable grid component to your Xataface application.&lt;/p&gt;

&lt;table border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;&gt;&lt;tr&gt;&lt;td&gt;
&lt;div id=&quot;toc&quot;&gt;&lt;strong&gt;Table of Contents&lt;/strong&gt;
	&lt;div style=&quot;margin-left: 0em;&quot;&gt;&lt;a href=&quot;#toc0&quot;&gt;Xataface DataGrid Module&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc1&quot;&gt;Synopsis&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc2&quot;&gt;Requirements&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc3&quot;&gt;License&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc4&quot;&gt;Demo Video&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc5&quot;&gt;Screenshots&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc6&quot;&gt;Demo&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc7&quot;&gt;Download&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc8&quot;&gt;Installation&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc9&quot;&gt;Setting Up Permissions&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc10&quot;&gt;Usage&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc11&quot;&gt;Limitations&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc12&quot;&gt;Support/Questions&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;


&lt;h3 id=&quot;toc2&quot;&gt;Requirements&lt;/h3&gt;
&lt;ul&gt;
    &lt;li&gt; PHP 4.3+&lt;/li&gt;
    &lt;li&gt; MySQL 4.1+&lt;/li&gt;
    &lt;li&gt; Xataface 0.8+&lt;/li&gt;
&lt;/ul&gt;


&lt;h3 id=&quot;toc3&quot;&gt;License&lt;/h3&gt;
&lt;p&gt;This module is distributed with ExtJS 2.2, which is distributed under the GPL v 3 (&lt;a href=&quot;http://extjs.com/products/license.php&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://extjs.com/products/license.php&lt;/a&gt;).&lt;/p&gt;

&lt;p&gt;In order to be compatible with the ExtJS license, this module is also distributed under the terms of the GPL v3 (&lt;a href=&quot;http://www.gnu.org/copyleft/gpl.html&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://www.gnu.org/copyleft/gpl.html&lt;/a&gt;).&lt;/p&gt;


&lt;h3 id=&quot;toc4&quot;&gt;Demo Video&lt;/h3&gt;
&lt;p&gt;
&lt;embed src=&quot;http://media.weblite.ca/lib/flvplayer.swf&quot; width=&quot;640&quot; height=&quot;500&quot; bgcolor=&quot;#FFFFFF&quot; type=&quot;application/x-shockwave-flash&quot; pluginspage=&quot;http://www.macromedia.com/go/getflashplayer&quot; flashvars=&quot;file=http%3A%2F%2Fs3.amazonaws.com%2Fweblite_media%2FDataGrid-640x480.flv&amp;image=http%3A%2F%2Fmedia.weblite.ca%2Ffiles%2Fphotos%2FDataGrid-640x480.flv.jpg&amp;showdigits=true&amp;autostart=false&quot; /&gt;
&lt;/p&gt;


&lt;h3 id=&quot;toc5&quot;&gt;Screenshots&lt;/h3&gt;
&lt;p&gt;Click on image to enlarge&lt;/p&gt;

&lt;p&gt;
&lt;script language=&quot;javascript&quot; type=&quot;text/javascript&quot; src=&quot;http://media.weblite.ca/index.php?-action=gallery&amp;-table=files&amp;categories=8&amp;-cursor=0&amp;-skip=0&amp;-limit=30&amp;-mode=list&amp;-photo_max_width=640&amp;--format=js&quot;&gt;&lt;/script&gt;

&lt;div style=&quot;clear:both&quot;&gt;&amp;nbsp;&lt;/div&gt;
&lt;/p&gt;


&lt;h3 id=&quot;toc6&quot;&gt;Demo&lt;/h3&gt;
&lt;ol&gt;
    &lt;li&gt; LibrarianDB Demo: &lt;a href=&quot;http://demo.weblite.ca/apps/librariandb/index.php?-table=books&amp;amp;-action=DataGrid_view&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://demo.weblite.ca/apps/librariandb/index.php?-table=books&amp;amp;-action=DataGrid_view&lt;/a&gt; , &lt;strong&gt;Log in with username &amp;quot;admin&amp;quot; and password &amp;quot;password&amp;quot;&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;


&lt;h3 id=&quot;toc7&quot;&gt;Download&lt;/h3&gt;
&lt;ul&gt;
    &lt;li&gt; &lt;a href=&quot;https://sourceforge.net/project/platformdownload.php?group_id=250381&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;DataGrid-0.2&lt;/a&gt;&lt;/li&gt;
    &lt;li&gt; SVN Repository: &lt;a href=&quot;http://weblite.ca/svn/dataface/modules/DataGrid&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://weblite.ca/svn/dataface/modules/DataGrid&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;


&lt;h3 id=&quot;toc8&quot;&gt;Installation&lt;/h3&gt;
&lt;ol&gt;
    &lt;li&gt; Download and extract the DataGrid directory into your xataface/modules directory.&lt;/li&gt;
    &lt;li&gt; Add the following line to the [_modules] section of your application's &lt;a href=&quot;/wiki/conf.ini_file&quot;&gt;conf.ini file&lt;/a&gt;:
&lt;pre&gt;&lt;code&gt;modules_DataGrid=modules/DataGrid/DataGrid.php&lt;/code&gt;&lt;/pre&gt;

&lt;/li&gt;
    &lt;li&gt; Ensure that your permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt; are set up appropriately to allow your users to access the grid action (see next section).&lt;/li&gt;
&lt;/ol&gt;


&lt;h3 id=&quot;toc9&quot;&gt;Setting Up Permissions&lt;/h3&gt;
&lt;p&gt;This module defines the following permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt;:&lt;/p&gt;

&lt;ul&gt;
    &lt;li&gt; DataGrid:view_grid      - Permission to view the data grid for a table.&lt;/li&gt;
    &lt;li&gt; DataGrid:create_grid    - Permission to create a new data grid&lt;/li&gt;
    &lt;li&gt; DataGrid:edit_grid        - Permission to edit an existing data grid&lt;/li&gt;
    &lt;li&gt; DataGrid:update            - Permission to update records via the grid&lt;/li&gt;
    &lt;li&gt; DataGrid:manage_grids    - Permission to access the datagrid control panel&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;In order for a user to access/use the grid he must be granted at least the Datagrid:view_grid and DataGrid:update permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt;.  Both of these permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt; are included in the following system roles by default:&lt;/p&gt;

&lt;ul&gt;
    &lt;li&gt; EDIT&lt;/li&gt;
    &lt;li&gt; EDIT AND DELETE&lt;/li&gt;
    &lt;li&gt; DELETE&lt;/li&gt;
    &lt;li&gt; ADMIN&lt;/li&gt;
    &lt;li&gt; MANAGER&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;And of course these permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt; are included with the call to Dataface_PermissionsTool::ALL() .&lt;/p&gt;

&lt;p&gt;If you have assigned your own custom roles and want to enable access to the grid, you can simply add the following to your role definition in your &lt;a href=&quot;/wiki/permissions.ini_file&quot;&gt;permissions.ini file&lt;/a&gt;: 
&lt;pre&gt;&lt;code&gt;[MY ROLE]
    DataGrid:view_grid=1
    DataGrid:update=1&lt;/code&gt;&lt;/pre&gt;

&lt;/p&gt;

&lt;p&gt;If you want to explicitly disable the grid for a role, you can extend the role and deny those same permissions&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=permissions&quot;&gt;?&lt;/a&gt;: 
&lt;pre&gt;&lt;code&gt;[MY ROLE extends MY ROLE]
    DataGrid:view_grid=0
    DataGrid:update=0&lt;/code&gt;&lt;/pre&gt;

&lt;/p&gt;

&lt;p&gt;&lt;pre&gt;    &lt;/pre&gt; 
&lt;h3 id=&quot;toc10&quot;&gt;Usage&lt;/h3&gt;
&lt;/p&gt;

&lt;p&gt;Once installed, log in as a user that has permission to access the grid. You should notice a new tab along with &amp;quot;details&amp;quot;, &amp;quot;list&amp;quot;, and &amp;quot;find&amp;quot;, called &amp;quot;grid&amp;quot;. Click on the &amp;quot;grid&amp;quot; tab to access the grid.&lt;/p&gt;

&lt;p&gt;You can double click on any field to edit it.  Modified fields will be marked in red, and automatically saved every 5 seconds - after the changes are saved the field is no longer marked in red.&lt;/p&gt;


&lt;h3 id=&quot;toc11&quot;&gt;Limitations&lt;/h3&gt;
&lt;p&gt;Currently only fields with the following widget types are available to be edited in the grid:&lt;/p&gt;

&lt;ol&gt;
    &lt;li&gt; text&lt;/li&gt;
    &lt;li&gt; textarea&lt;/li&gt;
    &lt;li&gt; select&lt;/li&gt;
    &lt;li&gt; date/datetime/time&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Other types of fields will simply not be included in the grid.&lt;/p&gt;


&lt;h3 id=&quot;toc12&quot;&gt;Support/Questions&lt;/h3&gt;
&lt;p&gt;Visit the Xataface forum at &lt;a href=&quot;http://xataface.com/forum&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;http://xataface.com/forum&lt;/a&gt;&lt;/p&gt;

&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Language&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;en&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;</description>
            <author>DataGrid</author>
        </item>
    </channel>
</rss>
