Questions tagged [csvtojson]

101 questions
0
votes
1 answer

Converting an Excel file to CSV and reading its contents in JSON format

When an excel file is uploaded in my program, it needs to get converted to a CSV file to be read. The process is working fine and I am using asyc/await, however whenever I try to read the file using the csvtojson package in Node, the file does not…
rut_0_1
  • 761
  • 1
  • 11
  • 34
0
votes
0 answers

Is there a way to reverse engineer BeautifulSoup; converting csv content to html?

I am building a website (HTML and CSS) to display and sell my art. At the bottom layer there will be multiple grandchildren, each page dedicated to a single work of art containing the item name, medium, description etc. I have written all the…
0
votes
0 answers

NodeJS and CSVtoJSON file stream

Expected functionality of the code: receive CSV file write it to a temporary directory convert that file to JSON by using csvtojson library add prefix data = to the file create JS file as a result, and write it to a different directory The…
IOOIIIO
  • 589
  • 1
  • 4
  • 13
0
votes
1 answer

Trying to convert a CSV file to JSON format in order to save it in mongodb (spring)

This is my first post in StackOverflow! I have been trying to upload a CSV file, parse it, and create a json file from it. I found this tutorial using Jackson parser: https://kalliphant.com/jackson-convert-csv-json-example/ (I picked that because of…
0
votes
2 answers

Import Vs Require Node issue. Cant we require any module using import?

const csv = require('csvtojson') this works import { csv } from 'csvtojson' but this dont. Can anyone help what the issue here ?
Shubham Singh
  • 199
  • 1
  • 3
0
votes
0 answers

How to read same more than one column having same name in Java

How to read same more than one column having same name in Java Description: I am converting CSV to JSON by reading csv schema and successful into it, but the problem is that the CSV file contains two column having same name, and it is overriding the…
Das Khatri
  • 93
  • 6
0
votes
0 answers

Issue with export in Nodejs

I am running some test scripts. I am using csvtoparse to convert the csv file into json and i am attempting to export the object sets using module.exports. My code is shown below: const csv = require('csvtojson'); async function getData(){ …
SWarr
  • 139
  • 2
  • 9
0
votes
1 answer

Apache NiFi - All the spanish characters (ñ, á, í, ó, ú) in CSV changed to question mark (?) in JSON

I've fetched the CSV file using GetFile processor where CSV have spanish characters (ñ, á, í, ó, ú and more) within the English Words. When I try to use ConvertRecord processor with controller service of JSONRecordSetWriter, it displays the JSON…
Manish Narang
  • 87
  • 1
  • 1
  • 10
0
votes
0 answers

Overload resolution ambiguity - Kotlin

var input = File(response) try { var csv = CsvSchema.emptySchema().withHeader(); var csvMapper = CsvMapper(); var mappingIterator: MappingIterator> = …
0
votes
1 answer

How can I convert my CSV to JSON and save it to MongoDB when uploading multiple files in one form with different mimetypes?

I'm trying to save a form to my MongoDB that includes both an image upload and a CSV upload. I'm using the Node modules Multer and CSVtoJSON to accomplish this. I've been able to accomplish each task on their own, but am struggling with getting them…
jrfii
  • 1
  • 2
0
votes
2 answers

CSVtoJSON returns UnhandledPromiseRejectionWarning: ReferenceError: JavaScript

I am trying to convert CSV from a CSV file to JSON. I have the following code (async() =>…
nad34
  • 343
  • 4
  • 13
0
votes
0 answers

How to read a date from a CSV in a particular format in Nodejs?

I'm trying to read a file using csvtojson module. Date field is getting read as "05-23-2020" & next date is "23-03-2020" . Format which I should use is dd-mm-yyyy. But here in the backend if I try to convert the follwing date "23-03-2020" using new…
sai
  • 487
  • 1
  • 7
  • 16
0
votes
1 answer

What's the best way to create a JSON array with sub-properties from UTF-8 CSV (English & Chinese characters)?

I've tried using the csvtojson module to create a GeoJSON-formatted file, but the nesting isn't working correctly at all. Can anyone point me in the right direction or do I need to write my own code? > npx csvtojson input.tsv >…
carpiediem
  • 1,918
  • 22
  • 41
0
votes
4 answers

Get CSV File From URL & Convert to JSON Array

I need to get data from a csv file hosted on a url and convert it to json array. Till now I'm using this. import request from "request-promise"; import encode from "nodejs-base64-encode"; let url = 'https://example.com/filename.csv'; …
Shan
  • 948
  • 1
  • 9
  • 17
0
votes
1 answer

CSV to Cloudant Import Large data set

I am working on Nodejs based script to import large csv file into ibm cloudant database. My approach for this script is as following: Script1: Download ZIP files from remote server using FTP connection. Script1: Iterate over downloaded zip files…
Mayur Bhatt
  • 65
  • 2
  • 7