Thread: Import csv file error with double newline

Import csv file error with double newline

From
phuongnh2
Date:
Hi all, help me ! I have scriber log file (text file), content inside file below: 201505012202210SE1457863,201505010104009,,ng0022119089,awttar7p6,A832624640,VLMB,1,ng0022119089,500000,1,201505010104009,2015-05-01 22:02:27 201505012202220SE2778097,201505010104010,,PE0020947080,YZBBLXWDX,S1915202387,VLMB,1,PE0020947080,100000,1,201505010104010,2015-05-01 22:02:28 201505012203570SE1363941,201505010104047,,WC0019824617,9NXZXPW9K,S1915202387,VLMB,1,WC0019824617,20000,1,201505010104047,2015-05-01 22:04:03 postgresSQL: COPY raw_so6_zingpay2015 FROM '/data/scribe_log/so6/2015-04-15/ZingPay_VLMB_BEZPay-2015-04-15_00012' WITH (FORMAT CSV, HEADER, DELIMITER E',', NULL '\n'); ERROR: missing data for column "dbgtransid" CONTEXT: COPY raw_so6_zingpay2015, line 2: "" what is option to double newline ?? thanks, phuongnh2

View this message in context: Import csv file error with double newline
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Re: Import csv file error with double newline

From
Payal Singh
Date:
What's the definition of raw_so6_zingpay2015 ? (\d raw_so6_zingpay2015)

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Wed, May 6, 2015 at 5:44 AM, phuongnh2 <phuongnh2@vng.com.vn> wrote:
Hi all, help me ! I have scriber log file (text file), content inside file below: 201505012202210SE1457863,201505010104009,,ng0022119089,awttar7p6,A832624640,VLMB,1,ng0022119089,500000,1,201505010104009,2015-05-01 22:02:27 201505012202220SE2778097,201505010104010,,PE0020947080,YZBBLXWDX,S1915202387,VLMB,1,PE0020947080,100000,1,201505010104010,2015-05-01 22:02:28 201505012203570SE1363941,201505010104047,,WC0019824617,9NXZXPW9K,S1915202387,VLMB,1,WC0019824617,20000,1,201505010104047,2015-05-01 22:04:03 postgresSQL: COPY raw_so6_zingpay2015 FROM '/data/scribe_log/so6/2015-04-15/ZingPay_VLMB_BEZPay-2015-04-15_00012' WITH (FORMAT CSV, HEADER, DELIMITER E',', NULL '\n'); ERROR: missing data for column "dbgtransid" CONTEXT: COPY raw_so6_zingpay2015, line 2: "" what is option to double newline ?? thanks, phuongnh2

View this message in context: Import csv file error with double newline
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Re: Import csv file error with double newline

From
phuongnh2
Date:
raw_so6_zingpay2015 structure

CREATE TABLE raw_so6_zingpay2015
(
  Col1 character varying(500),
  Col2 character varying(500),
  Col3 character varying(500),
  Col4 character varying(500),
  Col5 character varying(500),
  Col6 character varying(500),
  Col7 character varying(500),
  Col8 character varying(500),
  Col9 character varying(500),
  Col10 character varying(500),
  Co11 character varying(500),
  Col13 character varying(500)
) ;




--
View this message in context:
http://postgresql.nabble.com/Import-csv-file-error-with-double-newline-tp5848154p5848259.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.