xfemail[ Search for ""]

Application Versioning & Synchronization with Xataface

62 — Wed, 26 Nov 2008 14:16:49 +0100

Field	Value
News id	62
Headline	Application Versioning & Synchronization with Xataface
Content	One of the more annoying challenges involved with managing production web applications is keeping the development and production versions in sync. Verson control systems such as Subversion and CVS make this task trivial for source code and file system changes, but changes to the database schema between versions still need to be handled with [...]
Date posted	Wed Nov 26 06:16:49 2008
Posted by	shannah
Status	Approved
Categories	Blog
Source id	Steve Hannah's Blog
Source url	http://www.sjhannah.com/blog/?p=144

Replacing Scriptaculous/Prototype with jQuery

63 — Tue, 25 Nov 2008 14:34:24 +0100

Field	Value
News id	63
Headline	Replacing Scriptaculous/Prototype with jQuery
Content	I have used Scriptaculous in the past to sprinkle little bits of UI magic into Xataface. Specifically, I have used it to add collapsible sections, sortable sections (via drag-and-drop), and sortable tables (also via drag and drop). These worked great! The Scriptaculous library was a bit bulky and it made the initial [...]
Date posted	Tue Nov 25 06:34:24 2008
Posted by	shannah
Status	Approved
Categories	Blog
Source id	Steve Hannah's Blog
Source url	http://www.sjhannah.com/blog/?p=143

SVN committing

70 — Sat, 22 Nov 2008 21:01:00 +0100

Field	Value
News id	70
Headline	SVN committing
Content	This isn't exactly a Xataface related issue, but I found myself continually forgetting about this that I thought it would be good to blog about this so I can remember. When I have ssh'ed onto the server and I need to do a svn commit, I get an error message about not having an editor to input my svn commit message. The following piece of code fixes this:br /br /blockquotebr /export EDITOR=vibr //blockquotebr /br /Where vi is the editor program we are using. If you have something else installed on your server (and hopefully you do because vi really blows), then you can just use that.
Date posted	Sat Nov 22 13:01:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/11/svn-committing.html

Testing Xataface on IE6 when you have Vista

71 — Sun, 16 Nov 2008 15:42:00 +0100

Field	Value
News id	71
Headline	Testing Xataface on IE6 when you have Vista
Content	So I ran into a pretty annoying problem the other day. I had to test a Xataface application on IE6 with Vista as my OS. Which basically meant I had IE7 preinstalled, and I couldn't install IE6. Ughh...annoying. I don't understand why people still use IE6, but whatever.br /br /The best way to actually shove this is to install a virtual machine with the OS set to XP and then you can use IE6 on it. To do this follow this a href="http://www.raizlabs.com/blog/?p=221"tutorial/a. br /br /One thing you need to note is that Virtual PC 2004 does NOT work on Vista. So you actually have to use Virtual PC (VPC) 2007 . This can be found a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=04D26402-3199-48A3-AFA2-2DC0B40A73B6displaylang=en"here/a. The "Internet Explorer 6 Testing VPC Image" is still the same.br /br /Another annoying thing is that VPC 2007 is NOT fully supported with Vista Home edition (UGHHH...why are things to complicated!). And you'll be faced with all these messages not non-compatibility. But you are just limited from some features which I didn't bother looking directly into. But if you just want to test Xataface sites on it, then just ignore the messages and install it.br /br /After you have loaded the VPC image, then the next step is to actually setup internet connection from inside the VPC. If you are using a LAN connection, then do this:br /br /olbr /liEdit/libr /liSettings/libr /liNetworking /libr /liAdaptor 1: NAT/libr //olbr /br /Try to connect now, and if you have a firewall on then you will be prompted to allow the VPC to pass it. After you "unblock" it, then everything should work!br /br /If you are using wireless, then use this a href="http://claytonj.wordpress.com/2007/02/02/connect-virtual-pc-to-internet/"tutorial/a.
Date posted	Sun Nov 16 07:42:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/11/testing-xataface-on-ie6-when-you-have.html

Adding some text when no block/slot exists

72 — Wed, 12 Nov 2008 15:01:00 +0100

