METHOD AND APPARATUS FOR MANAGEMENT AND VALIDATION OF DATA
A method is performed by at least one processor for data validation in an electronic spreadsheet displayed in a user interface. The method includes receiving a selection of a set of data that includes a plurality of data cells arranged in at least one row and a plurality of data columns. The method further includes receiving a location in the electronic spreadsheet for insertion of the set of data. The method further includes, after receiving the location in the electronic spreadsheet, validating the set of data based on a master data configuration stored in one or more databases. The method further includes, after validating the set of data, displaying a message in the user interface indicating whether the validating the set of data is successful.
1 . A method performed by at least one processor for data validation in an electronic spreadsheet displayed in a user interface, the method comprising:
receiving a selection of a set of data that includes a plurality of data cells arranged in at least one row and a plurality of data columns;
receiving a location in the electronic spreadsheet for insertion of the set of data;
after receiving the location in the electronic spreadsheet, validating the set of data based on a master data configuration stored in one or more databases; and
after validating the set of data, displaying a message in the user interface indicating whether the validating the set of data is successful.
2 . The method of claim 1 , in response to determining the validating the set of data is successful, the set of data is inserted in the electronic spreadsheet, and the message displays a success message.
3 . The method of claim 1 , in response to determining the validating the set of data is not successful, an indication of a location of one or more errors is provided in the electronic spreadsheet, and the message displays an error message.
4 . The method of claim 3 , wherein the indication of the location of the one or more errors includes a highlighting of one or more data cells in the electronic spreadsheet that includes erroneous data.
5 . The method according to claim 1 , wherein the master data configuration specifies a relationship between a first data column in the plurality of data columns and a second data column in the plurality of data columns.
6 . The method according to claim 5 , wherein the relationship specifies that when a data cell in the at least one row and first data column has a specific value, a data cell in the at least one row and the second data column is limited one or more other values.
7 . The method of claim 5 , wherein the set of data includes at least one data column in the plurality of data columns that is not specified in the master data configuration.
8 . The method according to claim 1 , wherein the master data configuration specifies a relationship between at least one data column in the plurality of data columns and at least one field not included in rows and data columns of the electronic spreadsheet.
9 . The method according to claim 1 , wherein the set of data includes a plurality of rows including the at least one row, and wherein the validating is performed for each data column specified in the master data configuration for each row.
10 . The method according to claim 1 , wherein the master data configuration is arranged in a hierarchical relationship having a plurality of levels.
11 . The method of claim 1 , wherein the electronic spreadsheet is a first electronic spreadsheet, and the set of data is sourced from a second electronic spreadsheet different from the first electronic spreadsheet.
12 . The method of claim 1 , wherein the receiving the location in the electronic spreadsheet for insertion of the set of data includes a paste function that identifies the location in the electronic spreadsheet for pasting the set of data, and wherein the validating the set of data is performed at a time of pasting of the set of data in the electronic spreadsheet.
13 . An apparatus for data validation in an electronic spreadsheet displayed in a user interface, the apparatus comprising:
at least one memory configured to store computer program code; and
at least one processor configured to access said at least one memory and operate as instructed by said computer program code, said computer program code including:
first receiving code configured to cause at least one of said at least one processor to receive a selection of a set of data that includes a plurality of data cells arranged in at least one row and a plurality of data columns,
second receiving code configured to cause at least one of said at least one processor to receive a location in the electronic spreadsheet for insertion of the set of data,
after reception of the location in the electronic spreadsheet, validating code configured to cause at least one of said at least one processor to validate the set of data based on a master data configuration stored in one or more databases, and
after validation of the set of data, displaying code configured to cause at least one of said at least one processor to display a message in the user interface indicating whether the validating the set of data is successful.
14 . The apparatus of claim 13 , wherein in response to a determination the validating the set of data is successful, the set of data is inserted in the electronic spreadsheet, and the message displays a success message.
15 . The apparatus of claim 13 , wherein in response to a determination the validating the set of data is not successful, an indication of a location of one or more errors is provided in the electronic spreadsheet, and the message displays an error message.
16 . The apparatus of claim 15 , wherein the indication of the location of the one or more errors includes a highlighting of one or more data cells in the electronic spreadsheet that includes erroneous data.
17 . The apparatus according to claim 13 , wherein the master data configuration specifies a relationship between a first data column in the plurality of data columns and a second data column in the plurality of data columns.
18 . The apparatus according to claim 17 , wherein the relationship specifies that when a data cell in the at least one row and first data column has a specific value, a data cell in the at least one row and the second data column is limited one or more other values.
19 . The apparatus of claim 17 , wherein the set of data includes at least one data column in the plurality of data columns that is not specified in the master data configuration.
20 . A non-transitory computer readable medium having instructions stored therein, which when executed by a processor cause the processor to perform a method for data validation in an electronic spreadsheet displayed in a user interface, the method comprising:
receiving a selection of a set of data that includes a plurality of data cells arranged in at least one row and a plurality of data columns;
receiving a location in the electronic spreadsheet for insertion of the set of data;
after receiving the location in the electronic spreadsheet, validating the set of data based on a master data configuration stored in one or more databases; and
after validating the set of data, displaying a message in the user interface indicating whether the validating the set of data is successful.