<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to wiki</title><link href="https://sourceforge.net/p/getl/wiki/" rel="alternate"/><link href="https://sourceforge.net/p/getl/wiki/feed.atom" rel="self"/><id>https://sourceforge.net/p/getl/wiki/</id><updated>2020-01-05T13:13:23.555000Z</updated><subtitle>Recent changes to wiki</subtitle><entry><title>Home modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Home/" rel="alternate"/><published>2020-01-05T13:13:23.555000Z</published><updated>2020-01-05T13:13:23.555000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net3eff0f54704c7f157ea5799b75fdb52f11cacc94</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v2
+++ v3
@@ -10,3 +10,42 @@
 * All routine work ETL should be automated wherever possible;
 * Compiling the code on the fly bail speed and reserve for the optimization;
 * Sophisticated class hierarchy guarantee easy connection of other open source solutions.
+
+# Getl DSL
+&lt;p&gt;The implemented language extension makes it easier to work with data sources, file systems and simplifies the development of data processing processes.&lt;/p&gt;
+&lt;p&gt;Object-oriented coding is not required to work with data objects or file systems. All work is supported at the level of a simple scripting language. The language has built-in support for all types of data sources and file systems of the GETL classes.&lt;/p&gt;
+&lt;p&gt;To simplify the development of complex logic, support has been added for the local repository of the described data sources and file systems.&lt;/p&gt;
+&lt;p&gt;The language has added support for nested script calls for developing patterns of logic for working with data sources.&lt;/p&gt;
+&lt;p&gt;To extend the functionality of intermediate calculations, there is support for tables in the in-memory database and temporary text files.&lt;/p&gt;
+&lt;p&gt;To create parallelization of data processing, support for multi-threaded user code has been implemented. Connections and data sources that are registered in the repository are automatically cloned to work in threads.&lt;/p&gt;
+
+## The following data sources are supported
+* CSV files
+* Excel files
+* H2 database
+* Hadoop Hive
+* Hadoop Impala
+* JSON files
+* MSSQL Server
+* MySql
+* Netezza
+* Oracle
+* PostgreSql
+* Vertica
+* XML files
+
+## The following file systems are supported
+* local and sharing files
+* ftp
+* ssh file (sftp)
+* hadoop hdfs
+
+## Github Wiki
+For a more detailed description of working with Getl, see the GitHub wiki:
+https://github.com/ascrus/getl/wiki
+
+## Documentation
+Full Russian language documentation will be posted later on www.easydata.ru site. In the future, the basic part of the documentation will be translated into English and posted on Githab site.
+
+## Example project:
+https://github.com/ascrus/getl-examples
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2018-02-27T19:51:59.580000Z</published><updated>2018-02-27T19:51:59.580000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net8ca7541171945ea766ebd5c1060e7a27c4f4f279</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v12
+++ v13
@@ -1,3 +1,11 @@
+#Version 2.0.2
+# Future
+* Added support for reading data from SalesForce (used the interface com.force.api:force-partner-api). The eachRow method supports batch reading of data using the readAsBulk parameter. Also, the driver implements the bulkUnload method for batch uploading data from a source to a CSV file.
+
+# Fixed bugs
+* getl.proc.Flow: fixed bug for method Copy by excludeFields parameter
+* getl.csv.CSVDriver: extend support for reading logical types fields
+
 #Version 2.0.1
 #Future
 * Added support for reading data from Netsuite ERP (NetsuiteConnection). The following types of fields are supported: varchar2, number and timestamp.
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2018-02-23T11:09:35.549000Z</published><updated>2018-02-23T11:09:35.549000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net610a838a097675ffe719cdccb24112950af51ca9</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v11
+++ v12
@@ -1,3 +1,17 @@
+#Version 2.0.1
+#Future
+* Added support for reading data from Netsuite ERP (NetsuiteConnection). The following types of fields are supported: varchar2, number and timestamp.
+#Version 2.0.0
+The major version is increased due to the many changes in the functionality of the database drivers.
+# Fixed bugs
+* getl.jdbc.SQLScripter: fixed bug for MySQL and Oracle databases for IF statement
+#Future
+* getl.jdbc.JDBCDriver: added support UUID, BLOB and CLOB fields for all RDBMS
+* getl.jdbc.JDBCDriver: added support for using static compilation when generating dynamic code to work with all DBMS
+*getl.proc.Flow: added support for using static compilation when generating dynamic code
+* getl.proc.Flow: improved data type conversion when copying from source to destination
+* getl.utils.DateUtil: added functions to convert strings to date types from "java.sql" package
+
 #Version 1.3.8
 # Future (for colleagues from Transitional Data Service company)
 * CSVDataset: now the field names can be written and read into the file header as case-sensitive
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2018-02-01T12:59:15.855000Z</published><updated>2018-02-01T12:59:15.855000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.neta8820bbf3e71eb10ce5ac27ab27f93d13f1750fc</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v10
+++ v11
@@ -1,3 +1,94 @@
+#Version 1.3.8
+# Future (for colleagues from Transitional Data Service company)
+* CSVDataset: now the field names can be written and read into the file header as case-sensitive
+* ExcelDataset: added support for automatic field detection if the header property is enabled and no fields for dataset are specified
+
+#Version 1.3.6
+# Fixed bugs
+* getl.vertica.ReverseEngineering: fixed a bug where not generated grants roles to the role
+
+# Future
+* getl.vertica.ReverseEngineering: extended functional for GUI reverse project
+* getl.utils.Logs: added property printStackOnError
+
+
+#Version 1.3.5
+# Fixed bugs
+* getl.utils.GenerationUtils: fix bug for generate random numeric value
+* getl.jdbc.SQLScripter: when working with operators LOAD_POINT and SAVE_POINT with the wrong options, the server sends an SQL query these commands, now fixed the error about invalid parameters
+* getl.files.FTPManager: fixed a bug of setting the file modification time
+
+# Changed
+* getl.h2: change H2 version to 1.4.196
+
+# Future
+* getl.files.Manager: added "saveOriginalDate" property that indicates whether you want to keep time of original file when it is copied
+* getl.files.Manager: added "getLastModified" and "setLastModified" methods for reading and setting of file modification time
+
+#Version 1.3.4
+# Fixed bugs
+* getl.mysql.MySQLDriver fixed bug related to the creation of temporary tables.
+* getl.vertica.ReverseEngineering: changed name parameter sqlFile to script_path
+* getl.vertica.ReverseEngineering: modified config sections to three section: drop, create and filename (see below for a description of the structure of the configuration file)
+* getl.vertica.ReverseEngineering: fix bug in define cascade pools
+* getl.vertica.ReverseEngineering: fix bug if object has long name
+* getl.vertica.ReverseEngineering: fix bug sorting of grants
+* getl.vertica.ReverseEngineering: fix bug for first description line in script files
+* getl.utils.EMailer: fix bug in send by text plain format
+
+# Future
+* getl.utils.DateUtils: added support work this module under other not current time zone
+
+# Structure of sections in config file by ReverseEngineering
+generate drop statement for objects
+```
+"drop": {
+   "pools": false,
+   "roles": false,
+   "users": false,
+   "schemas": false,
+   "sequences": false,
+   "tables": false,
+   "views": false,
+   "sql_functions": false
+}
+```
+create statement for objects
+```
+"create": {
+   "pools": false,
+   "pool_empty": false, (generate only create pools without parameters)
+   "roles": false,
+   "users": false,
+   "user_empty": false, (generate only create users without parameters)
+   "schemas": false,
+   "sequences": false,
+   "sequences_current": false, (generate statement for setting current value)
+   "tables": false,
+   "table_constraints": false,
+   "column_comments": false,
+   "projection_tables": false,
+   "projection_ksafe": 1, (generate other ksafe in projections than current ksafe by server)
+   "projection_analyze_super": false, (added /*+createtype(A)*/ to super projections if they don't have hints)
+   "views": false,
+   "sql_functions": false,
+   "grants": false
+}
+```
+
+-- the mask of file for objects, you can specify a single file for each object type (default file mask &amp;lt;objects&amp;gt;.sql) or use variables to split the object files
+```
+"filename":{
+   "pools": "pools/{pool}",
+   "tables": "tables/{schema}/{table}",
+   "views": "views/{schema}/{view}",
+   "roles": "roles/{role}",
+   "users": "users/{user}",
+   "schemas": "schemas/{schema}",
+   "sequences": "sequences/{schema}/{sequence}",
+   "sql_functions": "functions/{sql_function}"
+}
+```
 #Version 1.3.2
 # Fixed bugs:
 * getl.jdbc.SQLScripter: fixed bug when using single comments (--) in the script
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2017-06-27T13:47:26.057000Z</published><updated>2017-06-27T13:47:26.057000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net1a8481df9afe16277dcecc8c69521b1674d4537d</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v9
+++ v10
@@ -1,3 +1,8 @@
+#Version 1.3.2
+# Fixed bugs:
+* getl.jdbc.SQLScripter: fixed bug when using single comments (--) in the script
+* getl.jdbc.SQLScripter: fixed bug when using WITH SELECT construction
+
 #Version 1.3.1
 # New features:
 * getl.utils.NumericUtils: added method "IsInteger"
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2017-05-10T15:44:16.888000Z</published><updated>2017-05-10T15:44:16.888000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net2bf98978ece8b774a762be441b504e4a80e5b862</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v8
+++ v9
@@ -1,3 +1,21 @@
+#Version 1.3.1
+# New features:
+* getl.utils.NumericUtils: added method "IsInteger"
+
+# Enhancement:
+* getl.jdbc.JDBCDriver: for the method bulkLoad unified parameters "files" and "fileMask"
+* getl.vertica.VerticaDriver: added support limit, offset and label parameters for eachRow and rows method
+* getl.mysql.MySQLDriver: added support limit and offset parameters for eachRow and rows method
+* getl.postgresql.PostgreSQLDriver: added support limit and offset parameters for eachRow and rows method
+* getl.hive.HiveDriver: added parameter "expression" for the method bulkLoad
+* getl.h2.H2Driver: added parameter "expression" in "bulkLoadFile" method
+* getl.data.FileDataset: when "append" mode is enabled, then existing file is copied into the temporary file, rows are added to it, then the original file is deleted and in its place the new renamed file
+* getl.jdbc.SQLScripter: convert variables Date type to java.sql.Timestamp type
+* getl.jdbc.SQLScripter: remove clear comments
+
+# Fixed bugs:
+* getl.utils.MapUtils: fix bug in method "ProcessArguments" if argument as string
+
 #Version 1.3.0
 # Change in environment:
 * groovy: switching to version 2.4.10
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2017-04-18T10:45:45.603000Z</published><updated>2017-04-18T10:45:45.603000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net774205af3f4f435be6f02d1a90d7b955b15807b9</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v7
+++ v8
@@ -1,3 +1,31 @@
+#Version 1.3.0
+# Change in environment:
+* groovy: switching to version 2.4.10
+* gradle: added repository for ftp4j library
+* gradle: remove the third-party libraries from getl jar, please use them as separate jar files in you class path app
+
+# Important changes:
+* getl.driver.Driver: renamed enum value Support.TEMPORARY as Support.LOCAL_TEMPORARY and added new value Support.GLOBAL_TEMPORARY, please validate your code
+
+# New features:
+* getl.hive: added support the Hive database, allow use Cloudera, Apache and Hotron JDBC driver, this allow create table with any format, read and write the data, bulk load the csv files and execute sql script, there is support for tables with partitions
+
+# Enhancement:
+* getl.data.Field: added properties isPartition and ordPartition for the fields that are included in the partition (used in the Hive driver)
+* getl.jdbc.JDBCConnection: in driverPath is now possible to specify not only the name of one of the jar file of the JDBC driver, but also the name of a directory to download all the jar files of this driver
+* getl.h2.H2Driver: added database default name for in-memory mode
+* getl.vertica.ReverseEngineering: added support udf sql functions
+* getl.utils.FileUtils: added method AddJarToClassPath for dynamically loading one or more jars from a running app
+* getl.utils.EMailer: added parameter isHtml to sendMail method
+* getl.utils.StringUtils: added methods GeneratePassword, ToSnakeCase and ToCamelCase
+
+# Fixed bugs:
+* getl.jdbc.JDBCDriver: added validation set value connectDatabase property (if needed)
+* getl.vertica: added optimization for MERGE operator (used PK fields in update section)
+* getl.utils.MapUtils: fixed bug in MergeMap function
+* getl.data.Dataset: fixeg bug on use transaction in method truncate
+* getl.files.HDFSManager: fixed bug on use "/" in rootPath
+
 #Version 1.2.10
 * change groovy version to 2.4.8
 * getl.utils.FileUtils: fixed bug in method MoveTo
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2017-01-24T17:35:45.269000Z</published><updated>2017-01-24T17:35:45.269000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.netcca6e2545c0c9ae97410ce40b40c2f0e640f490a</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v6
+++ v7
@@ -1,3 +1,15 @@
+#Version 1.2.10
+* change groovy version to 2.4.8
+* getl.utils.FileUtils: fixed bug in method MoveTo
+* getl.data.Field: fixed bug for comparing fields String and Text types
+* getl.jdbc.JDBCConnection: added property "driverPath" for dynamic loading  the jar driver for connection
+* getl.vertica.VerticaDriver: fixed bug invalid types in method the creating dataset 
+* getl.driver.Driver: added support the BLOB and CLOB the type for fields and MEMORY type for tables
+* getl.proc.Flow: added parameter "createDest" in method "copy". If true value, the copy method created destination dataset before data copy
+* getl.vertica.ReverseEngineering: added utility for reverse engineering Vertica database model in SQL file as DDL scripts. Tool supported pools, roles, users, schemas, sequences, tables, constraints, projections, views and grant for objects
+* getl.jdbc: fixed bug write bit fields
+* getl.utils.CopyTables: added the new utility "Copy data from JDBC tables source to the JDBC tables destination"
+
 #Version 1.2.08
 * added support the H2 database 1.4.193 version
 * getl.files.Manager: fixed bug for call buildList by null Closure parameter
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2016-11-22T12:26:14.576000Z</published><updated>2016-11-22T12:26:14.576000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.net2658e944d54e6af043fd80b9709001e922e1d1eb</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v5
+++ v6
@@ -1,3 +1,14 @@
+#Version 1.2.08
+* added support the H2 database 1.4.193 version
+* getl.files.Manager: fixed bug for call buildList by null Closure parameter
+* getl.jdbc.JDBCDriver: fixed bug in methods "eachRow" and "rows" for "onlyFields" parameter, where methods after run changed the list of fields Dataset to the list of fields from parameter
+* getl.files.FileCleaner: remove deprecated class, use files.Manager
+* getl.utils.CloneUtils: added new library for cloning Java objects of standart type (String, Integer, Long, Double, BigInteger, BigDecimal, Date, Map and List)
+* getl.utils.Path: fixed bug in "compile" method
+* getl.data.Field: added support the "equals" method
+* refactoring all source code
+* created test units for main functions and classes (getl packages csv, files, h2, jdbc, tfs, utils)
+
 #Version 1.2.07
 * getl.csv.CSVDataset: fix buf read file with custom date/time mask by field
 * getl.tfs.TFSConnection: didn't delete temporary files after completion of the work, fix it
