Contiki version information

Date Version Excel
Version
New Changed Improved Fixed Description Status
26 July 2020 20.07.2663 16, 19, 365

32 BIT
* Added: New option in Operation, (under Utilities), to add to a combination, a report with a list of Excel files that did not refresh well.
* Added: New buttons in Contiki’s Excel menu and in contiki itself to link to Contiki YouTube Chanel.
* Changed: In Manage Measures option, Excel stops changing to disable Power Pivot when finshed.
* Fixed: When copying Measures to Excel, In Manage Measures, copies them as text.
* Fixed: Hebrow text in Excel Slicers menue.
* Fixed: In open Dimensions in Excel, Excel Dimensions file comes to front.
Beta
Test
32 BIT
26 July  2020 20.07.2663 16, 19, 365

64 BIT
* Added: New option in Operation, (under Utilities), to add to a combination, a report with a list of Excel files that did not refresh well. Test
Release
Beta

64 BIT
09 July  2020 20.07.0961 16, 19, 365

64 BIT
* Added: New buttons in Contiki’s Excel menu and in contiki itself to link to Contiki YouTube Chanel. 64 BIT
28 June 2020 20.06.2861 16, 19, 365

64 BIT
* Fixed: Hebrow text in Excel Slicers menue 64 BIT
18 June 2020 20.06.1861 16, 19,365

64 BIT
*Added: A new “Flatten Module” for 64 bit.
* Changed: In Manage Measures option, Excel stops changing to disable Power Pivot when finshed.
* Fixed: Update Versins from web works.
* Fixed: In open Dimensions in Excel, Excel Dimensions file comes to front.
* Fixed: When copying Measures to Excel, In Manage Measures, copies them as text.
64 BIT
02 June 2020 20.06.0263 16, 19, 365

64 BIT
* FIRST 64 BIT VRESION
* Converted all except TIK and Flat from 32 Bit to 64 Bit
64 BIT
17 December 2019 19.12.1775 14,15,16,
19,365
* Added: button in Excel to freeze heeders in TIK Reports.
* Added: An option in Operation to select TIK Reports that the Header will be freezed.
* Fixed: In Operation closing Excel properly after it was opened by Contiki.
* Fixed: Selecting Less Keys in Crate cube; not adding Keys to columns that the sort order is not important or the same as default of column.
* Added: A view with the letters LK (Less Keys) to select less columns into Power Pivot.
* Added: An option in Operation under Utilities, to close All Excel running in the current user (instead of the bat operation).
* Changed: In the interface of Refresh Excel, when selecting a new file to be refreshed, so you only get the option for Power Pivot, unless you select Advanced GUI.
* Changed: In the interface of Refresh Excel, the width of the column with the file to be refreshed by Contiki.
* Fixed: In the interface of Refresh Excel, saving to the right location a new file selected to be refreshed by Contiki.
* Fixed: In the interface of Refresh Excel, selecting multiple files in one refresh definition.
* Added: Regarding Refresh Excel, an option to hide the sheet named ThisWorkbookDataModel in Power Pivot files that are refreshed by Contiki.
* Fixed: Send files to support, used an obsolete IP address (contiki.org.il was changed to contiki.co.il).
* Fixed: A problem with date format when running TIK from a CSV file.
* Added: A new option in Excel in Contiki's menu, to change at once some global settings for all Slicers in whole file or sheet.
* Added: In send mail, an option to export and import a txt (tab delimited) or Excel list of mails from the mail menu in Definition.
* Fixed: In send mail, a problem in sending mails where the name is only one or two characters long.
Release



32 BIT
22 August 2019 19.08.2271 14,15,16,17 *Fixed:     Opening Power Pivot with Contiki's Excel's Add in loaded, in Excel 2016 that did not get updates  
31 July 2019 19.07.3171 14,15,16,17 *Fixed:     Close Excel files no longer in use by the Measures Manager tool .
*Fixed:     Formatting only list in Excel measures in Measures Manager tool.
*Fixed:     Some issues regarding performance of Measures Manager tool.
*Added:   An option to delete sheets and files on the Excel side of the Measures Manager tool.
*Added:   An option to select a new Excel file to Save measures in the Measures Manager tool.
* Note:    Measures Manager tool works with Excel 2016 and newer.

08 July 2019 19.07.0871 14,15,16,17 *Added:  Color change between Versions (this one is light blue)
*AddedNew Feature in Excel menu: A tool to manage calculated measures in Power Pivot.
                 Keep and Organize All measures in an external Excel file.
                 Copy measures form the Excel file in to a Power Pivot model.
                 Copy measures form the Power Pivot model to an Excel file.
                 Delete measures in a Power Pivot model.
                 Sort measures in a Pow                 Color Format Measures in the Excel file.

23 April 2019 23 April 2019 19.04.2371 14,15,16,17 * Fixed: An issue regarding Running total views, changed measures from Group by to Sum()
* New: Compiled with Visual Studio 2019

14 March 2019 19.03.1403 14,15,16,17 * Fixed: An issue with language change.
* Fixed: Memory drain when running TIK from Operation.

27 Feb 2019 19.02.2702 14,15,16,17 * Added: Tik Reports generated out of CSV file instead of CUB file.
* Converted: Tik reports GUI migrated to .NET. (for CSV option).
* Added: Attachment size increased for mail list.
* Added: Attachment size for use of Contiki default mail increased to 25mb.
* Fixed: Function and Repots cubes not makes a Union SQL anymore.
* Fixed: Dimensions in Excel shown from Contiki interface.
* Fixed: Contiki exception management more integrated with new developed features.

28 Oct 2018 18.10.2801 14,15,16,17 * Fixed: Tab delimited headers placement.
* Fixed: An issue for large dataset to create union all view.
Previous
Release
8 Oct 2018 18.10.0804 14,15,16 * Added: Running total views support (sql with union all for levels to summarize), Support from SQL 2014.
* Fixed: Non Hebrew Collation.
* Fixed: Several bugs encountered in GUI resolved.
* Fixed: Default mail, password, domain
* Fixed: Application support continuation for additional years
 

 01 Dec 2017

17.11.0030

14,15,16

* Fixed: Several bugs Making  the SW stable.

