openerp-india team mailing list archive

[Houssine <972482@xxxxxxxxxxxxxxxxxx>]

** Description changed:

  on version 6.0.3 under windows
  
  Trying to import coda files.
  
  It doesn't happen with all CODA file only with the ones from one belgian
  bank.
  
  On the server logs I can see the following stacktrace :
  
- [2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:Sabine RINGELHEIM
-  Partner Account Number:BE51630500209962
-  Communication:Primes exceptionnelles 2010-2011
- 001Sabine RINGELHEIM
- Rue Antoine Breart, 165
- Ordre de paiement : Bénéficiaire : IBAN : BE51630500209962 Sabine RINGELH
- EIM Rue Antoine Breart, 165
-  Communication: Primes exceptionnelles 2010-2011 R
+ [2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
+  Partner Account Number:BE51630500209962
+  Communication:Primes exceptionnelles 2010-2011
+ 001XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
+ XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
+ Ordre de paiement : Bénéficiaire : IBAN : XX51630XXXXXXXXX XXXXXX XXXXXXX
+ EIM XXXXXXXXXXXXXXXXXXXXXXXXXXX
+  Communication: Primes exceptionnelles 2010-2011 R
  éférence du donneur d''ordre : 201203161130024083ISABEL
-  Value Date:2012-03-16
-  Entry Date:2012-03-16
+  Value Date:2012-03-16
+  Entry Date:2012-03-16
  ',E'(''2012-03-16'',)',E'-230.68',NULL,E'general',2645,1,now())
  Traceback (most recent call last):
-   File "sql_db.pyo", line 131, in execute
+   File "sql_db.pyo", line 131, in execute
  DataError: invalid byte sequence for encoding "UTF8": 0xe96ee9
  HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

** Description changed:

  on version 6.0.3 under windows
  
  Trying to import coda files.
  
  It doesn't happen with all CODA file only with the ones from one belgian
  bank.
  
  On the server logs I can see the following stacktrace :
  
  [2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
-  Partner Account Number:BE51630500209962
+  Partner Account Number:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
   Communication:Primes exceptionnelles 2010-2011
  001XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  Ordre de paiement : Bénéficiaire : IBAN : XX51630XXXXXXXXX XXXXXX XXXXXXX
  EIM XXXXXXXXXXXXXXXXXXXXXXXXXXX
   Communication: Primes exceptionnelles 2010-2011 R
  éférence du donneur d''ordre : 201203161130024083ISABEL
   Value Date:2012-03-16
   Entry Date:2012-03-16
  ',E'(''2012-03-16'',)',E'-230.68',NULL,E'general',2645,1,now())
  Traceback (most recent call last):
    File "sql_db.pyo", line 131, in execute
  DataError: invalid byte sequence for encoding "UTF8": 0xe96ee9
  HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/972482

Title:
  [V6]bug importing coda

Status in OpenERP Addons (modules):
  Fix Committed

Bug description:
  on version 6.0.3 under windows

  Trying to import coda files.

  It doesn't happen with all CODA file only with the ones from one
  belgian bank.

  On the server logs I can see the following stacktrace :

  [2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
   Partner Account Number:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
   Communication:Primes exceptionnelles 2010-2011
  001XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  Ordre de paiement : Bénéficiaire : IBAN : XX51630XXXXXXXXX XXXXXX XXXXXXX
  EIM XXXXXXXXXXXXXXXXXXXXXXXXXXX
   Communication: Primes exceptionnelles 2010-2011 R
  éférence du donneur d''ordre : 201203161130024083ISABEL
   Value Date:2012-03-16
   Entry Date:2012-03-16
  ',E'(''2012-03-16'',)',E'-230.68',NULL,E'general',2645,1,now())
  Traceback (most recent call last):
    File "sql_db.pyo", line 131, in execute
  DataError: invalid byte sequence for encoding "UTF8": 0xe96ee9
  HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/972482/+subscriptions