Field	Value
News id	72
Headline	Adding some text when no block/slot exists
Content	Sometimes you need to add some text to a certain template, but Xataface doesn't have the specific block or slot to use. For example, say you wanted to include some text underneath the password field in the login page for Xataface. You can't do this with blocks or slots since nothing exists underneath that field. You can however do a workaround by using javascript and the DOM concept. br /br /For example:br /br /blockquotebr /function block__after_login_form(){br /lt;script language=quot;javascriptquot;gt;lt;!--br /var div = document.createElement(#39;div#39;);br /div.className = 'formHelp';br /var text = document.createTextNode(#39;Please enter the correct password#39;);br /div.appendChild(text);br /br /document.getElementById(#39;Login-Password#39;).appendChild(div);br ///--gt;lt;/scriptgt;br /}br //blockquotebr /br /First thing to notice is we are using the block__after_login_form() which simply a block on that template. We are using it to include our javascript of interest. We could have actually used any block. br /br /blockquotevar div = document.createElement(#39;div#39;);/blockquotebr /br /The first thing we do is create a div element.br /br /blockquotediv.className = 'formHelp';/blockquotebr /br /Here are just giving it the css class name of formHelp which gives it a nice styling feel. This is the same style used for widget:description values.br /br /blockquotevar text = document.createTextNode(#39;Please enter the correct password#39;);/blockquotebr /br /And then we create a textnode which contains the text of interest.br /br /blockquotediv.appendChild(text);/blockquotebr /br /With out div element, we are appending the text node we just created to it.br /br /blockquotedocument.getElementById(#39;Login-Password#39;).appendChild(div);/blockquotebr /br /And finally we add our div element to our element of interest which happens to have the id of "Login-Password" This id has been assigned by Xataface itself.br /br /And if everything works out fine, then you should see the text appear below the password field!br /br /You can find more information about how to manipulate DOM structure using javascript a href="http://www.howtocreate.co.uk/tutorials/javascript/domstructure"here/a.
Date posted	Wed Nov 12 07:01:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/11/adding-some-text-when-no-blockslot.html

Displaying Xataface record values

33 — Sat, 02 Aug 2008 10:41:00 +0100

Field	Value
News id	33
Headline	Displaying Xataface record values
Content	Taking a look at the Xataface Record API presents you with several techniques to display the values of the record. At the lowest level, there is a function called val and can be called like this (assuming $rec is a Xataface record)<br /><br /><blockquote>$rec->val('fieldname')</blockquote><br /><br />What this does is it displays the raw value of field. As in exactly what is stored in the database. <br /><br />But what happens if the value is say a foreign key to another table say like a number of a company. We don't really want to display just the number, but rather the company name of the id. If a valuelist has been setup for this company_id in a valuelist.ini file, then you can easily display the field you really want by simply using the "display" function. <br /><br />So say for example, in your application delegate's valuelists.ini file you have this:<br /><br /><blockquote><br />[companies]<br />__sql__="select company_id,company_name from companies order by company_name"<br /></blockquote><br /><br />So you are basically telling Xataface to use the company_name as a replacement for the company_id. Since this is the application's delegate, this valuelist is accessible by any table and can be overwritten the own table's valuelist. In any case, if in your other table you just call:<br /><br /><blockquote>$rec->display('company_id')</blockquote><br /><br />Xataface will be smart enough to use the company_name in replacement for the company_id. This display function is also useful for database field types datetime, time, or date. If you were simply use the "val" function it would return the date as an array with keys "year", "month", "seconds", etc. And you would be left with having to piece together the information yourself. But by using the display() function you can quickly circumvent this problem.
Date posted	Sat Aug 2 03:41:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/08/displaying-xataface-record-values.html

Xataface: Setting a logo for a xataface record

34 — Thu, 31 Jul 2008 07:40:00 +0100

Field	Value
News id	34
Headline	Xataface: Setting a logo for a xataface record
Content	When you go into the details view of a record, in addition to the all the different values in the database about the record, you can also specify a logo for that record and this logo will appear in the top left corner of the record.<br /><br />You should first refer to this <a href="http://framework.weblite.ca/documentation/how-to/how-to-handle-file-uploads">document</a> on how to actually store images/file in xataface.<br /><br />I used method two because I always find it much easier to manage when the files exist physically and not just as bytes in the database. So let's assume that the picture field in the database is what is storing the file name in the database, and you have a directory called picture in your delegate class.<br /><br />The next step is to go into your delegate class that represents this record and include this function:<br /><br /><br /><blockquote><br /><br />function field__friend_picture(&$record){<br /> return '<img src="'.$record->display('picture').'"></img>'; <br /> } <br /><br /></blockquote><br /><br />What this does is define a custom field called friend_picture which will basically return the image. By using $record->display() we are returning the whole address of the picture. Xataface is smart enough to figure out how to return the address.<br /><br />This is opposed to using $record->val('picture') which would return the raw value of the field in the database which would just be the filename. <br /><br />And then final step is to go into the fields.ini file of this delegate class and include this:<br /><br /><blockquote><br />[friend_picture]<br />logo = 1<br /></blockquote><br /><br />This causes xataface to recognize this was a logo field for the record and then display the picture in the top left hand corner of the detail view of the record.<br /><br />And volia!<br /><br />Some things to note is that trying to include the logo = 1 as attribute for the field that holds the filename that's seem to work. For example, say in the fields.ini file you have:<br /><br /><blockquote><br />[picture]<br />logo = 1<br /></blockquote><br /><br />This would place this field to the top left hand corner, but it would just say "View Field Content In New Window ()" in the top left hand corner. You have to make a custom field. <br /><br />Also, you can specify exactly records of which table should display logos by including this line of code in the ApplicationDelegate class' getPreferences() function:<br /><br /><blockquote><br />//this is needed to determine which table records will have a logo on them<br /> if ( !in_array($query['-table'], array('companies', 'dealers','news', 'strategies', 'offerings') ) ){<br /> $prefs['hide_record_view_logo'] = 1;<br /> }<br /></blockquote><br /><br />What this basically did was check whether the current table viewing this record was either companies, dealer, etc. And if it wasn't, it would turn the hide_record_view_logo preference. So a modified line of code could be like this:<br /><br /><blockquote><br />if ( !in_array($query['-table'], array('companies', 'dealers','news', 'strategies, 'offerings') ) ){<br /> $prefs['hide_record_view_logo'] = 1;<br /> }<br /></blockquote>
Date posted	Thu Jul 31 00:40:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/07/xataface-setting-logo-for-xataface.html

Smarty Tags

39 — Thu, 05 Jun 2008 11:13:00 +0100

Field	Value
News id	39
Headline	Smarty Tags
Content	So Xataface employs smarty templates throughout its application to apply its styles and stuff. I am not 100% sure how it works, but there are list of ENV variables which are available to be used throughout any template file in xataface. These ENV variables can be found at this <a href="http://lamp.weblite.ca/dataface-0.6/docs/index.php?-table=Classes&-action=browse&ClassID=%3D41">link</a>.
Date posted	Thu Jun 5 04:13:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/06/smarty-tags.html

The debug option

42 — Tue, 03 Jun 2008 21:36:00 +0100

Field	Value
News id	42
Headline	The debug option
Content	You have the option of turning on debug = 1 in the conf.ini file in the application folder of a Xataface application. What this will do is basically display all the possible blocks you can insert code/templates into. <br /><br />Slots will not be displayed in the page, but rather they will be present in the html code in comments.
Date posted	Tue Jun 3 14:36:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/06/debug-option.html

Xataface - How to unset tabs in the table view

47 — Wed, 23 Apr 2008 07:29:00 +0100

Field	Value
News id	47
Headline	Xataface - How to unset tabs in the table view
Content	Inside of a delegate class' fields.ini file, you can specify the notion of "tabs" and actually put separate fields into their tabs. <br /><br />Sometimes you don't want a tab to appear in the view of a record. You can set the permissions of this like this:<br /><br /><blockquote><br /><br />function __tabs__(&$record){<br /> $user =& getUser();<br /> <br /> $t =& $record->_table;<br /> $tabs = $t->_tabs;<br /> if ( $record and !isAdmin() ){<br /> <br /> if ( !$record->val('people_approval_status') )<br /> unset($tabs['__people__']);<br /> if ( !$record->val('researcher_approval_status') )<br /> unset($tabs['__gcms__']);<br /> }<br /> return $tabs;<br />}<br /></blockquote><br /><br />Here we call the __tabs__ function to actually process the tabs before they are run. And then we unset the tabs that we don't want the user to see.
Date posted	Wed Apr 23 00:29:00 2008
Posted by	noreply@blogger.com (Fong Chun Chan)
Status	Approved
Categories	Blog
Source id	Fong's Blog
Source url	http://fongxataface.blogspot.com/2008/04/xataface.html

xfemail

shannah — Wed, 16 Dec 2009 21:28:42 +0100

Field	Value
Product id	8
Freshmeat project name	xfemail
Use freshmeat details	1
Freshmeat data	<?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE project-listing SYSTEM "http://freshmeat.net/backend/fm-projects-0.4.dtd"> <project-listing> <project> <project_id>72221</project_id> <date_added>2009-02-19 17:26:41</date_added> <date_updated>2009-02-19 19:23:58</date_updated> <projectname_short>xfemail</projectname_short> <projectname_full>Xataface Email Module</projectname_full> <desc_short>A Xataface module to email any set found in a MySQL database.</desc_short> <desc_full>Xataface Email Module allows you to email to the results of any set found in a Xataface application. This allows you to easily convert your existing database of contacts into a mailing list. It supports HTML email, recipient opt-out, mailmerge macros, and more. The email is sent in the background via a cron script, so arbitrarily large email lists can be supported.</desc_full> <vitality_score>1.00</vitality_score> <vitality_percent>0.00</vitality_percent> <vitality_rank>25885</vitality_rank> <popularity_score>29.87</popularity_score> <popularity_percent>0.05</popularity_percent> <popularity_rank>44181</popularity_rank> <rating>0.00</rating> <rating_count>0</rating_count> <rating_rank>405</rating_rank> <subscriptions>1</subscriptions> <branch_name>Default</branch_name> <url_project_page>http://freshmeat.net/projects/xfemail/</url_project_page> <url_homepage>http://freshmeat.net/redir/xfemail/77903/url_homepage/</url_homepage> <url_tgz>http://freshmeat.net/redir/xfemail/77903/url_tgz/</url_tgz> <url_bz2></url_bz2> <url_zip>http://freshmeat.net/redir/xfemail/77903/url_zip/</url_zip> <url_changelog></url_changelog> <url_rpm></url_rpm> <url_deb></url_deb> <url_osx></url_osx> <url_bittorrent></url_bittorrent> <url_bsdport></url_bsdport> <url_autopackage></url_autopackage> <url_jar></url_jar> <url_purchase></url_purchase> <url_cvs></url_cvs> <url_bugtracker></url_bugtracker> <url_list></url_list> <url_mirror></url_mirror> <url_demo></url_demo> <license>GNU General Public License v2</license> <latest_release> <latest_release_version>0.1</latest_release_version> <latest_release_id>294520</latest_release_id> <latest_release_date>2009-02-19 19:23:58</latest_release_date> </latest_release> <screenshot_thumb></screenshot_thumb> <authors> <author> <author_name>Steve Hannah</author_name> <author_url>http://freshmeat.net/~shannah/</author_url> <author_role>Owner</author_role> </author> </authors> <descriminators> <trove_id>10</trove_id> <trove_id>237</trove_id> <trove_id>3</trove_id> <trove_id>4</trove_id> <trove_id>1130</trove_id> <trove_id>235</trove_id> <trove_id>183</trove_id> <trove_id>30</trove_id> <trove_id>68</trove_id> <trove_id>914</trove_id> </descriminators> <dependencies> <dependency type="required"> <dependency_release_id>0</dependency_release_id> <dependency_branch_id>0</dependency_branch_id> <dependency_project_id>58929</dependency_project_id> <dependency_project_title>Xataface</dependency_project_title> </dependency> <dependency type="required"> <dependency_release_id>0</dependency_release_id> <dependency_branch_id>0</dependency_branch_id> <dependency_project_id>6904</dependency_project_id> <dependency_project_title>MySQL</dependency_project_title> </dependency> </dependencies> </project> </project-listing>
Product name	Xataface Email Module
Product description	Xataface Email Module allows you to email to the results of any set found in a Xataface application. This allows you to easily convert your existing database of contacts into a mailing list. It supports HTML email, recipient opt-out, mailmerge macros, and more. The email is sent in the background via a cron script, so arbitrarily large email lists can be supported.
Product license	GNU General Public License v2
Download url	https://sourceforge.net/project/platformdownload.php?group_id=253820
Website url	http://xataface.com/wiki/Email
Product category	Xataface Modules
Date posted	Wed Feb 18 23:15:58 2009
Last modified	Wed Dec 16 13:28:42 2009
Owner id	shannah