Previous
Release
8 Aug 2017 17.8.8080 14,15,16 * Added: Multi user installation.
* Fixed: Several bugs encountered in the new functions.
* Fixed: VB6 compatibality issue on Windows 10 with richtx32.ocx
 
30 Jul 2017 17.7.3000 14,15,16 * Added: More functionality like; Send Email, run Cmd, Create flat data, and more...
* Improved: Stability with Excel 2016 and Windows 10 (creators edition). Many functions completely rewritten.
 
25 Aug 2015 16.8.2500 16 * Added: SSL secure connections for al web services to it.contiki.co.il
* Added: UI personal color selection.
 
08 Oct 2015 15.10.0810 14,15,16 * Changed: Recompiled for Contiki I.T. ltd.
* Changed: Rewritten Upgrade for Ezcel 2013-6.
* Changed: Replacing xls for xlsx as default (while keeping backward compatibility).
* Fixed: Flatten Excel for Excel 2013-6
* Improved: Stability with Excel 2013 (MDI to SDI issues). Many functions completely rewritten.
* Improved: Speed.
* Changed: Refresh Power Pivot.
* Changed: TiK engine.
* Changed: Application does not need OS administrator rights any more.
 
18 Mar 2015 5.14.15.8 14,15 * Changed: Company (name) change from Y.A.H.-Contiki  to Contiki I.T.  
* Added: New Power Pivot refresh functionality.
* Improved: Stability with Excel 2013 (MDI to SDI issues). Many functions completely rewritten.
* Fixed: right click menu in Excel 2013 worksheets.
* Improved: Error trapping.
* Changed: Accesses Excel directly removing dependancy on Excel Interops (indirect).
* Changed\Added: ADODB reference. Instead of using the gerenic ADODB preinstalled with MDAC the Contiki installer supplies it's own ADODB (interop). Prevents failures on certain systems.
* Fixed: Message boxes were not always visible on top.
* Changed: Header and Column Colors in Excel index files (Meta Data).
* Removed\Replaced: Outdated 16 bits functions (WIN API and VB6) replaced with new 32 bits functions.
* Removed: Protection of unused cells in Indexes to improve speed in Office 2013/365.
 
28 May 2014 5.14.14.14 14,15 * Fixed: Compatability with Excel 2010.  
27 May 2014 5.14.14.13 15 * Improved: Stability and functionality and cosmetics with Excel 2013 SP1.  
10 Apr 2014 5.14.14.6 15 * Improved: Stability with Excel 2013 SP1. MS Excel 2013 is opening the wrong workbooks and sheets while running automated.  
28 Mar 2014 5.14.14.4 15 * Improved: Stability with Excel 2013.
* Fixed: MSSQL2012 compatibility issues (support for sp_dboption and other pre SQL2005 functionality dropped).
 
24 Mar 2014 5.14.14.3 15 * Improved: Stability with Excel 2013 (Yahtikolap5.dll), Tik (15.6) and Plan (YahPlan5.dll).  
01 Jan 2013 5.13.0.0 12,14,15 * Fixed: Adjusted and made compatible for use with Windows 8 and Office 2013.  
31 Dec 2012 5.4.12.61 12, 14 Recommended version 5.4.12.61 when using Contiki with Office 2010); Passed the test of time succesfully and was released to the public 31/12/2012  
14 Nov 2012 5.4.12.61 12, 14 * Fixed: Time out during SQL to Tab-file procedure; changed server default of 30secs to long TimeOut as defined in Contiki.
* Improved: Speed of SQL-query to Tab-file and stability.
* Changed: Tab-file headers transform more esthetical when importing to PowerPivot.
(Cleaner Header names; format of delimiter between Dimension and Level name changed from '.' to ' ')
* Changed: Run Schedules "always" extended from 48 times to 400 (*days|hours).
Previous
Release
29 Oct 2012 5.4.12.52 12, 14 * Fixed: TypeCast error in Excel add-in comparing string "" with "0.0" auto-converted to 0.0 (double).
* Fixed: ODBC (Oracle) connection not releasing itself fast enough.
 
27 Aug 2012 5.4.12.50 12, 14 * Fixed: Installer v5.4.12.49 skipped replacing parts of previous versions.
* Improved: Check for Updates works a litle faster.
 
18 Aug 2012 5.4.12.47 12, 14 * Fixed: Tik v32; Added a slight delay to avoid locking on "database.xls" during Tik Cube Query on rare occasions.  
03 Jun 2012 5.4.12.44 12, 14 * Fixed: Appliation recompiled using the new type libraries; see information below at 08 Jul 2011 and http://blogs.msdn.com/b/psssql/archive/2011/10/03/yes-we-made-a-mistake-and-are-finally-going-to-fix-it.aspx  and http://support.microsoft.com/kb/2640696
* Improved: Cubes creation scripts write now on the designated cube script directory one level above the cube.
* Added: Create the cube scripts only without cubes themselves being created.
* Fixed: Some initiation issue in the Cube creation wizzard.
 
22 May 2012 5.4.12.43 12, 14 * Fixed: versions 5.4.12 .40 to .42 had an error creating a measure with an inflation adjusted formula that would crash cube creation if used.  
22 May 2012 5.4.12.42 12, 14 * Improved: SQL query headers for create cube are more user friendly (shorter without the  ".NAME" extension were not needed)  
21 May 2012 5.4.12.41 12, 14 * Added: Create Cube creates extra output scripts for value added support from Contiki to 3th party tools like MS Excel Power Pivot and related technologies that can use them.  
03 May 2012 5.4.12.40 12, 14 * Fixed: Last beta installers did not register the Excel Com add-in so it would not load in Excel.
* Changed: Cube query now has friendly column names.
 
