Exporting/Importing data in Excel

(1) Share

Report

Posted on by Govinda Kumar

2,304 Moderator

Hello Community,

I want to copy rows from excel to the list page, but I cannot

4645.Untitled.png

If I have a boolean value as YES/NO in excel grids then I can easily copy/paste in list page.

When I export the data from the list page to excel, the boolean fields come as TRUE/FALSE

Good thing is that I import the data with boolean values from excel to the list page through code for both TRUE/FALSE and YES/NO, and it is working fine.

Hence I cannot validate the boolean value as TRUE/FALSE when I copy it from excel, I can only do it for YES/NO.

There are thousands of rows and I cannot make every value as YES/NO if it is exporting in TRUE/FALSE.

Is it possible for me to export the boolean values in excel as YES/NO instead of TRUE/FALSE?? Or what is the solution for my problem..

Regards.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

As of now as you copied all the rows and paste into excel, it choose the default values as per standard, you can not change that, so you need to put the same validation when you are trying to import the values from excel in BC.

Thanks.

Was this reply helpful? Yes No