Kopírování dat z externích zdrojů

Process / use case

1. The User compares the original table to be copied with the table to be pasted.
2. The User has to uniformize the order of table columns whether in:
   • MIS3 application - using UI settings Saving UI settings the table columns can be adjusted to match the table columns and their order in the external source table.
   • The source table - to match the table in the MIS3 system
3. User copies the original table outside of MIS3 using a standard CTRL+C hotkey.
4. In the MIS3 application the user must have the table in edit mode and have the typing cursor in the row and column where the data paste will start. Either the whole table or just selected column/columns can be pasted.
5. Using CTRL+V hotkey will do the following steps:
   • The system will check if a number of columns from the cursor location matches the rule "original_table.columns" =< "destination_table.columns"
     • If the number of columns of the original table is less or equal to the number of columns of the destination table --> OK
     • Else: User gets an error "Number of columns of the original table exceeds the MIS3 table. The table cannot be copied." and no data are pasted.
   • The system will check the number of rows from the cursor location matches the rule "original_table.rows" =< "destination_table.rows"
     • If the number of rows of the original table is less or equal to the number of columns of the destination table --> OK
     • Else: User gets an error "Number of rows of the original table exceeds the destination table. The table cannot be copied." and no data are pasted.
   • The system will check that the format of the table is correct (more in chapter "Table format"), in case the format is incorrect, the User gets an error "The format of column COLUMN.NAME is incorrect". Data are pasted to the table and incorrect format/mask fields will be in an error state.
   • If all validation passes, all spaces and unprintable characters at the start and at the end of each value pasted to the column are removed before the paste action.
   • The data are pasted to the editable table.
6. If any value exists in the MIS3 table, these values are overwritten by the paste action.
7. In case the value is pasted to the drop-down:
   • FE must match inserted value with the exact one value from the drop-down options
   • If zero or multiple options are available from the drop-down, the field will be empty and framed by red.
8. The user will save the changes to persist the paste action.

Pasting table data - behavior for disabled fields

1. The rules described in the section „Process/ use“ in the Paste of table data applies.
2. In the destination table in MIS3/CP there are one or more disabled fields (read-only).
3. Using CTRL+V hotkey will perform the following steps:
   • The system will check if a number of columns from the cursor location AND columns with disabled fields (counted as available columns) matches the rule: "original_table.columns" =< "destination_table.columns"
   • If the number of columns of the original table is less or equal to the number of columns of the destination table --> OK
   • The system will check if a number of rows from the cursor location AND rows with disabled fields (counted as available columns) matches the rule: "original_table.columns" =< "destination_table.rows"
   • If the number of rows of the original table is less or equal to the number of rows of the destination table --> OK
   • If the destination table has one or more fields in the disabled mode (read-only), then values that are copied to the destination table would be ignored. These data from the source table wouldn’t be pasted to the destination table. If any value exists in the disabled field, these values won't be overwritten.
4. The process continues with the existing validations.