25 Apr 2012 5.4.12.39 12, 14 * Added: "mmmm" format for months in cube creation.  
15 Mar 2012 5.4.12.38 12, 14 * Fixed: Custom text delimiter input field remained readonly after TAB or Space selection (Import datefiles settings Wizzard3)  
02 Nov 2011 5.4.12.35 12, 14 * Added: Change work directory without Contiki for "TiK only" users. Previous
Release
02 Oct 2011 5.4.12.32 12, 14 * Improved: Import data speed (without using bulk insert) by 400% (using improved data row cache). Still only less than half as fast compared to using fast and advanced bulk insert settings.  
30 Sep 2011 5.4.12.30 12, 14 * Added: Simple to configure (slow) Data Import without using temp files and without using bulk insert. Bypass the bulk insert methode when security settings for bulk insert (the prefered and fasted method) are not correctly configured.  
08 Jul 2011 5.4.12.26 12, 14 * Fixed: Application does not run on down-level operating systems after you recompile it on a computer that is running Windows 7 SP 1 or Windows Server 2008 R2 SP 1 or that has KB983246 installed (for detailed information follow the links; http://support.microsoft.com/kb/2517589  and Changes in MDAC ADODB COM components in Windows 7 Service Pack 1 ). (since version 5.4.12.24) Previous
Release
06 Jul 2011 5.4.12.25 12, 14 * Fixed: Send files to support would not open since version 5.4.12.22.  
30 Jun 2011 5.4.12.24 12, 14 * Added: References to recently released services packs (all versions of Windows and Office)  
28 Jun 2011 5.4.12.21 12, 14 * Added: Optional update service DNS\IP redirect.  
22 Jun 2011 5.4.12.20 12, 14 * Fixed: TiK Report "Super Summary Grouping - Flexible multi period".
* Fixed: TiK - Listboxes in Excel 2010 failed to load arrays and crashed.
 
14 Apr 2011 5.4.12.17 12,14 * Fixed: Contiki would save newly created workbooks in Excel 2010 with the wrong extension for the new file format; exporting metadata to such a new file would cause an error like warning message in Excel 2010 only.
12 Apr 2011 5.4.12.16 12,14 * Fixed: Listbox Error in Excel 2010 (fm20.dll) while running multiple reports in TiK.  
11 Apr 2011 5.4.12.15 12,14 * Fixed: After refresh of a PivotTable the "PivotTable Field List" within Excel would not always refresh its item list.  
01 Mar 2011 5.4.12.14 12,14 * Fixed: Update messages information would say expired when not expired. And if nearing expiration it will give plenty of detailed warnings\solutions long before actual expiration.  
28 Feb 2011 5.4.12.13 12,14 * Improved: Reliability of automatic updates on Contiki startup.  
27 Feb 2011 5.4.12.12 12,14 * Fixed: Contiki Excel menu missing in v5.4.12.11 (setup).  
24 Feb 2011 5.4.12.11 12,14 * Improved: Security; Contiki.exe can funtion without elevated administrator rights (on any modern OS with UAC like Vista, Win7, Server2008, ..). Program now is digitally signed as a full trust application.
* Improved: Check for updates over the internet works without administrator rights (limited user rights) if local policies\configurations allow so.
* Improved: "YahNet.exe -s" will run in silent mode suitable for use with scheduler (schtasks.exe).
 
17 Jan 2011 5.4.12.10 12,14 * Improved: Updater more flexible.  
15 Dec 2010 5.4.12.7 12,14 * Changed: Upgraded the .NET platform from v3.5 to v4.0.
* Fixed: Full forward compatabilty with Office 2010 (pivot tables issues solved if Pslite  is being installed)
* Improved: Update speed of pivot table refresh.
 
05 Sep 2010 5.3.xl.51 11,12,14 * Fixed: Contiki on  SQL-2000 server would fail to patch and open the database on startup.
* Fixed: Added create new database script (v0.3.1.91)  as bypass of problems with script update v0.3.1.90 (included in v0.3.1.91)
Previous
Release
30 Aug 2010 5.3.xl.50 11,12,14 * Improved: English help
* Fixed: English UI in Dimension Import\Export was in Hebrew.
Previous
Release
29 Aug 2010 5.3.xl.49 11,12,14 * Fixed: Tik menu item "Archive" had wrong descriptions displayed in sub menus.
* Fixed: "Send files to support" did not check for all illegal characters in Path\File to send.
 
03 Aug 2010 5.3.12.43 2007
2010
* Fixed: Tik would not open on Excel 2010 (xl14).  
29 Jul 2010 5.3.11.42
5.3.12.42
2003
2007
* Attempted Fix Of: Excel Pivot table refresh System.OutOfMemoryException: Not enough storage is available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY)) during Pivot table refresh;  
22 Jul 2010 5.3.11.41
5.3.12.41
2003
2007
* Improved: Fixes to UI and language.  
20 Jul 2010 5.3.11.40
5.3.12.40
2003
2007
* Fixed: "Contiki Updates" started as stand alone would crash during load because "AppDomain.CurrentDomain.SetPrincipalPolicy(PrincipalPolicy.WindowsPrincipal)" not set on current thread.
* Improved: Fixes to UI and language.
 
19 Jul 2010 5.3.11.38
5.3.12.38
2003
2007
* Fixed: YahPivotAddin would not unload all menus and cause them to be permanent.
* Improved: Fixes to UI and language.
 
19 Jul 2010 5.3.11.35
5.3.12.35
2003
2007
* Improved: Check for Updates
* Improved: Load speed Contiki.
* Changed: UI colors of forms.
* Fixed: Calculated Measure Exception while loading form.
 
15 Jul 2010 5.3.11.32
5.3.12.32
2003
2007
* Fixed: Calculated Measure Templates would not load.
* Fixed: This Info page would not load when requesting [Info] at updates.
 
01 Jul 2010 5.3.11.26
5.3.12.26
2003
2007
* Fixed: System information would not report correct .NET Framework version 4.0 when only client version installed.  
20 Jun 2010 5.3.11.22
5.3.12.22
2003
2007
* Changed: Contiki requires administrator rights (UAC settings Vista > Win7 > .. ) needed for http: protocal Webservices Customer Support (automatic updates & technical support).  
14 Jun 2010 5.3.11.20
5.3.12.20
2003
2007
* Fixed: Contiki manual configuration algoritmes for support on client.  
14 Jun 2010 5.3.11.19
5.3.12.19
2003
2007
* Fixed: Setup Upgrades would always bypass the bootstrapper and thus not install the required prerequisites like for example the .NET framework and KB908002 and others installed by setup.exe (*.msi installer bypasses bootstrapper features installed with setup.exe. Note; The MSI installer is faster if no prerequisites are missing.)  
09 Jun 2010 5.3.11.17
5.3.12.17
2003
2007
* Changed: readme.txt.
* Fixed: Some Hebrew and English text.
* Fixed: Some UI.
 
