About ashishtiw26

ashishtiw26 · ‎09-30-2021

Yes Sumita, it worked.

ashishtiw26 · ‎01-12-2020

@stevenmatison: Sure , i got your point. Csv Reader and Putdatabase Config are given below: Sample of content of Flowfile before putdatabase is as below: TIME,CAUSE,CATEGORY,PREVIOUSCOUNT,CURRENTCOUNT,AVERAGE,SEVERITY 2020-01-10 20:10:00,UNABLE TO COMPLY,DIAMETER: Permanent Failure,1172,1150,686,MAJOR 2020-01-10 20:10:00,Unspecified,NAS,15071,15240,13533,MINOR. Thanks for replying.

ashishtiw26 · ‎01-11-2020

Hi All, I want to insert csv data (which is getting generated from executsql) to database table. csv header are same as that of columns in table: TIME timestamp, CAUSE varchar(200) NOT NULL, CATEGORY varchar(100), PREVIOUSCOUNT numeric(11,0), CURRENTCOUNT numeric(11,0), AVERAGE numeric(11,3), SEVERITY varchar(30) My current flow is like : Executesql > updateattribute > validatecsv > updateattribute > putdatabase I am using avroschemaregistry and putting data as: { "type":"record", "name":"TestRecord", "fields":[ { "name":"TIME", "type":{"type":"long","logicalType":"timestamp-millis"} }, { "name":"CAUSE", "type":"string" }, { "name":"CATEGORY", "type":"string" }, { "name":"PREVIOUSCOUNT", "type":"float" }, { "name":"CURRENTCOUNT", "type":"float" }, , { "name":"AVERAGE", "type":"float" }, , { "name":"SEVERITY", "type":"string" } ] } Please help as i am stuck , i tried everything making translate field name to true and false both, but getting the same error. Looking for quick response.

ashishtiw26 · ‎12-31-2019

Hi Steven, Your solution worked well. but i have a question related to this topic. In Putemail, for the solution you provided i am using content type 'text\html' which is delivering result in table format (in mail body) but i am also attaching csv in my mail. Now this csv is also displaying data with html tag, is it possible to display the data in original form.(only csv format for attachment without html tag).

ashishtiw26 · ‎12-30-2019

Thanks Stevenmatison. It worked!!

ashishtiw26 · ‎12-30-2019

Thanks for your help but this is not solving my problem as i want the csv record which itself is in comma separated to be displayed in tabular format as in my mail body through PUTMAIL. I want records to be displayed in table format rather than comma separated or tab one. I have comma separated record : Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY SIP: [487] Request Terminated,173,393,1.271676300578034682,Critical and I want like this in mail body: Release Cause Previous Count Current Count Change_Ratio SEVERITY test_data 276 730 1.644927536231884058 Critical Please suggest a suitable method in order to do the same.

ashishtiw26 · ‎12-30-2019

Hi, I tried doing the same by replacetext but I am getting the output as: Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY test_data,276,730,1.644927536231884058,Critical but i want the same output in tabular format: Release Cause Previous Count Current Count Change_Ratio SEVERITY test_data 276 730 1.644927536231884058 Critical Please help for the same.

ashishtiw26 · ‎12-30-2019

Hi All, I have to display the records of csv file over mail body in tabular format using Putmail. I am extracting records by executing sql which is scheduled at some duration and than forwarding the same using putmail to some specific users. Can someone please tell me how to display the data of generated csv file in tabular format.

Online	Offline
Last Visited	‎10-01-2021 02:25 AM

Member Since	‎12-29-2019 11:18 PM
Last Visited	‎10-01-2021 02:25 AM
Posts	13
Kudos received	1

Cloudera Community

Re: Nifi || Mail || Display csv files content in t...

Re: NIFI || Putdatabaserecord processor error ||In...

NIFI || Putdatabaserecord processor error ||Insert...

Re: Nifi || Mail || Display csv files content in t...

Re: Nifi || Mail || Display csv files content in t...

Re: Nifi || Mail || Display csv files content in t...

Re: Nifi || Mail || Display csv files content in t...

Nifi || Mail || Display csv files content in tabul...