01-12-2022 02:28 PM - last edited on 05-24-2023 12:09 PM by JackLacava
SOURCE: ONESTREAM CHAMPIONS
Hi Team,
I am facing a typical issue ( Error Msg 1) while uploading the data from an excel. where as the code for csv upload works fine. Refer the Code attached here by for reference.
can any one help here to find what wrong am i doing in the below code.
Also i want to fetch the range selected somewhere in the error log… or the message box… how to achieve that ?
Also i could not find and XF Market place solution which enables this excel upload feature, Any guess on that as well.
Regards and Thanks
Darpan Bhansali
01-12-2022 02:29 PM
01-12-2022 02:29 PM
Hi Darpan,
the variable tbRangeContent is not a string and that is what the logmessage needs. you can simply add .tostring after the tbRangeContent in the brapi and it will convert its contents to a string and show to you in the error log.
01-12-2022 02:30 PM
Hi Marc,
Point noted , it worked partially, it removed the error , but all the excel data records were not displayed in Error Message ( where we intend to log them )
Also 1 more question - is there any difference between the two functions mentioned in below screenshot ?
i could see in both the cases data is being saved.
Regards
Darpan Bhansali
01-12-2022 02:39 PM
Thanks Marc for the honest response
i will try to read some more documents and dig further into the same, will update here, if got a chance to find the difference.
Regards
Darpan
01-12-2022 02:41 PM
I dont think there is a difference in operation. They both do the same thing. One does it by reading the fields from EXCEL, the other one you are providing the fields tokens. I’m in the process of creating a 3 part video series that explains how LoadCustomTableUsingDelimitedFile works.
01-12-2022 02:41 PM
The one explaining is scheduled for Tuesday.
The one below is the first. However, there is nothing that interesting in this one.
https://www.youtube.com/watch?v=a7-WdJ7SOu4
01-12-2022 02:41 PM
Here is the second video in the series that explains what LoadCustomTableUsingDelimitedFile is doing.