* FIX: ActionWriteExcel was crashing when clicking in the Anatella GUI on the drop-down button of the combobox to list the sheetnames (a work-around was available since the beginning)

* updated the Demos of Actions to use the tempDir

* upgraded python engine to v3.13.1 (and fixed compatibility issues due to the upgrade)

* upgraded R engine to v4.4.2 (and fixed compatibility issues due to the upgrade)

* upgraded Tableau engine to the latest version (and fixed compatibility issues due to the upgrade)

* the loops are now much faster: The loop box now runs “AnatellaConsole.exe” instead of “Anatella.exe” in silent mode (-s)

* added getTempDir(), tempLocation(), getTempDirComments() to the AnatellaGraph JS object

* added many buttons in the UI to open the xls,xlsx,xml,json,csv, files or the file dir

* better UI window to create an ODBC connection based on a connection string

* added ClosestPoint C++ Action

* added a more meaningful error message in SaveShape action for custom used-defined insert queries

* fist version of the Facebook, Snapchat, Tiktok boxes

* ActionSharepoint and ActionSharepointOut now supports URL columns inside LISTs

* UpsertOracle: better NULL handling

* added the “goUp” option inside PropagateDown C++ Action

* added the “skipNulls” option inside the unFlatten C++ Action

* added the “charMode” option inside the C++ WriteXML action

* better error reporting inside the publishToTableauServer JS action

* added “idRemove” option inside the testFileExists JS action

* fixed many compatibility issues with the new R v4.4.2. engine for the boxes: R_Cart_Full, R_HistogramGGP2, R_PieChart, R_ROC, R_PopulationPyramid, R_BoxPlot, R_CrossTable, R_PCA, R_KMeans, R_KMedoid, R_MClust, R_polCA, R_XGBoost, R_NNET2, R_CHaid, R_C50, R_CMA, R_timeSeries, R_Multiplot, R_GLM2, R_RandomForest, R_Confusion, R_PLS_PCR, R_CircularChart, R_ParetorChart, R_autoCorr

* DELETED: R_CRT_Web

* improved the Py_Scatter Python action to make it more usable and robust

* added the Py_readParquet, Py_writeParquet python actions

* added the “wait” option inside the ExcelUpdate Action

* added the updateExcelConnectionString, encryptXLSX, moveDataLake, extractTempDirData JS actions

* improved the IXMLParser

* upgraded TIMiEnterLicenceConsole.exe to support the options: -g,-ga,-e,-r,-c,-m,-o,-p,-s,-sa

* upgraded “TIMi_Downloader.exe” to support the installation of Python

* upgraded the Web interface to manage serials to be more robust against hackers

* upgraded the Web interface to manage serials to allow third party to create their own serials

* new integration with Python 3.13 (first non-dynamic version)

* the downloads of extra Anatella components is now from https://download.timi.eu instead of http://…

* in CreateTable action: added the “GuessSQL” mode

* added the ClickHouse C action (to run select’s on clickhouse)

* in clickHouse boxes: fixed changing the authenMode option

* in readJson action: allowed the “/” char inside field name (in a json dictionnary)

* in splitStratified JS action: added a new operating mode to select a defined number of rows

* fixed the Py_SCATTER Python action to accept columns of the string type that contains numbers

* upgraded setGlobalParameters JS box to new input layout

* FIX: the ‘\0’ at the end of the header was missing when saving encrypted .anatella files

* FIX: many fixes inside readExcelOld

* FIX: listFile2: sort in reverse order now works properly

* FIX: facebook box was crashing when closing

* replace \r and \r with XML character entities when saving .anatella files: This help with an issue when working with github that replaces \n with \n\r in all xml files

* added the “alwaysDelete” option inside writeGel, writeCGel box

* column chooser does not crash when deleting a missing selection

* added createDir option inside computeLift box

* added support for “>” inside readODBC

* added first version of Instagram Connector

* added “authenMode” option inside InsertClickHouse

* added “idDFormat2” option inside addOpenDays JS box

* FIX: DiceJoin action was not working properly when K=1

* FIX: sapReader: no more deadlock when extracting empty table

* upgraded Spatialite to version v5.1.0.

* better performances for GIS operations: upgraded JoinGIS,TesselateGIS Action to use “CreateMbrCache()” instead of “CreateSpatialIndex()”

* added YoutubeAnalytics Action

* added “IJSONRender.cpp”

* upgraded FBConnector Action to latest Facebook API

* upgraded GAds Action to latest Google Ads API

* added first version of upsertClickHouse Action

* FIX: closing the Actions PropagateDown & WriteExcel sometime crashed when no input rows.

* MICROSOFT WINDOWS I/O UPDATE FIX(3/3): FIX: a deleting a (c)gel file before replacing it was producing an unexpected “File is locked” message, followed by an annoying time-out, followed by a success of the operation.

* FIX: readODBC was not working when executing several commands from the input pin

* FIX: some rows were not properly inserted at the end of the UpsertPostgreSQL box in text mode

* added the option “allowKeyOnly” inside MultiJoin action

* added the option “allowEmpty” inside TimeTravel action

* first version of insertClickHouse box (uncomplete)

* FIX “TIMi_Downloader.exe” to use https (instead of http) to download R

* FIX: completion percentage at end of run is now always 100%

* FIX: some arrows were not moved after an undo

* FIX: it’s now possible again to get a data preview on a specific pin when the graph is running

* FIX: undo of “move” action now works properly

* automatically extend the graph canvas when items are moved on the borders

* added nRetryODBC,nRetryOleDB,delayODBC,delayOleDB for ODBC and OleDB connectors

* added better support for utf8 inside ReadODBC action

* added support for bugged ClickHouse ODBC drivers inside ReadODBC action

* added help message on SendEMail action

* added the WriteJob_deleteCustomObjects for HubspotWrite Action

* added outputMode=2 option for Flatten action

* added second input pin for TimeTravel action

* added pgpDecrypt, pgpEncrypt JS Actions

* added decryptXLSX VBA action

* upgraded timeSeries, multiPlot R boxes

* upgraded code that read .anatella files to support character entity with code point>0xFFFF (this is only useful for the WEB interface for Anatella)

.

2024-06-06 / Anatella v3.49 – TIMi v12.29 – Stardust v0.18

.

* FIX: maximum number of output pin was not properly displayed (when number of output pin is set to “variable” in JS action).  ui.spMaxOutPin->setValue(t->nPinOutMax);