06 Jun 2010 5.3.12.15 2007 * Added: Some hebrew added (instead of English)
* Fixed: Send files to Support MsgBox right click menu could have users loop the UI for sending files leading to instability.
 
06 Jun 2010 5.3.12.14 2007 * Fixed: Updates configuration file had the old update server missing.
* Changed: Icon for Contiki on Terminal Server and changed Contiki 5.2 references in the start menu to v5.3.
 
03 Jun 2010 5.3.11.09
5.3.12.12
2003
2007
* Improved: Send logs to support on msgbox (User Interface and stability).  
02 Jun 2010 5.3.11.11
5.3.12.11
2003
2007
* Changed: English helpfile.
* Changed: Icons on main form.
* Improved: Send logs to support on msgbox (User Interface, stability and extra server added).
 
27 May 2010 5.3.11.10
5.3.12.10
2003
2007
* Fixed: Notification for new Contiki version to be TopMost (above splash screen).
* Added: Send logs to support on msgbox.
26 May 2010 5.3.12.9 2007 * Fixed: Contiki would not detect latest installed .NET Framework and its related service pack correctly.
* Changed: Removed the PIA from the installer (xl12) reducing the size with 7MB since it is part of MS Excel. (How to: Install Office Primary Interop Assemblies)
 
20 May 2010 5.3.11.8
5.3.12.8
2003
2007
* Changed: EULA and readme to reflect changes in Contiki from v 5.2 to v5.3.
* Added: Entering operations checks for server messages.
* Added: Extra Server for Version Updates etc.
* Changed: Tik version licence.
 
16 May 2010 5.2.11.35 2003/7 * Changed: Same like v5.3.1x.8 but without .NET Framework 3.5 support (for backward and nonprogressive systems only)

Final versions 5.2 reached; next generations will be v5.3 + v5.4 based on the .NET 3.5\4.0 Framework.
 
04 May 2010 5.3.12.5 2007 * Fixed: Some forms (CubeBuilder, Indexes on Server,...) failed to load because Object reference not set to an instance of an object (the new help provider).
* Fixed: Export Indexes on a English system would create Hebrew Indexes if creating new Indexes.
 
04 May 2010 5.3.12.4 2007 * Added: English Help.
* Fixed: Internationalisation of create new database script.
* Added: .NET Framework 3.5 Technology (upgraded from 2.0).
* Added: Automatic installation on Office 2007 of the interops (included in the install) if not found installed.
* Added: DB Patch for v5.3 compatibilty.
* Fixed: Fix names in Excel would crash if found a "none standard workbook" like a chart in Indexes.
* Added: Update services has added functionality and security in preparation for future planned services.
* Fixed: A few buttons had Hebrew text instead of English (in English UI)
 
22 Mar 2010 5.2.11.34
5.2.12.34
2003
2007
* Added: Save as Text on SQL query results.
* Fixed: Refresh pivot table would error occasionally reason when selecting it using "Excel.XlPTSelectionMode.xlOrigin".
 
22 Feb 2010 5.2.11.33
5.2.12.33
2003
2007
* Fixed: When changing between databases some database connection did not reset to the newly selected connection. Could cause wrong or missing data during data import as a result.  
01 Dec 2009 5.2.11.32
5.2.12.32
2003
2007
* Added: msstdfmt.dll used by Function TIK and cube query interface. On very clean Windows7 OS this dll was not found pre-installed. Would cause a hidden #713 error when missing and openening Tik Function wizzard or the Tik cube query wizzrd.  
16 Nov 2009 5.2.11.31
5.2.12.31
2003
2007
* Fixed: Shrink did not shrink to the maximum extend possible leaving the database files (*.mdf+*.ldf) bigger than needed. Previous
Release
04 Nov 2009 5.2.11.30
5.2.12.30
2003
2007
* Changed: Contiki Updates can now be run exteral from Contiki and be dynamicly configured in case of Server\IP changes.
* Changed: YahNet.exe (was YahNet.dll). Updates can be done while bypassing Contiki5.exe. This is handy at new customers were Contiki is not yet fully configurated.
 
28 Oct 2009 5.2.11.29
5.2.12.29
2003
2007
* Fixed: Checkbox "Advanced" on Cube Settings dialog would wrongly uncheck after clicking other items on the dialog.  
27 Oct 2009 5.2.11.28 2003 * Changed: Syncronized with v5.2.12.28 (except for Excel 2007 features).  
25 Oct 2009 5.2.12.28 2007 * Fixed: Refresh of table of "Pivot tables to link" after selecting a new pivot for "linked pivot reporting". Selection now visible.  
12 Oct 2009 5.2.12.27 2007 * Added: System Information.
* Fixed: Three more errors while printing "Linked Pivots" (related to multiple selection option in Pivot Filter)
 
24 Sep 2009 5.2.12.26 2007 * Fixed: Another error while printing "Linked Pivots" (related to multiple selection option in Pivot Filter)  
09 Sep 2009 5.2.12.25 2007 * Fixed: Errors while printing "Linked Pivots"  
07 Sep 2009 5.2.12.24 2007 * Fixed: Some Ribbon (menu) errors from v5.2.12.23.
07 Sep 2009 5.2.12.23 2007 * Added: More Excel 'Ribbon buttons' (all except for Plan).  
06 Sep 2009 5.2.12.22 2007 * Fixed: Errors while updating "Linked Pivots"  
30 Aug 2009 5.2.12.21 2007 * Fixed: Installer 5.2.12.20 would not always replace previous install correctly.
* Fixed: Update Linked Pivots would error (since v5.2.12.17)
 
21 Aug 2009 5.2.12.20 2007 * Fixed: TiK.xla to TiK12.xlam
* Added: More Excel 'Ribbon buttons'.
 
04 Aug 2009 5.2.12.19 2007 * Fixed: Excel 2007 Create new 2007 Pivot would of crash on Excel 2003 type workbooks (since version 5.2.12.18). Will now create a pivot table version the same like the Excel file version.
* Changed: After Select Cube file (*.cub) for Pivot Table will automatically connect.
 
02 Aug 2009 5.2.12.18 2007 * Fixed: Hebrew Ribbon
* Changed: Create new Pivot will create an Excel 2007 version Pivot Table.
 
30 Jul 2009 5.2.12.17 2007 * Fixed: Pressing 'Linked Print' could cause add-ins to behave unstable.
* Added: More Excel 'Ribbon buttons'.
 
