Enable import button for end users

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