* FIX: R&Python boxes now works when nPinIn=0

* FIX: in writeExcel: the cell starting with ‘=’ are not always formula’s anymore

* FIX: s3 credentials are now properly loaded from registry

* added many graph examples for many R nodes

* added libcurl inside TIMi distribution

* deprecated old JS file-related functions

* added the simpleFileOps2 JS actions that uses the new “AnatellaFile” JS object to copy/move/delete/list files

* added the listFile2 Action (to replace the old listFile action)

* extended to 20 items the “recent file list” inside Anatella

* better show deprecated box inside the search bar

* better error reporting for Sharepoint upload

* added the idKeep parameter inside ReadPDF2

* upgraded many R boxes.

* Deprecated HDFS: we won’t support reading/writing to hdfs anymore

* !! first intermediate version of S3 drive support !! (the S3 drives replace the HDFS drives).

* added URL comments inside graph (+undo/redo support for this)

* added DiceJoin C++ Action

* added SanityCheck inside setGlobalParameter

* upgraded dateTimeFormatter to format many date columns (instead of 1)

* added anonymizeSHA256 JS Action

* FIX: allow opening examples for JS/R/Py Actions

* FIX: allow table name with a space inside LoadGeoPackage, SaveShape C++ action

* FIX: made the geopackage more compatible (with external tools) inside the SaveShape C++ action

* FIX: python/r actions were crashing with an empty table on second input pin

* FIX: inMeMoryJoin was not working when joining a subset of columns

* FIX: upgraded R/Python “empty/default” template to support no table in input

* added the option to save a GeoPkg inside the saveShape box

* added the LoadGeoPkg box

* FIX: the salesForceIn,salesForceOut boxes are now working properly again

* FIX: there were some errors inside the interface of the GAds box

* FIX the button to “download&install Hyper librairies” now works again

* FIX: in the JS/R/Python action the “manyfilesopen” parameter now supports listing a specific file extension

* FIX: applyModel R action was not working when there were special chars in column’s name

* FIX in daVinci JS box (openai did a breaking change in the API).

* FIX in ActionConcaveHull, ActionConvertGIS, ActionLoadShape, ActionReprojectGIS, ActionShapeInfo, ActionTesselateGIS: use “CastToMulti()” instead of “CastToMultiPolygon()” to allow to support points,lines,etc.

* updated the C SDK to Anatella v3.30

* add the “force2D” option inside ActionConvertGIS box

* inside the createTable box, the columns larger than 1000 chars are now of the “varchar(max)” type.

* added the “blobMode” option inside the ActionReadSQLite box

* added the “tableName” option inside the ActionSaveShape box

* added support for very long columns inside the upsertODBC box (when the size of one cell multiplied by the batch size is above 2GB).

* added the “name” option inside the ActionWebServer box

* added the shortestPath box

* added the FindConnectedGroups C box

* added the “undirected” and “ignoreErrors” options inside the ActionInfection box + refactor the whole code to make it work better

* added the “slope”, “outputOriginalVar”, “timeWindowNoTarget” options inside the timeAggregate box

* upgraded the readExcel box to read special excel files not generated by Excel (without “r” tags)

* upgraded the readExcelSheet box to read special excel files not generated by Excel (with namespaces inside the tag’s names)

* upgraded the writeExcel box to better handle file error situations (when it’s impossible to rename files)

* added the “humanReadable”, “indentStart” options inside the writeXML action

* allow empty input tables inside the collate JS action

* added the “idV” (Version of the Tableau Rest API) option inside the publishToTableauServer JS action

* added the “0” or “negative” support for the idxPages option inside the readPDF2 R action

* inside the downloadAndUpload, multipleDownloadAndUpload box, curl now follows redirections

* added the password option inside the zipfiles2 JS box.

* better error reporting in the R_HistogramGGP2 R box when 2 labels are the same

* FIX: powerBI action is improved to be easier to use.

* FIX: saving 10 backup graph files was not working anymore

* FIX: S3UploadFile: the filename was not always properly computed

* FIX: inside ReadSquare action: the “Z” type (to read Kobol files) was not always handled properly

* FIX: the loopAnatellaGraphAdv2 JS action was not properly taking into account the “idSilent” action

* FIX: “_n<100” inside filterRows action was only working to select less than 2e9 rows.

* FIX: better handling of “append” mode in writeCSV

* FIX: set nPinIn=1 for runSelectedPin action in C++

* added JSonViewer inside Anatella distribution

* upgraded branding inside installer wizard

* added option “countKey” inside Aggregate action

* upgraded the JS loadFile to always handle a third parameter (maximum number of bytes to load)

* 1st attempt to improve logging (some log rows are still disappearing).

* added second input pin on Sort Action

* separates Jenkins settings between 32bit and 64bit anatella

* renamed “ovh” JS actions to “ost” JS actions (open stack)

* upgraded saveGIS action to handle .geopkg files

* upgraded GoogleAds,GoogleAnalytics actions to support new google API’s

* upgraded powerBI action to handle Date hierarchies and to handle DAX expressions

* upgraded sharepoint Action to name the column of a LIST based on the “displayName” (instead of the columnName”)

* upgraded sharepointOut Action to run with less privileges and added “empty list” mode

* upgraded the PHP code that handles Azure requests to be more resilient against WebHackers

* added the readCobol action inside Anatella 32 bit

* upgraded the insertKey action to make it faster

* added a second input pin to the NaiveDeduplicate action

* added a first version of the timeAggregate action

* upgraded readExcel action to handle exotic files not created with Excel.

* added “idxPages” option to the ReadPDF2 R action

* upgraded the wordCloud JS action to output the “Len” column

* various FIXES inside: extractDataFlow,extractSurroundingLines JS actions

* various FIXES inside: R_HistogramGGP2, R_AggAndHistoGGP, R_ApplyModel2, R_Scatter, R_PieChart, R_BoxPlot, R_CorrMatrix2, R_CrossTable, R_PCA, R_HIERARCHICAL, R_KMEANS, R_KMEDOID, R_poLCA, R_XGBoost, R_NNET2, R_BayesNet, R_SVMe1071, R_CHAID,  R_C50, R_MCA, R_MultiDimensionalScaling, R_CloudOfWords, R_Multiplot, R_GLM2, R_GLMTREE, R_Waterfall_Chart, R_CoxModel, R_RandomForest2, R_Confusion, R_PLS_PCR actions

