DART Version
History
* New Feature
* Bug Fix
*
Amendments
*
Beta
Version 4.2.0.159
* DART/DVerto unicode support, Previous
it had issues with PC's installed with a Chinese character set.
Version 4.2.0.158
*
Added extra debugging around date/decryption on start up and if there is
an error update the error log rather than a pop up message.
Version 4.2.0.157
* Bug
Fix, 'Work Tables' were no longer working or found due to the table look
changes in 4.2.0.157, they now working again.
Version 4.2.0.156
* The
DART "Table Lookup" returned false for MS Access "linked
Tables", you was able to create the table from a link MS Access table but
DART return table not found if you tried to re-open a saves chart.
Version 4.2.0.155
* Licence
timeout check extended*
Version 4.2.0.154
* Slightly
increase the 'Eval nag message' duration.
Version 4.2.0.153
* DART
Licensing failed if the PC was not using a
Version 4.2.0.152
* Ops,
Bug Fix you was unable to create new Data Views after 4.2.0.151 and was given a
Group By and Value fields can not be the same message.
Version 4.2.0.151
* Now
checks the Chart 'Group By' and 'Value' fields are not the same.
Version 4.2.0.150
* Correct a problem where the Advanced SQL filter
failed when the table was not a 'dbo' schema.
Version 4.2.0.149
* Fix a bug caused in 4.2.0.146 when
running DART with MS Access tables failed when checking how many records in the
table.
Version 4.2.0.148
* DART now works with Table Schema's other
than the default of 'dbo'.
* Fix a bug when adding a filter sometimes
you needed to click the OK button twice to continue.
Version 4.2.0.147
* You
was not asked to save the Data Grid View/Layout when editing the Data View
Filter so once the filter was applied all the previous formatting was lost
(unless you remembered to save it before hand).
Version 4.2.0.146
* If there are over 50,000 records in the
source table and no filters have been applied we warn the user this may slow
down the finally output and give the option to return back and add some
filters.
* Added a total record count (before
filtering) on the source table to a new status bar at the bottom of the filter
form.
. Version
4.2.0.145
* When
reloading a saved "Data View" the decimal place formatting was
restored from the grid layout definitions when it was previously saved so
ignoring any new decimal place settings if changed in DART settings. This has
now been changed so the Decimal Placing set in the DART Settings overrides the
setting that were saved in any previous grid layout definitions.
Version 4.2.0.144
* Added an "Edit Chart
Grouping" option in Load/Mu Charts if you right click on the selected
chart, this allows you to change the fields if for some reason they no longer
exist or have been renamed in the back in database.
* Updated the 'hints' to the crosstab
icons.
Version 4.2.0.143
* Added
a DART "License Expiry Warning" when with in 30 days of the expiry
date.
Version 4.2.0.142
* The
"Chart Sort Order" no longer defaults to "Desc" when
creating charts from CSV imports.
Version 4.2.0.141
* Fix
launching DART via a CSV fro
Version 4.2.0.140
* Under
a certain mix of Chart Themes and Colours set in setting the Crosstab chart
creation was causing an Access Violation, we not check if we can apply the
selected theme and warm the other if there is a problem.
Version 4.2.0.139
* The
Crosstab "Colour Each Pie Slice" option was being ignored when you
first load a crosstab chart, there was also a problem causing Bar Charts to
colour each series when changing from a pie to a bar chart.
Version 4.2.0.138
* We now check the CSV file format has a CR/LF etc at the end of each
record line before we import any data, before hand DART crash out with
spectacular exception error and had to be killed off. This error is normally
caused when copying a file from a UNIX server to the PC in a binary format.
Version 4.2.0.137
* There
is now an option to create CSV DEF files in the "CSV database import"
this will take the first line of the CSV and then let the user to edit the
field name, data types and field lengths.
* Added
a "Open CSV Folder" toolbar option in "CSV Database import"
this will open the folder where the CSV (and DEF) files are required before
DART can progress them and import them.
* Adding HEADER=Y to the [SETTINGS]
section in a .DEF file will cause DART to skip/ignore the first line when
importing the data.
* In Setting "Pre-Database
Processing" when the "CSV to
DB table import" is selected your are prompted if you would like to change
the DART database to look at the imported database.
* Listing the CSV files in the "CSV
database import" box now still show if there is no matching DEF file,
before hand the CSV never appeared for importing in the list if there was no
.DEF file.
Version 4.2.0.136
* New
email address field in the DART Activation settings.
Version 4.2.0.135
* Rebuild the Chart/Data View work tables
could actual rebuild a different chart/View than the one currently
selected/active.
Version 4.2.0.134
* The
"Save Layout" option was not showing in "Data View" when
viewing data launched via
Version 4.2.0.133
* Changes
to the CSV default folder used with launching DART from
* In "Data View" check the field
ranking is not used before allowing the Analysis/Crosstab option.
Version 4.2.0.132
* When creating a "Data View"
with ranking if the source Table/View contained a ft
Version 4.2.0.131
* When
the "DART Apps.log" file gets to around 500kb it is renamed as
"DART Apps.001" and a new log is started, previously the log file
just grow and grow and grow.
Version 4.2.0.130
* Added
4 new "numeric decimal placing" options in settings: these are True
Values and zero decimal places both with comma formatting. We also added one or
two decimal places options but please be aware all values will use these
decimal placing options so for example numeric accounting periods will show as
3.00 instead of 3.
* If
a SQL or grid error occurs while showing the required information in the
"Data View" we now attempt to close down the Data View cleanly with
out any additional exception errors and access violations , if the grid is
using a ranking field this is also reset incase the source table is not
compatible with rankings.
* On fresh /new installs the DART Snapshot
field was not defaulting to "Snapshot" in settings.
* The chart 3D OrthoAngle was not being set
correctly when going from different type of charts like Pie chart to Bar chart
etc, so the chart 3D was incorrect in some cases.
Version 4.2.0.129
* Charts (inc Legends) now also apply the
"Numeric decimal placing" in settings. You can show true values or
round to zero decimal places.
Version 4.2.0.128
* Fixed the
Madics/
Version 4.2.0.127
* DART now has the ability to create work
tables based on the selection filters/criteria of the Chart or Data View, this
is very useful and will improve over all speed of DART if the source table/view
is very large or takes a while to calculate when an SQL command is issued to
it. To enable this option tick the following option in Settings: “Enable DART
Work Tables for Chart/Data Views”.
Please check with your SQL Server Administrator first to check you have
premmisssion to create table on the backend SQL database. (This option is not
available for MS Access connnections).
* DVerto (comes as a part of the DART
install) now has the ability to rebuild any DART Chart/View Work Tables over night,
this will give the user the latest information first thing in the morning with
out a long wait while the tables are rebuilt, DVerto version 4.2.0.55 or later
required.
* The following fields are now available to
select and show in the My Charts/Views data grid: Work Tabled Enabled, Work
Table Name and Last Work Table Update
* Added more Work Table help
information/text to the dialogs.
* Correct tab order of the Data View
Settings in Settings.
* You was not prompted if you wanted to
create a Work Table (if enabled) when creating a new Data View.
* You
was able to create a Work Table from a Data SnapShot, this has been disabled
and really no point as it will be no quicker and the data in the table will
never change.
Version 4.2.0.126
* Additional speed Increases Opening a
Chart or Viewing Data when using Work tables.
* Basic Data Views were doing some total calculations what were not
needed, this will speed up the Basic Data View slightly.
Version 4.2.0.125
*
DART Work tables no longer show in the table/View selection list when creating
a new chart/view.
* If the Chart/View Work table was used it
fell into the work table refresh logic to often and offered "Use current
work table data" in far more places than needed.
Version 4.2.0.124
* Fresh out the software beta Lab is the foundation for DART Work
Tables, If enabled/allowed DART will be able to create tables in the connected
SQL database based on the selection/filter criteria, these tables can then be
used to improve general reporting speed in DART. (This option will not be
available in MS Access connections) currently to enable this select the Beta
tab in Setting and tick the option "Allow DART to create tables in SQL
database". Please remember this is still work in progress or under testing
and enable at your own risk.
Version 4.2.0.123
* The
"Edit Chart Title Icon" now also allows you to edit the Chart Name,
before hand you had to close the chart and go into "My Chart/Views".
*
Changed the "Edit Chart Title" toolbar Icon to something slightly
more meaningful than a NotePad Icon.
* The
Chart/DataViews executed SQL command is now stored, this may come useful in the
future to give the ability to execute the same command and get the same result
from another application other than DART. To save this command go into "My
Charts/Views" and right click on the required Chart/View and select
"Save execute SQL Command".
* The "DART Update" (Ver
4.2.0.3) now displays the list of file(s) that will be updated before they are
downloaded.
* Fixed a bug what we introduced in the
past half a dozen version changes where the “Data View” right hand field list
aways restored to all fields being ticked/visible when loading an existing
“Data View” this did not effect how the “View” was layed out and the orginal
select fields and format were still shown.
* Solved a "Database Query Error Field n/a not found" this
occured when viewing a section of chart data and then directly creating a new
Data View or opening an existing Data View.
* The
"Edit Name" option in "Charts and Views" did not check to
see if a Chart or View already existed with the newly entered name, this caused
all kinds of weird side effects having two or more Chart/views with the same
name.
* Updated
the Support email Chart table fields list, some newer fields were missing.
Version 4.2.0.122
* There
is now a new Copy Chart/View option,
Useful if you want to compare two charts with just the value field
different.
* Added
a new "Rotate Bottom Axis Labels" in Display Options.
* Added a new "Show All Bottom Axis
Label" in Display Options.
* Added
DART restart required warning if the Database was changed in settings.
* The Cancel button was ignored when
changing a chart type (Pir,Bar,Line) and it still applied the changes.
* The
newer Data View Layout Reset and Ranking options were availble to read only
users, these have now been disabled.
* Test
Database Tables in SQL Connnection
settings Test was not changing to the selected database until you re-started
the DART application.
Version 4.2.0.121
* If its a SQL database connection we now
set the ADO Data connection Default Database before hand this was always left
blank.
* The ISAPI license date is now always set
to a
Version 4.2.0.120
* Added
"Test Database Tables" to the SQL Server "Test Connection"
button in Settings, this will test the connection to the database, as well as
list database tables and show the selected tables field name, datatype and
length.
Version 4.2.0.119
* Added
a Data View button/option to reset the Data View's field and grid layout
formatting back to default.
* You was able to select the Ranking option
in the Data View when connected to a MS Access database, this in turn then
errored as MS SQL Server 2005+ or later is requires.
Version 4.2.0.118
* Added
new 'Ranking' option in the Data View. Please note Ranking will take longer to
process as it will run a few extra SQL commands.
* Added new chart methods of: Avg,Min and
Max.
* New Chart Theme/Colour palette Preview
in Settings.
* The "Chart Colour Palette"
has now moved from Options to Settings.
* You are now able to see the last SQL
command executed by right clicking on the Help Button.
* The Support Email includes the last
executed Chart, CrossChart and Data View SQL Commands.
* Failed SQL commands now display in a
new text/info box rather than a
* The cross chart series colours were not
being set correctly on first creation.
* The Advanced SQL in come cases failed to
set the
Version 4.2.0.117
* If launching DART from
* Added additional checks and error trapping around DART.SBX/
Version 4.2.0.116
* Added the ability to see multiple
opened charts on the screen at the same time, for example this is useful if you
have two charts one with budgets and another with actuals and want to see both
values on the screen at the same time to compare them, to enable this there is
a new standard chart tool bar 'toggle' option/icon, click this and you will be
able to select the charts to show in the Open Charts form.
* New
option in Help to "Email Madics for Support", you also have the
option to send all the Chart/View Configurations in an Excel file, this maybe
useful for Support to debug/understand any issues. The Users settings INI file
and any TraceWindow contents are also attached.
* Trace window size changes.
*
We was still showing the Standard filter descriptions when in Advanced filter
mode and Crosstab charts, this now
displays "Advanced filter applied" same as the standard charts.
* The options pie charts "Group
'Other' Slice %" and "Explode Biggest %" was not effect all pie
charts in the crosstab charts.
* Corrected the ExpandedText in the Create
Data Analysis CrossTab confirmation, this was wrapping off the diaglog.
* Other misc bug fixes.
Version 4.2.0.115
* Moved the "Analysis/Crosstab"
icon from the Data View smaller toolbar to the upper (larger) toolbar.
Version 4.2.0.114
* Right Clicking on a Data view column
also activated it, much like left click already did but does not sort the
column content.
* Added the ability to change the row and
grouping sizing, Added Row Indicator and a Quick Column Customisation Icon (top
left corner of data grid) this is another way to add/remove fields and reorder
the columns.
* Added "Sort By Grouped
Values" menu option when right clicking on a Data View column header and
Grouping is active.
* Bug Fix to the DevExpress cxGridStdPopup
* Bug Fix, Grid saved format layout some
times failed to restore the grouping data field.
Version 4.2.0.113
* More
information is now shown on the Busy Please Wait dialog.
Version 4.2.0.112
* Fix
a bug where on a fresh install you got the message "User Search
Error" UserAdmin not found.
Version 4.2.0.111
* The Chart "Created By" field
has now become "ChartOwner" an administrator
user has the ability to change the ownership of changes using the new
"Chart Owner" button im My Charts/Views, this allows the
Administrator to setup/create charts for different users and then assign it to
them at the end once finished.
* New user permission to disable the user
from creating new charts and views.
* New Administrator Filter Lock when
creating filters, this allows an administrator to set a filter and lock it so
users are unable to edit or delete it, this is useful if you dont want users to
see a certain selections of data etc.
* With a SQL Server database the Data
Snapshot was failing to copy/inherit the soure security settings and error'ed.
Version 4.2.0.110
* A slightly limited Data Analysis
crosstab is now available when using a MS Access MDB with a maximum of 20
columns, this feature needs to access to and will create temporary tables in
the actual Access MDB database we recommend compressing the Access MDB as often
as you can to minimise the database size increase. There is also a limit on how
many fields/columns the Access/Jet engine can define, we recommend looking into
using SQL Server 2005 if you wish to do
Analysis on data other columns like Accounting periods etc.
Version 4.2.0.109
* Fix a big where the fields never listed
when creating/Importing CSV files from
*
The Data Analysis crosstab Export and toolbar was enable/visible before any
selections were made.
Version 4.2.0.108
* The Data Analysis crosstab checkbox data has been reduced even further
down to 52 as PC's/SQL Servers were timing out when collecting too much
information if there were say 350+ columns and hundreds of thousands of records
(rows).
The first 52 unique data fields will be
displayed, and there is a button to rebuild and show All unique field but
depending on the size of the table/view this may take far longer to build.
Please note still on 52 items can be selected.
There is a Select/Unselect all if you
Right click on the check boxes.
Version 4.2.0.107
* When creating the Data Analysis crosstab
checkbox we only show the first 366 unique data fields.
* Speed up the Data Analysis crosstab
selection entry, it could take a while for the field selection boxes to come up
if there
was over a million records.
* Misc Error message changes, excluding SQL command from
Data Analysis message.
Version 4.2.0.106
Added Excel Export etc to the ‘Data View’
Analysis data grid.
* Data
Analysis field selection now show in the tab caption title.
* Added Data Analysis tool bars commands
and grouping totals much like the "Data view' does already.
* Correct a bug when aborting a Data View
and then creating a new Chart it still thought it was a new Data View and half
the chart options were missing.
Version 4.2.0.105
* Introduce
a new ‘Data View’ Analysis Crosstab/Pivot option, click on the Wizard Icon in
“Data View” to be asked which fields to be displayed.
* We lost the right click "Remove
Share" option in My Charts/Views when we changed the data grid component,
this is now back and once again you can unshare charts/views.
* It was possible that an application error
ocurred if you changed the 3D, Colour each pie slice and/or True Cirlcle
setting in options after each other.
* if the Standard Chart hide legends option
was enabled this caused a show/hide error when trying to load a Crosstab Chart.
Version 4.2.0.104
* Fix a bug where you was able to
delete/edit chart/view details when they were in use (in 'My Charts') this
happened only if the chart/view was the first one in the list.
* Added missing ToolTips in Data View.
Version 4.2.0.103
* If enabled the manual CSV(DEF) import was
not importing data as the CSVDB.mdb database may not exist first time around,
we now copy this from the application folder if its not in the ..\DART
Application Data\CSV folder.
* Launching DART via
Version 4.2.0.102
*Added 'Cancel' button when creating
charts from
* When creating a "Data View"
using a new table/view for the first time the field security settings where not
created leaving you with a blank Data View and no fields, even if your user had
Access to the most secure data, the work about was to edit the field security
for the table/view and then open the "Data View" again. This did not
apply to creating charts.
* Creating new charts now default to Bar
Charts.
Version 4.2.0.101
* When
executing DART from
* Removed
the Profile Button in Settings, this is launch separately.
* Changing a field in the Field Security and
then clicking the exist straight away never saved the last change.
* Removed the 3 extra buttons separators
showing at the start of DART when executed from
Version 4.2.0.100
* Added a column data search in the Data
View.
* Speed
up the process of getting the table/views fields names when running on a SQL
Server connection.
* Database command time out has been
changed from 30 seconds to 180 seconds, Database connection time out is now 60
seconds, this has been increased to try to solve Server timeouts errors.
* Internal changes to the debug window,
Application/User folders are output'ed to this at the start of the program.
* Fix an exception error when sometimes
exiting the application.
* In a Crosstab chart the "View
Data" button was not being re-displayed when returning from viewing the
data in a "Data View" for the first time.
Version 4.2.0.99
The Basic and Advanced Data View now have
there own saved columns/view/layout settings.
* Data View column filters are no longer temporary and are now saved
along with the columns and grouping when saved in the Advanced Data View.
* The "Data View" fields selection/checkbox was not always
sorted in alphabetical order.
* Snapshot failed if there was a duplicate
field in the column and the chart group by etc, this big was caused back in
4.2.0.95 when we added brackets around field names to allow spaces in them.
* Switching from the Basic to the Advanced
Grid now shows the application is busy and processing before hand it looks as
if it had hung.
* When creating a "Data View" for the first time (not loading
an existing one) the DataViewOnly flag was forgotten creating some weird side
effects including Snap Shot field n/a not found errors.
* You was able to take a Data Snap Shot while the column filters were
enabled and filtering the grids this gave the impression it would snap shot of
what was only showing in the grid where it really took at snap show of complete
Data View you was viewing at the time.
Version 4.2.0.98
* Ops, Fixed a bug caused in the previous
version change what caused Filters and other options to crash if you changed
the chart while it was being displayed. It was not re-loading the chart with
the newly applied settings.
* When adding to a column filter in the
Data View depending on the field data type yo could of got an error or
"arguments that are of the wrong type, are out of acceptable
range". (The grids data controllers
AutoDataset filter has now been disabled)
Version 4.2.0.97
* A few Advanced Grid tool Icons reapeared
when in the Basic Data View grid.
* Changes to the Load Chart/View form, in
some cases the form was left on screen while the data/charts was loading giving
mis-leading information and the user not knowing what was going on.
Version 4.2.0.97
* A few Advanced Grid tool Icons reapeared
when in the Basic Data View grid.
* Changes to the Load Chart/View form, in some
cases the form was left on screen while the data/charts was loading giving
mis-leading information and the user not knowing what was going on.
Version 4.2.0.96
* The new Express Quantum Data Grid could
take a long time if there was thousands and thousands of records to display
this was because it was automatically giving you the ability to group, quick
filter, sort, sum, count etc. Now if there are more than 5000 records (default,
change in Settings) to be displayed you willbe asked if you would like to use a
Basic Data View (No Sort, Grouping, quick filter etc) this reads the records as
needed and not all at once. You have the
ability to switch to the Advanced Data View at any time my selecting the new
option that will appear, be warned if there is a lot of data this could take a
few minutes.
Test show under a Basic Data Grid a 30
field table containing about 600,000 records takes a few seconds to display
(after the SQL completes) the Advanced Data View took a few minutes. (Please
note this all depends on your PC Hardware and the located and type of the
Database)
Version 4.2.0.95
* Fix a big where the Snap Shot failed if
the data field names had spaces in them.
* The Data View decimal place mask was
incorrectly beeing set on first install, please set this in Setting.
Version 4.2.0.94
* Added new option in settings of
"Data View numeric/decimal
mask", The "Data View" numeric values will use this mask
to display the values, it defaults to zero decimal places the other setting is
true value.
*
* Removed check for updates in Settings,
this is now a separate program, if its not on your DART menu it can be located
in C:\Program files\Madics Systems Ltd\DART\DARTupdate.exe.
* Changed the OnExit Charts list (where
you can select what newly created charts to want to keep) to use the Quantum
Data Grid.
* On first install the Sub title fonts
are now set to purple rather than white. The default Opera theme had a white
background.
Version 4.2.0.93
* Add new ExpressQuantum Data Grid components, you are now able to many
more things in the "Data View"
including, grouping, filtering and totalling.
* New toolbar in the "Data view" to Add/Remove all columns,
Expand/Collapes all grouping, Best fit columns etc.
* MyChart/Views now uses the new ExpressQuantum grid component, the fields layout can be changed and the
column format is saved on exit.
* Data Views left hand side Field
selection Panel visible state is now saved and remembered between uses.
* Word and PDF export "Data
View" has been removed as it was 100% correct with the latest data grid,
and there was other better method of doing so.
* Changes to Data SnapShot to rake into
account the Data Grid grouping fields.
* Remove the "please restart DART for
changes to be effective' message what popped up every time you typed a
character in the Access MDB file path edit box.
* Standard charts "rotate icon"
was visible even if the chart was not a pie chart.
* Correct "Chart Display Filter"
tab order.
* Important to note, After updating to
this version any older Data View grid column formats will be lost.
Version 4.2.0.92
* Added
toggle chart labels icon in the tool bar, this saves the user going into Options.
* There is a new Snap Shot button in the
Data View, if enabled in Settings (disabled by default) the data/fields
selected and displayed including the
Chart/Data View is saved to a new static table to the current database. This
has been disabled as default as you may
not want users to write back to the backend database.
* Added Export
chart values to Excel icon to Normal Charts toolbar.
* Added missing Cross Tab 'Chart Display'
tool tips.
* After changing a "Data View"
Filter it failed to re-create the Data Grid.
* Hunt down and hopefully traced where at
one of the exceptions occurs when exiting DART.
* Field security table panel width make
wider to fit longer table names in,
Version 4.2.0.91
* You
are now able to change the CrossTab series colours if you double click on the
series colour in the chart list. (Any colour changes are not saved when the
chart is closed)
* By
default only the first 12 series in a Cross Tab are selected/active.
* Added Help button for Online Help
Guide.
* Cross Chart series colours now re-repeat
rather then any series over 11 all set to one colour.
* Combo boxes made long when creating a new
chart allowing longer field names to be seen easier.
Version 4.2.0.90
* Add missing 'print' chart tool tips.
* Changes to the CSV import/display from
Version 4.2.0.89
* Now
able to create Sub Chart from Cross Charts.
* Clicking on the "View Data"
button always return back to a Crosstab Chart if one was created/active.
* Excel export, numeric cells are now set
to an Excel general type rather than a 2 decimal place number.
Version 4.2.0.88
* Added
XML to the Data Export.
* In CrossTab charts You can now right click
on any of the charts with out making it active/selected first.
* Changed Cross Tab SQL order by to use
DARTGroupField fist, and disabled the sortby on the CrossTab Charts List, this
fixed a problem where the colour of the charts in the Charts List did not match
the colours of the slices/bar charts themself.
* Select All Cross Tab button did not reset
ColorEachPoint to false so multiple charts colours were all the same colour.
Version 4.2.0.87
* The
DataView export to Excel has been completely change to use new data export
component, this also allows the user to export to text, Word, HTML or create a
PDF file, There are new options of Open or Email once the export is complete.
* Added 'test SQL Server' connection
button in settings.
* All
'data records' option removed, due to security data issues.
* Fix a bug where the Excel Export failed
if used via the "Data View" and not by creating a chart first.
* The "View Data" button was left
showing after opening/Closing a "Data View" and no other charts were
open.
* Only the creator of the chart/view or the
admin user can now delete charts.
* Fix backdoor password bug.
* Bug Fix, you was able to add blank users
to the DART user file.
* Several other bug fixes.
* Important to note, Export Data to Excel
has changed, you may need to change/check any Macos that you run in Excel after
the export has completed.
Version 4.2.0.86
* Share or Personal, all charts default
to personal and only the user that created them will be able to access them
unless they are flagged as Shared. this option/button can be located in Open
Charts, right click the chart record to unshare.
*
Only the Chart/Data View creator can save the Data View field/column layout.
* Fix Show/Hide all fields in
"DataView" sorry broken in previous version.
* Read Only users were abled to edit the
charts main title.
* Important to note all previous charts were
always shared, this is no longer the case and they are not shared by default,
You can re-share this by selecting the Share button in “My Charts”
Version 4.2.0.85
* Added Field Level Security, each user can be assigned a field security
level of 1 to 5, this level corresponds to the level set on each field of each
table/view in settings.
* New
standard chart display criteria to show all records, top x records etc, this
allows you to filter out all the smaller amount records.
* Added 'like' as a filter option, this
will includes anything that matches the entered string.
* Added Crosstab Bar Chart display types of
side-by-side (default), stacked and behind each other.
* Introduce a Advance SQL filter giving
the user more flexibility creating selection over the current simple filter.
Sub Charts can not be created from charts created using the Advanced SQL filter
option.
* Speed up Crosstab chart creation by
only selecting the 3 required fields in the SQL query and not all fields.
* Increase SQL execution timeout from 30
to 180 seconds, for slow responses from SQL Servers.
* Chart display
attributes (eg. 3D effects) were not being re-applied when toggling between
open charts.
* Important if updating from an earlier
version and running in Multi user mode, Field level security defaults to 'on'
so no fields will show until each existing user record it edited and a field
level is assigned. Select the "Field Security" option in Settings
-> Multi user mode to edit table/view
fields levels.
Version 4.2.0.84
* If
a table/View no longer existed in Multi User mode and there was a saved
chart/data view even then Admin user did not have permissions to access and
deleted it.
* Realign forms and change fonts in in the
User Access Control in Settings.
Version 4.2.0.83
* New
settings option of "Ignore tables/views starting with" - DART will
ignore any tables/views that start with this, defaults to temp_.
Version 4.2.0.82
* When
viewing the Chart data in the "Data View" for the first time it now
only shows the data fields you selected for the chart, "Data View"
onlys will still show all fields.
* Check for latest version of DART in
settings now launches DARTupdate.exe rather than UpdateCenter.exe directly.
* Table list failed to re-shows if you
created a CrossChart, deleted/removed it and then went back to create a new
chart.
* You was able to edit/delete charts from
"My Chart/Views" while they were in use by yourself or another user.
* Save Chart button apeared in "Data
View" when it should not of, causing an error if selected.
* Save Chart button still was left
displaying once the chart and been removed/deleted from the screen.
Version 4.2.0.81
* Added
'Total Columns' button in "Data View" this will add up all numeric
values and total in the grid footer.
* In
the "Data View" you now have to double click on a field in the field
list box to goto that field in the data grid, before hand it went directly to
that field on a single click, in some cases you may not of wanted to move from
the current focused cell.
* Ticking a field to show in the
"Data View" now makes this new field/column in the data grid focused.
Version 4.2.0.80
* We
now ask the user if they are sure they want to close DART before just closing
it down.
* Standard charts are now
sorted/displayed by the group by value,
* Set
the Pie Chart OrthoAngle to zero on change of chart, otherwise the chart looked
a little weird changing from a Bar Chart.
* Add a splitter to allow the CrossTab
Chart and Legends to be resized.
* When creating a new Chart the DART title
was not getting set to the Chart Name by default or was inheriting the previous
charts title.
* Closing a 'Data View' only was not
releasing the lock and said it was still in use.
* The 'Data View' was incorrectly showing
and refreshing in Dialog Mode, Tabbed version was working fine.
Version 4.2.0.79
* In some cases the 'View Data' button did
not re-apear if you selected a different chart from the Open Charts list.
* If you pointed the source database a SQL
Server Database or UDL source and the Access MDB filename was blank a miss
leading error of 'source database not found' apeared.
* SQL Server System Views no longer show in
the Table/Query List.
* Fix a bug where you got 'field x not
found' when openning a Data View, close it and open a chart and select View
Data.
Version 4.2.0.78
* Add
Tabs for normal Charts and CrossTab Charts allowing the user to toggle between
the two.
* The "Data View" can now be in
a Tab or shown in a Dialog, Set this in Settings.
* Added 'Right Click' see data in the
Cross Tab Charts, Hi-light the Required series in the righthand panel first,
double clicking on the series will display all the data for the selected
series.
* Added "Save Grid Columns"
Button in "Data View" the fields selected/columns no longer auto save
and only now saved if the user wishes by clicking the Save Grid Columns button.
* Disconnect the sql query between the
CrossTab charts and the DataView, these now have there own sql Query.
* Speed-up background Data Queries, only
run if the user selects to see Data View etc.
Version 4.2.0.77
* New
Statistics showing charts Max,Min,Avg, Range,
* Under Windows Vista the toolbar Icons
clashed very close to the main form.
* Changed/Updated the Chart Data Values
data form to show values in a different table.
* Creating a child chart left the parent
chart on the screen at the same time.
* Fix filter query error - tblGrid field
not found problem where opening a crosstab chart for the 2nd time.
Version 4.2.0.76
* New
'CrossTab' Charts
* New
Opera Chart Theme
* New Chart Title text.
* New 'Show chart value' form
* Several other enhancements and new
features, including 3D Charting, Colour themes, Magnify glass etc..
* Updates to the My Chart/Views/Load
form.
* Data View form now shows/sizes with in
the main form.
* Updated to TeeChart version 8.02
* Additional internal updates tweaks to the chart zoom feature.
* Update DART.SBX - Version 4.2(504) to allow CrossTab field be passed
from
* Misc bug fixes.
Version 4.2.0.75
* New 'Data View' option this allows your
to access the tables/query directly skipping the need to create a chat at the
start, you still have the ability to Filter data and if required convert the
Data View to a Chart any any time.
* Read only users permission had full
acccess to lot of the newer features added, these have now been locked now.
* Open Charts, buttons moved in a new
order.
* General wording changes like 'Open
Chart' becomed 'Open' etc.
* Correct settings/version tab key
ordering.
* Attempt you trace the reason why on some
Windows XP PC DART does not maximise completely on start up.
Version 4.2.0.74
*
Added Licence Check/Reset option.
Version 4.2.0.73
* Fix a bug where the icon options still
popped up in a panel rather than in the top icon bar.
Version 4.2.0.72-1
* Updated midas.dll to version 6.0.10.157
from 5.0.6.18, New installs will also place the midas.dll in
c:\windows\systems32 rather than the DART application folder. This version of the midas.dll is now the same
version as the one used by www.caliq.com and solves some database issue that
was caused when DART's older version was registered and used instead.
Version 4.2.0.72
* Set version
history web page in DART to the new location of www.da-rt.com/darthistory.htm
Version 4.2.0.71
* Fix a possible field type mismatch when
export data into Excel.
* The 'Verify Activation Key' button
displays if its a Single or Multi key licence.
Version 4.2.0.70
* The 'Verify Activation Key' option was
not validating the complete code.
Version 4.2.0.69
* The internal AMOS Pre-Database
Processing has now been replaced with the new Madics Data-Exchange Console.
"The Madics 'D-Verto' (Data-Exchange) Console gives you complete
flexibility extracting and manipulating your data from Madics (AMOS random data
files) into a SQL Server or MS Access. It allows you to access nearly any
Madics data file, all or selected fields. This is based on scripts stored on
your Madics server for easy maintenance and backup.
There are several types of scripts depending on the action:
Extract/Export Data, Create Views/Queries, or execute SQL commands. These all
can be scheduled for background processing.
More information can be found at www.da-rt.com/dvertohistory.htm
Version 4.2.0.68
* DART Version details now included in
Activation Check with Madics.
Version 4.2.0.67
* Internal activation tweaks based on
single and multi user options *
Version 4.2.0.66
* Added some extra activation checks and
messages if invalid and multi user enviorment changes.
Version 4.2.0.65
* Activation licence changes, Warning,
you will need to be re-issued a new activation key from Madics.
Version 4.2.0.64
* New option in settings to 'show/hide
* The Tools panel has now gone, and all
the Tools icons now live on the main Chart screen.
Version 4.2.0.63
* We now show the first line of any '
* Removed the evaluated data export
component.
Version 4.2.0.62
* Added a new SQL Security type field in settings for SQL Server
connections, this can be either Windows Integrated security or Specific user
name/password, previously it used Windows Integrated security if the user name
was blank.
Version 4.2.0.61
* Manual CSV importing/updating now
automaticlly creates the UDL connection file depending on the current profile.
Version 4.2.0.60
All field types are now encased with quotes when Exporting to Excel,
this solves a problem where the field wrapped to a new cell if a quote was
included in the text.
Version 4.2.0.59
* If in Multi Chart Mode, Bar Charts are Stacked side by side and each
series in its own color rather than each bar.
Version 4.2.0.58
* Evaluating data export component, currently there is a new 'Export
option' in Data View, this will not end up like this in the finally product.
While this is enabled you will
be pestered by an extra evaluation message time to time.
Version 4.2.0.57
* Added a Simple
SQL Query editor in the debug windows to allow close manual inspection of the
data.
Version 4.2.0.56
* Bug Fix, If a Query timed out, DART continued to try to create a Chart
and locked up.
* Multiple Charts, try to solve (not guaranteed) the on-visible error on
Show/Hide message when clicking the show/hide chart checkboxes.
Version 4.2.0.55
Added DART Profiles, each DART profile is a unique instants of DART,
with its own database, settings, and even DART licence.
Launching DART from Madics/
Use DARTProfiles.exe to setup, edit and delete profiles. this can be
launched in Settings -> Maintenance.
Bug fix, An Access Violation ocurred if you selected 'PC Licenses' once
DART trial version expired.
Version 4.2.0.54
* Edit Users, passwords no longer show,
just display as stars.
* If you ever need or want to point
DART's database, Application Data etc somewhere other than the default of
C:\Documents and Settings\[user]\My Documents\My DART Saves you are now able to
do so. This also allows you to run multiple DART's all running different
settings, connections and saved charts. Currently to enable this, create a
DataLocation.ini in the same folder as the DART.EXE and in a [DART] section set
the following: DataFolder={folder location}/
Recommend using DART Profiles instead of
this, see 4.2.0.55.
Version 4.2.0.53
* When creating a new chart the 'group
by' and 'value' fields are now sorted in alphabetical order.
* Increase the SQL
connection timeout to 60 seconds.
* Force an application.processmessage
around the 'busy - please wait' before hand the form may not of shown til the
of an SQL command, what was a little late by then.
Version 4.2.0.52
More speed up tweaks, including speed up
listing available fields when creating a new chart, previously it opened the
whole table before continuing, which could take a long time! if there was a lot
of data. Also opening the 'table' only
reads the first 50 records to start with, instead of the all!
Version 4.2.0.51
Read-Only users were able to change the
'Data View' fields and columns as well as the chart display settings, these
have now been disabled.
Version 4.2.0.50
In the 'Data View'' we have removed the
'table' name as the parent of tree we now just show all the available fields,
also added Show and Hide Fields buttons. First time around we also sort the
fields checkboxes in alphabetical order.
Version 4.2.0.49
* Attempt
to speed up viewing the datagrid, looks like there is a slight improvement.
* Added a DART Debug Window to show the
background motions and SQL commands to hi-light where some things take longer
than others to process. This only occurs when this window if visible. (Enabled
in Settings)
Version 4.2.0.48
Added a new option in Setting to load the
Excel Personal Workbook, this then allows you run an Macros saves that are
saved in this file.
Version 4.2.0.47
DART now creates the CSVDB.UDL on the fly
when launched from
DART.SBX 4.2(503) now reads the DART Users
Data Folder from the PC's registry.
Version 4.2.0.46
Warning, Read below before updating to
this Version from an earlier beta version.
The DART database and settings have been
re-located from C:\Program Files to:
C:\Documents and Settings\[user]\My Documents\My
DART Saves\DART Application Data.
If you want to keep any pre-defined
charts and settings we recommend taking a copy of your dart.db and INI files
etc before updating, uninstall DART and do a fresh re-install, then copy your
dart.db etc into the new install location, you also may have to re-license
DART.
Version 4.2.0.45
Mostly thanks to Windows Vista extra
security we now have relocated DART Registry setting from Local_Machine to Current_User,
these are moved and saved to the new location the first time you launch this
(or later) versions of DART.
For
Also, Added Madics License ID to DART PC Licensing list.
Version 4.2.0.44
Added a new option 'Check for DART
Updates' in Settings -> Maintenance, this is testing DART with the new
UpdateCentre by Firmaware (http://www.firmaware.pt).
Version 4.2.0.43
* The
busy 'Please Wait' timer is now displayed when changing charts, sometimes
if the database was large and it took a while it may of looked as if the
application had hung.
Version 4.2.0.42
* The charts list is no longer fixed on
the right hand side, instead it has been turned into a floating panel giving
far more space for charts, legends etc to be displayed. this is now known as
the 'Open Charts' panel will automatically display when a 2nd or more chart is
loaded, or if the 'Charts Open' icon is selected.
* Change Chart display from a Tab Panel
to a normal Panel as the TAB's were not used, this also now gives a little more
screen space for the chart itself.
* The Load Charts icon has now changed to
a folder.
Version 4.2.0.41
* Fix a bug where you was unable to
connected to a SQL database if you entered a user name and password in the connection settings, previously you
had to get around this by creating a UDL file.
* When setting a SQL Database connection
the 'Database' is now a combo box that lists available databases for the
current SQL server.
* We have also change the SQL Server edit
box to a combo, if SQLDMO is installed a list of SQL Servers on the network
will list in here.
Version 4.2.0.40
* In Options panel we have added Show
Chart Label and different styles: Label, value, percentage, Label and Value, Label
and Percentage.
Version 4.2.0.39
* Added 'Beta' option in Settings, All new, experimental, or not fully
implemented options for beta testing go here. The 'Show multiple charts on
screen' option has been re-located here from 'Settings' along with a new 'Show
charts in 3D'
Version 4.2.0.38
* Chart, filter and changes 'Apply dialog' box Component has been
changed.
Version 4.2.0.37
* The general chart display filter and
sort order has now been removed from the options panel and moved to a New Red
Filter icon in the Tools bar, these are now stored on the chart table.
* Added 'Edit Chart Display' to My
Charts/Load Chart.
* Chart Display Filter now included in
the title.
* 'Show All Data' in table button in the
Data View is no long available unless the user is admin or in single user mode.
* 'Data Grid' button rename to 'View
Data'
* Re-arrange icons in Tool Bar.
* Fix the problem where dialogues where not
returning on-top of the main DART form after toggling to and from other Windows
applications causing it to look like DART had frozen.
Version 4.2.0.36
* Added a general chart filter to allow
the user to filter down the amount of records shown by entering a value in the
'Values greater than' box in the chart options panel. In a later release this will be stored on the
chart record.
Version 4.2.0.35
* Added 'Chart Data' Excel export in
Tools, this exports the chart data displaying and not the complete breakdown.
* New 'Sort By' in the Chart Options to
allow you to sort the chart in value order.
Version 4.2.0.34
* New 'save chart' dialog yes/no box on
on exiting, previously you was just given the list of newly created chart you
wish to keep.
Version 4.2.0.33
* Settings dialog changes, options split
up into more groups.
Version 4.2.0.32
* Chart export/excel folder now defaults
to My DART Saves in the users Documents folder, rather than the common desktop.
* Chart toolbar font type and size
changed.
* Main form is visible/preview in Windows
Vista when minimised or toggling windows via Tab/Windows in Aero.
* Other Windows
Version 4.2.0.31
* In multi user mode the last user login
is now remembered and the password edit box is focused, C/R is also accepted
saving you clicking on the login button.
* Added a DART internal database heath check warning if its not been ran
in the last 90 days, Only displays to DART Administrators.
Version 4.2.0.30
* New
'created by user' field on the saved charts table.
* Read only users were able to save newly
created sub-charts, this has now been disabled.
Version 4.2.0.29
* 'Saved/Users Charts' now shows if the
user does not have permissions to open that chart at the bottom of the form in
multi user mode.
* When
launching DART via DART.SBX it caused an application error exiting if Multi
user mode was enabled.
* DART.SBX - You are now able to pass the
DART user name and this is used to login, no password is need.
Version 4.2.0.28
* Added user table access (multi user mode), you are now able to select
which tables/query users have access too.
* 'Data Display' is now not saved if the user has only read-only
permissions.
* Cosmetic icon changes in settings.
Version 4.2.0.27
* Excel export fix, if you de-selected all
fields in the 'Data Display' then just select some fields, then move the
columns in a different order and export to Excel it got a little confused and
ended up with different fields not matching the field headings.
Version 4.2.0.26
* Email activation email option added in
Settings -> Licenses.
Version 4.2.0.25
* New option to view 'My Charts' sorted
by table/query (data source) in a tree.
Version 4.2.0.24
* CSV importing, reserved database field
name of 'Currency' is automaticlly replaced by 'Currencyx'
* Fix a problem with the Excel export of
'All' data in the 'Data Display' the same row was exported over and over.
* Now checks to see if DART is already
running.
Version 4.2.0.23
* If the group and/or value field is
blank when launching via DART.SBX in
* Change message dialogue box for
re-apply chart changes.
* New evaluation version message box on
start-up.
Version 4.2.0.22
* Long fields in the 'Data Display' now
auto adjust down to a maximum width of 50 characters.
* Fix a problem in 'Data Display' when 2 or
more different charts were open looking at different tables/views it caused a
showhideAll error.
Version 4.2.0.21
* 'Count' now works again with SQL Servers,
we broke the SQL Server query command in the previous version.
* If there was a CSV import error on just
one line you was ask if you wanted to abort for every other line there after.
* Importing from a CSV, the following
characters are removed from the currency field before imported: £,$,€ and
commas. also commas from a numeric field.
Version 4.2.0.20
* Correct method 'Count' this was only
working on the grouped by field and not taking into account the 'value' field.
* Lots of changes to the 'Data Display'
including a new datagrid component.
* 'Data Display' now automatically saves
field and grid selections (save button removed), this is also link to the chart
you opened now and not the data source allowing different data view per chat.
* New 'Data Display' buttons toggling
between all and filtered (selected) data.
*
'Data Display' column positions and sizes for Filtered and ALL records
now work independent.
* Changes to the 'Data Display' check box
panel, clicking on a field takes you to that fields column in the data grid.
* The group by, method and value boxes
when creating a new chart has been re-arranged in a better more meaningful
order.
* Change the Excel export to export
filtered or all data depending on what your viewing at the time.
Version 4.2.0.19
TeeChart components now fully registered,
no more TeeChart trial warning on startup
Pressing [Escape] is the same as clicking
the exit button on the main DART form.
Version 4.2.0.18
CSV import now ignores blank lines,
caused import errors if the CSV file was not in a Windows format with C/R, line
feed.
CSV import now offers you an abort if
there are import/field conversion errors.
After CSV imports the database is
compressed, otherwise it will grow and grow.
Version 4.2.0.17
Added the ability to create and display
charts on the fly based on data from a CSV file passed and called from Madics/
See DART.SBX for more information.
Version 4.2.0.16
Added CSV to DB pre-processing...this
takes a CSV file a long with a .DEF file detailing the field structure of the
CSV and imports the data into a local database, you can then use this data to
display charts within DART.
Version 4.2.0.15
Added direct AMOS pre-processing (random data
files) to DB, this reads in an AMOS file from the server and updates a database
on the local PC or Server.
Version 4.2.0.14
* Legends now scroll.
Version 4.2.0.13
* License changes.
Version 4.2.0.12
* Line chart line make a little thicker
and points added.
Version 4.2.0.11
* Enable right click operations (see
data/new child chart) even when right click scrolling is enabled.
Version 4.2.0.10
* Added Database health check/compress in
settings.
* Change chart and legends right clicks
to only popup if valid data is selected.
Version 4.2.0.9
* Added email chart icon.
Version 4.2.0.8
* New option to list only certain types
of tables, Eg. queries only, Tables only, or both.
* enable beta multi user version. There
are 3 user types, adminstrator, normal user and read only user (read only users
are able to create sub charts to drill down the data, but there are not saved)
* FIx bug where table was blank when
re-editting chart group by or creating child chart.
Version 4.2.0.7
* Added common settings tab, mulit user
check box and DART Database location.
* Added user login under multi user mode.
* DART database changes (inc new user
table). DART db location is now stored in the application settings ini file.
* Fix bug on launching themes and the
default business theme.
Version 4.2.0.6
* Added chart themes
* Remove the chart list radio button and instead make just the selected
active, previously you had to click on the radio button to change the active
chart.
* Zoom in and out for bar and area
charts, use left mouse button dragging down around the area you wish to zoom,
to zoom out do the reverse by dragging mouse up.
* New setting: Allow scrolling for bar
and area charts, use the right mouse button once zoomed in.
* Allow charts order to be changeed by
dragging the charts around in the chart list.
* Added points to the area charts.
* New licence dialogue to allow multi
license to be entered.
* Added 'created by' to 'My Charts' table
list (this is the computer name it was created on).
* Settings INI files Separated into user and application for multi user.
* Show PC's MAC address on the License tab of settings.
* Changes to the licence encryption formula.
* Selecting
'area chart' sections was a section out.
Version 4.2.0.5
* Multi user support allowing the same
chart database to be used across multiple computers.
* New chart the values combo box was not
always populating with the correct field types if you select the count method
straight away.
Version 4.2.0.4
* New checkbox in settings, this allows
multiple charts on the screen at once, to see the data, use the tools and
create sub charts etc you need to select the chart on the charts list before
hand to make it active.
* New tool box icon to allow the chart
group by to be changed.
* Small changes to the Chart Filter
dialogue box, don’t show edit/delete if no filters.
* The new filter 'cancel button was not
letting the user out with out entering valid fields.
Version 4.2.0.3
* Added COUNT grouping.
Version 4.2.0.2
* Chart data grid now titled with the
chart series title.
* Filter types/operators now have a full
description rather than the command. EG.
'Equal to' instead of '='
* Chart titles use the full filter operator
description (see above).
Version 4.2.0.1
Editing/Adding new filters are now done in its own dialogue rather than
editing the data table direct, the parameters are also checked before
exiting/accepting the selection.
Fix a problem where the chart selection/filter
titles were incorrectly getting set when change from chart to chart, it was
remembering the last chart only.
Evaluation version now allows 4 charts
instead of 3, child chart creation also follows this rule.
Version 4.2.0.0
Start of the DART beta release....