error importing CSV columns with Umlaute

[Ferdinand]

autodedect raises error

selecting the columns manualy imports the rows, but unly the first columns till "Geschäftsjahr"

IMHO a UTF-8 mapping issue

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have checked your issue, would you please inform us which particular view did you talk about attached screenshot. So we can easily reproduce same at our end.

Thanks and waiting for your reply.

[Ferdinand (office-chricar)]

It's a custom module to import account_move_lines from a 3rd party system

but you should get the same problem importing periods if OpenERP preference language is "German"

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have tested your issue in germane language as per as scenario but I didn't faced any problem.
I have Import the account period in germane language it is successfully import ".csv" at my end.

"Ende der Periode","Geschäftsjahr","Buchungsperiode","Beginn der Periode"
"2011-01-31","Fiscal Year 2011","01/2011","2011-01-01"
"2011-02-28","Fiscal Year 2011","02/2011","2011-02-01"
"2011-03-31","Fiscal Year 2011","03/2011","2011-03-01"
"2011-04-30","Fiscal Year 2011","04/2011","2011-04-01"
"2011-05-31","Fiscal Year 2011","05/2011","2011-05-01"
"2011-06-30","Fiscal Year 2011","06/2011","2011-06-01"
"2011-07-31","Fiscal Year 2011","07/2011","2011-07-01"
"2011-08-31","Fiscal Year 2011","08/2011","2011-08-01"
"2011-09-30","Fiscal Year 2011","09/2011","2011-09-01"
"2011-10-31","Fiscal Year 2011","10/2011","2011-10-01"
"2011-11-30","Fiscal Year 2011","11/2011","2011-11-01"
"2011-12-31","Fiscal Year 2011","12/2011","2011-12-01"

Would you please check it at your end.

Thanks and waiting for your reply.

[Ferdinand (office-chricar)]

the problem is probably here:

'fiscalyear_id' : fields.many2one('account.fiscalyear','Geschäftsjahr'),

as I need this module only to import csv with German column headers I used the German name directly in py and it seems to work in v6 now - except for import

even if I run OpenERP in English or French, the column headers of the CSV will not change.

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

We are considering the py field name for import compatible output csv file at the time of export data.
This is generic solution what we follows, When you will uncheck the import compatible boolean field in export wizard It always consider the field label in output csv.

Correct me If I am wrong.

Thanks.

[Ferdinand (office-chricar)]

I am not talking about export (compatibility) , I am talking about import of 3rd party accounting data, which supply column header "Geschäftsjahr", and the fact that it seems not possible to import such a file, even if the filed is defined correctly as "Geschäftsjahr" in py.
what works is to define a field "Gechaeftsjahr" and a German translation "Geschäftsjahr" and run the client in German as shown in #4

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have also apply 'fiscalyear_id' : fields.many2one('account.fiscalyear','Geschäftsjahr') into .py file with German

Language and import the data and it is working as expected. I have attached a video check it.

Thanks and waiting for your reply

[Ferdinand (office-chricar)]

a working module (without umlaute) is here
http://bazaar.launchpad.net/~c2c-austria/openobject-addons/c2c_austria_dev/files/head:/chricar_account_move_line_igel/
I attach the module with "Geschäftsjahr"
and a csv file which causes the error

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have tried to install "chricar_account_period_sum" which is depends on module 'c2c_account_closing_remarks'.
which is again a custom module and not available in extra-addons.

Thanks and waiting for your reply.

[Ferdinand (office-chricar)]

why this?

I attached the module "module to install"

chricar_account_move_line_igel.zip

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello,

Following steps for reproduce bug :

(1) First I have installed a module as per comment #11 which is custom module.

(2) Secondly after installation of module import the csv as per comment #10, I have faced the same problem.

I have attached video please check it.

I have tried to import csv for other object "account.fiscalyear" and "account.period", it is working as expected for

the same field label "Geschäftsjahr" with german language.

@GTK Team : Would you please check this for special condition "Auto-Detect" Button will not fine the field.

Thanks.

[Naresh(OpenERP) (nch-openerp)]

Hello Ferdinand,

Thanks for reporting !

The fix has landed at trunk client with revision-info:1985 <email address hidden>

Regards,