File Release Notes and Changelog
Release Name: 2.0.11
Notes: 2.0.11 - Feb 10, 2009 * IMPORTANT! For the first time the database schema has changed. If you are upgrading the server to 2.0.11 you must run the upgrade_to_2_0_11.py script. See the RELEASE_NOTES. * Added new Country table that is populated with a country list. * Added new fields 'province' and 'country' to the Customer table. * Changed the zip code field in the Customer table from 5 to 20 characters. * The client will no longer allow 0% for an activity percentage when ending activities. It must be a positive value. * Various improvments for running with a Microsoft SQLServer backend. * The DCS Server and Web Server will now run as services on the Windows platform. * New feature: you can now edit the operation of a laborDtl record in DCS Web. * There is a new format key for use when defining what an operation's description format in the config file. It is named 'item_assembly_operation_description'. It is a specially formatted combination of item/assembly/operation that removes duplicate descriptions to provide the most concide description possible w/out duplicated info. * Various bugfixes. See the ChangeLog.
Changes: 2009-02-10 Seth Remington <sremington@saberlogic.com> * SaberNet DCS 2.0.11 released 2009-02-10 Seth Remington <sremington@saberlogic.com> * debian/rules: Trying again to get rid of Debian package errors about multiple packages installing the same egg file. It appears that egg files might also now be installed into /usr/share/pyshared (at least on Ubuntu). 2009-02-03 Seth Remington <sremington@saberlogic.com> * sndcs/CustomerFactory.py: Added getActiveCustomers() function. Changed getCustomerById() and getCustomerByName() so that they return a single object or None. * sndcs/ItemFactory.py: Changed getItemByNumber() so that it returns a single object or None. 2009-02-02 Seth Remington <sremington@saberlogic.com> * configure_sndcs.py sndcs/Operation.py sndcs/server/OperationProxy.py: Added new format key item_assembly_operation_description for an Operation's formattedDescription() function. This is a specially formatted combination of item/assembly/operation that removes duplicate descriptions to provide the most concide description possible w/out duplicated info. 2009-01-29 Seth Branan <sbranan@saberlogic.com> * dcs_edit_time/assembly.py, dcs_edit_time/edit_labordtl.py, dcs_edit_time/labordtl.py, dcs_edit_time/operation.py: Added functionality to edit the operation attached to a laborDtl record in DCS Web. 2009-01-16 Seth Remington <sremington@saberlogic.com> * sndcs_common/__init__.py: Updated the copyright year for 2009. 2009-01-12 Seth Remington <sremington@saberlogic.com> * gtk/Application.py: Fixed typo in startEventSubsciber() that failed to call stopEventSubscriber() properly. 2009-01-02 Seth Remington <sremington@saberlogic.com> * Classes.csv: For the LaborDtl object changed the prevLaborDtl property from onDeleteOther='cascade' to onDeleteOther='detach' so that deleting a laborDtl record will not delete all of the following records linked to it. 2008-12-24 Seth Branan <sbranan@saberlogic.com> * dcs_edit_time/index.py, dcs_edit_time/labordtl.py: Confirm with user before deleting laborHed and laborDtl in DCS Web. 2008-12-24 Seth Remington <sremington@saberlogic.com> * dcs_edit_time/labordtl.py: Adding new laborDtl records in DCS Web would incorrectly set the qtyComplete and qtyScrap if the JobHed had qtyComplete or qtyScrap set. 2008-12-08 Seth Remington <sremington@saberlogic.com> * setup.py, win32serversetup.py, sndcs/__init__.py, server/SndcsServer.py, configure_sndcs_server.py, sndcsd_service.py, sndcs2httpd.py: Changes to make sndcsd and sndcs2httpd run as windows services. 2008-11-25 Seth Remington <sremington@saberlogic.com> * sndcs_config/sndcs_config_server.glade: Making some changes to get the server config GUI working. 2008-11-20 Seth Remington <sremington@saberlogic.com> * sndcs/CountryFactory.py: Fix a bug when getting the Country object with the serialNum and the serialNum is not a valid int. 2008-11-14 Seth Remington <sremington@saberlogic.com> * sndcs/CountryFactory.py, sndcs/DepartmentFactory.py, sndcs/EmployeeFactory.py, sndcs/ItemFactory.py, sndcs/JobHedFactory.py, sndcs/LastUsedFactory.py, sndcs/ParameterFactory.py, sndcs/ScrapCodeFactory.py, sndcs/ShiftFactory.py, sndcs/StateFactory.py, sndcs/Store.py, sndcs/TasksFactory.py, sndcs/TerminalFactory.py, sndcs/UserFactory.py, sndcs/UserParameterFactory.py, dcs_admin/terminals.py, dcs_edit_customers/customers.py, dcs_edit_customers/search.py, dcs_edit_departments/departments.py, dcs_edit_employees/edit_employee.py, dcs_edit_employees/search.py, dcs_edit_items/index.py, dcs_edit_items/scrapcodes.py, dcs_edit_items/search.py, dcs_edit_items/unitsofmeasure.py, dcs_edit_jobs/index.py, dcs_edit_shifts/shifts.py, dcs_current_activity/search.py: Use store.sqlEscape() anywhere there is a WHERE clause. 2008-11-13 Seth Remington <sremington@saberlogic.com> * Store.py: In sqlEscape() escape single quotes for MS SQL Server. * sndcs/CustomerFactory.py: Use the sqlEscape function on WHERE clauses. 2008-11-12 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/search.py: Change SQL for MS SQL Server to sort job number numerically if it can. 2008-11-10 Seth Remington <sremington@saberlogic.com> * server/OperationProxy.py: Change SQL for MS SQL Server to sort job number numerically if it can. 2008-11-06 Seth Remington <sremington@saberlogic.com> * sndcs/Employee.py, upgrade/UpgradeDatabase.py: Change SQL LIMIT clause to TOP for MS SQL Server 2008-10-28 Seth Remington <sremington@saberlogic.com> * gtk/Application.py: Fixed bug [2204615] Client should not allow 0% for activity percentage. 2008-10-21 Seth Remington <sremington@saberlogic.com> * UpgradeDatabase.py: Fixed bug where the default integer for classID type objects was getting set incorrectly. * Classes.csv, upgrade_to_2_0_11.py: Changed the zip code field in the Customer table from 5 to 20 characters. * dcs_edit_customers/customers.py: Added new fields (province, country) to the Customer form. * lib/SitePage.py: Added a blank country to the "State" dropdown so that the state field is not mandatory. 2008-10-16 Seth Remington <sremington@saberlogic.com> * upgrade/UpgradeDatabase.py, upgrade/upgrade_to_2_0_11.py, sndcs.mkmodel/Classes.csv, sndcs.mkmodel/Samples.csv: First attempt at providing a method to make modifications to the database. MiddleKit has some serious limitations when it comes to upgrading a production database so this is a limited workaround at best. Added new Country table to the database and populated it with a country list. Added new fields 'province' and 'country' to the Customer table. 2008-09-16 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/index.py: Fix on 2008-08-11 was incorrectly setting the item on created assemblies. The correct item should be used now. 2008-09-15 Seth Remington <sremington@saberlogic.com> * ActiveEmployeesTreeView.py, AvailableActivitiesTreeView.py: The description columns are now resizable so the user can click and drag the width of the column. 2008-09-02 Seth Remington <sremington@saberlogic.com> * dcs_edit_customers/customers.py: Added 'address2' field to the customer form. 2008-08-28 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/index.py: Save the item that the Assembly was created from when adding a new Assembly to an existing JobHed. 2008-08-11 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/index.py: Save the item that the Assembly was created from if it was created from a BOM. 2008-08-07 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/search.py: Make the search results try to sort by the job number numerically even though the field is actually a varchar. 2008-07-22 Seth Remington <sremington@saberlogic.com> * dcs_edit_jobs/index.py: Change the back page to the "search" page in the Edit Jobs area of DCS Web. That way when a user logs in after a session timeout it doesn't default to the entire job list page which takes a long time to load. 2008-07-06 Seth Remington <sremington@saberlogic.com> * gtk/ActiveEmployeesTreeView.py: Changed the functionality when an add_employee and edit_employee events are received. The add employee event will no longer disaply the *** New Employee *** text. The edit_employee event will actually update the employee info (name, departments) correctly and should allow employees to be edited in DCS Web while they are still logged in once the DCS Web code is updated. 2008-07-03 Seth Remington <sremington@saberlogic.com> * dcs_edit_employees/edit_employee.py: Fixed bug when addding a department(s) to an employee at the same time they are created. * sndcs/web/sndcs2_web/dcs_edit_employees/index.py: Fixed bug where employee delete event wasn't being sent out if the employee record couldn't be deleted because of referential integrity and the status is set to "Terminated" instead. We still want the event to go out so that the employee will drop off of the active employee list. 2008-06-28 Seth Remington <sremington@saberlogic.com> * dcs_edit_employees/edit_employee.py: Improperly formed closing HTML tag. 2008-06-17 Seth Remington <sremington@saberlogic.com> * DepartmentFactory.py: getDepartmentByCode() should not include records that are linked to employees or terminals.
