Import currency field

Injenia · 31 May 2016 08:16

Hi,

I’m using SuiteCRM 7.2.2

I have a custom modules with some currency field.
Default and also user currency is EUR (€)

I’m trying to import data from a txt file (tab separator) where I have some numeric value (decimal separator is comma (,) and 1000s Separator is none
I have two decimal digits (example 1110,00)

During import I set up correctly the parameter (decimal separator, decimal position, …), but the value was always multiplied by 100

So, at the end, instead of 111,00 I have 11100,00 (the same for 74,20 that became 7420,00

How can I import this data?

In the attached file an example of file I need ti import

Thanks

Kind Regards

Matteo

vger72 · 25 August 2016 00:33

I have the same problem.
Any developments on that ?

vger72 · 5 October 2016 23:20

What’ve found is that it does not multiply by 100. It just ignores the decimal separator.

If in the Admin -> Locale I set the default decimal and 1000s separators ( dot and coma ) and the same in user preferences and Import properties, all is ok.
If one uses non default ( for example, dot for 1000s separator and coma for decimal separator) the import function ignores it.

Ivanams · 4 July 2023 17:55

hi @pgr , i have this problem but i try diferent solution but i can´t import amount correctly.

When i import 71,50 , in importa give 7150,00 .

Can you help us?

Versión 7.13.1
Sugar Versión 6.5.25 (Compilación 344)

pgr · 5 July 2023 11:17

You posted in a 7-year old thread, and mentioned someone that is not even in the thread…

I guess this is what you’re experiencing:

github.com/salesagility/SuiteCRM

Fix #9880 - Error when importing currency fields with a decimal separator

salesagility:hotfix ← SinergiaTIC:issue_9880

opened 05:24PM - 02 Jan 23 UTC

SinergiaCRM

+8 -1

resolve #9880 ## Description If the decimal separator is set to a comma "," in… the user's settings, an error occurs when importing currency fields that include decimals because the decimal separator is removed and the result is the value of the field multiplied by 100. The error was caused by the filter set for importing currency fields being incorrect, as it passes the same filter as float fields, when a currency field, after the currency symbol is removed, should follow the same treatment as a decimal field. This is what has been implemented in the solution. ## Motivation and Context Prevent errors when importing currency fields with different types of decimal separators. ## How To Test 1. Set the decimal separator to a comma “,” in the user's settings. 2. Import a record from the Opportunities module with the Opportunity Amount set to a decimal value, for example 1,12. 3. Verify that after the import, the Opportunity Amount field has been set to 1,12. ## Types of changes - [X] Bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds functionality) - [ ] Breaking change (fix or feature that would cause existing functionality to change) ### Final checklist - [X] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/). - [ ] My change requires a change to the documentation. (It would be nice to specify in the documentation that the inheritance of security groups is applied exclusively at record creation time.) - [X] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.

try that fix and tells us if it works.