Information’s about Change log Company ############################################## !!! FORMAT CHANGE: Version 2.16.32 & newer !!! Insert Measuerment Bulk function: old: #TIME# = '4:25:00 PM' new: #TIME# = '4:25:00.000 PM' replace #TIME# into #TIMEEASY# to get the same format like the old: #TIMEEASY# = '4:25:00 PM' ############################################## _____________ Change log Version 2.25 [02/2024] Service: AdvancedSQLSVC to Version 2.20 - Update: Application Bug outofmemory after long running state - FIX: Eventlog entry correction Version 2.25 [04/2023] - ADD: Add Keyword for SmartDac AuditTrail #AUDITSTRING# #AUDITSTRINGSUB# - UPDATE: yAdvData.dll V2.56.4 - FIX SmartDAC Audit Trail Version 2.24 [11/2022] - UPDATE: yAdvData.dll V2.55.1 - FIX DEMO Modus - UPDATE: yAdvData.dll V2.54 - Timestamp for GX/GP/GM files - UPDATE: yAdvData.dll V2.54 - corrected DX data conversion Version 2.23 [07/2022] - ADD: /ERRORLOG parmaeter for create fast Error Log. - ADD: User Right settings for Win11 support. - FIX: DX recorder file handling - FIX: moving file function - UPDATE: yAdvData GX Convertion Timezone calculation - UPDATE: yAdvData Error Handling Version 2.22 [11/2020] - UPDATE: some data files - UPDATE: Eventlog function - UPDATE: Service Control Application Version 2.21 [04/2020] - UPDATE: License key info field - IMPROVE: Print Project function Version 2.20 [11/2019] - ADD SmartDac(GX/GP/GM): consider Timezone settings Version 2.19 [11/2019] - ADD: Print function for documentation - UPDATE: SmartDac convertion DLL - CHANGE: Setup procedure improve. Start of Service procedure improve. Version 2.18.34 [09/2018] - ADD [SMARTADC]: Now it is possible to add #CHC001MIN#; #CHA001MIN# as channel name in Insert measurement data statement - CHANGE: Setup procedure improve. Start of Service procedure improve. Version 2.17.33 [09/2018] - CHANGE [SMARTADC]: Clean INSERT String. If Keyword #xxx# not replaced with value it will be replaced with 0 [Zero] - CHANGE [DXAdvanced]: Clean INSERT String. If Keyword #xxx# not replaced with value it will be replaced with 0 [Zero] - CHANGE [SMARTADC]: Clean INSERT BULK. If no data for Columne available, it will be remove from BULK INSERT String - CHANGE [DXAdvanced]: Clean INSERT BULK. If no data for Columne available, it will be remove from BULK INSERT String Version 2.16.32 [09/2018] ################################################################ !!! FORMAT CHANGE: Insert Measuerment Bulk function: old: #TIME# = '4:25:00 PM' new: #TIME# = '4:25:00.000 PM' replace #TIME# into #TIMEEASY# to get the same format like the old: #TIMEEASY# = '4:25:00 PM' ################################################################ - ADD: Check entry routine. Check if data already exist at the database - ADD: Channel Name definition in Procedure "Insert Header" for 4 count channel XXXX - CHANGE: Move all SQL Statements to a seperate tab. - UPDATE: Documentation - UPDATE: Icon for "Insert Measurement" - CHANGE: Change background color Version 2.15.31 [08/2018] - UPDATE: Channel Name definition in Procedure "Insert Measurement" - UPDATE: documentation Version 2.14.31 [08/2018] - ADD: Print Projekt Configuration - ADD: License Number View - UPDATE: Channel Name definition in Procedure "Insert Measurement" - UPDATE: removed Service Control button from settings page - UPDATE: improve Error Handling - UPDATE: documentation Version 2.13.30 [07/2018] - UPDATE: Keyword format for Channel values improve, eg. for Channel 1: #CH001MIN# and #CH0001MIN# possible - FIX: SmartDac(GX/GP/GM): Events adding into database Version 2.12.29 [06/2018] - UPDATE: Setup to set User Rights for Folder - FIX: Error, if no Header set Version 2.11.28 [11/2017] - UPDATE: SmartDac(GX/GP/GM): Update DLL Version 2.11.27 [11/2017] - FIX: SmartDac(GX/GP/GM): Correct Timestamp for Daylight Saving Time Version 2.10.26 [09/2017] - ADD: Support for SmartDac Recorder Firmware R4.x - ADD: Fast Insert Routine for Measurement Data - UPDATE: Data File conversion DLL (SmartDac Time Format) Version 2.9.25 [05/2017] - ADD: MW100 dat file format *.mxc Version 2.8.24 [04/2017] - ADD: Terminate Application in Servcie Mode after x Minutes. - UPDATE: Documentation - UPDATE: Service Exeution Application Version 2.7.22 [03/2017] - ADD: Move convertion window bar with mouse - ADD: Add sample SQL string by double click on the "SQL-String" text label - ADD: DX200/DX100: Implemented Measurement values Insert function - FIX: SmartDac(GX/GP/GM): Signature and Alarm implementation - UPDATE: improve some routine Version 2.7.21 [03/2017] - ADD: SmartDac(GX/GP/GM): Implemented Measurement values Insert function - ADD: DXAdvanced (DX1000/DX2000): Implemented Measurement values Insert function - UPDATE: improve some routine - UPDATE: Documentation german Version 2.6.20 [02/2017] - ADD: SmartDac: /AS1 Reorder implemented. (File extension "GSE" and "GSD") - UPDATE: improve some routine Version 2.5.19 [01/2017] - FIX: SmartDac: Signature Info selection - FIX: SmartDac: Alarm Info selection - ADD: Error Log file are added into zip file. Send the complete file via email! - UPDATE: improve error handling routine Version 2.4.18 [07/2016] - UPDATE: /Autostart parameter for Windows Systray Version 2.4.17 [07/2016] - UPDATE: Error Message Window Version 2.4.16 [06/2016] - UPDATE: Header Information for SQL INsert String. Version 2.3.15 [06/2016] - FIX: Error Handling routine Version 2.3.14 [06/2016] - UPDATE: [DX/DXAdvanced] If file read not correct, stop reporting and resume with next file Version 2.2.13 [11/2015] - UPDATE: [GX/GP/GM] Support for Firmware R3 - FIX: GX Demo Modus: Get No Measurement Values Version 2.1.12 [062015] - FIX: [GX/GP] date / time convertion less 1 sec interval Version 2.1 [042015] - ADD: $dChXXXminlast$ (Last Measurement Value of the selected Channel) for Header Version 2.0 [092014] - Final Version _____________ Created 2012-2017 Description report Yokogawa Recorder files into user defined database. Name AdvancedSQLV2 Company Yokogawa Deutschland GmbH Broichhof Strasse 7-11 D-40880 Ratingen Germany Phone +49-2102-4983-666 Web www.yokogawa.de Author Dipl. Ing. M. van Cleve