http://www.synapp2.org/forum/ synapp2.org en Sat, 19 May 2012 22:37:46 +0000 http://www.synapp2.org/forum/topic.php?id=95#post-168 Sun, 15 Jan 2012 09:55:59 +0000 richard 168@http://www.synapp2.org/forum/ <p><strong>Q:</strong> Are checkbox, radio-button, or autocomplete/autosuggest fields are supported and is this documented?</p> <p><strong>A:</strong> SynApp2 builds GUI elements to support fundamental operations and manage records in related database tables. It does that using a small set of html input elements - 'text', 'textarea' and 'select', to be specific. The date picker is an example of how slightly more sophisticated GUI is incorporated. SynApp2 happens to do this automatically, as dates are essential to so many practical applications.</p> <p>It's quite amazing how far you can go with these basic building blocks wrapped around a normalized database structure.</p> <p>With experience and understanding, it is certainly possible to integrate any kind of specialized GUI to work with, or parallel to, the underlying framework. </p> <p>See SynApp2 Concepts, 2010-04-10, Page 46<br /> <a href="http://www.synapp2.org/documentation/SynApp2_Concepts.pdf" rel="nofollow">http://www.synapp2.org/documentation/SynApp2_Concepts.pdf</a></p> <p>The SynApp2 'application' pages that support the code generation use exactly the same framework as generated applications, and have custom GUI that incorporates 'radio' type input elements. So, it's absolutely possible to incorporate them in other areas too. It would just take understanding. That would come only with experience. As far as autocomplete goes, same story. But, I will suggest that the way SynApp2 deals with multi-table navigation is a ready, and perhaps better, alternative to autocomplete/autosuggest than I've seen implemented in a number of applications where 'lookups' are done in the course of filling out forms.</p> <p>The mission of SynApp2 is to get effective, useful database applications up and running quickly and reliably. There is necessarily some compromise.</p> <p>I always recommend that developers start with the database design that's going to make it possible to capture and report from the accumulated data - first. SynApp2 can get you working with a database design very quickly. SynApp2 is small, lightweight and can co-exist with nearly any other tools or frameworks that you may have or find useful. You don't have to make any hard choices or commit to use SynApp2 exclusively. If you're working with MySQL or Oracle, SynApp2 can and does provide great value.</p> <p>So, everything comes down to what your needs are. </p> http://www.synapp2.org/forum/topic.php?id=94#post-167 Thu, 25 Aug 2011 05:31:16 +0000 richard 167@http://www.synapp2.org/forum/ <p>I'm sorry to report that fighting off the spammers is more than I have time to deal with.</p> <p>Send me an email, or use the contact page if you'd like to join.</p> <p>Richard </p> http://www.synapp2.org/forum/topic.php?id=72#post-145 Sun, 21 Aug 2011 07:43:42 +0000 richard 145@http://www.synapp2.org/forum/ <p>Kudos to the Opera team for bringing the keyboard event handling in line with the rest of the pack. The most notable change is how PgUp / PgDn keys can now be captured by SynApp2 SELECT forms to page through database records, even in a small window with an active vertical scrollbar. </p> http://www.synapp2.org/forum/topic.php?id=69#post-142 Sun, 19 Jun 2011 16:44:15 +0000 richard 142@http://www.synapp2.org/forum/ <p>If you haven’t tried SynApp2 – now is the time. If you’ve been waiting for the official production release – it’s here! SynApp2 Web Application Generator and MVC framework has the power to bring information management projects to life. Create GUI, PDF reports and special processing features quickly and reliably. Web-based access makes deployment and integration with your business workflow easy.</p> <p>Take a break from spreadsheets. Build your next project with SynApp2.</p> <p>SynApp2 is supported by PHP, MySQL database and Apache HTTP Server – all free and open source software projects.</p> <p>Visit <a href="http://www.synapp2.org" rel="nofollow">http://www.synapp2.org</a> </p> http://www.synapp2.org/forum/topic.php?id=54&page=2#post-141 Sun, 19 Jun 2011 16:41:36 +0000 richard 141@http://www.synapp2.org/forum/ <p>SynApp2 version 1.8.1 has support for ISO-8859-2 (latin2) and other single-byte character sets. </p> http://www.synapp2.org/forum/topic.php?id=54&page=2#post-126 Sat, 02 Apr 2011 11:56:52 +0000 richard 126@http://www.synapp2.org/forum/ <p>I've been making progress on a comprehensive approach to character set management, and have learned a lot. In a nutshell, all the layers have to match - html, xml, php, MySQL (database and connection) and, in the case of FPDF the fonts.</p> <p>Through SynApp2 1.8.0 (beta 4), there are some discontinuities. The html pages and xml are using utf-8, but the database connection and manipulation assumes latin-1. A conversion layer, implemented by encode_entities() and decode_entites(), compensates. This explicit conversion layer turns out to be <em>unnecessary</em> if all the pieces agree on encoding and character set.</p> <p>See MySQL and UTF-8 Notes: <a href="http://www.phpwact.org/php/i18n/utf-8/mysql" rel="nofollow">http://www.phpwact.org/php/i18n/utf-8/mysql</a></p> <p>There's a significant difference between utf-8 and many, if not all, of the ISO characters sets like latin-1, latin-2, etc. - the number of bytes per character. UTF-8 is Unicode and each character may be encoded with multiple bytes, whereas the latin- character sets , for example, are represented with single-byte values that are commingled with traditional ASCII. </p> <p>In order for a client (browser) or database to understand what character is represented by a specific single-byte code (e.g., does \xA1 represent '¡' or 'Ą') the character set must be known. The same code represents a different character depending on the character set. This also implies that the single-byte character sets can't really be mixed. You can have latin-1 or latin-2, but not both. With utf-8 each character has its own code, so characters (languages) can be mixed.</p> <p>Handling multi-byte characters correctly, requires some additional care and attention to detail. Functions that handle [data] at an application-level, must be implemented appropriately. In the case of PHP particularly, string functions that count, search, or manipulate multi-byte character data, must be suited to the task.</p> <p>The changes needed for character set management fall into several distinct areas:</p> <ol> <li>configuration - designation of character set/encoding</li> <li>generating html markup with correct meta tag charset</li> <li>returning correct xml response encoding</li> <li>use correct data processing/manipulation functions</li> <li>implement utf-8/unicode multilingual character set and fonts for FPDF (with tFPDF) </li> <li>translate database results (as needed) to utf-8 for FPDF reports</li> </ol> <br /> This all should be reasonably straight forward and contained.</p> <p>The ball is rolling.</p> <p>-Richard </p> http://www.synapp2.org/forum/topic.php?id=55#post-125 Fri, 25 Mar 2011 00:43:49 +0000 ggery 125@http://www.synapp2.org/forum/ <p>Hi Richard</p> <p>Thank you very much for your help. I missed that in the documentation.</p> <p>Regard,<br /> GGery </p> http://www.synapp2.org/forum/topic.php?id=55#post-124 Thu, 24 Mar 2011 07:52:53 +0000 richard 124@http://www.synapp2.org/forum/ <p>Once you get NAV/RPT tabs you want, then you can use the <code>TAB_ORDER</code> customization element to set the display sequence on the page. </p> http://www.synapp2.org/forum/topic.php?id=55#post-123 Thu, 24 Mar 2011 07:45:17 +0000 richard 123@http://www.synapp2.org/forum/ <p>I was able to duplicate the behavior you described. Thank you for the feedback. Improvements are on the way.</p> <p>In the mean time, you should be able to work around the issue. The details depend on what you want to do.</p> <p>A) rename the tab for the uk table page (uk.htm) to be 'United Kingdom'<br /> B) create an additional tab and page for the uk table</p> <p>If you just want to rename the tab for qid/table 'uk':</p> <p>1. use PageGen to generate the basis page for qid/table 'uk' as 'united_kingdom.htm'<br /> 2. add a customization element (to custom.inc.php) for the tab:</p> <p> <code>$this-&gt;m_data[APPID][&#39;countries&#39;][INCL][NAV][] = array(A_HREF=&gt;&#39;united_kingdom&#39;, A_TEXT=&gt;&#39;United Kingdom&#39;);</code></p> <p> * OR *</p> <p> <code>$this-&gt;m_data[APPID][&#39;countries&#39;][INCL][NAV] = &#39;united_kingdom&#39;;</code></p> <p>3. delete the Basis Page file 'uk.htm' (or it will continue to appear with a NAV tab) (the same is true for uk_report.htm)</p> <p>If you want an additional page for qid/table 'uk':</p> <p>1. use Tools/QueryID to define a Secondary QueryID 'united_kingdom' for Basis QueryID 'uk'<br /> 2. use PageGen to generate a Basis Page (and/or) Report Page for qid/table 'united_kingdom (uk)'</p> <p>You could use the Secondary QueryID technique to just create renamed NAV/RPT tabs, pages and reports from the outset. But, if you've used PageGen to generate a Basis Page and/or Report Page for a default qid/table, then you'll have to clear the Basis Page and/or Report Page check box(es) and Run PageGen again, to record the settings, and prevent the page/report from being re-generated. Delete the corresponding default qid/table Basis Page and/or Report Page (.htm file(s) to get rid of the pages (and tabs).</p> <p>So, I'll work on the INCL/OMIT behavior while you see if you can use the suggestions to get your application working the way you want.</p> <p>-Richard </p> http://www.synapp2.org/forum/topic.php?id=55#post-122 Thu, 24 Mar 2011 00:50:44 +0000 ggery 122@http://www.synapp2.org/forum/ <p>Hi<br /> I have a problem with the order of names of tables in synapp2 and the names of these tables. NAV feature, and omit do not work as it is described.</p> <p>(<br /> $this-&gt;m_data[APPID]['countries'][INCL][NAV][] = array(A_HREF=&gt;'uk', A_TEXT=&gt;'<em><strong>United Kingdom</strong></em>');<br /> )</p> <p>This makes duplicated names... </p> http://www.synapp2.org/forum/topic.php?id=54#post-121 Mon, 21 Mar 2011 08:42:57 +0000 richard 121@http://www.synapp2.org/forum/ <p>Ok. I'll take a look at adding support for additional character sets, starting with ISO-8859-2 (Latin-2). </p> http://www.synapp2.org/forum/topic.php?id=54#post-120 Mon, 21 Mar 2011 01:24:00 +0000 ggery 120@http://www.synapp2.org/forum/ <p>Yes ISO-8859-2 (latin2).</p> <p>problematic charts ĄąĆćĘꣳÓ󌜯ŻŹź</p> <p>Thanks richard </p> http://www.synapp2.org/forum/topic.php?id=54#post-119 Fri, 18 Mar 2011 10:34:29 +0000 richard 119@http://www.synapp2.org/forum/ <p>Perhaps what you need is support for the ISO-8859-2 (Latin-2) character set? This character set reportedly covers Polish language characters.</p> <p><a href="http://www.global-translation-services.com/iso8859.html#ISO-8859-2" rel="nofollow">http://www.global-translation-services.com/iso8859.html#ISO-8859-2</a></p> <p>Do any (or all) of the characters depicted on the page (linked to) above, match the ones you're having trouble with?</p> <p>-Richard </p> http://www.synapp2.org/forum/topic.php?id=54#post-118 Fri, 18 Mar 2011 09:07:57 +0000 richard 118@http://www.synapp2.org/forum/ <p>Currently, SynApp2 supports ISO-8859-1 (Latin-1) character set with UTF-8 encoding.</p> <p>The data exchange between the browser and the server uses AJAX and XML. XML requires an entity definition for all but a few special characters. The entity management is handled by three functions in _shared_/util.php - encode_entities(), decode_entities() and get_entity_references().</p> <p>If you need support for another character set, encode_entities() and decode_entities() will require modification.</p> <p>UTF-8 is an encoding method, not a character set. Exactly what character set do you need to support? ISO-8859-15 and WINDOWS-1252 are a couple of possibilities.</p> <p>Perhaps you could send me a database with a table and records with the characters you're trying to work with. It shouldn't be too hard to add another character set, but I have to know what it is, first.</p> <p>Richard </p> http://www.synapp2.org/forum/topic.php?id=54#post-117 Fri, 18 Mar 2011 00:54:33 +0000 ggery 117@http://www.synapp2.org/forum/ <p>Hi</p> <p>I'm new. I have a problem with displaying characters in the Polish language in UTF-8 charset. Synapp2 cuts accented characters when entering into the database from aplication. Entered directly into the database are not displayed correctly.<br /> Everywhere I set UTF-8: apache, php5, mysql database and mysql table.<br /> How to fix it?? </p> http://www.synapp2.org/forum/topic.php?id=53#post-116 Mon, 07 Mar 2011 12:37:55 +0000 MarkJohns 116@http://www.synapp2.org/forum/ <p>Never mind. I had an error in my SQL that was wiping out the new table as soon as it was created. </p> http://www.synapp2.org/forum/topic.php?id=53#post-115 Mon, 07 Mar 2011 12:32:40 +0000 MarkJohns 115@http://www.synapp2.org/forum/ <p>I am working through a little application, and I found I needed to add a table. How do I get PageGen to see the new table? I've logged off/on, and I re-ran setup.htm on the database/app name. Still in PageGen, the new table still does not show up as an option for the basis table.</p> <p>Thanks </p> http://www.synapp2.org/forum/topic.php?id=51#post-114 Thu, 17 Feb 2011 08:15:38 +0000 MarkJohns 114@http://www.synapp2.org/forum/ <p>I <em>carefully</em> re-read the instructions, and I have got it going. I'm just starting to poke around in one of my existing apps, just to see how it goes. </p> http://www.synapp2.org/forum/topic.php?id=52#post-113 Wed, 16 Feb 2011 15:48:23 +0000 richard 113@http://www.synapp2.org/forum/ <p>This problem affects all versions of SynApp2 through 1.8.0 Beta 4, but will only surface when there is a copy of <code>fpdp.php</code> in the PHP <code>include_path</code> other than the one distributed with SynApp2. Member MarkJohns found this (thank you!) to be the case with a recent XAMPP distribution for Windows. I verified the problem with <code>XAMPP 1.7.4</code> running on <code>Windows 7</code>.</p> <p>The workaround is to edit <code>_shared_/3rdparty/mc_table.php</code>, and comment out or remove line 2.</p> <p>Change:</p> <p><code>require(&#39;fpdf.php&#39;);</code> </p> <p>To:</p> <p><code>//require(&#39;fpdf.php&#39;);</code></p> <p>Or, delete the line altogether.</p> <p>The problem will be permanently fixed in the next SynApp2 release. </p> http://www.synapp2.org/forum/topic.php?id=52#post-112 Wed, 16 Feb 2011 13:38:32 +0000 richard 112@http://www.synapp2.org/forum/ <p>I've been able to duplicate the problem on one of our servers with XAMPP.</p> <p>I'm looking at what it takes to mitigate it. Please stand by. </p> http://www.synapp2.org/forum/topic.php?id=51#post-109 Wed, 16 Feb 2011 09:16:52 +0000 richard 109@http://www.synapp2.org/forum/ <p>Hi Mark,</p> <p>I'll need some more details.</p> <p>I assume you're using the Beta 4 release? </p> <p>If so, point your browser to the setup diagnostics page - something like this:</p> <p><a href="http://YOUR_DOCUMENT_ROOT/synapp2/synapp2/setup.htm" rel="nofollow">http://YOUR_DOCUMENT_ROOT/synapp2/synapp2/setup.htm</a></p> <p>Fill in the fields, appid, username, password and click Test. (with a standard installation the username and password should both be 'admin')</p> <p>You can send me the Diagnostic Messages in an email. richard@ synapp2 dot org.</p> <p>-Richard </p> http://www.synapp2.org/forum/topic.php?id=52#post-108 Wed, 16 Feb 2011 06:44:17 +0000 MarkJohns 108@http://www.synapp2.org/forum/ <p>Installation went without a hitch. I tried running the User report and got the following messages:</p> <p>Notice: Constant FPDF_VERSION already defined in D:\xampp\php\PEAR\fpdf.php on line 10</p> <p>Fatal error: Cannot redeclare class FPDF in D:\xampp\php\PEAR\fpdf.php on line 13</p> <p>Just FYI. I don't know if it happens on Ubuntu, where I will be deploying for real. </p> http://www.synapp2.org/forum/topic.php?id=51#post-107 Wed, 16 Feb 2011 06:41:33 +0000 MarkJohns 107@http://www.synapp2.org/forum/ <p>I have an existing web app written in PHP and backed by MySQL.<br /> 1. I put the name of the database for this app in AppID<br /> 2. Click the green checkmark button<br /> 3. Nothing happens. No error messages, no choices appear in the QueryID</p> <p>Is there something I'm missing? I am running under the latest XAMPP on Windows XPSP3, latest Firefox.</p> <p>Thanks </p> http://www.synapp2.org/forum/topic.php?id=50#post-106 Wed, 09 Feb 2011 15:09:45 +0000 richard 106@http://www.synapp2.org/forum/ <p>These customization methods are new for <strong>SynApp2 1.8.0 (Beta 4)</strong>, and provide a convenient alternative to array notation for setting customization elements in <code>custom.inc.php</code> files. Use the <code>get_custom()</code> function to return a reference to the <code>global $g_custom</code> [master] instance of <code>class custom</code>.</p> <p>Invoke any of these methods, from <code>&lt;application_dir&gt;/custom.inc.php</code>, using the following form:</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;<code>get_custom()-&gt;set_...();</code></p> <p><code>////</code></p> <p><code>custom::set_username_password_mgr($qid = UPW_STD_QID)</code></p> <p><code>custom::set_validator($qid, $col, $func, $context_key = VALIDATOR_PRIMARY)</code></p> <p><code>custom::bind_process($qid, $func, $context_key = PROCESS_MAIN)</code></p> <p><code>custom::set_col_media_type($qid, $col, $media_type) // especially to identify report columns as: TYPE_IMAGE</code></p> <p><code>custom::set_rpt_row_size($qid, $row_size) // especially when there is column set to media TYPE_IMAGE</code></p> <p><code>custom::set_export_type($export_type, $qid = null)</code></p> <p><code>custom::set_media_loc($media_loc, $media_type = TYPE_ANY, $qid = null)</code><br /> <code>custom::set_temp_loc($temp_loc, $qid = null)</code></p> <p><code>////</code></p> <p>The SynApp2 Wiki examples show all of these functions in action: <a href="http://www.synapp2.org/wiki/index.php?title=Examples" rel="nofollow">http://www.synapp2.org/wiki/index.php?title=Examples</a></p> <p>The SynApp2 Customization document has detailed explanations of configuration elements: <a href="http://www.synapp2.org/documentation/SynApp2_Customization.pdf" rel="nofollow">http://www.synapp2.org/documentation/SynApp2_Customization.pdf</a> </p> http://www.synapp2.org/forum/topic.php?id=49#post-105 Sat, 05 Feb 2011 10:02:31 +0000 richard 105@http://www.synapp2.org/forum/ <p>SynApp2 1.8.0 (Beta 4) has greater configurability of database connections settings. It works with GoDaddy and has been tested with several interesting setups, on hosts around the world. </p> http://www.synapp2.org/forum/topic.php?id=19#post-104 Sat, 05 Feb 2011 09:56:12 +0000 richard 104@http://www.synapp2.org/forum/ <p>Version 9.0.597.84 of Google Chrome works, as does the built-in PDF viewer. </p> http://www.synapp2.org/forum/topic.php?id=48#post-103 Sat, 05 Feb 2011 09:48:42 +0000 richard 103@http://www.synapp2.org/forum/ <p>The built-in PDF viewer seems to work again, as of Chrome 9. You can adjust plugin settings for Google Chrome if you navigate to <a href="chrome://plugins" rel="nofollow">chrome://plugins</a> (in the GC address bar). </p> http://www.synapp2.org/forum/topic.php?id=43#post-102 Sat, 05 Feb 2011 09:23:45 +0000 richard 102@http://www.synapp2.org/forum/ <p>Examples of complete applications are available on the SynApp2 Wiki. Detailed commentary, screenshots and download kits let you explore practical ways of working with the MVC framework. Learn about handling images, document links, access privileges and more.</p> <p><a href="http://www.synapp2.org/wiki/index.php?title=Examples" rel="nofollow">http://www.synapp2.org/wiki/index.php?title=Examples</a> </p> http://www.synapp2.org/forum/topic.php?id=49#post-101 Sat, 18 Dec 2010 08:43:59 +0000 richard 101@http://www.synapp2.org/forum/ <p>Go Daddy dot com hosts MySQL databases from servers that are separate from the http host/server. SynApp2 version 1.8.0 (beta 4) has additional configuration elements to explicitly manage multiple database hosts. A new setup test/diagnostic tool is in the works.</p> <p>The configuration test tool shows details about the database connection configuration and how it's working (or not).</p> <p>If you'd like to preview the new configuration and database connection test features, use the SynApp2 contact page to let us know: <a href="http://www.synapp2.org/main/?page_id=145" rel="nofollow">http://www.synapp2.org/main/?page_id=145</a></p> <p>Here are a some help articles about MySQL database hosting on godaddy.com.</p> <p>Setting up a MySQL or SQL Server Database for Your Hosting Account: <a href="http://help.godaddy.com/article/36" rel="nofollow">http://help.godaddy.com/article/36</a></p> <p>Locating Your Database Host Name: <a href="http://help.godaddy.com/article/39" rel="nofollow">http://help.godaddy.com/article/39</a> </p> http://www.synapp2.org/forum/topic.php?id=49#post-100 Mon, 06 Dec 2010 08:55:26 +0000 richard 100@http://www.synapp2.org/forum/ <p>I'm working on this with Milga offline. There are in fact a few hoops to jump through to host SynApp2 from GoDaddy. A concise summary will be posted as soon as we find a good course of action.</p> <p>-Richard</p> <p>[moved topic from General Discussion to Installation] </p> http://www.synapp2.org/forum/topic.php?id=49#post-99 Sun, 05 Dec 2010 16:46:38 +0000 kbir1220 99@http://www.synapp2.org/forum/ <p>Hello,</p> <p>I want to have GoDaddy host a SynApp2 app. The problem is, the synapp2 user will not have access to my database. GoDaddy only allows a user that is the same name as your database, and only that user is given privileges to the database, so SynApp2 user will not be able to get to the tables.</p> <p>Have you seen this before? Is there a work around, like maybe changing the username SynApp2 uses (from SynApp2 to the name of my GoDaddy User)?</p> <p>Many Thanks,</p> <p>Milga </p> http://www.synapp2.org/forum/topic.php?id=48#post-98 Fri, 03 Dec 2010 11:58:09 +0000 richard 98@http://www.synapp2.org/forum/ <p>The built-in PDF viewer supplied with Chrome 8 is unusable and it's enabled by default.</p> <p>To restore Adobe Reader:</p> <p>1. in the Chrome address bar enter: <strong>about:plugins</strong><br /> 2. find Chrome PDF Viewer and click: Disable<br /> 3. find Adobe Reader and click: Enable</p> <p>If you don't have Adobe Reader installed - get it: <a href="http://get.adobe.com/reader/" rel="nofollow">http://get.adobe.com/reader/</a> </p> http://www.synapp2.org/forum/topic.php?id=47#post-97 Fri, 26 Nov 2010 13:42:16 +0000 richard 97@http://www.synapp2.org/forum/ <p>Here is the definitive discussion about MySQL 5.1 installation for Mac. MySQL comes pre-loaded on some Mac Server systems. Don't do anything more than is necessary.</p> <p><a href="http://dev.mysql.com/doc/refman/5.1/en/macosx-installation-pkg.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/macosx-installation-pkg.html</a> </p> http://www.synapp2.org/forum/topic.php?id=46#post-96 Fri, 26 Nov 2010 11:40:30 +0000 richard 96@http://www.synapp2.org/forum/ <p>Assuming you've enabled Apache HTTP Server on your Mac, here's a good discussion about enabling PHP and MySQL:</p> <p><a href="http://stackoverflow.com/questions/1293484/easiest-way-to-activate-php-and-mysql-on-mac-os-10-6-snow-leopard" rel="nofollow">http://stackoverflow.com/questions/1293484/easiest-way-to-activate-php-and-mysql-on-mac-os-10-6-snow-leopard</a> </p> http://www.synapp2.org/forum/topic.php?id=45#post-95 Mon, 22 Nov 2010 18:43:29 +0000 richard 95@http://www.synapp2.org/forum/ <p>SynApp2 is a free and open source software project, worthy of some good press.</p> <p>Please give your support to the SynApp2 project with links, bookmarks and mentions, in appropriate channels, wherever your travels take you.</p> <p>Thanks,<br /> Richard </p>