ReleaseNotes

ARS Server Database Plugin

0.7.2 - 2019/03/08
- With DI version 8.2 a new test method is required. No functional change.
- For DI version >= 8.2

0.7.0 - 2014/06/16
- Initial version
- For DI version 5.0-8.1

ARS Server Input Plugin

V0.3.0 - 2019/03/08
- Added preview function
- Download attachments / compression
- Inlucde optinal attachment field ID in the file name
- Fixed: Attachment output field name is used if defined
- Fixed: Environment variables in attachment download path supported now

0.2.1 - 2016/02/15
- overrived logged ip

0.2.0 - 2015/07/28
- index of out bound execption when query enum fields with none linear ids. ( new remedy feature since 7.? )
- definied lookup fields were not loaded from the repository or KTL file
- a query chunksize of 5000 is not hard coded anymore
- some minor changes in UI

0.1.0 - 2014/06/22
- initial version

ARS Server Output Plugin

0.9.2 - 2019/03/08
Fixed
- Changed plugin name in annotation. Was twice listed in DI 8.2 step

0.9.1 - 2015/02/13
Fixed
- override preveous IP = true

0.9.0 - 2015/02/13
New feature
- the lookup condition EXTERNAL supports it's input from a stream field now
- logging the final ARS Query in case of an error
- some more informations in the tooltips
- new function in spoon, to assign ARS and stream fields by name
- transform insert/update values:upper,lower,trim,capitalize

Fixed
- NPE if lookup only for the entryID and a fixed value is set
- adapt value was active per default, the setting in the definition has been ignored

0.8.3 - 2015/02/03
Fixed
- NPE im rowlevel logging mode if a value is null
- function: "adapt sting values to the max. size of the arsystem CHAR field (Y/N) switch in the update table", maxSize=0 fields where adapted

V0.8.2 - 2014/07/11
New feature
- support of java.sql.Timestamp and java.sql.Date as ARS DateTime type input
- support of java.sql.Timestamp and java.sql.Date as ARS Date type input
- support of java.sql.Timestamp and java.sql.Date as ARS TimeOfDay type input

V0.8.1 - 2014/06/30
New feature
- support of java.lang.Long as ARS enum type input

V0.8.0 - 2014/06/22
Fixed
- UI: in a new definition, wrong database was preselected, if only one database is definied
- $NULL$ variable in query not translatet correct
- NPE in rowlovel logging mode if load fields was checked + null value
- replace space in outputfield names with underline ( if load fields is checked )
- wrong output columns if load fields was checked in case of attachment or diary NULL values
- properties file was not loaded, moved properties to ${user.home}/.kettle/arsystemplugins.properties
- feedback was not displayed
- step output/update counter were not refreshed

New feature
- new property arsoutput.getarsfields.output.excludefieldids, to exclude IDs in the output tab

Data format:
- Output datatype change (only relevant if load after fields is checked)
- 1. ARS-Datatype:Integer
old: java.lang.Integer
new: java.lang.Long
- 2. ARS-Datatype:Real
old: java.lang.Double
new: java.math.BigDecimal

Others
- changed package name

V0.7.0 - 2014/06/16
- Step validation function extended
- Installation instuctions updated (https://sourceforge.net/p/arsoutputplugin/wiki/Installation/)
- archive splitted into two zip, one for database, one for step, to be ready for the marketplace function
- arapi jar entrys from plugin.xml removed , see installation notes, put the jars into the DI lib directory

Fixed
- empty field names in output, if no fieldname was defined, the ars fieldname is now used in this case
- errorhandling was permanent active

V0.6.0 - 2014/06/13
Fixed
- prozessing time output was not appended is "load fields after updated" was not checked, now its idenpended from this setting
- UI validation, showed missing output fields althrought "load fields after updated" was not checked
- in case of more then one ARSOutput transformations within one step, the AR Server rejected the logging while the steps
has been initialized parallel. No the ars logon phase is syncronized
- incorrect position of processing time/operation in the following combination:
- load fields after update checked
- diary or attachment fields in the output
- ognl passthrough checked, and matched to the row

V0.5.0 - 2014/06/03
New feature
- new checkbox "Use MERGE operation for updates" in others tab, if checked, instead of SET, the MERGE operation is used. see the tooltip

Fixed
- the checkbox bypass updates was without function. If in addition the checkbox, "add operation to output" checked, the value will be "none"
if no insert, update or bypass was executed.

V0.4.0 - 2014/06/01
New feature
UI
- show the datatype of the stream fields in the tables
- changed position of some fields
- validation button, validates the step definition
- shows timestamp/username of the last change (saving)
- new plugin.properties in the step plugin directory, possible to define some default values or exclude ars field ids in the get ars field function
- some more tooltips

Fixed
- After seperation the database plugin, within the connection editor test function is no test possible,
in case of using this function, an note will displayed

V0.3.0 - 2014/05/28
New feature
Step:
- OGNL passTrough expression, if the expression match, to row will be forwarded directly to the output,
without any remedy query. e.g. if a lagre input is compared against a large table
with a merge join, you can pass-trought identical datasets with: flagfield eq 'identical'
so you dont need to split and rejoin the stream. every fieldname in the pass-trought condition with be replaced
with the current value of the row.

V0.2.0 - 2014/05/26
New feature
UI
- extended function for button "AR Types"
- shows ar field option per field in all tables, ( Display Only , System , Required, Optional )
- shows ar field Id per field in all tables
- new button "AR Fields" in update and output table
- loads arfields into the table
- output => download attachments
- if the function is enabled and a attachment field is definied in the output,
the file will be extracted in the definied path, automatic filename prefix is the
ID of the dataset.
- Tab others
- option to append the processing time per row to the output
- option to append the operation per row to the output, to indicate if it was in insert or update
Step
- if a diary field is defined in the output stream, 3 outputfields will be generated,
with following suffix.Timestamp,User,Text
- if a attachment field is defined in the output stream, 4 or 5 outputfields will be generated,
with following suffix. [Name,ValueFileName,OriginalSize,CompressedSize,LocalFileName].
If the download of file is checked as well, the field with prefix LocalFileName shows
the name of the file in filesystem
- long Value and BigDecimal as DateTime Input ( seconds since 1970)

Fixed
- input Long values are hown as zero in remdey, workound: transformation to integer
- wrong month when update/insert ARS date fields
- db plugin didnt work under pan in the steps plugin directory, jar moved to ./plugins/database directory

V0.1.0 - 2014/05/18
New feature
- show ars datatype for lookup fields in the dialog
- NOT LIKE expression for Lookups
- choice to adapt sting values to the max. size of the arsystem CHAR field (Y/N) switch in the update table
- append rows to outputstream when "fail on multiple request match" is disabled, if
more than one item is found while an update operation, for every additional lookup item
an output row will be generated
- protocol the ars field name in the error log and error row stream after an arexception
- datatype mapping optimized
- some changes in the gui
- attachment output to arserver is possible now, filename needed in the inputstream
- if "load ars fields after update" is checked
- all regular fields of a form can be selected ( in v.0.0.1 only max two fields)
- datatype mapping optimized
- attachmant fields will generate filename and size in the outpout stream field, seperated by ";"
- diary fields will generate user, date and context in the outpout stream field, seperated by ";"

Others
- seperate jar for database plugin classess

V0.0.1 - 2014/05/12
- initial Version

ARS Server Delete Plugin

V0.2.0 - 2014/06/22
initial Version