Hi,I'm facing error while migrating data from excel sheet.How can I check with one or two records at first if it is getting migrated properly?As, after debugging I'm getting below error.
Hi Ayushi.
ExceltoRecordlist doesn't give you an option to process only selected rows. Because it matches the excel binary data with the structure given and try to load everything into the recordlist. For more advanced options like reading only selected rows/sheets, skipping empty rows etc. you can use a forge component like Advanced Excel
Hi @Prashanth G Thanks for sharing our feedback on this.It is really helpfulThanks Regards,Ayushi
Hi @Ayushi Kumari ,
According to the error, please check the Excel data; there may be string values in a boolean column. Please correct the data.
If possible, share your OML file, Excel data, or structure attributes and table column details, so I can review them and assist you further.
Thanks,
Vipin Yadav
Hi @Vipin Yadav Thanks for sharing our feedback on this.It was actually this issue only.Thanks Regards,Ayushi
Hi @Ayushi Kumari
The error message is very clear, It means the structure (Record Definition) you associated with ExcelToRecordList widget is expecting a boolean value (true or false) for column 'Online Public Registration Required' but in excel file its not boolean,
To overcome this you can allow person to only select true or false value in excel column, It means the excel template should be same for all users who'll fill excel sheet.
Hope its help!
ThanksDeep
Hi @Deepsagar Dubey Thanks for sharing our feedback on this.It was actually this issue only.Thanks Regards,Ayushi