Using parse float while importing the data in the collection

[banerjee...@gmail.com]

Hi Team,

In my application, i am uploading the data into the collection via csv, now the issue is for the two columns, amount from and amount to, i want the data should be converted to be floating type before it enters the collection, since it is backoffice, for manually adding the columns i am using the below code

my_object.credit_amount_from = parseFloat(my_object.credit_amount_from);
my_object.credit_amount_to = parseFloat(my_object.credit_amount_to);,

so by manualy adding i can get the required approvers for this amount in my web interface, but while i am trying to get the data after uploading through csv, it is not coming the way i want.

I can understand since the data in csv is treated as general, this issue might be occuring,

So please help me out with this

Regards
Somjit

[Murali]

Hi Somjit,

Does your problem resolved ? If not, what is the exact problem you are facing?
As per below code its converting the String value into Integer.

Regards,
Murali

[Somjit Banerjee]

Hi Murali,

No my problem is not solved yet, the issue is when i am uploading the data into the collection via csv, then i am unable to get the set of approvers for a particular amount range, but while i am manually adding the data through back office into the collection i am able to get the set of approvers, for that particular range of amount,

Now the below code ,

my_object.credit_amount_from = parseFloat(my_object.credit_amount_from);

my_object.credit_amount_to = parseFloat(my_object.credit_amount_to);

i am using in the back-office, i want this similar kind of thing while upload the data throgh csv, so that before inserting into the collection the strings get converted to integer.

Regards,

Somjit

[Murali]

Hi Somjit,

If you require further assistance on this issue, i can arrange for a discussion with Business Development team.

Regards,
Murali

[yves.d...@gmail.com]

Hello Somjit,

Your issue seems similar to the one I've faced a couple of months ago. It's now solved. See here https://groups.google.com/a/runmyprocess.com/forum/#!searchin/supportforum/yves/supportforum/_pLI8gR2Lj8/K_9yBwn4BREJ

Hope it helps

Regards
Yves

[Somjit Banerjee]

Hi Yves,

Thanks for the help, it's working for me now.

Regards,

Somjit