Data dodania Pytanie
2017-11-30 15:11 How to save item in DataMapper database in to a CSV and download it to the browser using Ruby/Sinatra? »
I am currently using Ruby and Sinatra. I have a DataMapper DataBase. When the user clicks a button asking for a report of the DB contents, I want to...
(0) odpowiedzi
2017-11-27 20:11 Writing RDD Data to CSV with Dynamic Columns in Spark - Scala »
I am reading multiple files from an HDFS directory, and for each file the generated data is printed using: frequencies.foreach(x => println(x._1 +...
(2) odpowiedzi
2017-11-27 06:11 How to compare column value in csv »
I tend to compare two column value like: name columnA columnB hahaha [123] 123 one with square brackets,one without squar...
(1) odpowiedzi
2017-11-21 22:11 How to sort a file alphabetically by named column, python, csv »
I have three csv files each with three named columns, 'Genus', 'Species', and 'Source'. I merged the files into a new document and now I need to alpha...
(1) odpowiedzi
2017-11-21 20:11 _mysql_exceptions error(1064, "check the manual that corresponds to your MySQL server version for the right syntax to use near 'default) VALUES »
I am trying to import CSVs to mysql database automatically using python script. I used the script from https://bitbucket.org/richardpenman/csv2mysql t...
(2) odpowiedzi
2017-11-16 23:11 Using \COPY to load CSV with JSON fields into Postgres »
I'm attempting to load TSV data from a file into a Postgres table using the \COPY command. Here's an example data row: 2017-11-22 23:00:00 "{\"i...
(2) odpowiedzi
2017-11-11 18:11 Send large csv file to ASP.net Core 2 web api method in chunks »
I have a requirement where I need to import csv from a client browser app (built using Angular4) and send that to a web api (built using ASP.net Core ...
(0) odpowiedzi
2017-11-06 10:11 How to filter csv file? »
I have a csv file containing random data but I want to filter the data from the file. I want to filter all rows that have contents starting with $ and...
(1) odpowiedzi
2017-10-29 20:10 PHP download a specific row from database table »
I'm learning PHP right now and connecting to MySQL. I'm able to connect to a table called "info" and display the "date", "time", and "data" of each ro...
(1) odpowiedzi
2017-10-27 16:10 How to add names to an array of unnamed JSON objects? »
So I'm currently using csvtojson in order to convert a csv file to, well, json, and my code is returning an array of unnamed objects. However, I want ...
(2) odpowiedzi
2017-10-27 15:10 Returning CSV from .NET Core controller »
I'm having trouble having a .NET Core API Controller endpoint resolve to a CSV download. I'm using the following code which I pulled from a .NET 4.5 ...
(2) odpowiedzi
2017-10-21 10:10 Reorder CSV rows »
I have this code which basically reads a CSV and should output a table where the CSV row content should be reordered! Example : fish;4;1;33 fish sh...
(1) odpowiedzi
2017-10-15 21:10 Python psql \copy CSV to remote server »
I am attempting to copy a csv (which has a header and quote character ") with python 3.6 to a table on a remote postgres 10 server. It is a large CSV ...
(1) odpowiedzi
2017-10-15 11:10 Converting json like data to csv »
data file looks like the below. Note that the tags and values are not necesirly fixed (i.e. one file may have 10, next 30, 31 etc) { 1=648749...
(0) odpowiedzi
2017-10-07 00:10 How to import a csv-file into a data array? »
I have a line of code in a script that imports data from a text file with lots of spaces between values into an array for use later. textfile = open(...
(2) odpowiedzi
2017-10-01 12:10 Scraping and storing in CSV in Ruby »
I am a Ruby-newbie and I tried my first scrapper today. It's a scrapper designed to store recipes in a CSV file. Nevertheless, I can't figure out why ...
(3) odpowiedzi
2017-09-29 03:09 How to customize jquery datatables export such as PDF Excel Print and CSV? »
I am using a jQuery DataTables from datatables. I want to customize the export files plugin of those tables such as CSV, Excel, PDF and the Print butt...
(1) odpowiedzi
2017-09-20 08:09 Writing the content of a csv file to PostgreSQL with NPGSQL fails »
I am writing the Content of a csv file to a PostgreSQL table with help of NPGSQL in version 3.2.5. The content of my csv is the following id, value ...
(1) odpowiedzi
2017-09-19 18:09 How to remove headers and second column in CSV in ruby? »
I have a CSV that looks like this: user_id,is_user_unsubscribed 131072,1 7077888,1 11010048,1 12386304,1 327936,1 2228480,1 6553856,1 9830656,1 10158...
(5) odpowiedzi
2017-09-18 04:09 Java: how to filter incoming files by filename, not extensions? »
I currently have a simple program that inserts data into a mysql database table like so: System.out.println("New path created: " + newPath); ...
(2) odpowiedzi
2017-09-14 08:09 Datatables:Trying to get selected radio buttons values of each table row in csv format »
I am using jquery datatable plugin. What I am trying to do is to get all selected radio button values in CSV (comma separated values) format. As there...
(2) odpowiedzi
2017-09-14 02:09 How can I read CSV with strange quoting in ruby? »
I have CSV file with some line like: col1,col "two",col3 so i get Illegal quoting error and fix that by setting :quote_char => "\x00" ["col1", ...
(2) odpowiedzi
2017-08-30 12:08 PHP: exporting mysql database into CSV based on 2 columns? »
I have a users table in mysql database and each user has a referral_code column and a referral_code_used column. The referral_code holds the users re...
(2) odpowiedzi
2017-08-26 09:08 Why does this Free Monad Interpreter not resolve String to Id[A] »
I've been playing with Free Monads of Cats. I have written a DSL to process CSV Records. The primitive operation is to process CSV Record and I have w...
(1) odpowiedzi
2017-08-18 10:08 Error unicode export csv file - Laravel/Excel »
I have a problem, can you guys help me ? I use Maatwebsite/Laravel-excel to export japanese text from database to csv file. When I open export file ...
(1) odpowiedzi
2017-08-15 23:08 How to plot date data evenly along x-axis? »
I am plotting data from a csv file with the values on the y-axis and the date on the x-axis. My dataset only includes data from June, July and August ...
(2) odpowiedzi
2017-08-08 18:08 Rails 4 ActiveAdmin CSV export yields "You are not authorized to perform this action." in browser »
I am using "out of the box" installations of Devise gem and ActiveAdmin gem in my Rails 4 project. I have an ActiveAdmin model that works fine as an i...
(1) odpowiedzi
2017-08-06 15:08 Ruby - CSV Import split data into different tables »
I'm trying to import a csv file with a rake task. The csv looks like this model,brand,type,engine,price,doors Corsa,Opel,cupe,1100,14500,2 Corsa,Opel...
(1) odpowiedzi
2017-07-27 18:07 Rails 4: Parsing large csv file »
I have a very large csv file that I need to read, parse, and then present the user with the data so they can make adjustments / verify that things loo...
(1) odpowiedzi
2017-07-13 13:07 Csv file content replace use regex »
I've the CSV file and contents has below "Jakins, Ann-Margaret",Ms.,Ann-Margaret, ,Jakins,Ms. Ann-Margaret Jakins,Individual,Nurse_Practitioner,Femal...
(2) odpowiedzi
2017-07-13 09:07 Ignore html the data in html data-* attribute while exporting to csv jQuery datatables »
I am using jQuery data-tables export buttons to export data as CSV from my tables. The table has a title column in which each title is diplayed as a ...
(0) odpowiedzi
2017-07-07 20:07 HttpResponseMessage Content Disposition "attachment" is not added in Api Controller »
I have a controller with some of the stringbuilder/input details omitted: public class SampleController : ApiController { [HttpGet] [CustomRo...
(0) odpowiedzi
2017-06-30 21:06 How to keep JSON : in CSV output instead of =>? »
A json field ui_layout in postgres table needs to be exported to CSV in Rails 4.2. The ui_layout looks like it in postgres table: {"val":"test","val1...
(1) odpowiedzi
2017-06-29 02:06 In Rails, how can I submit a form and request a csv formatted page? »
I have a few parts of the solution, but I'm having trouble bringing them together. I have a page with two text fields (in a form_tag) in which I'll ...
(2) odpowiedzi
2017-06-27 07:06 Is there a way to force ASP.NET Web API to return data in csv feed format? »
Currently Using ASP.NET web API I'm able to return data in JSON format. Now I'm trying to return data in csv (feed) format. Is it possible to force...
(3) odpowiedzi