DEV Community: NardjesBen

Add onclick event to material table react js

NardjesBen — Mon, 30 Aug 2021 17:36:35 +0000

I need to retrieve data from the server then I display this data in a table and if a user clicks on a button in the table he can download the file

Here is my data :

files = [ {name : "file1", created_at: "29/01/2021"},
          {name : "file2", created_at: "20/03/2021"}]

table headers :

const tableColumns = [
  { title: "name", field: "name" },

  {
    title: "Date",
    field: "created_at",
    type: "date",
    dateSetting: { locale: "en-GB" },
    filterComponent: (props) => <CustomDatePicker {...props} />
  }
];

My array :

{file && (
<Fragment>
<MaterialTable
columns={tableColumns}
data={file}
title="Material Table - Custom Filter Component"
options={{search: false, filtering: true }}

actions={[
  {
    icon: 'save',
    tooltip: 'Save User',
    onClick: () => window.open('http://localhost:5000/files/' + file.name, '_blank').focus()
  }
]}
/>
</Fragment>)}

I get the error: ENOENT: no such file or directory, stat '/Users/admin//files/undefined'"}

how can i use in react js the link of each file, i tried to use the map function on my data but it doesn't work

Ignore headers of csv files with papaparse

NardjesBen — Sun, 27 Jun 2021 18:33:33 +0000

I have a csv file that I need to parse and store in a database. I use sequelize for this

Here is how I defined the model of my table in sequelize :

    const Person= sequelize.define(
      'person',
      {
        id: {
          type: DataTypes.UUID,
          primaryKey: true,
          defaultValue: uuidv4(),
          allowNull: false
        },
        name: {
          type: DataTypes.STRING,
        },
        age: {
          type: DataTypes.INTEGER,
        }
        }, {
            createdAt: false,
            updatedAt: false,        
            tableName: 'person'
         }
    )
    return Person
  }

then I have a csv file "test.csv":

he ,dd
liza, 23
sarah, 22

basically I can't change the headers in my csv file and I have to keep the same structure defined in the db, I use papaparse to parse this file :

        const papa = require('papaparse');
        const fs = require('fs')

        const file = fs.createReadStream(__basedir + "/test.csv");


        papa.parse(file, {
          header: true,
          step: async function(results, parser) {
            console.log("Row data:", results.data);
            try{
              await Person.create(results.data)

            }catch(e){
              console.log(e)
            }

          }
      });

in output I get the following error :

SequelizeUniqueConstraintError: Validation error

the name, surname and age fields are null in the database

I am looking for a solution to ignore the headers of the csv file, how can I do that?

Combine React js with Node Js ?

NardjesBen — Wed, 12 May 2021 13:01:06 +0000

I am a beginner and I would like to make an application with :

Front-end : React js
Back-end : Node js

my interface will contain 2 buttons : Download and Send, I would like to download csv files from a sftp server and when we click on download files will be displayed in the interface and the send button allows to send files from my local machine to the sftp server.

How can I combine the react and node part, I was able to connect and upload files in nodejs but I don't know how to combine that with React?