jQuery.extend(Drupal.settings, {"basePath":"\/","CTools":{"pageId":"page-6f55a3dab9245b9753f660c011339be7"},"googleanalytics":{"trackOutgoing":1,"trackMailto":1,"trackDownload":1,"trackDownloadExtensions":"7z|aac|avi|csv|doc|exe|flv|gif|gz|jpe?g|js|mp(3|4|e?g)|mov|pdf|phps|png|ppt|rar|sit|tar|torrent|txt|wma|wmv|xls|xml|zip"},"lightbox2":{"rtl":0,"file_path":"\/(\\w\\w\/)sites\/default\/files","default_image":"\/sites\/all\/modules\/lightbox2\/images\/brokenimage.jpg","border_size":"2","font_color":"000","box_color":"fff","top_position":"","overlay_opacity":"0.6","overlay_color":"000","disable_close_click":1,"resize_sequence":"0","resize_speed":100,"fade_in_speed":100,"slide_down_speed":100,"use_alt_layout":0,"disable_resize":0,"disable_zoom":0,"force_show_nav":0,"loop_items":1,"node_link_text":"","node_link_target":0,"image_count":"Image !current of !total","video_count":"Video !current of !total","page_count":"Page !current of !total","lite_press_x_close":"press \x3ca href=\"#\" onclick=\"hideLightbox(); return FALSE;\"\x3e\x3ckbd\x3ex\x3c\/kbd\x3e\x3c\/a\x3e to close","download_link_text":"","enable_login":false,"enable_contact":false,"keys_close":"c x 27","keys_previous":"p 37","keys_next":"n 39","keys_zoom":"z","keys_play_pause":"32","display_image_size":"","image_node_sizes":"()","trigger_lightbox_classes":"","trigger_lightbox_group_classes":"","trigger_slideshow_classes":"","trigger_lightframe_classes":"","trigger_lightframe_group_classes":"","custom_class_handler":0,"custom_trigger_classes":"","disable_for_gallery_lists":true,"disable_for_acidfree_gallery_lists":true,"enable_acidfree_videos":true,"slideshow_interval":5000,"slideshow_automatic_start":true,"slideshow_automatic_exit":true,"show_play_pause":true,"pause_on_next_click":false,"pause_on_previous_click":true,"loop_slides":false,"iframe_width":"600","iframe_height":"400","iframe_border":0,"enable_video":0},"thickbox":{"close":"Close","next":"Next \x3e","prev":"\x3c Prev","esc_key":"or Esc Key","next_close":"Next \/ Close on last","image_count":"Image !current of !total"}});
an update of fmSQL Synch, a replication and synchronizing utility which<br />
updates records in both a FileMaker and SQL database. Available for Mac OS<br />
9 and Mac OS X, fmSQL Synch employs AppleEvents and JDBC to exchange data<br />
between FileMaker and SQL databases.</p>
<p>Existing databases can be configured for synchronizing with just a few<br />
modifications. fmSQL Synch can also be used to migrate data to/from<br />
FileMaker and SQL databases.</p>
<p>Two-way synchronizing will update data from both FileMaker and SQL<br />
databases. Synchronizing includes updating changed records as well as<br />
adding or deleting records. Any record changes made in the FileMaker<br />
databases are replicated in the SQL database and vice-versa.</p>
<p>fmSQL Synch employs field-level conflict checking and resolution. Changes<br />
to records in both databases are compared on a field-by-field basis. Any<br />
records that have been modified on both FileMaker and SQL database since<br />
the last synchronization will have all change conflicts logged so the user<br />
can choose which data to keep.</p>
<p>fmSQL Synch has been designed to be easy to use. The setup assistant will<br />
walk the user through the required configuration steps, including setting<br />
up the JDBC connection details and choosing which fields to use from each<br />
table.</p>
<p>Easily integrate existing FileMaker solutions with a few extra<br />
modifications to any existing databases. Once modified the user can use<br />
fmSQL Synch to synchronize FileMaker and SQL databases and control all<br />
synching conflicts.</p>
<p>After selecting which fields to synchronize in the SQL tables, the user can<br />
have fmSQL Synch create all the SQL statements automatically. The user can<br />
even let fmSQL Synch create the SQL tables which also makes it useful as a<br />
tool for FM to SQL migration.</p>
<p>"Companies have found cost savings in using a separate web database and are<br />
looking for ways to exchange data with both their web database and their<br />
in-house database" said Charlie Garrison, founder of Garrison Computer<br />
Services. "fmSQL Synch was developed to make that data exchange easy and<br />
reliable."</p>
<p>"The updated fmSQL Synch app worked flawlessly today. Tried couple of times<br />
as I did before, I can not break the synchronization. Besides my testings,<br />
the fmSQL Synch synchronization has kept pace with our Production users<br />
throughout the day. Needless to say, I am ecstatic."<br />
--Henry Chang, Pentagon Technologies</p>
<p>CHANGES IN LATEST VERSION</p>
<p>fmSQL Synch v1.0.1 has a few new features as well as some bug fixes:</p>
<p>- Added DEBUG logging to assist with finding 'set data' errors<br />
- Added support for varying SQL date formats (eg. mySQL, MS SQL, etc)<br />
- Bug fixes & additional support for US vs int'l date formats<br />
- Change IDParent in MergeConflicts and DeleteLog from type 'number' to 'text'<br />
- Updated documentation</p>
<p>PRICING AND AVAILABILITY</p>
<p>fmSQL Synch is available now in two versions; with and without a license for<br />
SQL Plugin. The bundle with a license for the SQL Plugin is on special until<br />
May 15.</p>
<p>- fmSQL Synch, single-user US$129<br />
- fmSQL Synch with SQL Plugin, single-user US$149</p>
<p>To download a demo or for purchasing options, please visit the company's web<br />
site at <a href="http://www.garrison.com.au/products/fmsql_synch.html" title="http://www.garrison.com.au/products/fmsql_synch.html">http://www.garrison.com.au/products/fmsql_synch.html</a>, send email to<br />
<a href="mailto:sales@garrison.com.au">sales@garrison.com.au</a>, or call +61 2 4575 5247.</p>
<p>REQUIREMENTS</p>
<p>- OS9 or OSX 10.2 or later<br />
- FileMaker Pro v4 or later (not compatible with FMv7 until fmSQL Synch v2)<br />
- SQL Plugin v2.1.2 or later<br />
- JDBC driver for the SQL database</p>
<p>Note: fmSQL Synch v2 is fully compatible with FMv7. Version 2 is in final<br />
beta testing and a public beta will be released in a few weeks.</p>
<p>The SQL Plugin from Rumora Automatisering en Advies is required. The latest<br />
version (at this time) is SQL Plugin 2.1.4. The plugin is commercial<br />
software but a demo version is available for testing fmSQL Synch. A demo<br />
copy of the plugin is included in the fmSQL Synch package. A version of<br />
fmSQL Synch bundled with SQL Plugin is available.</p>
<p>A JDBC driver for the SQL database is also required. fmSQL Synch has been<br />
developed for use with mySQL but any database which has a JDBC driver<br />
should work. The latest version (at this time) is MySQL Connector/J 3.0.15.<br />
The driver is free to download and its use is licensed under the GPL. The<br />
mySQL driver has been included in the fmSQL Synch package for convenience.</p>
<p>ABOUT GARRISON COMPUTER SERVICES</p>
<p>Garrison Computer Services develops web applications and database solutions<br />
for small to medium sized businesses. The company has specialized in<br />
automating Macintosh software and systems since 1987. Other products from<br />
the company include Make Tracks, a customizable FileMaker template for<br />
marketing and customer service databases, and Email Archiver, a tool for<br />
keeping the size of mailboxes to a reasonable limit. For more information,<br />
please visit the company's web site at <a href="http://www.garrison.com.au/" title="http://www.garrison.com.au/">http://www.garrison.com.au/</a>, send<br />
email to <a href="mailto:info@garrison.com.au">info@garrison.com.au</a>, or call +61 2 4575 5247.</p>
<div class="links"><ul class="links inline"><li class="comment_forbidden first last"><span><a href="/user/login?destination=comment%2Freply%2F85380%23comment-form">Login</a> or <a href="/user/register?destination=comment%2Freply%2F85380%23comment-form">register</a> to post comments</span></li>
</ul></div>
</div>
<div class="left_inner_box_bottom"> </div>
</div>
<!--[if !IE]> End left box inner page <![endif]--></div>
<!--[if !IE]>End left content<![endif]--> <!--[if !IE]>Start right content<![endif]-->
<span class="field-content"><a href="http://forums.applecentral.com/ubbthreads.php/topics/537782/Analyst_sees_iPad_killers_less#Post537782" target="_blank"> Analyst sees iPad killers le...</a></span>
</div>
</div>
<div class="views-row views-row-5 views-row-odd">
<div class="views-field-title">
<span class="field-content"><a href="http://forums.applecentral.com/ubbthreads.php/topics/537649/Small_business_accounting_soft#Post537649" target="_blank"> Small business accounting so...</a></span>
<span class="field-content">Introducing the App Hall of Fame!</span>
</div>
<div class="views-field-body">
<div class="field-content"><div class="body-row" id="body-row-213485"><div style="background:#F5F5F5;">App discoverability continues to be a real issue. With the fast churn of apps in the App Store, an app has only a few weeks of promotional life in it before it‚Äôs largely forgotten. There are a few things developers can do to fix that, but those... | Read more »</div></div></div>
<span class="field-content">Gobliiins Are Coming</span>
</div>
<div class="views-field-body">
<div class="field-content"><div class="body-row" id="body-row-213486"><div style="background:#F5F5F5;">In the midst of the huge Q4 launch schedule, the cult classic, Gobliiins, as well as the rest of the trilogy, are being ported to the iPhone in all of their original glory. The Goblins trilogy was a quirky Atari/Amiga game series from the early 90‚Äôs... | Read more »</div></div></div>
</div>
</div>
<div class="views-row views-row-3 views-row-odd">
<div class="views-field-title">
<span class="field-content">myPhoneDesktop – Chrome to iPhone Extens...</span>
</div>
<div class="views-field-body">
<div class="field-content"><div class="body-row" id="body-row-213469"><div style="background:#F5F5F5;">Anyone who has used myPhoneDesktop knows that it is a fantastic tool for streamlining your onscreen workflow. Instead of having to type line after line into your phone directly, you can use myPhoneDesktop to type from your computer directly into... | Read more »</div></div></div>
<span class="field-content">AutoVerbal Talking Soundboard Pro helps...</span>
</div>
<div class="views-field-body">
<div class="field-content"><div class="body-row" id="body-row-213471"><div style="background:#F5F5F5;">Being able to speak and communicate with others is something that many of us take for granted. It‚Äôs not so easy for many folks though, in particular for individuals with autism spectrum disorders, as well as those who have suffered various brain... | Read more »</div></div></div>
<span class="field-content">Get Your Roast Right With ‘Time To Roast...</span>
</div>
<div class="views-field-body">
<div class="field-content"><div class="body-row" id="body-row-213473"><div style="background:#F5F5F5;">Roasting meat, in the cooking world, is about as simple as it gets. The greatest roast recipe I‚Äôve ever found is from Michael Ruhlman‚Äôs website, with the recipe titled, ‚ÄúThe World‚Äôs Most Difficult Roasted Chicken Recipe.‚Äù | Read more »</div></div></div>
MacTech is a registered trademark of Xplain Corporation. Xplain, "The journal of Apple technology", Apple Expo, Explain It, MacDev, MacDev-1, THINK Reference, NetProfessional, Apple Expo, MacTech Central, MacTech Domains, MacNews, MacForge, and the MacTutorMan are trademarks or service marks of Xplain Corporation. Sprocket is a registered trademark of eSprocket Corporation. Other trademarks and copyrights appearing in this printing or software remain the property of their respective holders. Not responsible for typographical errors.
</div>
</div>
<div class="footer_bottom"></div>
</div>
<div id="bootom_foo_ter">All contents are Copyright 1984-2010 by Xplain Corporation. All rights reserved. Theme designed by <a href="http://www.icreon.com">Icreon</a>.</div>
<div id="newuser-popup" style="font-size:14px">Greetings, and welcome to the new MacTech web site! Our home page is designed to be your <cite>Industry Dashboard</cite> -- so you can have a snapshot of all that's relevant in the industry in one easy location. Many readers tell us that because the information is updated so frequently, they are now checking the site multiple times a day.
Here's a quick run down of the features on the new web site, which can be subtle.
<UL><LI>We're running regular raffles. If you want free stuff make sure to register. <a href="/register">It's easy and only takes a minute!</a>
<LI>Registering for the site allows you greater functionality.
<LI>The first few blocks are original content from MacTech (for geeks) and our sister web site, MacNews (for general users)
<LI>Below that are MacTech's scanners, which scan the web and organizes it into News, Rumors, and Documentation. Updated every 15 minutes.
<LI>Our Whitepapers, Screencasts, and Videos section give you insight into great products
<LI>The Community Search narrows your search to the most relevant of Apple related sites for better results
<LI>The forums give you a place to ask questions, and share your knowledge.
<LI>Our partners at MacUpdate, MacPrices.net and the Jobs Boards keep you up to date
<LI>Want to see all the news in one big list? Check out our new <a href="/firehose">Information Firehose</a>
<LI>And, don't forget the Apple Central area, and ads throughout the site. Advertisers are what make the site possible</UL>
We truly hope you <a href="/register">register</a> so that we can keep you up to date about new features as they are implemented. And, please use the BETA button in the top right to provide us any feedback, suggestions or bugs. We love to hear from you. </div>
<!--[if !IE]>End pop_up<![endif]-->
<!-- Google Analytics now handled by Google Analytics Module in drupal -->
<!--VISISTAT SNIPPET//-->
<script type="text/javascript">
var DID=13280;
var pcheck=(window.location.protocol == "https:") ? "https://sniff.visistat.com/live.js":"http://stats.visistat.com/live.js";