Method and system for processing data for data translation
The present disclosure provides a method for processing data and service system thereof. The present disclosure comprises a steps for receiving a plurality of data from one or more users, wherein the plurality of data includes text in a source language. The present disclosure further comprises steps for storing the plurality of data in a delimited format, wherein the plurality of data is arranged in one or more rows and one or more columns based on the plurality of information associated with one or more users, wherein the data in the one or more rows and the one or more columns are stored in the form of one or more cells comprising one or more characters. The present disclosure further comprises steps for identifying the cell with largest character count from the one or more rows and selecting the row corresponding to the identified cell. The present disclosure further comprises steps for determining if the source language of the selected row is a non-English text; and in response to determining that the selected row is a non-English text, transmitting the selected row to a data translation engine for conversion from source language to target language.
1 . A method of processing data for data translation, comprising:
receiving, by a data management server, a plurality of data from one or more users, wherein the plurality of data includes text in a source language;
storing, by the data management server, the plurality of data in a delimited format, wherein the plurality of data is arranged in one or more rows and one or more columns based on the plurality of information associated with one or more users, wherein the data in the one or more rows and the one or more columns are stored in the form of one or more cells comprising one or more characters;
parsing, by the data management server, the one or more rows to determine the one or more cells containing textual description comprising of one or more keywords;
identifying, by the data management server, the cell with largest character count from among the one or more determined cells containing the textual description from the one or more rows and selecting the row corresponding to the identified cell;
determining, by the data management server, if the source language of the selected row is a non-English text;
segregating, by the data management server, at least one cell in the selected row containing the non-English text; and
in response to determining that the selected row is a non-English text, transmitting, by the data management server, the selected row comprising the segregated at least one cell to a data translation engine for conversion from source language to target language.
2 . The method of claim 1 , wherein the one or more cells include English and Non-English texts.
3 . The method of claim 1 , wherein the information associated with one or more user includes complaints, deviation, corrective and preventive actions, manufacturing processes details.
4 . The method of claim 1 , wherein the delimited format is a CSV format.
5 . The method of claim 1 , wherein the one or more user is a customer located across the world.
6 . The method of claim 1 , further comprising:
parsing the one or more rows and selecting the row with one or more keywords, wherein the keywords include description, event details, summary and/or text.
7 . The method of claim 1 , further comprising:
identifying the one or more cells within a row having non-English language text;
saving the identified cell at the end of the row; and
aggregating and transmitting the saved one or more rows to the data translation engine for conversion from source language to target language.
8 . The method of claim 1 , further comprising:
receiving a plurality of data from one or more users, wherein the plurality of data comprises information from the user, including a language selected by the user;
identifying the existing data of the user and assigning the selected language to all the existing data of the user;
determining the selected language of the user and identifying the data as non-English,
transmitting the identified plurality of data to the data translation engine, wherein the source language is converted to the target language.
9 . A data processing system for data translation, comprising:
a memory;
a data translation engine; and
one or more processor configured to:
receive a plurality of data from one or more users, wherein the plurality of data includes text in a source language;
store the plurality of data in a delimited format, wherein the plurality of data is arranged in one or more rows and one or more columns based on the plurality of information associated with one or more users, wherein the data in the one or more rows and the one or more columns are stored in the form of one or more cells comprising characters;
parse the one or more rows to determine the one or more cells containing textual description comprising of one or more keywords;
identify the cell with largest character count from among the one or more determined cells containing the textual description from the one or more rows and select the row corresponding to the identified cell;
determine if the source language of the selected row is a non-English text;
segregate at least one cell in the selected row containing the non-English text; and
in response to determining that the selected row is a non-English text, transmit the selected row comprising the segregated at least one cell to a data translation engine for conversion from source language to target language.
10 . The data processing system of claim 9 , wherein the one or more cells include English and Non-English texts.
11 . The data processing system of claim 9 , wherein the information associated with one or more user includes complaints, deviation, corrective and preventive actions, manufacturing processes details.
12 . The data processing system of claim 9 , wherein the delimited format is a CSV format.
13 . The data processing system of claim 9 , wherein the one or more user is a customer located across the world.
14 . The data processing system of claim 9 , wherein the processor is configured to:
parse the one or more rows and select the row with one or more keywords, wherein the keywords include description, event details, summary and/or text.
15 . The data processing system of claim 9 , wherein the processor is configured to
identify the one or more cells within a row having non-English language text;
save the identified cell at the end of the row; and
aggregate and transmit the saved one or more rows to the data translation engine for conversion from source language to target language.
16 . The data processing system of claim 9 , wherein the processor is configured to
receive a plurality of data from one or more users, wherein the plurality of data comprises information from the user, including a language selected by the user;
identify the existing data of the user and assign the selected language to all the existing data of the user;
determine the selected language of the user and identify the data as non-English; and
transmit the identified plurality of data to the data translation engine, wherein the source language is converted to the target language.
17 . A non-transitory computer-readable storage medium storing program instructions for processing data for data translation, perform the steps of:
receiving, by a data management server, a plurality of data from one or more users, wherein the plurality of data includes text in a source language;
storing, by the data management server, the plurality of data in a delimited format, wherein the plurality of data is arranged in one or more rows and one or more columns based on the plurality of information associated with one or more users, wherein the data in the one or more rows and the one or more columns are stored in the form of one or more cells comprising characters;
parsing, by the data management server, the one or more rows to determine the one or more cells containing textual description comprising of one or more keywords;
identifying, by the data management server, the cell with largest character count from among the one or more determined cells containing the textual description from the one or more rows and selecting the row corresponding to the identified cell;
determining, by the data management server, if the source language of the selected row is a non-English text;
segregating, by the data management server, at least one cell in the selected row containing the non-English text; and
in response to determining that the selected row is a non-English text, transmitting, by the data management server, the selected row comprising the segregated at least one cell to a data translation engine for conversion from source language to target language.
18 . The non-transitory computer-readable storage medium of claim 17 , further comprising program instructions to perform the steps of:
parsing the one or more rows and selecting the row with one or more keywords, wherein the keywords include description, event details, summary and/or text.
19 . The non-transitory computer-readable storage medium of claim 17 , further comprising program instructions to perform the steps of:
identifying the one or more cells within a row having non-English language text;
saving the identified cell at the end of the row; and
aggregating and transmitting the saved one or more rows to the data translation engine for conversion from source language to target language.
20 . The non-transitory computer-readable storage medium of claim 17 , further comprising program instructions to perform the steps of:
receiving a plurality of data from one or more users, wherein the plurality of data comprises information from the user, including a language selected by the user;
identifying the existing data of the user and assigning the selected language to all the existing data of the user;
determining the selected language of the user and identifying the data as non-English,
transmitting the identified plurality of data to the data translation engine, wherein the source language is converted to the target language.