* upgraded R_HistogramGGP2 to support partitions

* upgraded the AzureUnlock action to work with less permissions

* upgraded oneDriveListFiles, oneDriveDownloadFiles, oneDriveUploadFiles to support files with accents

* added doWebServiceBrige JS action

* MICROSOFT WINDOWS I/O UPDATE FIX(1/3): upgraded the file access code to always use “no caching” so that it’s always possible to open a file just after writing it on the SSD.

* added the “Allow Command Line” option inside the Serial system

* FIX an error inside writeColumnarGel

* FIX an error inside Jenkins Wizard (“run weekly” was not working properly)

* FIX racing condition inside readStat box

* FIX: writeSAS: always terminate&close file properly

* FIX many small errors inside AzureAddContact, sharepointList, SharepointUpload

* FIX inside hubspotWrite box: tab \t chars are not allowed inside hubspot: replace them with space

* added the “transient” property to GP

* make sure that the “transient” GP are not visible inside the logs (on the command-line when running a new Anatella process)

* added support for Transient and Encrypted GP inside the getParametersFromFile box

* added support for transient GP inside setGlobalParameter, loopAnatellaGraph2, loopAnatellaGraphAdv2 JS action

* added contextual help examples for the JOIN box

* added dynamic HELP Menu with lessons on Data preparation

* added TIMiWebProxy.php

* allow to use a GP to define the separator inside readCSV & writeCSV box.

* added the C++ action “runSelectedPin” (converted from JS)

* added the possibility to search for text/columns inside the boxes (with the search bar+F2+F3)

* make the resizing of PNG inside the graph smoother

* added the “SQLInit” and “SQLClose” parameters inside upsertODBC box

* upgraded the Encrypt box to allow to encrypt a subset of the rows

* added many images on Sharepoint boxes

* added the “mode” option inside ActionOCI (to support dynamic SQL from pin 0)

* un-deprecated all Huawei OBS storage box

* added moveDataLake JS action

* added the “dist2(lat1Lon1,lat2Lon2)” function inside the calculator box

* FIX: error in readOCI box when extracting very long strings.

* FIX: MS-dynamics CRM is now working for extracting data (injecting data into azure still needs more works)

* FIX: small errors in various R boxes: R_ApplyModel2, R_Multiplot

* FIX: the network license was not working properly anymore on old Linux distributions

* FIX: the sound theme is now working again

* improved the security of all Azure boxes now allow to use “Azure Client Secrets”

* changed the default formatting of FLOAT type inside the data previous to %.16g (instead of %g).

* changed the default view of the RowCounter box to “extended”

* Anatella: added the possibility to change the background logo in the main windows (useful for partner’s branding)

* added a new help system inside the main menus to enable direct access to training sessions on youtube

* added the link to the first training session inside the help menu

* updated the JS AnatellaGraph class (for reflection) to include the latest changes in the Anatella I/O capabilities

* added the “allowNullInput” option inside the inLineSort, Sort, MergeSort, megreSortInput actions

* added the “bufferSize” option in the writeCSV box

* allow editing the cells inside the parallelRun box (with a middle-mouse click)

* added more font size for the comments inside the graphs

* added more comment-box colors inside the graphs

* added the possibility to download form data and contact history data from Hubspot (in the HubspotRead box)

* added the possibility to upload form data  to Hubspot (in the HubspotWrite box)

* First draft of the SalesForce boxes (need re-works)

* in readExcel,writeExcel: added the “excelHack” option to improve compatibility when excel dates for the TimePeriod between 1900 and 1901.

* FIX: fixed bug in upsertOleDB,upsertPostGre in “update” when there are multiple keys

* added hidden functionality: kill all Child processes when the main process is killed (using “JobObject”).

* added the option “charsetUTF16WithBOM” inside writeCSV

* added the possibility to right-click a box and get examples about the box

* added the possibility to drop PNG files inside the graph for commenting purposes

* added AzureAddContact Action

* automatically renew/extend Azure tokens every 8 days.

* added the option “newMode”, “extractDates”, “numIsFloat” inside ActionOCI

* added the upsertOracle Action

* miniAudit: now displays all modalities, always.

* FIX: always delete “SortTape*” files

* FIX: sendMail: was returning a timeout-error for large emails

* FIX: sharepointDownload now always download files

* FIX: writeJSON was crashing when using “JSONItemType_OnePreformated” item before a sub_level

* add support for “>” inside calculator and calculatorVectorized actions

* add support to export formsData from Hubspot

* FIX: the new SlowlyChangingDimension box is now working properly

* FIX: for security reasons, actionSaveShape was not able to save geometries as .shp files (saving as .html file was ok). It was still possible to bypass the error by defining the proper DOS environmental variables but this is a much better fix.

* FIX: inside OutlookGet, it’s now possible to properly select any email PROFILE from Anatella

* FIX: inside OutlookGet, synchronization procedure is now waiting up to the end of sync before going further

* FIX: AZURE authentication: for all AZURE boxes (AzureAccess, sharepoint, getMailOffice, sendMailOffice, PowerBI, OneDrive, DynamicsCRM): Switch to a better authentication mechanism using “Azure Anatella Secret”

* FIX: Join action: you can now close the A (master) table at the end of the inner join (when the option “always close” is checked)

* FIX: saving .anatella files now works better on very slow (network) drives (no more warning about “your file has changed”)

* allow to simply click the output pin of the writeGEL to run the graph (instead of a right-click + run)

* added the “NoAutoAnatella” option inside TIMi Cloud

* added the Directory path for the GlobalLock mechanism inside Anatella interface

* added the Transient flag for Global Parameters

* added DropBoxListFiles, DropBoxDownloadFile, DropBoxUploadFile, DropBoxDeleteFile JS actions

* added the manualSQL option inside the upsertODBC action

* added option to listFiles, downloadFiles in Sharepoint Action

* added option to uploadFiles in SharepointOut Action

* added “hwid” variable inside Python (i.e. hardwareID is now accessible inside Python)

* added “hwid” variable inside R (i.e. hardwareID is now accessible inside R)

* added the option addColBefore inside ActionReadXML action