05 Apr 2009 5.2.xl.16 2003/7 * Changed: Versioning numbers syncronized. Previous
Release
04 Apr 2009 5.2.12.15 2007 * Fixed: Contiki Menu missing in Excel Ribbon (new install only, update ok).
* Upgraded: User interface and Zip libraries.
 
1 Apr 2009 5.3.12.14 2007 * Changed: Uses the .NET Framework 3.5 instead of 2.0 version.
31 Mar 2009 5.2.xl.14 2003/7 * Added: Full SQL Server 2008 compatibility.
6 Jan 2009 5.2.xl.11 2003/7 * Fixed: Trying to open Excel workbooks would fail if Excel was not found running already (only since 30 Nov 2008). Previous
Release
20 Dec 2008 5.2.xl.10 2003/7 * Fixed: Contiki menus in excel would not load in versions 5.2.xl.8+9. (because a missing registration reference to the  MSADDNDR.DLL for MS Office automation).
15 Dec 2008 5.2.xl.9 2003/7 * Added: More Operation log information about cubes being build (location, size and date).
* Added: Checking for new versions when changing databases to avoid version compatibility issues.
7 Dec 2008 5.2.xl.8 2003/7 * Fixed: Start of 5 paralel bulkinsert threads by SQL server will be run with 0.5 seconds delay inbetween them. This to avoid on slow systems random IO system errors . This can happen for example when an antivirus program (or any other  file\connection related software) takes a lock on files when opening them. And then releases the locks on them slower then the speed that the system opens them ('System error 71' or file not found).  
30 Nov 2008 5.2.xl.7 2003
2007
* Added: Open Excel error information. When failing to open a workbook more information is provided in the log files. And it will retry again to open the workbook for three times after waiting a minute each attempt.  
25 Nov 2008 5.2.11.6
5.2.12.6
2003
2007
* Fixed: Another issue with import of negative numbers in combination with functions. Combinations like -(-[number]*-1) nested with other functions would fail to import.  
4 Nov 2008 5.2.11.5
5.2.12.5
2003
2007
* Fixed: Week of Year level in cube had wrong sorting format ('yyyww' instead of 'yyyyww')  resulting in double level members.  
2 Nov 2008 5.2.11.4
5.2.12.4
2003
2007
* Fixed: Function NONENUMERICTOZERO() would evaluate negative numbers (<0) as none numeric and convert to zero (0).  
23 Oct 2008 5.2.11.3
5.2.12.3
2003
2007
* Changed: No more administrator rights requered for running 'contiki.exe'.  
2 Oct 2008 5.2.11.2
5.2.12.2
2003
2007
* Fixed: Cube Query in Excel 2003 would ask user in a loop to save workbook (Excel 2003 SaveAs parameters not the same like in the Excel 2007 version). Previous
Release
3 Sep 2008 5.2.11.0
5.2.12.0
2003
2007
* Upgraded: Replaced all (old) dll.s with dependencies to the .NET Framework 1.1 to be compatible for Studio 2008 (.NET Framework 2.0 and higher).
1 Sep 2008 5.1.11.54 2007 * Fixed: When calculation mode of Excel is on manual then opening Excel files for data import would hang in an endless loop waiting for Excel to report to finish calculating.  
13 Aug 2008 5.1.11.53
5.1.12.53
2003
2007
* Fixed: When creating Cubes at root of any drive (like 'C:\*.cub' or 'X:\*.cub') then would not export indexes (*.xls) to Excel to the correct location and\or error.
* Fixed: Data Import from Excel files when selecting a sheet with formulas references to other sheets that have been 'refreshed' after the current sheet and calculation mode is not manuel. The Excel interop would read the cells values even while\before recalculating during wich period the not yet calculated cells return value -2146826259 (that is the number of the #NAME error).
 
05 Aug 2008 5.1.11.52
5.1.12.52
2003
2007
* Fixed: MSI Installer now automaticly removes and installs previous versions in correct order (No need to uninstall and reinstall anymore).  
04 Aug 2008 5.1.11.51
5.1.12.51
2003
2007
* Fixed: User interface of several form were partly invisible on Vista.
* Fixed: File tranferor would filter out all files with wrong wildcard when selecting files.
 
03 Aug 2008 5.1.11.50
5.1.12.50
2003
2007
* Fixed: Refresh Pivot table exception. Caused because of  incompatabity when passing a reference between managed and unmanaged code (CLSCompliant issue).
* Fixed: Refresh Pivot table exception (another). When openening a second Workbook would not find the Excel reference anymore.
* Fixed: Refresh Pivot table exception (yet another). When a Pivot table defined in refresh (Operations) is not found or is a Pivot Chart you will a message instead of an error and Operations will continue with the next pivot table.
* Fixed\Improved: Refresh a single PivotTable on a sheet would refresh all pivots on that worksheet instead of one.
* Fixed: Pivot Table Fix from version 5.1.11+12.41. If found open another workbook refresh pivot tables would silently skip refresh in other 'todo' workbooks or\and raise 'missing components' exceptions.
* Fixed: YahTikOlap.dll version was less then the older Active-X component. Would not always upgrade as a result.
 
03 Aug 2008 5.1.12.47
5.1.12.47
2003
2007
* Fixed: Some more connection errors (Update Indexes).  
30 Jul 2008 5.1.11.46
5.1.12.46
2003
2007
* Fixed: Refresh Pivot Error.  
28 Jul 2008 5.1.11.45
5.1.12.45
2003
2007
* Added: Setup.exe now installs MS patch KB908002  (for loading add-ins in Excel).
* Fixed: Update Dimensions on server connection error.
 
10 Jul 2008 5.1.11.44
5.1.12.44
2003
2007
* Fixed: Right click on page 'Hierarchy' would display an connection exception (error).
Previous
Release
10 Jul 2008   2003
2007

When working with Excel and having errors about missing assemblies then click this hyperlink
 
07 Jul 2008 5.1.11.42
5.1.12.42
2003
2007
* Added: Function COL(x) is now supported in any part of an IF((COL(1)=True,COL(2),COL(3)). Previous use of this example would always evaluate false and return COL(3). Now if COL(1)=True then COL(2) will be returned. Tested with several levels of nesting.
* Added: Does now import *.xlsx Excel 2007 files.
* Fixed: Doing calculations with COL functions like COL(1)+COL(2) would not calculate anymore since 29 Mar 2008.
* Changed algorithms for Column values COL(x) having 'auto# 200-900' without having them change to 'auto# -700' ('=auto# 200less900').
 
02 Jul 2008 5.1.11.41
5.1.12.41
2003
2007
* Failed Fix: Custom Functions like (Col(0) - Col(1)) would not evaluate anymore since v5.1.12.31
* Refresh Pivot table using operations should keep Excel more stable (again).
* Fixed: Interface for Refresh Pivot tables was partly invisible.
 
29 Jun 2008 5.1.12.40 2007 * Refresh Pivot table using operations should keep Excel more stable.
24 Jun 2008 5.1.10.24 XP * Upgrade now replaces all old versions from any previous version. * Upgrade now replaces all old versions from any previous version. Previous
Release
24 Jun 2008 5.1.12.39 2007 * Syncronized with 5.1.11.39
* Upgrade now replaces all old versions from any previous version.
 
24 Jun 2008 5.1.11.39 2003 * Synchronized with 5.1.12.39
* Upgrade now replaces all old versions from any previous version.
 
23 Jun 2008 5.1.11.37 2003 * Fixed: Upgrade now replaces all old dll's. Would not upgrade several dll's when Contiki already installed causing all sorts of errors. This was caused by different assembly versions and the file versions within the dll's involved. (Problems found only in versions 5.1.11.33 until 36, clean install would work however).  
22 Jun 2008 5.1.11.35 2003 * Fixed missing menu buttons in Excel (on some systems).  
19 Jun 2008 5.1.11.34 2003 * Fixed crash of Yahtikolap5.dll on PC's with both Excel 2003 and 2007 Installed.
* Cosmetic changes to colors in Excel Index files when updated with Yahtikolap5.dll.
* Installer 10% smaller.
 
18 Jun 2008 5.1.11.33 2003 * Synchronized with all features, improvements and fixes like in version 5.1.12.34 (the Excel 2007 version).
* Renewed and rewritten Yahtikolap5.dll replacing ActiveX with .NET technology.
 
17 Jun 2008 5.1.12.34 2007 * Added the 'Send files to Support' to the installer. Can send files straight to support bypassing email limitations. Can be used for Zipping as well.
* Added a database script improving cube building speed (good for certain models only)
 
29 Apr 2008 5.1.12.31 2007 * Compatible with x64 bits Operating systems (Win XP x64, Vista x64, Server 2008 x64)
* Improved speed for Data import and Cube creation by using parallel instead of serial processing were possible.
* Compiled and rewritten for Studio 2008 in preparation for more new features, smaller download size.
* Changed: Abort task now quickly aborts Contiki.
* Changed: After function Col() stops evaluating other functions. (previous 'item 10-6' would change to 'item 4'; ten less six)
 
29 Mar 2008 5.1.11.25 2003 * Changed: Abort task now quickly aborts Contiki.
* Changed: After function Col() stops evaluating other functions. (previous 'item 10-6' would change to 'item 4'; ten less six)
 
24 Mar 2008 Previous
Release

5.1.10.23
5.1.11.23 5.1.12.23


XP
2003
2007
* Fixed: Date dimensions with  'weekday' (like 'yy\ww') would show weekdays but internally be 'day of week'.internally be 'day of week'. Previous
Release
18 Mar 2008 5.1.10.22
5.1.11.22
5.1.12.22
XP
2003
2007
* All versions synchronized.
* Fixed: Check for new versions (updates) would stop after 24 hours.
 
17 Mar 2008 5.1.10.21
5.1.11.21
5.1.12.21
XP
2003
2007
* Fixed some Hebrew  language mistakes as requested by customers.
* Added some small cosmetic changes.
 
11 Mar 2008 5.1.11.2 2003 * All synchronized with version 5.1.12.10  
11 Mar 2008 5.1.12.10 2007 * Improved stability of the backup when the OS has legal security exceptions  like 'insufficient rights' etc.
* Fixed the timeout of many database commands like shrink, attach, backup and more from the default 30 seconds to the Contiki Medium Timeout setting. Good for big databases.
 
9 Mar 2008 5.1.12.9 2007 * Fixed Backup Timeout error (now medium).  
4 Mar 2008 5.1.11.1 2003 All synchronized with version 5.1.12.8

* Fixed Backup Timeout error (now medium).
* Backups pass the 2GB barrier.
* Loading speed of large Dimensions on Server improved.
* Some exception messages show more relevant details.
* Rename Dimensions in Cube made easier.
 
26 Feb 2008 5.1.12.8 2007 * Sorting of dates improved within the cubes new date options.  
25 Feb 2008 5.1.12.6 2007 * Formatting algorithms of dates in Create Cube changed.
* Drag and Drop in MDX editor adjusted.
 
28 Jan 2008 5.1.12.5 2007 * Added Hebrew Ribbon in Excel.
* Improved information when adding measures\members into cubes with names that already exist.
 
17 Jan 2008 5.1.12.4 2007 * Fixed: Update Accounts in an Index type Excel file would show the wrong Summery Grouping names (offset of -1)  
15 Jan 2008 5.1.12.3 2007 * Fixed: Cube Query would when creating temporary file 'CubeDB.xls' create it in the wrong format and cause errors. Otherwise all fine when using the old file.  
07 Jan 2008 5.1.12.3 2007 * Renew of dimension\measure made easier, now the old name is copied to be edited.
12 Dec 2007 5.1.12.1 2007 * Fixed: Update Cost Centres could throw an exception when updating the table.
12 Dec 2007 5.1.12.0 2007 * Same like v5.1.11.1 (new versioning policy)
* New versioning policy >   All versions 5.1.12.xxx are for Excel 2007
12 Dec 2007 5.1.11.0 2003 * Upgrade engine does not install an older version.
* New versioning policy >   All versions 5.1.11.xxx are for Excel 2003
 
12 Dec 2007 5.1.10.0
XP * Upgrade engine does not install an older version.
* New versioning policy >   All versions 5.1.10.xxx are for Excel XP
 
12 Dec 2007 5.1.11.1 xl12 * All Contiki \ Excel versions (for xl-10/11/12) synchronized with each other and compiled separately for improved stability. That is why Contiki has 3 branches (xl-10/11/12).  
11 Dec 2007 5.1.11.1 xl12 * After requested download of an older version explanation is added how to manually do a downgrade to an older version.  
11 Dec 2007 5.1.11.0 xl12 * Same like 5.1.2.34 but with new version numbers.  
11 Dec 2007 5.1.9.1 xl11 * Update engine improved (Added extra download server).
* Fixed: Operators '>' and '<' in import function 'IF(..)' now
evaluate dates as dates and not anymore as text.
 
11 Dec 2007 5.1.8.0 xl10 * Update engine improved (Added extra download server).
* PIA's for Excel-XP added as support in Tools.
* Fixed: Operators '>' and '<' in import function 'IF(..)' now
evaluate dates as dates and not anymore as text.
 
11 Dec 2007 5.1.2.34 xl12 * Update engine improved (Added extra download server).  
11 Dec 2007 5.1.2.33 xl12 * Update engine improved.  
11 Dec 2007 5.1.2.32 xl12 * Update engine improved.  
10 Dec 2007 5.1.1.12 xl11 * Update engine improved.  
10 Dec 2007 5.1.1.11 xl10 * Update engine improved.
* Fixed: Import GLD constraint error.
 
10 Dec 2007 5.1.2.31 xl12 * Update engine improved, checks CRC of downloaded file now.  
09 Dec 2007 5.1.1.8 xl11 * Update engine improved.
* Fixed: Import GLD constraint error.
 
06 Dec 2007 5.1.1.7 xl10 * Update engine improved.  
06 Dec 2007 5.1.2.29 xl12 * Update engine improved.  
03 Dec 2007 5.1.2.21 xl12 * Fixed: Operators '>' and '<' in import function 'IF(..)' now evaluate dates as dates and not anymore as text.
* Added new buttons to Contiki 5 Ribbon.
* Added: After download of new Contiki version the installer can be started from Contiki.
 
19 Nov 2007 5.1.2.12 xl12 * Fixed: Import Indexes from Excel would not find the file when no extension supplied.  
6 Nov 2007 5.1.2.12 xl12 * Fixed: Update OBS with Cost Centres that look like dates would freeze Excel.
* Fixed: Update OBS with Comments would freeze Excel.
 
03 Nov 2007 5.1.2.11 xl12 * Fixed: Sort when exporting Indexes would sometimes sort the Columns instead of the Rows.  
31 Oct 2007 5.1.2.10 xl12 * Changed xl Function =Tik1() has been renamed to '=TikF1()' to avoid conflict with TIK1 range.
* Fixed: Open indexes from xl Menu would look for 'YahSets.xml' in the Contiki3 Work Directory location instead of the Contiki 5 location.
 
31 Oct 2007 5.1.2.9 xl12 * Fixed a typing error of a Range Name preventing import of Accounts (Indexes)  
31 Oct 2007 5.1.2.8 xl12 * Register yahtikolap5.dll as Com Add-in when Installing so it is recognized by Excel.  
30 Oct 2007 5.1.2.7 xl12 ** Renewed and rewritten Yahtikolap5.dll replacing ActiveX with .NET technology adding extended Excel 2007 functionality.  
26 Aug 2007 5.1.1.5 xl11\2 * Initialization issue during Create Cubes Settings solved. Selecting General Ledger Balances while defining Create Cubes Settings would stop processing and show an error message under some conditions.  
22 Aug 2007 5.1.2.x xl12 * Renewed Yahtikolap.dll using .NET adding extended Excel 2007 functionality.   
9 Aug 2007 5.1.1.4 xl12 * Checks for updates during operations scheduled for more than one day.
* Slow loading of huge indexes improved.
 
6 Aug 2007 5.1.1.3 xl12 * Replaced Zip technology for Database Backups with 64bits compression so that the backup zip file can be very much bigger than the normal 2GB barrier.  
18 Jul 2007 Previous
Release

5.1.1.2
xl10 * Same like v5.1.1.1 but only for old Excel XP (xl10) clients. Previous
Release
24 Jun 2007 5.1.1.1 xl11 * Fixed - Rename Cube Dimensions would not check for illegal characters.  
20 Jun 2007 Previous
Release
5.1.1.0
xl11/12 * Extended import from Excel files with more than 255 columns.
* TiK user date extended and name changed.
* Fixed Tik cube query "error 1004" when replacing indexes with more than 10.000 Activities (Tik version C5.11.11.22). This was caused by an pointer error in Excel.
 
06 Jun 2007 5.1.0.19 xl11/12 * More detailed error logging when updating Indexes
* Wrong
identifier fixed in xl12 version (was xl11)
 
15 May 2007 5.1.0.17 xl11/12 * Create Cube now has Connection Pooling option included for PC where the Connection Pool seems to be instable. This is related to a problem that is resolved by Microsoft in SP1 for SQL2005 and in SP3 in SQL2000 server. We recommend the latest service packs. Today those are: SP4 for SQL2000 server and SP2 for SQL2005 server.
*Create Cube on error does check much faster if the problem is related to missing data. This could take hour before this version. If found data the user interface includes now a notion that the connection pooling settings can be the cause.
 
08 May 2007 5.1.0.16 xl11/12 * Create cube Time Out error doing counting for query rows fixed.  
08 May 2007 5.1.0.15 xl11/12 * Sheet Button text length in xl12 fixed (xl12 only supports 32 chars). New Tik version v5.11.11.21 compatible for both xl11 and xl12 included.  
25 Apr 2007 5.1.0.13 xl12 * Updated download for Office 2007 version. Same like Office xp version.  
25 Apr 2007 5.1.0.13 xl11 * Import metadata had too much useless log information slowing down processing.  
22 Apr 2007 5.1.0.12 xl11 * Fixed Missing cube templates.
* Fixed
compatibility issues when running on Vista..
 
23 Mar 2007 5.1.0.11 xl11 * Added more import data log information.
* Added shortcut for use in Virtual Server allowing for multiple instances of Contiki5 to be running.
 
22 Mar 2007 5.1.0.10 xl11 * Fixed import data > When Temp Files location would be the same like the Server side location using different naming conventions the import data could error (for example C:\Temp=\\MyPc\C\Temp)
* Added extra checking and error trapping and UI warnings\information.
* Fixed missing "\" to the Log file location.
* Changed: Add-ins write to different log file.
* Changed: When denied write access to Server Side Directory then The Server side directory defaults back to the Temp file location.
 
20 Mar 2007 5.1.0.9 xl11 * Fixed: Abort Operations would leave files open causing errors running next Operation
* Added: Extra logging about processing Temp files.
* Changed: The location of the MDX template files avoiding conflicts when 2 users run Contiki
simultaneous.
* Fixed MDX cube templates would not load the first time after a clean installation.
* Changed default location of the Log and Temp files from ..<User>\Local Settings\Application Data\.. to .<User>\Application Data\.. since this path is visible to most users.
* Fixed: Clean log and Temp files older than 30 days would not clean at the current location.
 
14 Mar 2007 5.1.0.8 xl11 * Added some extra log output.
* Better
handling of slashes (\) as defined by users as the Temp Directory (avoids 'c:\tmp\\temp.txt' like errors).
 
14 Mar 2007 5.1.0.7 xl11 * Fixed destructive impact of coding done by our cat on YahPivotAddin  v5.1.0.6. (The cat is being re-educated not to hunt the mouse of the PC anymore It now attacks the fish on the screen saver).  
14 Mar 2007 5.1.0.6 xl11 * Added 0.3.1.88 Full-Create New Database.sql for creating new databases fully optimised including all separate updates.
* Fixed a bug where Run Operations would not run at all with short operation names including a none latin font. Characters would not be recognised as nvarchar with a operation name like 'א' for example causing operation sto skip them.
 
12 Mar 2007 5.1.0.5 xl11 * Added user control for Log, Temp and Database Bulk Data control (Set Work Directory in definitions).
* Bulk insert location can be a location on the SQL-Server PC and instead of on the client.
* Changed default Log and Temp location from 'Program Files' to the
equivalent of "C:\Documents and Settings\<UserName>\Local Settings\Application Data\YAH\Contiki5\.." (depending on your system).
* 2 Scripts patching database to allow
multiple file locations adding a new table called 'tblWorkSpace'.
* Deletes temporary bulk import files before starting to import data. This will prevent some in rare cases that previous import data gets imported twice instead of the intended new data.
* Added new and updated help.
* Replaced YahFuncTik4.dll with a new version (v21) that should handles 'date zero' better.
* Fixed some bugs at script checking that would cause some scripts updates not to run.
* Added some improved logging here and there.
* Loads the Splash screen faster while loading Contiki.
* Changed\Added on the Select Database form a 'time out' control with a default of 15 seconds.
* Removed the Excel 2003 interop check in the installer to allow installations on systems with only Excel 2007. Be sure to have the correct MS Office Excel interops installed for Contiki won't function well without them.
* Added another error trap layer at the start-up of Contiki. Errors during load that are not trapped by Contiki point to problems in the
environment like for example the .NET 2.0 Framework. 
* Added a script (0.3.1.84) to improve query speed when building olap tables (create cube).
28 Feb 2007 5.1.0.4 xl10 * Updated xl10(XP) version and the same like xl11(2003) version 5.1.0.3  
27 Feb 2007 5.1.0.3 xl11 * Improved Function IF() in data import, added => and =< (<= and >= where already supported before) to avoid simple user errors.
* Fixed Function IF() in data import. Import not enter into an endless recursive loop when encountering an unsupported condition statement (like using => and =< before this version)
* Fixed the create new database script (0.3.1.83). Added basic initializations.
 
22 Feb 2007 5.1.0.2 xl11 * Improved closing of Excel.
* Added a new form for settings of additional database properties
15 Feb 2007 5.1.0.1 xl11 * Fixed the identifier of the create new database script.(from *.79 to *.81)
* From this version onwards the installer will uninstall previous versions (starting from 5.1.0.0)
automatically when found installed.
13 Feb 2007 5.1.0.0 xl11 * Added a new import function named SHA1 that does encrypt text with any length to a string with a maximum length of 28 characters. (2^160 change on doubles)
* Changed internal version of the project to 1.0.* instead of 0.5.*. This will uninstall previous versions
automatically when installing a newer version.
* Added new scripts with extra indexes to speed up cube creation. Starting the program can take a long time when database patched are applied to a full database.
*
Synchronised all data adaptors with the latest database avoiding potentional errors with data sizes.
8 Feb 2007 5.0.7.127 xl11 * Added support for longer Leaf Level and Branch Level names (100 instead of 50). Needs however a DB script that is not yet supplied...
6 Feb 2007 5.0.7.126 xl10 * Same like 5.0.7.125 but for Excel XP  
5 Feb 2007 5.0.7.125 xl11 * Added Full script needed for creating a new fully updated database.
5 Feb 2007 5.0.7.124 xl11 * Added Script that synchronizes Leaf Levels found in Data but not associated with every Hierarchy at import Data. This does fix missing data in Cubes in some cases.
23 Jan 2007 5.0.7.123 xl11 * Improved database synchronisation algorithms in case of program abort.
* Added abort operations.
* Added extra details in the error message when creating a local cube fails.
* Added some Script Update information in the Splash Screen
* Added more information after receiving an Update..
21 Jan 2007 5.0.7.122 xl11 * New Unassigned Metadata message not hidden anymore when running multiple operations.
* Added Database Scrips with new indexes to improve speed.
* Improved Stored Procedure 'FixAphostrophe' to boost data import speed.
* Removed Import from Contiki3 *.mdb database because of potentional
incompatibility with Contiki5
*
Synchronize Database during Operations only when needed.
03 Jan 2007 5.0.7.118 xl11

* Added this version History Information.
* Added some sounds.
* Improved the File
Transferrer. Can be called from within Contiki.

03 Jan 2007 5.0.7.117 xl11

* Added file transferor (v1.0.1.3) for Contiki support

02 Jan 2007 5.0.7.116 xl11

* Checks at start-up before downloading a new version if it was already downloaded before

01 Jan 2007 5.0.7.115 xl11 * Release version for Excel 2003 (xl11)  
01 Jan 2007 5.0.7.114 xl10 * Release version for Excel XP (xl10).  

xl10 = Excel-XP/> xl11 = Excel 2003
xl12 = Excel 2007
xl14 = Excel 2010
xl15 = Excel 2013
xl16 = Excel 2016