Questions tagged as 'csv'

Tagged questions
1
answer

Help with condition to mount csv layout with php

I am generating a .CSV for an import where it is returning me the data as you can see in this gist:   link What happens is that I have 2 treatment lines: 1: M;123;CSV PRODUCAO;22/05/2017 2: *P;30080 ;7891 ;180;163,74 ;160;30080 JOAO SI...
asked by 30.06.2017 / 03:28
1
answer

How to use Python integrated with .CSV

Good morning. I have to read a field (line) from a file in .csv and fill a certain field in the system. How should I do? For example, my .csv is mass of data for filling in a record.     
asked by 21.06.2017 / 18:19
0
answers

How to group numerical sequences?

Friends, I have a csv file with 5k lines which lists shopping transactions. There is an id for each purchase, it happens that for a lot where several purchase transactions are performed there is an id that always starts with the same numerical s...
asked by 10.06.2017 / 00:24
4
answers

Excel transpose row to column and preserve columns and replicate them online

Good morning! Next, I have a csv as follows A; B; C; D; 1; 2; 3; 4; 5 E; F; G; H; 6; 7; 8; 9; 10 The columns of letters have a regular structure, and those of a number not but it could explode them and put them in columns but it will...
asked by 10.05.2017 / 16:59
1
answer

input type file does not load .CSV file

Hello, I'm trying to get the data from a .CSV file with php, but when I use the input file to get the .csv it's not loading html code <form id="form" name="form" action="add_analise.php" enctype="multipart/form-data" method="POST">...
asked by 05.05.2017 / 04:17
1
answer

How to import CSV file to MySQL? error 1295

How to import a CSV file into MySQL? I get error code 1295:    ERROR 1295: 1295: This command is not supported in the prepared   statement statement yet SQL Statement I sent the command: LOAD DATA LOCAL INFILE 'caminho_do_arquivo' INTO...
asked by 25.04.2017 / 19:31
1
answer

How to extract data from a Django QuerySet

I have a table with some information, the name of the employee, pis, date and time, the time field records the time of the record in the point clock, these records are all in the same column, for example: Employee 1, has four check in, check in,...
asked by 21.11.2016 / 21:24
1
answer

How to save data from a JSON consisting of arrays?

Hello. I have a JSON that has the following structure: { "_id": { "$oid": "3432fa43242" }, "posts": [{ "thread": { "uuid": "2911da", "url": "http://www.google.com", "site_full": "opiniaoenoticia.com.br",...
asked by 25.09.2016 / 22:51
0
answers

Bug reading csv per http request (WebService)

I'm having trouble reading a csv file through http request. It would be a RESTFul webService that receives a csv and uses its content. I have already tried to read it in different ways, with opencsv, JavaCsv .. Anyway, the bug I'm having is that...
asked by 01.07.2016 / 21:22
1
answer

Create a * .csv file with data found from a file

I'm developing a project that extracts information from a * .pdf file, I was saving this information in a * .txt file, but now I was asked to save this information in the form of a worksheet, I want to create a * file. csv, but the only way I fo...
asked by 15.08.2016 / 20:46