&lt;/pre&gt;
&lt;/div&gt;</summary></entry><entry><title>Change log modified by Alexsey</title><link href="https://sourceforge.net/p/getl/wiki/Change%2520log/" rel="alternate"/><published>2016-10-31T10:18:29.141000Z</published><updated>2016-10-31T10:18:29.141000Z</updated><author><name>Alexsey</name><uri>https://sourceforge.net/u/ascrus/</uri></author><id>https://sourceforge.neta0a02aed1ac460c267aee80a82cbbe8dcd20b7a7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;pre&gt;--- v4
+++ v5
@@ -1,3 +1,10 @@
+#Version 1.2.07
+* getl.csv.CSVDataset: fix buf read file with custom date/time mask by field
+* getl.tfs.TFSConnection: didn't delete temporary files after completion of the work, fix it
+* getl.files.HDFSManager: add support Hadoop file system (HDFS) for file manager
+* getl.files.Manager: always save modified time of files for upload and download operators
+* getl.files.FTPManager: add timeZone property for set time zone FTP server
+
 #Version 1.2.06
 * getl.jdbc.SQLScripter: added support EXIT command
 * getl.jdbc.SQLScripter: added support operator LOAD_POINT and SAVE_POINT for load and save pointer in sql script
&lt;/pre&gt;
&lt;/div&gt;</summary></entry></feed>