* added the option to have HTML output inside the following R actions: R_HistogramGGP2, R_Scatter, R_AggAndHistoGGP, R_BoxPlot, R_CorrMatrix2 actions, R_KMEANS, R_KMEDOID, R_XGBoost, R_MCA, R_Multiplot, R_GLM2, R_GLMTREE, R_RandomForest2, R_Confusion, R_PLS_PCR

* added the N option inside the daVinci JS Action

* added the serverLock JS Action

* added the ReadPickle and WritePickle Python actions

* FIX: there were some missing files while listing the root directory using the GoogleDriveListFiles action

* FIX: the GDriveDownload action is more robust (do not attempt to download directories)

* FIX: now allow accents in filenames in S3ListFilesInBucket, S3DownloadFile, S3UploadFile, S3DeleteFile, S3ListBucket

* added the “trim” paramater in the GetParametersFromFile action.

* added azureUnlock, phantomBuster, dropcontact, bouncer, davinci boxes

* added speed throttling on HubSpot boxes.

* updated azure authentication system for the getMailOffice, sendMailOffice, powerBI, SharepointDownload, SharepointUpload, OneDriveListFiles, OneDriveDownloadFiles, OneDriveUploadFiles, OneDriveDeleteFiles actions

* in StringReplace action: improved “toTitleCase()”

* added ignoreErrors and permissiveNumbers options inside the readJSON action

* allow empty input table for setGlobalParameters action

* allow accents in filenames in R_ReadPDF2

* added the functions round2(x,d), roundUp(x,d), roundDown(x,d), mid(x,b,l) inside the calculator box.

* FIX: intervalJoin inside the mode point-interval was sometime crashing

* FIX: undo/redo was incorrect when attaching a comment to a box

* FIX: inside the ReadExcel and the ReadExcelOld box, the name of the input column containing the filename to read is not lost anymore when reopening the .anatella file

* FIX: upsertODBC and upsertOleDB were not working when the TableName required a dot.

* FIX: the “GenBenchmarkData” c++ box now also works inside AnatellaConsole

* FIX: the readJSON box does not abort on empty input file

* FIX: inside the FindConnectedGroups JS box: there was an error when the option “isNumberNodes” was false

* FIX: many fixes inside the R_timeSeries, R_GLM2 box

* FIX: prevent the GDriveDownload box to download files that cannot be downloaded

* FIX: NominatimGeocode JS box: is not crashing anymore on \\ and \” chars

* FIX: the calculator box was crashing on invalid expressions such as “1 && ?1:0”

* FIX: RedshiftBulkUpload was not working anymore

* FIX: initTIMiWeb: added \n to prevent Anatella crash

* FIX: useE option inside writeCSV did not always write E instead of e

* added “trim” option inside GetParametersFromFile c++ Action

* added formatting option to display FLOAT inside data preview

* added check to detect if the file really changed in disk (check if SHA256 of the content changed)

* inside the Anatella search bar, it’s now possible to enter numbers to zoom-it on the matching box

* now downloads WinMerge and WhoIs from https://timi.global.ssl.fastly.net/ThirdParty

* Send F13 key every 30 sec while running to prevent computer to switch to “Power Saver” mode

* added “Search on Community forums” inside the search box

* added CTRL+C and paste on the “Global Parameters” table

* allowed to easily edit the OleDB connection string

* limit the createTable box to the “AllRows_ApplySQL” mode

* added the filter and samplingLevel option inside the GoogleAnalytics box

* added a first version of the HubSpotRead and HubSpotWrite box.

* added “AutoDate” option inside ReadExcel box

* added the option “boolIsSpecial” inside the writeJSON box

* added inside the publishToTableauServer a new authentification mode (Personnal Access Token-PAT)

* added inside the publishToTableauServer support for https or http URL

* added the versionPlusPlus and the addOpenDays JS box.

* inside the shiftColumns JS box: allow to shift columns “outside” the row

* added inside logarithm JS box a mode to compute exponential (instead of log)

* added support for wide columns inside TIMiAudit box

* added the option “idCloseExcel” inside the excelPdfExportation JS box

* added many options inside the DeepL JS box

* added the possibility to read the internal content of .xlsx files with the readXML box.

* EnterLicence: now request new serials using HTTPS

* TIMi_Downloader: display warning message when reducing install size

* added undo/redo functionality

* FIX: abortIfMissing option in ReadGel and ReadCGel was stopping when no rows with filenames in input

* added “isSelect” option inside OracleOCI action

* cleaning: removed all image resources from AnatellaConsole

* FIX: the .anatella File Watcher now works properly. This means that you can edit your .anatella with notepad and, just after, go back to Anatella and see the changes made in notepad.

* the Jenkins wizard now supports encrypted Anatella files.

* added the BingIsochrone JS action

* added better error support inside GIS actions

* added the “mustCreate” option inside PowerBI Action

* added the readExcelOld C++ action

* added support for old .xls files inside readExcelSheets

* upgraded TIMi_Downloader to use HTTPS and multi-file downloads across different directories

* updated doc with new GIS section (5.10)

* FIX: fixed initTIMiWeb to make “top most” the 2 required windows

* Added plenty of GIS C++ actions: ConcaveHull, ConvertGIS, ExpandGIS, reprojectGIS, SimplifyGIS, tesselateGIS, ShapeInfo

* re-do and added ShapeInfo C++ Action

* FIX: ActionGeocode was not working anymore with new SSL/HTTPS

* FIX: R_ReadPDF2 should now be able to read PDF files with accentuated chars

* upgraded icon for KNN action

* created the category “GIS”

* added the option “TableMode_truncateCreate” in writeSQLite action

* improved support for qlikDateFormat in writeQVX action

* added option “idOut” in createGISGrid JS action

* added the possibility to sign Anatella files

* added the SaveShape Action (for GIS)

* first version of “initTIMiWeb.exe”

* removed the 32bit install from the NSIS installation Wizard

* removed/disabled special code for big memory allocations

* added some security checks in ActionSharePointOut

* added some security checks in ActionAppend

* ActionAppend now support different columns with same names

* added support for invalid dates inside ActionWriteHyper

* added support for Dates (in addition to Date-time) inside ActionWriteQVX

* added the “runExcel” option inside ActionWriteExcel

* added second input pin in AutoUnFlatten JS action

* added whileLoop,excelUpdate JS actions

* added uninstall option “u” inside “TIMiFileAssociation.exe”

* FIX: adding a job in Jenkins with a name containing non-latin1 char was failing

