//------------------------------------------------------------ // v3.2.0 - released 31 March 2017 //------------------------------------------------------------ ConnectIt-Opera.exe v3.2.0 ConnectIt Configuration.exe v3.2.0 ADDED: support for a SQL Server hosted version of Pegasus Opera. ADDED: Configuration | Opera tab | Database tab - options to enter SQL Server database configuration settings. //------------------------------------------------------------ // v3.1.0 - released 28 September 2016 //------------------------------------------------------------ ConnectIt-Opera.exe v3.1.0 ConnectIt Configuration.exe v3.1.0 ADDED: Configuration | Search tab | Check Products tab - to enter details of the what to display to the User when they use the 'Check Products' feature on the Document Transfer screen. ADDED: Configuration | Export Details tab | Item tab - to enter details of the exported file output for a Stock Items import from information in the QuoteWerks Document Items tables as opposed to the current import for Stock Items from information in the QuoteWerks Products database(s). ADDED: Document Transfer | 'Check Products' button - this option checks that Product(s) on the selected Document(s) exist in Opera. If they do not, then a list of those which do not exist is presented to the User for them to select which one(s) they would like to create. //------------------------------------------------------------ // v3.0.0 - released 6 July 2016 //------------------------------------------------------------ ConnectIt-Opera.exe v3.0.0 ConnectIt-Opera3.exe v3.0.0 ConnectIt Configuration.exe v3.0.0 ADDED: Configuration | Opera tab | Database tab | Table Details section - Product table details. ADDED: Configuration | Search tab | Products tab - to enter details of the Search Criteria and Results grid screen settings. ADDED: Configuration | Export Details tab | Product tab - to enter details of the export file Column Title Captions, Database Field Names, Field Data Types and Field Formats. ADDED: New ConnectIt-Opera3 executable for allowing the User to export Products from QuoteWerks to then import them into Pegasus Opera. ADDED: Registration | Create Menu button - this now additionally creates a QuoteWerks "Create Product(s) in Opera" menu option to allow easy access to the new module. //------------------------------------------------------------ // v2.0.0 - released 11 February 2016 //------------------------------------------------------------ ConnectIt-Opera.exe v2.0.0 ConnectIt Configuration.exe v2.0.0 ADDED: Configuration | Export Details tab | Invoice tab - Account Number Field and Account Name Field 'Error if Blank' options. If ticked, then if the relevant field is blank on any of the Documents selected for export, then ConnectIt will fail with an error message. UPDATED: Configuration | Export Details tab | Invoice and Transaction tab - Field Data Type values for Pegasus Opera II v7.45 database schema. UPDATED: ConnectIt-Opera | Export button - if either of the new 'Error if Blank' options are ticked and the relevant field is blank on any of the Documents selected for export, then ConnectIt will fail with an error message. UPDATED: ConnectIt-Opera - made form resizeable. //------------------------------------------------------------ // v1.1.2 - released 23 April 2013 //------------------------------------------------------------ ConnectIt-Opera.exe v1.1.2 ConnectIt Configuration.exe v1.1.2 ConnectIt Registration.exe v1.1.2 ADDED: support for 64-bit operating systems //------------------------------------------------------------ // v1.1.0 - released 20th June 2011 //------------------------------------------------------------ ConnectIt-Opera.exe v1.1.0 ConnectIt Configuration.exe v1.1.0 ADDED: support for transferring information using DBF file types (see Configuration Export Details | Files tab). This means that Memo data type fields (such as the Invoice Transaction IT_MEMO field) can also be used to transfer information from QuoteWerks into Pegasus Opera //------------------------------------------------------------ // v1.0.1 - released 28th March 2011 //------------------------------------------------------------ ConnectIt-Opera.exe v1.0.1 ConnectIt Configuration.exe v1.0.1 ADDED: option to change the name of the QuoteWerks Document Number field on the Search Results grid (see Configuration Document Search tab | Results tab | Document Number Field option). ADDED: option to automatically delete the CSV file(s) if the export / import fails (see Configuration Advanced tab) ADDED: option to automatically delete the CSV files if the import is successful (see Configuration Advanced tab) UPDATE: use direct OLEDB access to the Pegasus Opera database files instead of linking via Microsoft Access due to issues observed onsite when an unlicensed version of Access is installed on a user's PC (see Configuration | Opera tab | Database tab | Database Details options) UPDATE: installer package to include a shortcut to the main ConnectIt-Opera Document selection screen on the Windows | All Programs | ConnectIt-Opera menu FIXED: ConnectIt tried to do the import even though a Transaction (Details) filename had not been selected by the user. FIXED: A message box appeared saying that the export / import had failed even though it worked ok. ConnectIt was incorrectly reporting the failure, message box does not appear now. FIXED: "Syntax error in SQL statement... incorrect syntax near 'AS'" error when exporting documents. When using Corporate edition rehosted to SQL and trying to update the Status and Locked flag of the document after exporting. SQL statement revised to work with SQL Server backend. //------------------------------------------------------------ // v1.0.0 - released 24th March 2011 //------------------------------------------------------------ ConnectIt-Opera.exe v1.0.0 ConnectIt Configuration.exe v1.0.0 ConnectIt Registration.exe v1.0.0