question Re: none of the fields in the records map to the columns CSV to putDatabaseRecord in Support Questions

none of the fields in the records map to the columns CSV to putDatabaseRecord

sachith — Wed, 16 Oct 2019 13:03:03 GMT

I am trying to read a csv file and put those records into a postgres table. To do it, I have used some tips given Loading a simple CSV file using nifi.

My template is :

GetFile -> UpdateAttribute -> PutDatabaseRecord

In UpdateAttribute I have used `schema.name` -> `postgres database`

In PutDatabaseRecord ->

CSVReader

AvroSchemaRegistry

DBCPConnectionPool

My CSV file

```

userid,username

1,'sachith'

```

When I put this to my source folder, it goes to PutDatabaseRecord and gives following error

> None of the fields in the record map to columns defined by the nifi.nifiTest table.

First I used MySQL just with GetFile -> PutDatabaseRecord, it was working properly without error.

What am I missing here? I am pretty new for Nifi.

Re: none of the fields in the records map to the columns CSV to putDatabaseRecord

sachith — Mon, 21 Oct 2019 12:17:35 GMT

I have fixed this issue with the help of my supervisor. I have used only two processors.

GetFile and PutDatabaseRecord.

Two changes made for `PutDatabaseRecord` Processor

1) Schema name : public

2) Translate field names : false

Also didnt use AVRO reader.

I hope this would help someone.

Re: none of the fields in the records map to the columns CSV to putDatabaseRecord

Souleater — Wed, 04 Dec 2019 22:43:47 GMT

AvroReader is required in PutDatabaseRecord, I have the same issue, how you solve it?

Re: none of the fields in the records map to the columns CSV to putDatabaseRecord

sachith — Thu, 05 Dec 2019 03:30:34 GMT

Sorry, I havent use AVRO, as my scenario entirely based on csv data. I think posting a new question may give attention from community.