Tag Archives: TSV

I will introduce you several way to output sql result into a file with using psql.

Continue reading →

Readers who viewed this page, also viewed:

Code

PHP: Read TSV and CSV

Tuesday March 8th, 2016 Kenji

I wrote the code to handle TSV and CSV.

Continue reading →

Readers who viewed this page, also viewed:

Code

RAILS 4 : Load Seed from TSV and CSV

Tuesday March 8th, 2016 Kenji

At the article Rails 4 : Load Seed from TSV, I wrote about how to inject tsv seed data into your db. This time, I wrote about how to inject not only tsv, also csv seed data into your db.

Continue reading →

Readers who viewed this page, also viewed:

Code

Rails 4 : Load Seed from TSV

Wednesday September 16th, 2015 Kenji

Some days ago, I was requested to enable to load seed data from excel, by my client, in rails 4 project. I told that data to be edited should be managed in database, not excel. But he really requested excel, then I and he decided load data from tsv. Excel is functional, so TSV is appropriate.

Select data area and copy and paste with mouse, Excel data can be pasted as TSV data to text editor, and vise versa.

Environment

Ubuntu 14.04 LTS
Rails 4.1.8
Ruby 2.2.2

Direction

Create feature to load TSV data as a task, and enable to execute with rake.
On executing rake db:seed, execute the task to load TSV.

Continue reading →

The Life

Tag Archives: TSV

PostgreSQL: How to Export SQL Result to File

Readers who viewed this page, also viewed:

PHP: Read TSV and CSV

Readers who viewed this page, also viewed:

RAILS 4 : Load Seed from TSV and CSV

Readers who viewed this page, also viewed:

Rails 4 : Load Seed from TSV

Environment

Direction

Readers who viewed this page, also viewed:

A Life Summary of an Gypsy