The easy import functionality is very powerful, but we marked it as advanced because is also very dangerous and a user can easily damage data defining a wrong file.
So, actually is a tool for implementors, but cannot be really used by end-users.
To enable the usage for end users we thought on a possible approach where implementor can define authorized templates for the users.
The structure is something like:
AD_ImportTemplate
AD_Window_ID
AD_Tab_ID
Name
CharSet
Header
AliasHeader - this is to allow users a different header (i.e. with translated names, or fieldnames instead of columnnames)
AD_ImportTemplateAccess
AD_ImportTemplate_ID
AD_Role
AllowedInsert
AllowedMerge
AllowedUpdate
The solution would add a toolbar Import button enabled for users (not advanced) when the role has enabled the CanImport and also if the role has any authorized template for that tab.
The button would open then a window for the user to choose the template, then the operation (allowed by permissions), and the file.
The first step would be to check if the file header is corresponding with the template header or the alias header, if not then the file cannot be processed.
Regards,
Carlos Ruiz