* FIX: in the GetInfoOnIP Action, the “whois” tool was not properly downloaded

* FIX: in SharepointOut Action, was crashing if ” or \ inside the data to upload

* FIX: all mailbox.org JS actions were re-done.

* included libs=’MathParser’ inside AnatellaCore.dll

* added support for a “licence.xml” file that contains the standard NAME and SERIAL for the licensing system (also upgraded the “TIMiEnterLicence.exe” and “TIMiEnterLicenceConsole.exe” tools to support this).

* allow to have the passwords “in clear” (not encrypted) everywhere inside the .anatella file

* removed IrfanView and putty from the installation

* added the SQL Wizard metadata configuration file inside SVN

* added web Extensions (to have “download” buttons inside the interface)

* added the option “output-meta-type” when converting to ET inside the changeDataType action

* disable zoom on input pin when input pin is already connected

* ODBC configuration screens: better parsing of the ODBC connection string (for the editor)

* added the R_CrossTable action

* added the work-around to be able to INSERT inside ACCESS using OleDB.

* added abort condition in % inside the Abort action

* added the option “alwaysOutputAvg” inside the SmoothenRows action

* added the button “Add multiple sets” inside the UnFlatten action

* added the options “emptyFile” and “Time” exportation inside the WriteQVX action

* added the options “readFormulas”, “abortIfMissing”, “readTimeOut”, “colFileName”, “colSheet” inside the readExcel action

* added the options “abortIfMissing”, “readTimeOut” inside the readJSON action

* added the options “abortIfMissing”, “readTimeOut” inside the readXML action

* added the options “bEqualisFormula”, “ToFormula” inside the writeExcel action

* upgraded many JS actions (shiftColumns, multipleDownAndUpLoad, testFileExists, upgradeToXLSX, downgradeToXLS, listFilesInZip, wordExportation, excelPdfExportation, pptxPdfExportation) to support empty input tables.

* added the mode “create dir” inside simpleFileOp JS action

* improved my R actions: R_ApplyModel2,R_HistogramGGP2,R_XGBoost,R_NNET2,R_CHAID,R_timeSeries,R_GLM2,R_GLMTREE,R_PLS_PCR

* added the functions “toETF()”,”dateEOM()”,”dateEOQ()” inside the Calculator action

* inside the “DataPreview”, double-click a cell inside a column named “filepath”,”url” or “graph” and it opens a new process to edit the file named inside the cell.

* added the option “createLog” inside the “TIMi_Downloader.exe” tool

* FIX: the ProcessRunner JS class does not attempt to read the input stream from the executed processes. This caused havoc under Linux in Wine.

* FIX: the downAndUpload action now support remote files with accentuated chars and spaces.

* FIX: the extractDataFlow JS action does not put garbage anymore inside the Global Parameters

* FIX: the upsertPostgre action now handles correctly the upsertDBBinary mode when there is a composite primary key

* FIX: the writeDocTable action can now write the & chars inside the .docx file

* FIX: readSquare

* FIX: AnatellaServer was sometime opening the same file in 2 different windows.

* FIX: resetting file associations for “AnatellaServer.exe” or “TIMiServer.exe” is now also ok (before it was only ok for “Anatella.exe”).

* FIX: in writeQVX action: prevent to write ‘\0’ chars inside the qvx file.

* FIX: php web request new serial was registering brazil instead of Belgium.

* added the SignatureCypto C++ Action

* upgraded the sendEMail action to support accentuated chars in “email subject” and to better handle error reporting.

* upgraded the wordExportation JS action to handle the “blocking” situation (when exporting .docx files with external links) and to add a new export mode (high quality PDF)

* upgraded the TIPS to add a link to the FRENCH tutorials

* upgraded the writeSQLite Action to allow a dynamic table name

* added links to download the “spatialite lib” inside the joinGIS,loadShape action

* upgraded the OracleOci action to encrypt the saved password (inside the XML file) and to trim all extracted data.

* fixed the default RegExp inside the RegularExpressionTest action to detect valid emails.

* added support for DUAL types inside the writeQVX action.

* added the “discardNameSpaces” option inside the readXML action

* added the “nrIncludeTitleRow” option inside the writeExcel action

* added the “alwaysWrite” option inside the writeJSON action

* upgraded the ReadExcel,writeExcel interface to list all sheet names

* cleaned the display of the prefix&suffix inside the writeJSON,writeXML action interface

* New R_ApplyModel2 action

* upgraded the R_AggAndHistoGGP, BoxPlot, SVM_1071, CHAID, C50, timeSeries, GLM2, GLMTree, RandomForest, Spline, PLS_PCR R actions

* upgraded the excelPDFExportation JS action to allow to select the sheets to export

* added the squareSplit and distanceBetweenPoints JS Actions

* upgraded the readXML action to allow to read HTML files that have tag-attributes without value

* FIX: made the empty string and the NULL string different inside ActionConfusionMatrix, ActionDiscretizeBin, ActionFlatten, ActionIntervalJoin, ActionMultiJoin, ActionReplaceString

* FIX: R_histogramGGP2 now correctly supports NULL values

* FIX: metadata display mode in AnatellaConsole is now in utf8

* FIX: R_ReadPDF is now R_ReadPDF2 and is fixed

* added the “advancedNaming” option inside writeCSV

* added the initScript option inside JenkinsWizard

* added many options inside R_Multiplot

* added a second input pin inside ActionEncrypt

* added zohoUnlock, zohoDownload JS actions

* added support for “QVX_QV_DUAL” data type inside ReadQVX action

* added splitOnVar option inside writeQVX

* FIX: readODBC is now compatible with snowFlake

* added new “Data Engineering” category

* new SlowlyChangindDimension, redshiftBulkUpload, snowflakeAzureBulkUpload, snowflakeS3BulkUpload Actions in the new “Data Engineering” category

* FIX: in stardust, the “distribution window” now always shows some variables

* new “AnatellaDataPreview.exe” tool

* added “nRows” option inside readGel

* added better error reporting in JoinGIS

* added the “NOT_FOUND” status inside upsertODBC

* added the “ignoreReadOnlyFlag” inside upsertOleDB

* added the Google Ads Action

* added JenkinsListJobs, JenkinsListBuilds, suiteCRMDownload, suiteCRMUpload, suiteCRMDelete, supermetricsRawDownload, surveyMonkeyListSurvey, surveyMonkeyDownloadResponses JS Actions.

