Search options (Page 190 of 247)

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.

Thanks for including the fix. Please correct it as per the attachment.

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.

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.

Unless you create one and donate it to the project.
Quick Entries may do the job in the meanwhile.
Sales person commissions....

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.

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);

Another issue that introduces duplicate customer branches is the retention of last edited branch in the bottom update form even when a new customer / branch is chosen and the listing display stands refreshed correctly. When a new customer is chosen after adding/editing one branch in the branch edit form, instead of staying put in the branch edit form, it should show a new branch form.

@geoffreywalton: That is a good catch!

You're right about the orders <==> sales nomenclature - it had me stumped for a while in the early days, but I guess it was to distinguish it from the "sequential order" connotation.

The function start_table() is in the includes/ui/ui_controls.inc file that must have gotten the constants after the original osc_import (and now osc_orders) extension was made.

@joe: You may take the version bumped commit from my GitHub repo.

Excellent idea.
@joe: can we get a new entry into the sys_prefs table and company preferences form for this and it's fallback in the config.php or in the scripts for backwards compatibility?