Removed redundant ORDER BY clause and removed redundant description grouping as the category_id and stock_id primarily control grouping and will be automatically ordered as such.
Attached the patch and the files reporting/rep303.php
4,701 12/22/2014 09:49:46 pm
Topic: Item Check List report rep303 optimised (0 replies, posted in Items and Inventory)
4,702 12/22/2014 09:46:28 pm
Topic: stock_moves.stock_id char(20) => varchar(20) (1 replies, posted in Accounts Payable)
Change stock_moves.stock_id to be varchar in synch with it's usage everywhere else.
Commit available to be pulled in.
4,703 12/22/2014 03:40:16 pm
Re: Login Error with the given installation guide (5 replies, posted in Installation)
Please post versions of php, mysql, platform and error logs to help us assist you.
4,704 12/21/2014 08:18:23 pm
Re: Suppliers ERD update (3 replies, posted in Accounts Payable)
The New Supplier Form fields matched to the FA db table fields is available in the Wiki.
4,705 12/21/2014 06:11:38 pm
Re: Renaming Backup File Feature Mod (5 replies, posted in Setup)
A set of screenshots for this feature are now in my FA Support Wiki.
4,706 12/21/2014 05:15:57 pm
Re: /gl/manage/currencies.php (3 replies, posted in Report Bugs here)
If you change it in the FA Web UI, what appears in the database (not in sql dump) - view it in a mysql client like the SQLyog community edition in GoogleCode.
Check Browser settings (sample attached).
4,707 12/21/2014 05:07:40 pm
Re: Custom Theme Bootstrap FA (2 replies, posted in Setup)
Good Interface means only new users will come. New developers will then have no work to do.... 
Existing users and code grabbers will certainly benefit.... 
4,708 12/21/2014 05:06:12 pm
Re: Remove redundant indexes (4 replies, posted in Installation)
It did stand full fixed.
It has now been reverted (as of 2014-12-22) due to database schema policies on minor revisions and only these changes (en_US-New.sql, en_US-demo.sql) have been moved to the Unstable v2.4 branch where further redundant indexes still exist.
4,709 12/21/2014 12:38:33 pm
Re: Salesperson can only view details of his/her own customers (3 replies, posted in Setup)
Some SELECT / UPDATE or INSERT sql statement that refers to the tables concerned where an extra or new WHERE clause will need to be used when a certain class of of user logs in (session user).
4,710 12/21/2014 12:36:53 pm
Re: /gl/manage/currencies.php (3 replies, posted in Report Bugs here)
Check your encodings in the browser and MySQL and try to enter it using the normal "C" English language in FA.
4,711 12/21/2014 12:30:07 pm
Re: Suppliers ERD update (3 replies, posted in Accounts Payable)
The actual ERDs can be captured from SQLyog or MySQL Workbench or any MySQL client - checkout the SQL community edition (the enterprise edition with one standard key not blacklisted for years and possibly allowed for developers unofficially) of SQLyog in GoogleCode.
Although there are many commercial (hammer to kill an ant) applications like AShampoo and FACapture besides behemoths like XARA and PhotoShop, RealDraw and it's ilk, the best in freeware are the Dia Installer in Sourceforge and Vectorian Giotto.
Earlier versions of FACapture that were absolutely freeware (v5.3 or earlier I think) and some plain old PrtScr / Alt-PrtScr are good enough to capture screenshots in Windoze. Overlays in MS Word or any word processor is also possible.
If I remember right I have provided links to some of these programs in the wiki and/or in these forums to help users quickly explain issues.
4,712 12/21/2014 06:45:39 am
Topic: Suppliers ERD update (3 replies, posted in Accounts Payable)
To understand the Suppliers import / export process in FrontAccounting, an ERD subset has been prepared and placed on the wiki with notes.
4,713 12/21/2014 06:38:28 am
Re: Remove redundant indexes (4 replies, posted in Installation)
Thanks for including the fix. Please correct it as per the attachment.
4,714 12/21/2014 04:42:30 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Could you please provide what changes need to be done in the extension files for it to work?
4,715 12/20/2014 05:00:25 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
It is only a comparison between manual data entry in FA vs. imported data via extension to see what needs to be fixed in the extension to match your needs.
4,716 12/20/2014 04:57:05 pm
Re: Remove redundant indexes (4 replies, posted in Installation)
It's easy to remove these in v2.3 itself. It practically does not affect any table structure or break any script processing.
4,717 12/20/2014 04:55:29 pm
Re: Renaming Backup File Feature Mod (5 replies, posted in Setup)
Actually, I was testing out various means of directly populating the database with suppliers data when I needed to rollback several times to different snapshots. The standard naming feature has just the database name, table prefix and date and time (hh:mm only). Twice, when backups were done within the same integral minute, the old one was overwritten.
Also providing some sort of a suffix to the file name part (not the extension) would be human readable.
We can use several linux and dos commands to achieve the same but when done within the Web UI it seemed cool and useful. Many times we may have the same named file from different VPSes which auto synch to a single folder with similar names and even if the date and time portions are different, the files are easy to get confused with one another.
It also helps avoid having to give FTP and shell / SSH access to the end user.
QED.
4,718 12/20/2014 10:52:04 am
Re: Renaming Backup File Feature Mod (5 replies, posted in Setup)
Screenshot of the new functionality is attached. The New file name needs to be entered into the comments section of the Create Backup Column.
4,719 12/20/2014 10:40:00 am
Topic: Renaming Backup File Feature Mod (5 replies, posted in Setup)
I have just made a modification of the admin/backups.php file to allow for renaming of backup files to .sql or .gz files after stripping all spaces (and periods for other extensions, forcing an .sql.gz extension for such ones).
@joe: you can include it in the core.
--- old/admin/backups.php Sat Dec 20 14:35:56 2014
+++ new/admin/backups.php Sat Dec 20 15:43:18 2014
@@ -142,6 +142,26 @@
display_error(_("Select backup file first."));
}
+if (get_post('rendump')) {
+ if ($backup_name) {
+ $rename_file = str_replace(" ", "", trim(get_post('comments')));
+ if (strlen($rename_file) > 0) {
+
+ $file_extn = pathinfo($rename_file, PATHINFO_EXTENSION);
+ if (!in_array($file_extn, Array("sql","gz")))
+ $rename_file = str_replace(".", "", $rename_file) . '.sql.gz';
+ $rename_path = BACKUP_PATH . $rename_file;
+
+ if (rename($backup_path, $rename_path)) {
+ display_notification($backup_name . " : " . _("File successfully renamed.")." "
+ . _("New Filename") . ": " . $rename_path);
+ $Ajax->activate('backups');
+ } else display_error(_("Can't rename backup file."));
+
+ } else display_error($rename_file . " : " . _("Enter valid new file name to rename backup file."));
+ } else display_error(_("Select backup file first."));
+}
+
if (get_post('deldump')) {
if ($backup_name) {
if (unlink($backup_path)) {
@@ -191,6 +211,8 @@
start_table();
submit_row('view',_("View Backup"), false, '', '', false);
submit_row('download',_("Download Backup"), false, '', '', false);
+ submit_row('rendump',_("Rename Backup"), false, '','', 'process');
+ submit_js_confirm('rendump',_("You are about to rename database backup file.\nDo you want to continue?"));
submit_row('restore',_("Restore Backup"), false, '','', 'process');
submit_js_confirm('restore',_("You are about to restore database from backup file.\nDo you want to continue?"));Pushed to my github repo till inclusion into core.
4,720 12/20/2014 07:57:05 am
Re: Only White Screen for Index.php after updating approx 6 SOLVED (3 replies, posted in Setup)
You can also update the FA to the latest version and there are no database changes that affect your install since your existing version. The themes may have changed a little since your initial install. All changes in the themes can be tracked from my github repo.
Although themes may be maintained by other users, the signed package repo is maintained by the lead devs and the onus would be on them to provide for user run unsigned repos if wished, code for which exists in my github repo / FA Wiki as well.
4,721 12/20/2014 07:51:23 am
Re: PO for consumable materials (4 replies, posted in Accounts Payable)
Unless you create one and donate it to the project.
Quick Entries may do the job in the meanwhile.
Sales person commissions....
4,722 12/20/2014 07:46:54 am
Re: Import Multiple Journal Entries - an error occurred while processing t (1 replies, posted in Modules Add-on's)
Check the permissions of the modules folder and the specific extension folder as well. Generally 644 is okay for all files as long as it is owned by the webserver process.
Try the equivalent (for your brand of linux) of:
FAROOT=/var/www/frontac
find ${FAROOT} -type f -exec chmod 644 \{\} \;
find ${FAROOT} -type d -exec chmod 755 \{\} \;4,723 12/20/2014 07:42:32 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
1. Take a backup of the db.
2. Manually enter one set of transactions that you would normally want to import.
3. Take another backup of the db.
4. Compare the two say in WinMerge.
5. Now you can get the changed entries (ignore the history and last update entries in the user tables).
6. Group the entries in the order in which they were performed and match the values to the source form fields.
7. Lookup any other entries in the config.db, session and sys_prefs and other defaults tables.
4,724 12/18/2014 06:42:49 pm
Re: Sales Quote Inquiry (10 replies, posted in Wish List)
Yes, I saw the automatic creation entry, but only wanted it for new installations to be complete. This will be useful in code analysis as well rather than searching all over the php files for all possible values.
4,725 12/18/2014 06:08:52 pm
Re: Email Address in Company Set Up (4 replies, posted in Report Bugs here)
Even the Company Name too can be made as big (50).
--- old/admin/company_preferences.php Mon Sep 29 21:21:28 2014
+++ new/admin/company_preferences.php Thu Dec 18 23:35:49 2014
@@ -161,15 +161,15 @@
table_section(1);
-text_row_ex(_("Name (to appear on reports):"), 'coy_name', 42, 50);
+text_row_ex(_("Name (to appear on reports):"), 'coy_name', 50, 50);
textarea_row(_("Address:"), 'postal_address', $_POST['postal_address'], 35, 6);
text_row_ex(_("Domicile:"), 'domicile', 25, 55);
text_row_ex(_("Phone Number:"), 'phone', 25, 55);
text_row_ex(_("Fax Number:"), 'fax', 25);
-email_row_ex(_("Email Address:"), 'email', 25, 55);
+email_row_ex(_("Email Address:"), 'email', 50, 55);
-email_row_ex(_("BCC Address for all outgoing mails:"), 'bcc_email', 25, 55);
+email_row_ex(_("BCC Address for all outgoing mails:"), 'bcc_email', 50, 55);
text_row_ex(_("Official Company Number:"), 'coy_no', 25);
text_row_ex(_("GSTNo:"), 'gst_no', 25);