Questions tagged as 'csv'

1
answer

read file csv fill out a form

I need to automate a process, I need to read a csv file (generated by an excel) and be able to automatically dump it into a common php web form. Is it possible to do it with these tools? the idea would be, enter a form, and at the time of...
asked by 27.08.2018 / 19:02
2
answers

cURL error 56: Recv failure: Connection was reset

I'm getting data from a csv (approx 9450 rows), and sending it by Guzzle from a Laravel 5.4 to a Lumen 5.4, but when I try to do it, I get this error "cURL error 56: Recv failure: Connection was reset" I use 2 local servers, the native of lar...
asked by 26.08.2018 / 03:12
0
answers

Create CSV from a list of Dictionaries and enclose the data

I have a list of dictionaries like this: lotes = [{'lote': '30045612', 'producto':'nombre_producto1'}, {'lote': '30045613', 'producto':'nombre_producto2'}, {'lote': '30045614', 'producto':'nombre_producto3'}, {'lote'...
asked by 23.08.2018 / 17:21
0
answers

When I read .csv files c # does not detect the values it contains

I have an application that reads .csv files, these files come to me by mail and by means of a macro they are automatically saved in a server directory. The problem is that if the files that are saved automatically by the macro read the program d...
asked by 09.08.2018 / 17:20
1
answer

Problems with INSERT from PHP

I tell you my problem: I have a csv file with a certain amount of data, what I do is open this file and modify some fields that are badly loaded (Phones with spaces, hyphens, etc ...) and then I have to load them in my database. Postgress dat...
asked by 03.08.2018 / 23:03
1
answer

Modify a csv file in python

I have a file in .csv and I want to add a name to each column without modifying its contents. How could I do it? Thank you very much.     
asked by 20.07.2018 / 22:47
0
answers

Replace words from one column in another column in a text

I am trying to replace words from one column in another column in a text: Text:    While these delays were noted, active nuclear power plants have been building individual warehouses within their facilities to store the dangerous spent f...
asked by 18.07.2018 / 17:38
0
answers

Save blank column in Excel CSV

I want to import an Excel CSV file into my database with phpMyAdmin. It turns out, that my table has to store 4 different fields. id , codigo , nombres , apellidos where: id: Is the ID of the table as a primary...
asked by 02.07.2018 / 20:59
2
answers

Undefined offset when opening CSV file in PHP

I have a list of products in a CSV file that I'm trying to pass to a database. This is my code to open the file. $tmp_archivo = "file/catalogo.csv"; $archivo = fopen($tmp_archivo, "r"); $row = 0; if($archivo){ while ($datos = fgetcsv($a...
asked by 05.07.2018 / 15:17
0
answers

Merge JSON files into CSV

I need to combine several Json files (as input files) into a single CSV file (as an output file). I have managed to do it with a single json file with the npm module "json2csv" but I need to do it with several files.     
asked by 16.07.2018 / 22:09