What's new in PeopleRes Data Manager 1.2.0.0
Jul 8, 2013
- Fixed performance issues when exporting large amounts of data to CSV, Excel and Generating SQL Statements
- Testing performance on a sheet with 121662 rows and 16 columns:
- CSV export in 2 seconds (24.7mb)
- XML export in 3 seconds (76mb)
- SQL INSERT statements generated in 5 seconds (56.4mb)
- Excel 2010 in 25 seconds (9mb)
- Added support to export to XML (individual sheet or whole project)
- When attempting to display more than 500 generated SQL statements, a warning will display and recommend rather writing directly to file
- When exporting to Excel, the blank column on the left used for selecting and dragging rows, won’t be included in the export. Data will thus begin in column A.
- Data Source can now be selected directly on the Data Sheet Editor. The Build popup window is now optional.
- When copying a sheet, the Data Sheet Editor will automatically open for the newly created sheet
- It is now possible to create a new project directly from an Excel Workbook or XML file. All the tabs / tables will automatically be imported:
- The program can also be started with one of these file types as parameter. (i.e. drag an Excel file and drop it on the PRDataManager’s icon)