What's new in EMS Data Import for InterBase/Firebird 3.7.0 Build 44144
Jun 9, 2014
- Import rate is increased due to use of multithreading.
- Data Import for PostgreSQL. The possibility to choose schema to create a new table is implemented.
- Data Import for PostgreSQL. For server versions 8.1 or higher it is possible to get the list of databases from postgres database.
- XML. Added the possibility of manual and automated identification of the type of the imported XML-file.
- Now log contains information about the string number where the error occurred.
- When importing from several files their logs are located at different tabs, while the main log contains general information about these processes.
- DBF. Wrong identification of Integer type fields. Fixed now.
- Data Import for SQL Server. "Keep identity" option did not work. Fixed now.
- DBF. Data Import for MySQL. National characters were imported incorrectly. Fixed now.
- yyyy-mm-ddThh:nn:ss format was recognized incorrectly. Fixed now.
- HTML. When importing from HTML file with the links the application froze. Fixed now.
- Data Import for MySQL. CSV. Errors in Native mode - CSV insert. Fixed now.
- Other improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.5.0.1 (Nov 30, 2011)
- Added the possibility to rollback the transaction, if an error occurs.
- The interface of the third step for all types of the imported files is uniformed now.
- Import console. Now the import process information is displayed after certain time intervals.
- Data Import Wizard. Now the import process information is displayed after certain time intervals.
- Now localizations are loaded when the language directory is changed.
- On opening a new field editor is filled in with default values now.
- Now when importing to a new table, it is possible to determine the length of the string field by default.
- Excel 2007. Added the possibility to configure Ranges when importing from Excel 2007, the same as importing from Excel 2003.
- Excel 2007. Import speed is increased.
- XML Data packet. Added the possibility to select the file encoding.
- Access. Added the dialog for entering a username.
- XML. Importing to a new table caused an AV error. Fixed now.
- Excel. Using the range of rows in Map caused the incorrect data import. Fixed now.
- Excel. When parsing a file with a field containing the SUM function with one argument, an error occurred. Fixed now.
- Excel. When opening the Map Range editor, the data in it displayed incorrectly. Fixed now.
- Data Import for MySQL. Fixed the critical bug in the Native mode.
- Data Import for SQL Server. Fixed the bug connected with the autogeneration of values.
- Data Import for PostgreSQL. When importing string data into the integer column, no error message displayed. Fixed now.
- Some other improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.4 (Nov 30, 2011)
- Added the support of Microsoft Office Access 2007 files.
- The work with data is more convenient now. Templates for basic date formats are added.
- Now when importing from an Access file to a new table, the structure of any Access table from a file is created.
- Added the support of complicated date templates: mmm dd yyyy hh:nn:ss:zzzAP or yyyy-mm-ddThh:nn:ss.zzz.
- Fixed a memory leak error which occurred when importing from large text files (CSV, TXT) in the Native mode of the utility (for Data Import for SQL Server and Data Import for InterBase/Firebird).
- Fixed an error connected with the display of views with names in the lower register (for Data Import for InterBase/Firebird).
- Now it is possible to set BigInteger (64bit, 19 Decimal digits) values for the generator at step 5 of the utility.
- Some other improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.3 (Nov 30, 2011)
- Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
- Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
- It is now possible to map more than 256 columns when importing from MS Excel 2007 (the maximum number is 16384, it is Excel 2007 restriction).
- The console version now forms a more informative log file.
- Some visual changes are introduced; the sizes of forms/form parts are saved now.
- Added the possibility to save settings of the previous import procedure: formats, import mode, etc.
- Fixed the "Object table name is in use" error occurred during table recreation (InterBase/Firebird).
- The support of date formats is expanded, the YYYYMMDDHHMMSS format is now supported (SQL Server).
- Fixed an error occurred when creating tables which contained _ in their name (DB2).
- Other minor improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.2 (Nov 30, 2011)
- Added the possibility to create separate tables for each source data file. The table structure is built on the basis of the source data analysis.
- It is now possible to specify the source data charset when importing TXT and CSV files.
- The ability to set correspondences between source data and existing table fields is implemented. This correspondence is based on the identity of the source columns’ and destination table fields’ names.
- Added the possibility to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
- SQL Server 2008 support is implemented.
- PostgreSQL 8.3 support is implemented.
- Destination table fields' types are now displayed. (DB2)
- The "Automatically reconnect when connection is lost" option is added. (MySQL)
- Added the possibility to set the Connection Timeout parameter before connecting to the host. (SQL Server)
- Importing data in the Universal mode resulted in error. Fixed now. (DB2)
- Using "-log" parameter in console versions used to result in error. Fixed now.
- Other minor improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.1 (Nov 30, 2011)
- Added a possibility to import data from the text of XML documents embedded nodes.
- Added a possibility to explicitly specify the data file for the console version using the -datafile= parameter. Now you can use one and the same template file to import from several data files of the same type.
- Added auto-recognition of columns and autofill of table fields for TXT files.
- Wizard window is now resizable.
- The field type is now displayed for DBF files.
- Unicode data are now imported into NTEXT type fields correctly (SQL Server).
- Fixed a connection error that occurred on attempt to establish connection to SQL Server 2000, when running the utility in Windows Vista environment and using SQL authentication (SQL Server).
- Import to NCLOB type fields is now supported (Oracle).
- In some cases an error occurred upon import of DATE data in the Native mode CSV Insert. Fixed now (MySQL).
- Other minor improvements and bugfixes.
New in EMS Data Import for InterBase/Firebird 3.0 (Nov 30, 2011)
- The new “Native” method of import is added which includes two algorithms – Single Commands and Batch Insert. Single Commands mode serves to generate and execute single SQL commands on the server; whereas Batch Insert uses native commands for a particular server: BULK INSERT (SQL Server), LOAD DATA INFILE (MySQL) and COPY (PostgreSQL). With the help of Native mode your data can be imported dozen (!) times faster compared to Universal mode which was used in the previous versions.
- Unicode support. Now you are able to import Unicode data (for SQL Server, MySQL, PostgreSQL).
- Import from new formats is available now:
- MS Excel 2007
- MS Word 2007
- HTML
- Generic XML
- Open Document Format (Open Document Text and Open Document Spreadsheet)
- Now there is a short field type description next to field names that appear in different lists. This option is enabled by default. When necessary, it can be disabled from Tools>Preferences.
- Utility source code significantly optimized, work speed increased.
- Identity fields support implemented (for SQL Server).
- Ability to import data from text files containing TAB symbols as a separator is added.
- Other small improvements and bugfixes.