Data dodania Pytanie
2017-01-15 18:01 Error Transaction.new into Rails app trying to import CSV data »
I try to import a CSV file into my database in a Rails app. I follow this gist. Here is my code: # db/seeds.rb require 'csv' csv_text = File.read(R...
(1) odpowiedzi
2017-01-04 22:01 DataTables for large CSV files »
I'm using datatables to display data from a CSV file. Some 60k rows. All works well apart from it obviously takes ages (over 70s) to display <?php...
(0) odpowiedzi
2017-01-04 15:01 How to COPY CSV as JSON fields »
Is there a way to COPY the CSV file data directly into a JSON or JSONb array? Example: CREATE TABLE mytable ( id serial PRIMARY KEY, info jS...
(1) odpowiedzi
2016-12-24 22:12 Sinatra Display CSV entries »
How do i display data from a csv file into a Sinatra-App? Sinatra: csv = CSV.read(data.csv) csv.each do |entry| @output = "#{entry[1]},#{entry[4...
(2) odpowiedzi
2016-12-19 07:12 Split column values in postgres »
I have one table with two columns id and data. The values in the table are as follows: id|data| 1 |A,B | 2 |B,C | 3 |C,D | 4 |D,A | 5 |E,C | I need...
(1) odpowiedzi
2016-12-18 23:12 How to extract data tables trapped in scanned pdf »
I have data tables trapped in scanned PDFs. I want to extract these tables into CSV files. Something similar to tabula in jruby is preferred. ...
(0) odpowiedzi
2016-12-17 20:12 Fast extraction of chunks of lines from large CSV file »
I have a large CSV file full of stock-related data formatted as such: Ticker Symbol, Date, [some variables...] So each line starts of with the s...
(3) odpowiedzi
2016-12-15 15:12 What's a fast and simple way to change a CSV sort order from a shell script? »
I have some CSVs with many columns per record; some are integers, some are (short) quoted strings. All CSVs have the same columns (and data types in t...
(1) odpowiedzi
2016-11-29 23:11 How can I export my bookmarks and import them into a table? »
I have hundreds of bookmarks that I have collected over the years that I would like to put into a searchable table with extra information such as cate...
(2) odpowiedzi
2016-11-21 14:11 How to replace comma in .xlsx file in ColdFusion? »
I have excel file that can contain commas in some fields. This can cause problem if I want to use cfspreadsheet to convert my file to csv. I was wonde...
(1) odpowiedzi
2016-11-21 13:11 Laravel whereBetween and Exporting result to CSV »
I'm using Matt Stauffer CSV export package. Using Reporting::all() I get the expected result and the CSV report is downlooaded successfully. But usin...
(1) odpowiedzi
2016-11-20 05:11 Wordpress Timeout »
I am a back end dev for a WordPress website: https://westtechshipping.com. The admin side is where the majority of our time is spent. We deal with ...
(0) odpowiedzi
2016-11-19 19:11 Writing a list to a CSV file »
I've got a piece of code that extracts coordinates from a KML file. It works beautifully and prints to the screen the way I'd want it to print to a C...
(1) odpowiedzi
2016-11-13 21:11 Letter with accent is not appearing properly in my Rails console, Postgres database or Webpage »
I have a Microsoft Excel file (saved as a CSV file) that contains a list of names. A few of the names have letters with an accent over it, like so: M...
(0) odpowiedzi
2016-11-11 19:11 Write dict to csv file with keys not in alphabetic order »
I know that when using python to write dicts to csv files, the headers will be put in alphabetic order. So is there a way that I can write the header ...
(3) odpowiedzi
2016-11-10 14:11 How to aggregate values over a bigger than RAM gzip'ed csv file? »
For starters I am new to bioinformatics and especially to programming, but I have built a script that will go through a so-called VCF file (only the i...
(2) odpowiedzi
2016-11-06 19:11 CSV | Text stored as elements of a list »
I am creating a csv file which gathers several articles scraped from a website. The articles are obtained by scraping the text from URLs contained in ...
(0) odpowiedzi
2016-11-03 12:11 How do easily filter CSV data in Ruby »
I am dealing with a CSV file(approx 500 lines). Is there a way to select data from this file with filters. I know I can do this in ruby by parsing the...
(2) odpowiedzi
2016-11-01 21:11 Where is the CSV gem in Rails? »
I’m using Rails 4.2 with Ruby 2.3.0. I want to use the CSV parsing library, which according to the documentation is part of the core Ruby distribut...
(1) odpowiedzi
2016-11-01 18:11 Importing CSV file into postgreSQL but have duplicates »
I am importing CSV data into postgreSQL using Python. I seem to have duplicates in my CSV file. I have five columns in my CSV file and one of them is ...
(1) odpowiedzi
2016-10-31 11:10 How to create CSV from a text file in Ruby »
I need to create a CSV file from a textfile with billing data about my calls. My textfile has a structure like: 01.02.2016 10:35:49 8998775 New York ...
(3) odpowiedzi
2016-10-28 22:10 importing CSV data into postgreSQL using Python »
I am trying to import CSV data I have into postgreSQL using Python. It shows an error near (User) when I run the code. Can someone please provide assi...
(2) odpowiedzi
2016-10-28 16:10 A way to write data from very large csv into SQL database »
I have a multiple csv files with the following content: Duration (ms),Start date,End date,Start station number,Start station,End station number,End s...
(1) odpowiedzi
2016-10-25 11:10 Python MySQL CSV export to json strange encoding »
I received a csv file exported from a MySQL database (I think the encoding is latin1 since the language is spanish). Unfortunately the encoding is wro...
(2) odpowiedzi
2016-10-25 06:10 How to download a csv file in python from a server? »
from pip._vendor import requests import csv url = 'https://docs.google.com/spreadsheets/abcd' dataReader = csv.reader(open(url), delimiter=',', quo...
(3) odpowiedzi
2016-10-24 15:10 Assert Capybara table data »
The app I am testing shows a lot of tables with multiple columns. Each table shows data that the app fetches from different data sources(csv files) wh...
(1) odpowiedzi
2016-10-22 03:10 How to iterate over rows and print out CSV::Table values in Sinatra »
I'm making a simple Sinatra app and have the following 'numbers.csv' file: Name,Title,Phone Ally Smith,Manager,888-552-444 Rick Jones,Director,888-55...
(1) odpowiedzi
2016-10-19 15:10 Get results as CSV from postgresql using hibernate »
I execute a query which should return the results as a CSV to the STDOUT. When I execute my query in the pgAdmin I successfully get results. However...
(2) odpowiedzi
2016-10-18 05:10 rspec to test respond_to format and csv »
I want to test if top_users eq User.top_users in my rspec controller. How do i access the format.csv? I need something like: it 'format csv’ do ...
(1) odpowiedzi
2016-10-13 13:10 Do something else when reached last line of CSV »
I want to do something else when the for-loop has reached the last line, I found some examples online but they all ruined the rest of the code. I want...
(0) odpowiedzi
2016-10-12 10:10 python preserving output csv file column order »
The issue is common, when I import a csv file and process it and finally output it, the order of column in the output csv file may be different from t...
(2) odpowiedzi
2016-10-12 02:10 How to add custom header or title and footer information of company in csv export option of datatable? »
I am using dataTables and trying to add new feature where I can add customized title information or can say customize header and footer information. ...
(1) odpowiedzi
2016-10-10 07:10 Django Integrity Error in Bulk Import via CSV in Admin »
I am trying to implement a CSV Import in Django Admin and save bulk data corresponding to the CSV file's rows. I have a model Employee with a OneToOne...
(1) odpowiedzi
2016-10-01 14:10 How do I create a subdirectory if no one exists when writing to a CSV file? »
I am creating a CSV file like this: CSV.open("#{city}.csv", "a+") do |csv| csv << listing end But, ideally I would like to do r...
(1) odpowiedzi
2016-10-01 13:10 Validation problems while creating record through file import using Roo gem and following railscast »
I am trying to create records through file imports format can be csv excel etc and I have implemented it following the Railscast396. but as I import f...
(1) odpowiedzi