Questions tagged as 'csv'

Tagged questions
1
answer

Import PHP CSV file

I have a CSV file with contacts. I want to import these contacts into an sqlite database. How can I read the file and insert it into the database?     
asked by 10.11.2014 / 12:59
1
answer

Ruby on rails read csv file and fill table

I have the following news table: create_table "noticia", force: true do |t| t.integer "conteudo_id" t.integer "entidade_id" t.integer "imagem_id" t.string "texto" t.datetime "created_at" t.datetime "updated_at" e...
asked by 24.06.2014 / 15:05
0
answers

Data import error in R [closed]

Hello! I minded a base I ordered via LAI for R. I was sent in excel, but I converted to csv by work facilities. I know that by transforming all the data from the columns of "character" to "numeric", one of them gets the values multiplied by 1000...
asked by 01.12.2018 / 19:09
0
answers

How to convert a CSV file to HDF5 without code, is it possible? [closed]

I need to convert a file .csv to hdf5 to use in RapidMiner to create templates. However, I've been looking for and only find solutions using Python and other programming languages. As I have no knowledge in any of the lan...
asked by 16.10.2018 / 20:12
0
answers

CSV file via FTP automatically

Dear, I have a doubt, I have a script in php that already creates a CSV file for the machine itself. I need this CSV to be sent to an FTP automatically every day, however I can not think of the logic of joining the two scripts, given that it is...
asked by 21.06.2018 / 21:22
0
answers

Duplication of values when importing .csv file when there is one or more column (s) missing in the file

When I import a .csv file to save to the database and the file is missing the name of some column instead of inserting null in the database, it repeats the value of the first column. Here's an example; $sourcePath = $_FILES['fileTabelaTes...
asked by 24.05.2018 / 22:37
0
answers

Import of CSV (which is inside a zip) received by email automatically to the Spreadsheet

What happens is that every day I receive an email with an attached report. This attachment is zipped (.zip), and inside this zip has a CSV file. I need this zip to be converted to CSV and that this CSV will automatically go from my email (gma...
asked by 02.04.2018 / 13:47
0
answers

Set file cell * .CSV as merged

Is it possible to have a particular cell merged into a generated * .csv file? I'm asking because I'm generating a * .csv file where the user should only make a Ctrl + C \ Ctrl + v in the content and paste it into a standard workshe...
asked by 10.11.2017 / 16:26
0
answers

Python Pandas CSV

I started learning Python a short time ago and I'm doing a project to normalize client data. But I do not know how to make a comparison of type: reads the CSV field the CP7, searches for all CP7 of the CSV CTT and writes in the table PN...
asked by 02.06.2017 / 16:25
1
answer

Import csv without duplicate records

I have a worksheet with 32000 records, and I need to play to a table in the database. The problem is that in this worksheet I do not have the ID of the records and I can not let it duplicate when I import. I need to make that when I do the impor...
asked by 12.04.2017 / 20:38