* FIX: conversion of surrogate chars from UTF8 to UTF16

* FIX: teradataWriter: the password is now properly saved

* FIX: writeCSV: append mode is now working again

* FIX: scatterPlot

* added better error reporting when Anatella cannot load an Action because the action is created with a more recent version of Anatella.

* added upsertPostgre C++ action

* upgraded the loopAnatallaGraph, loopAnatallaGraphAdv action to support new verbosity levels

* added jenkinsListJobs, JenkinsListBuilds, suiteCRMDownload, suiteCRMUpload, suiteCRMDelete, supermetricsRawDownload, printLog JS actions

* added R_timeSeries and convertTimeZones R actions

* upgraded the R engine to v3.6.3 (instead of v3.5.2)

* upgraded the “TIMi_Downloader.exe” to make it possible to upgrade the R engine.

* added “_tempDir”, “_currentFile” constants inside the calculator/rowFilter actions

* upgraded the .yxmd converter to handle box with R codePostGre

* added the option “always1Row” in the aggregate Action

* display graph: avoid checking if a .gel file exists when the .gel file is on a network drive (path starts with \\)

* added the CATEGORIES inside the tooltip in the output of the search box

* improved actionJoinGIS to handle ‘POLYGON’ geometries (in addition to ‘MULTIPOLYGON’ geometries)

* “AnatellaDataPreview.exe”: output is always in utf8

* MathParserVectorized action: allow non-vectorized computations

* readHyper Action: now allows a free-form SQL command

* added the “mergeByName” option in the readExcel action

* added the “overwrite” option inside the simpleFileOps action

* upgraded the R_Multiplot action

* added dynamic mode to CalculatorVectorized

* added verbosity level 2 to Run Anatella Graph (to see the logs of subgraphs)

* FIX: automatically download language pack for Tesseract ocr

* FIX: readSquare was not re-starting properly after a run

* FIX: progress bar of the Sort action

* FIX: GMailGet action: the “mark as read” option was not working

* FIX: allow utf-8 as default encoding of empty .anatella files

* FIX: “group by” mode in SQL Wizard

* added “minDist” option in actionKNN

* added CTRL+F to search inside Anatella

* added pptxPdfExportation,ovhSendSMS,ovhQuerySMS,Neo4j,jiraList,jiraQueryIssues JS action

* added convertTimeZones R action

* added dynamic mode to ActionQuantile

* added dynamic mode to PropagateDown (removed support for N-Way-Multi-Threading)

* added support for composite key in actionWriteSQLite

* added mongoDB support (read&write)

* added the “newNames” option inside Unflatten Action

* added button to open “https://regex101.com” from RegExp and ReplaceString Actions

* added support for .pptx file inside writeDoc action.

* added the image option inside writeDoc.

* upgraded R_CART_Full, R_Scatter, R_ROC, R_XGBoost, R_NNET2, R_C50, R_MCA, R_GLM2, R_Waterfall_Chart, R_RandomForest2, R_Spline, R_PLS_PCR,  R actions

* upgraded loopJenkins to support new Jenkins v2.226.0

* upgraded Anatella sdk to v2.43

