ExcelToCI limitations

ExcelToCI is a tool that allowed consultants with little or no technical knowledge to quickly load data into the system. But what are the most significant ExcelToCI limitations? You may find others, but from my experience, these are quite important:

* ExcelToCI does not allow to determine the order in which fields are loaded into the application. The order is determined by the tab order defined at the page level in Application Designer.
* Loading large data volumes becomes unpractical for performance reasons. Excel could easily hang when manipulating spreadsheets with over 10,000 rows.
* Excel becomes nearly blocked when executing the load. It's difficult to perform any other action on the same workstation, and particularly to load several files in parallel.
* Can only run in Add or Update mode, but there is not hybrid option to first try to Add and then Update is the row was present.

Now, FTEL is using ExcelTOCI-based technology. It's easy for HRees - who have little technical knowledge) to use. But It will be slower when the employee's data increase. When the number of employee-job-data's records is larger, the GET process will be slower because the large amount of data being transfered. To kill the GET process, the users must input all key-fields, but it's out of the user's abilities. In the future we hope that we will another solution or can upgrade this ExcelToCI-based technology.