• From: South Africa
  • Registered: 07/01/2017
  • Posts: 64

Topic: Bank Import: A non well formed numeric value encountered in file

Hello.

I had to do a reinstall to address an incorrectly configured primary bank account.

Now when I try to import the csv files that worked before (as a Deposit or Payment import), I get:

       A) 2:10601 in red where 10601 is the GL code for the current bank account, residing under the header 1060 Bank Accounts

       B) Error messages: "A non well formed numeric value encountered in file:  /var/www/html/accounts/modules/import_transactions/includes/import_transactions.inc at line ........" ( line numbers are mentioned)

As far as I can ascertain the format of the CSV file is correct.

Can anyone advise me on how to fix please?

Regards

Regards Barry
  • From: South Africa
  • Registered: 07/01/2017
  • Posts: 64

Re: Bank Import: A non well formed numeric value encountered in file

Hi. I managed to fix the problem myself. I was using LibreOffice Calc to format the CSV import file and for some reason, in the specific import file, the character formatting in 2 columns was set to an unknown locale. When I selected Format as US English for the column and save the file as a CSV the problem was eliminated.

Regards Barry