* FIX: intervalJoin: the intervals are now always [a b[ (instead of sometime [a b])

* AnatellaConsole: retrieve Script code from template when no script code is given

* new spatialite GIS system that supports “CreateSpatialIndex()”

* added ActionJoinGIS C++ Action

* added LoadShape C++ Action

* added preliminary version of the Discretize C++ Action

* Integrate Jenkins directly inside Anatella

* added the option “getTagPresenceFlag” inside the readXML action

* added the option to append data inside a .xlsx file

* version v0.03 of the .yxmd to .anatella converter

* ProcessRunner: avoid any retry when Modeler exit code is 13 or 244

* ActionReadCSV: avoids closing&re-opening zip files

* FIX: readGel actions were not always closed&freed properly

* ODBC connection setup: added a comboBox with all named DSN

* QSearchbox: added a counter

* FIX: readSQLite action: added support for the new spatialite

* added support for Latin1 encoding inside ReadAlteryx action

* added ActionCRC C++ action

* added a new alternativeNaming option inside the Flatten Action

* added a new mode in the unflatten action that expects only 1 column on input pin 1

* added support for empty input table for the simpleFileOps JS action

* added new runProcess, countEmoji, NominatimGeocode, NominatimReverseGeocode, ElasticSearchDownload, ElasticSearchUpload, ElasticSearchDelete, ElasticSearchListIndexes, MailBoxListFiles, mailboxDownload, mailboxUpload, mailboxDelete, splunkDownload,splunkUpload JS actions

* added sentimentAnalysis Python action

* improved R_Scatter, R_PieChart

* added a “SQL Wizard” that works with MSSQLServer,Oracle,Postgre,SQLite,MySQL/MariaDB

* FIX: now always properly close HDCache file at the end of the run

* FIX: in memoryJoin action: execution in “meta-data mode” was crashing

* FIX: readSQLite conversion to double

* FIX: in createTable action, the selection of the OleDB/ODBC connection now always works properly

* FIX: added support for “shortCuts” inside GDrive

* FIX: added support for “infinity” (instead of “inf”) inside readJSON action

* FIX: improper command-line-parameter handling inside the TIMiEnterLicence tool

* added converter to convert .yxmd files to .anatella files

* added GmailSend,GMailGet C++ actions

* added ListFiles C++ Action

* added ReadExcelSheet C++ action

* added the writeSAS_XPT C++ action for cdisc

* added the “namedRange” option inside the WriteExcel action

* added the “cleanTemp.anatella” file inside the AnatellaDemo dir for distribution (deprecated the deleteGelFile JS Action)

* added unidecode C++ Action

* improved speed of columnRename action

* added support for GlobalParameter in ActionSplit

* upgraded the R actions: AggAndHistoGGP, extractRegExpPosition, ApplyModel, NNET, SOM, GLM, RandomForest, CorrMatrix2

* added the .rtf option inside the wordExportation JS action

* added the “haversineDistance()” function inside the calculator action

* deprecated the ListFiles JS Action

* FIX: correctSpelling Action: multiple passes are now ok.

* FIX: TIMi Modeler: the drift report sometime showed a small drift where there was actually no drift at all

* FIX: apply Stardust segmentation Models with modal centers was crashing

* Stardust FIX: when loading a SegXML file: the 1 var window now correctly sets the var.

* added centralized windows inside UI for OleDB

* added the UpsertOleDB Action

* added the ReadOleDB2 Action

* added the option “oleJob_fromPinAndCopyInputStatus” inside ReadOleDB & ReadOleDB2 actions

* added support for OleDB inside CreateTable action

* changed the old ReadOleDB Action to deprecated

* changed “GlobalLock” to be a server-wide parameter

* updated the Anatella SDK (and the scripts that creates the SDK)

* added ToolTips inside Anatella

* refactor the code of DynamicsCRM get/send actions

* added Linkedin actions

* scripting action: attempt to load SVG if PNG is missing

* TIMi_downloader: checks that the new “TIMi_downloader” is downloaded ok before switching to it.

* webform to request licenses: add data privacy terms

* FIX: opening filenames with accent created on a mac now always works

* added the ReadAlteryx action to read .yxdb files

* added the code to display “tips of the day”

* added 12 “tips of the day”

* added the option “memMin” inside readODBC action

* added the option “timeOut” inside readColumnarGel,writeColumnarGel action

* added the option “CrossProduct” inside the join action

* added the first version of MS-DynamicsCRM actions

* instantaneous display of tooltips inside the palette of actions.

* FIX: readExcel: all dates columns are now always converted to dates

* FIX: in readODBC action: support for nvarchar(max) column type

* FIX the searchBox for high-dpi screens

* FIX: writeDocTable action: almost nothing was working in the first version

* FIX: included “TIMi_Downloader.exe” inside “TIMiSetupFull.exe”

* data preview window is now almost unlimited (limited to 2 billion rows)

* upgraded application icons

* upgraded plus/minus icons

* changed many png icons to svg

* added rounded borders to actions inside the graph

* added meta-data (input, output, cloud, file, etc.) in all actions

* upgraded the AnatellaGraph Javascript class to handle all new actions.

  This means that the “ExtractDataFlow” JS action now works properly on all new actions.

* add a 5 pixel space between all icons inside the palette of actions

* hide the little R,JS,Py logo in the bottom-left corner of the box when the box icon is not defined.

* removed the StatusBar from the gui

* added UIPathList,UIPathRun,downgradetoXLS,sshRun JS actions

* added OdooRead, OdooWrite, getMailOffice,sendMailOffice C actions

* added the option “allowCustomDir” inside ExportToKibella action

* added the option “memFactor” inside readODBC action

* added the option “startRow” inside writeExcel action

* FIX: inline table had rows of different sizes?

* FIX: R,Python action: now supports tables with columns with empty names

* FIX: propagateDown action: loose pointer fixed

* FIX: readExcel: non-date column declared as date was bugged

* New fully automated installer/updater!!

* re-designed the “Enter Licence Wizard” displayed at the first run

* new SVG icons for the most important actions

* new search bar to search for boxes

* “about us” windows updated for high-dpi screens in Anatella

* added “snap to grid” option

* added fixed-width font option

* added display actionID option

* added support to read BLOB inside readODBC action

* added “always Close B” option inside Join action

* various fixes inside timeAggregate, writeDocWithTable action

* added writeHyper and readHyper actions

* set deprecated flag on the old writeTableau action

* added splitStratified JS action

* registration: added a Default Registration Name

* added “atob642()” and “b64toa2()” inside calculator box

* FIX: minimumAnatellaVersionNumber option is now properly initialized for scripts

* FIX: font size was changing inside the graph when the DPI changed.

* added the writeDocTable action

* new SVG support for JS,R,Py actions

* new search bar for keywords to find Actions

* decoration icons in the graphs are in now in SVG

* added soft shadows underneath all actions in the graph

* make the context-menu in the graph with a round-shape all the time

* added tooltips to the context-menu in the graph

* added keywords for all Actions (C++,JS,R,Py)

* added R Spline regression action

* switched to SVG icons for most R actions

* Anatella is now “Per-monitor DPI aware”

* initial support for SVG icons

* new boxes with shadows and multiple shapes&colors.

* added PropagateDown C++ action

* added R_SplineReg, R_RandomForest R actions

* added HuaweiOBS,bingMapGeocode,bingMapRoutes,Twitter,DeepL,TextRazor,Unicheck,  JavaScript actions

* added GDriveUpload and GDriveDelete JS actions

* upgraded the indexing system of JS/R/Py actions to have a 4-digit index (instead of 3)

* upgraded the TIMiBinaryArray JS class: added constructor and append

* preliminary support for scriptFileNames with 4 digits prefix (instead of 3)

* FIX: revision number is now always increased when commit&replace a script.

* added b64Encode,b64Decode JS functions

* added support for RAW data-type in OracleOCI action

* upgraded R_CART_Full, R_AggAndHistoGGP, R_ROC, R_CorrMatrix2, R_KMEANS, R_KMEDOID, R_MCLUST, R_SOM, R_MultiDimensionalScaling, R_GLM, R_CRT_Web.

* added JS Actions: AzureStorageListFile, AzureStorageDownloadFile, AzureStorageUploadFile, AzureStorageDeleteFile, AzureStorageListContainers, OneDriveListFiles, OneDriveDownloadFiles, OneDriveUploadFiles, OneDriveDeleteFiles

* Added: Anatella SQL Logs option (to save all SQL operations in a protected repository)

* FIX: in changeDataType action: strict conversion defined in input pin are now ok

* added PowerBI, SharePointDownload, SharePointUpload actions

* added Date and DateTime support in WriteQVX action

* added damagedFileAction=3 option inside readCSV action

* added top1,top2 options inside upsertODBC action

* many R actions improved: R_MAH, R_CART_Full, R_HistogramGGP2, R_Scatter, R_PieChart, R_PopulationPyramid, R_BoxPlot, R_CorrMatrix2, R_PCA, R_SOM, R_MCA, R_CRT_Web, R_ApplyModel, R_AggAndHistoGGP, R_ROC, R_HIERARCHICAL, R_KMEANS, R_KMEDOID, R_MCLUST, R_DBSCAN, R_XGBoost, R_NNET, R_SVMe1071, R_CHAID, R_C50, R_GLM, R_ApplyXGBOOST, R_CoxModel, R_CRT_Web

* added sha256 JS Action

* added R_Confusion R Action

* logos upgraded

* added negative option in meta-data in ActionR and actionPython for the oneColumn datatype

* added the appendFile() JS method

* added the encoding=5 inside the runImmediateExtended JS function

* added the computeAzureHMAC JS function

* added the “setEnglish()” JS method of the DateTool JS class

* recoded the Accumulate action in C

* added replaceLF option in WriteJSON action

* FIX: premature end of extraction in SAP action

* FIX the “allowMoreColumns” option inside the readGel action

* FIX extract binary fields inside readODBC action

* FIX extract Date and TimeStamp fields inside OracleOCI action

* added Facebook action

* added SalesForce Download action

* added SalesForce Upload action

* added TimeAggregate action

* moved GoogleAnalytics Action to AnatellaPluginCloud2.dll

* Changed the versioning system of the graphs to be at the level of the Action.

* added an optional locking mechanism for .anatella files to prevent 2 users to edit simultaneously the same file

* allow no password for ODBC connections

* updated the Anatella SDK to v2.06 and made a packaging system for the Anatella SDK

* FIX: csvReader was sometime crashing on small files (<1MB)

* added a new mode for the “forceQualifier” option in the writeCSV action

* added a new mode for the “mergeMode” option in the intervalJoin action

* added the “dynamicRE” option in the RegularExpressionTest action

* better handling of errors (added “COMMUNICATION_FAILURE”) in SAPReader

* added throttling in SAPReader

* added the paramsDimention and paramsMetric options in the GoogleAnalytics action

* added the readTagsFromInPin on readJSON action

* added “dateAddS()” inside calculator action

* FIX: “timi.exe”: scoring failed when the target is a muExpression and a column inside the muExpression was missing

* fix excelWriter action (multiple selected panels)

* fix R_HistogramGGP, R_AggAndHistoGGP R actions

* updated Anatella C++ SDK to v2.04

* added GAnalytics C++ action

* added “myMaxTitle” VBA function (useful for multiclass VBA models)

* added “commandLineToArray()” JS function

* added a new extraction mode (ODBCJob_fromPinCopyInputOutputStatus) in readODBC action

* added expandString(expression) in calculator and rowFilter actions

* added “keyStorage” option in ActionEncrypt

* added “outputMode” option in intervalJoin Action

* added SAPreader action

* added fromInputPinMode=2 option in readJSON action

* added fromInputPinMode=2 option in readXML action

* updated GoogleUnlock, GDriveListFiles, GDriveDownload, GoogleStorageListFiles, GoogleStorageDownload, GoogleStorageUpload, GoogleStorageDeleteFiles, GoogleStorageListBuckets, BigQueryDownload, BigQueryUpload JS actions

* added scanDir JS action

* added “fileSize()” JS function

* added “ignoreInvalidCharInTagName” in XMLReader action

* added testFileExists JS action

* added GoogleStorageDownload,GoogleStorageDeleteFiles

* finished replacing old anti-piracy library with the new one

* added 100% asynchrone read in readCSV

* upgraded signature to “TIMI SPRL”

* added GoogleUnlock, GDriveListFiles, GDriveDownload, GoogleStorageListFiles, GoogleStorageUpload, GoogleStorageListBuckets, BigQueryDownload, BigQueryUpload JS actions

* added SAPReader C++ action (beta version)

* FIX: bagOfWord was crashing on very long words

* added useStrictToDouble, useStrictToKey options in ChangeDataType action

* in all script actions, the parameters of the “password” type are not hidden anymore when starting with “>”

* in simpleFileOps, the destination dir is created, if necessary.

* added amazonDamaged option in readCSV

* added support for TLS1.2 in getEmails, sendEmail

* FIX: OutlookGet action was not always returning HTML body

* Stardust: now displays Ward-dissimilarity

* new C++ SDK!

* new C++ actions: outlookGet, outlookSend

* new JS actions: S3ListFilesInBucket, S3DownloadFile, S3UploadFile, S3DeleteFile, S3ListBucket, GDriveListFiles, GDriveDownload

* new JS function: commandLineToArray(), computeS3HashCode(), computeS3Hmac(),

* new section in the documentation: “5.22. Cloud services”

* improved in-line table

* FIX: the readODBC action was not always handling the “SQL_NO_DATA” result properly

* FIX: crypted box was not decrypted when the same box exists in the uncrypted state in the “built-in” plugin dir

* FIX: removed “_setmode( _fileno( stdout ), _O_BINARY );” from AnatellaConsole

* FIX the “Global Settings” window to allow scrolling when the screen is not big enough to display everything

* FIX in ReadColumnarGel: the filepath was not always properly computed when reading files from input pin

* FIX TIMiEnterLicense was not working properly for the Community edition

* FIX TIMiWizard was not initializing properly when no categories were selected

* licensing system now supports: community edition, pro edition, corporate edition. This implies many changes in the binaries and on the website.

* the “sharedFolder” publication option in not available for the community edition anymore

* upgraded the “Teaser” system to include many more teasers (20 additional teasers!)

* added exportation of TIMi models to HTML+JS

* added an option in the Global Settings to hide all Teasers

* added the “OutlookGet” and “OutlookSend” actions

* added the PublishToTableauServer JS action

* added the R_ODBCInsert R action

* created a new upload script for the new web infrastructure on https://timi.eu

* created the new https://timi.eu infrastructure using the FASTLY CDN.

* upgraded all the URLs in the binaries to point to http://download.timi.eu

* updated the Wizard-based installer with new Logos

* created 3 installations sizes: small, medium, large

* upgraded the “ProcessRunner::runImmediateExtended()” JS function to add one last parameter that is sent to stdin

* added the “fileBinaryLoad” JS function

* added the “forceQualifier” option in writeCSV action

* added the “ODBCAbort_neverAbort” option in the readODBC action

* added the “allowStrangeChars” option in the upsertODBC action

* added a better error message in ReadColumnarGel when the ColumnSet file is missing

* added a better error message in Python when 2 columns have the same name inside the returned panda data frame.

* added a “Get Help” button to help users with the initial configuration of Python

* upgraded the R_ReadPDF, R_HistogramGGP, R_Scatter, R_PieChart, R_PopulationPyramid, R_Boxplot, R_Hierarchical, R_SOM, R_MCA R-based actions

* upgraded the ListFilesInZip, Sleep JS-based actions

* upgraded the TIMiEnterLicense to get better licensing messages (i.e. display the edition)