AnsweredAssumed Answered

Pentaho Spoon - How to read email and push data in columns of DB table?

Question asked by B523W5TI on Dec 14, 2017
Latest reply on Dec 30, 2017 by B523W5TI

Hello world,

 

I need to create a workflow with Pentaho Spoon that:

- read mail;

- parse body email (capturing info);

- push data in respective column of Db Table.

 

I tried with a workflow custom composed with folliwing objects:

- Email messages input;

- Regex evaluation;

- Table output.

 

Unfortunately I cannot work with regex (parse body to respective column)....

 

The email has the following body:

 

Notification Type: AAAAAA

Service: Percentile: Interface vlanxxxx
Host: Oslo.group.xxx
Address: 99.200.XX.YYY
State: OK

Date/Time: Sun Sept 10 22:53:32 CEST 2017

Additional Info:

OK
- Interface 400 = Average IN: 140.626Gbps(50.50%), Average OUT: 519.888Mbps(80.962%)

 

The regex I used is the following:

 

^Notification Type:\s*(.*)$

^Service:\s*(.*)$

^Host:\s*(.*)$

^Address:\s*(.*)$

^State:\s*(.*)$

^Date/Time:\s*(.*)$

^Additional Info:\s*(.*)$

 

But my workflow not works.

 

Can anyone help me?

 

Regards

Outcomes