How to convert unstructured data to structured data

  • 111 Views
  • Last Post 25 May 2018
mounikap.in@mouritech.com posted this 18 May 2018

Hi,

I have a notepad with unstructured data and i want to get structured data like (server name, user name and commands) and store it in excel.

please find the attached notepad data and below sample structured excel data.

structured Excel Data:

 Notepad Data:

 

HEARTBEAT failed TWICE for psmanager.jar on server brrpappbib01 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user cognos on brrpappbib01, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brrpappbib02 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user cognos on brrpappbib02, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brpsappcab01 !!!

The reason is : host error: unknown host brpsappcab01 at /opt/oracle/scripts/do_remote_task line 30. .. host error: unknown host brpsappcab01 at /opt/oracle/scripts/do_remote_task line 30. 

---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappcab01 and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brpsappcab02 !!!

The reason is : host error: unknown host brpsappcab02 at /opt/oracle/scripts/do_remote_task line 30. .. host error: unknown host brpsappcab02 at /opt/oracle/scripts/do_remote_task line 30. 

---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappcab02 and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brpsappint1 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappint1 and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

 

HEARTBEAT failed TWICE for psmanager.jar on server brdiappcaa2 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user oracle on brdiappcaa2, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brdiappcab1 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user oracle on brdiappcab1, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brdiappcab2 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user oracle on brdiappcab2, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

HEARTBEAT failed TWICE for psmanager.jar on server brdiappint1 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user oracle on brdiappint1, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.

--------------------------------------------------------------------------------------------------- 

 

Thanks,

Mounika

Order By: Standard | Newest | Votes
Ravi posted this 21 May 2018

 

Hi mounika

Under String utilities section we have few components like ,get text after,get text before,get text between etc.

Using those components you can extract the desired words.

for your reference check the below image 

 

 

Regards,

Ravi

 

mounikap.in@mouritech.com posted this 22 May 2018

Hi Ravi,

Thanks for your response, We tried using string utilities it is working fine, but how to export these data in to excel sheet.

 

 -> For each loop is not repeated even though String Utilities-Split component contains multiple rows of data(usernames, server names and commands) we are getting only first row output in message box.

Thanks,

Mounika.

Ravi posted this 25 May 2018

Hi Mounika,

 

I have sent a sample automation file to your email address. It will extract data from one type of error message from the email, i.e. "HEARTBEAT failed TWICE for psmanager.jar on server brrpappbib01 !!!

The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. 

---> Please logon as user cognos on brrpappbib01, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running."

 

You can change the automation to extract information from the other type of message as well. 

 

Please review the same and let me know if you need any further assistance.

 

Thank's for your interest on INTELLIBOT

 

Regards,

Ravi

Close