SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the board
Thread view  Mix view  Order
TCT(R)

15.03.2015, 14:27
 

Chart List Import problem (General)

Hi,

First of all, for producing such a good program, please accept my sincere thanks!

A few days ago I downloaded and it and work about on...


My mother language is Turkish and I live in Turkey. In our country GL chart has over 300 items. I prepared 2 files for it, one in iso-8859-9 and other one utf8 form.

This is the any one line from this SQL for your info:
"
insert into chart (accno,description,charttype,category,gifi_accno,link) values ('103','Verilen Çekler Ve Ödeme Emirleri(-)','A','A','AR_paid:AP_paid','');
"

When I want to import complete GL chart SQL file from my computer, can see all on monitor, but after the latest click on button, get the following error:

"
DBD::Pg::db do failed: ERROR: value too long for type character(1) at SL/AM.pm line 122.
Content-Type: text/html
Error!

INSERT INTO chart
(accno, description, charttype, gifi_accno, category, link,
contra)
VALUES ('','description',
'charttype', 'gifi_accno',
'category', '', '0')
ERROR: value too long for type character(1)
"
Would you please check it where goes it to wrong?

Sincerely,

Tayfun

Dieter Simader(R)

16.03.2015, 11:09

@ TCT

Chart List Import problem

» Hi,
»
» First of all, for producing such a good program, please accept my sincere
» thanks!
»
» A few days ago I downloaded and it and work about on...
»
»
» My mother language is Turkish and I live in Turkey. In our country GL chart
» has over 300 items. I prepared 2 files for it, one in iso-8859-9 and other
» one utf8 form.
»
» This is the any one line from this SQL for your info:
» "
» insert into chart (accno,description,charttype,category,gifi_accno,link)
» values ('103','Verilen Çekler Ve Ödeme
» Emirleri(-)','A','A','AR_paid:AP_paid','');
» "
»
» When I want to import complete GL chart SQL file from my computer, can see
» all on monitor, but after the latest click on button, get the following
» error:
»
» "
» DBD::Pg::db do failed: ERROR: value too long for type character(1) at
» SL/AM.pm line 122.
» Content-Type: text/html
» Error!
»
» INSERT INTO chart
» (accno, description, charttype, gifi_accno, category, link,
» contra)
» VALUES ('','description',
» 'charttype', 'gifi_accno',
» 'category', '', '0')
» ERROR: value too long for type character(1)
» "
» Would you please check it where goes it to wrong?
»
» Sincerely,
»
» Tayfun

character set for dataset and the character set for the imported data must match.

TCT(R)

16.03.2015, 14:28

@ Dieter Simader

Chart List Import problem

» » Hi,
» »
» » First of all, for producing such a good program, please accept my
» sincere
» » thanks!
» »
» » A few days ago I downloaded and it and work about on...
» »
» »
» » My mother language is Turkish and I live in Turkey. In our country GL
» chart
» » has over 300 items. I prepared 2 files for it, one in iso-8859-9 and
» other
» » one utf8 form.
» »
» » This is the any one line from this SQL for your info:
» » "
» » insert into chart (accno,description,charttype,category,gifi_accno,link)
» » values ('103','Verilen Çekler Ve Ödeme
» » Emirleri(-)','A','A','AR_paid:AP_paid','');
» » "
» »
» » When I want to import complete GL chart SQL file from my computer, can
» see
» » all on monitor, but after the latest click on button, get the following
» » error:
» »
» » "
» » DBD::Pg::db do failed: ERROR: value too long for type character(1) at
» » SL/AM.pm line 122.
» » Content-Type: text/html
» » Error!
» »
» » INSERT INTO chart
» » (accno, description, charttype, gifi_accno, category, link,
» » contra)
» » VALUES ('','description',
» » 'charttype', 'gifi_accno',
» » 'category', '', '0')
» » ERROR: value too long for type character(1)
» » "
» » Would you please check it where goes it to wrong?
» »
» » Sincerely,
» »
» » Tayfun
»
» character set for dataset and the character set for the imported data must
» match.

Thanks, I did not find this important info in your e-book.

I have now another idea to solve the matter...

First template1 export in PostgreSQL as usual text SQL file,
second open it in text editor and save as utf8 formatted text SQL file,
third import this utf8 formatted SQL to PostgreSQL as template1 (now it is in utf8 format),
fourth test it for working and try it to import my utf8 formatted GL Chart List...

Hope it works properly!

Perhaps it may work

Back to the board
Thread view  Mix view  Order
986 Postings in 325 Threads, 327 registered users, 91 users online (0 registered, 91 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum