Wow, definitely the best well explained tutorial for converting REF from reading queue items to excel I've ever seen. Thank you for putting this video out there.
Very Informativevideo on REframework with excel..use this condition for all columns IsNumeric(in_TransactionItem("Cash In")) And IsNumeric(in_TransactionItem("On US Check")) And IsNumeric(in_TransactionItem("Not On US Check"))= true
if you are facing issue in the If condition for IsNumeric(in_TransactionItem("CashIn")) then please use below condition (in_TransactionItem(“CashIn”).ToString).IsNumeric
HI Brother, again excellent video. my friends also started to watch your videos........ i have few questions..... 1. in this video you worked through Excel. in some other video you worked through queues. so my question is ,in real time projects, which one is practically workable and which one is efficient way to process the transactions? 2. pls do one video using retry scope in real time projects....... i have seen your retry scope video,but in that only one simple scenario, take multiple scenario and explain...
Hi manish hope you fine appreciate to make this awosome video but most of the people facing compile error while applying "IsNumeric.in_transectionitem.spacificcontent("cashIn"))" condition please give us solution for it😊
Thank you for the video Why did you use the kill process under close application, I believe you should close application using click activity under the close application workflow. There is a difference between close application and kill application. Please share your thoughts / input.
Thank you for watching my videos.. Yes we have a close application activity to close the application and Kill Process activity should only be used when there is any error in closing application.
Great Effort. in this case i want to use both queue & excel. I mean to say that i will take input from excel, add them to queue & and update both excel & Queue item. if possible upload a video or share xaml file for this. Thank You.
I have one more doubt. At which part the DataRow getting the value from the transactionData or the excel file where values are assigned of added to TransactionItem variable.
Hello great tutorial for reframework 🙂. Just currious cause im dealing with multiple sheets. does that mean i need to declare another applicationdata and transactionitem datarow and datatable if i will have to look up for value from one datatable to another? This is am confused of
I need help. Is it possible to use both excel updating (as you shown in this video) and queues at the same time. As in my current project it is client’s requirement to update the same information to queues as well. So he needs updated excel and queues as well. If yes, then how? As if we change data type of transactionitem to datarow for excel but also need queueitem for queues?
Hi Manish, Thankyou for the video. Can u do a video on that where if bot got stopped in the middle and again if we run it should take the next transaction item from where it got stoped earlier. Thankyou
Hey Manish, If I want to send only the first 10 rows out of 30 rows to process the transaction state, what should be the condition in Get Transaction State?
Hi sir, Please let us know difference between Non production Robot and Development Robot. I seen your previous videos but not cleared. Can you please give some example?
42:52 showing there expression as object. But u have entered in_transactionitem. It's datarow type. Still it accepted. In my project. it's not accepting. Showing validation error. Is there any correction to do?
Thank you bro. I have done one by reference this. I think this is amazing explanation. my question is --- (in_TransactionItem(“CashIn”).ToString).IsNumeric or (in_TransactionItem(“OnUsCheck”).ToString).IsNumeric and which you have used like IsNumeric(in_TransactionItem("CashIn")) though code is not working? It showing the error when used yours code.error like-- ......... explicit instance of a class. Please resolve the issue
Hi Team, thanks alot for the video it is very helpful. Just wanna highlight one thing, I did not get where you are filling the transaction item from transaction data Like in the else part you ar setting it to nothing but in the Then part the TransactionItem should be populated with the transaction data row.
Thank you very much maneesh you have done great work. I jave question i have followed same instruction as you given but when i call transactions items in process workflow with code in_transactionitem.item("collumn").tostring It throw exception with name "object reference not set to an instance of an object" Could you please explaim why i am viewing this?
Great efforts you kept in it. Have a doubt, any how we are not using Queues. So we can design the project in flowchart, instead of RE framework. Is it applicable ?
Here I got a doubt. While updating in excel you have used write cell in workbook activities. Data is been processed and updating action is also processing but why we didn't get any error. If we use Excel activities we will not get any error.
Hi Thanks for video , i have followed same steps but im getting error where you are assigning the data to TransactionItem (Assign TransactionField1: Object reference not set to an instance of an object.)
Hello Manish Sir, at 36:12 - is it necessary to change the condition for the "new transaction transition"? i guess the condition "TransactionItem IsNot Nothing" should also work ... please comment - Thank you
How to get specif data from Orchestrator in REFramewok in Process Transaction Activity. I mean which Variable hold this data, so that I can use it in below format : in_TransactionItem.SpecificContent(“ColumnNameFromOrchestrator”).ToString
Hello manish Ji, thanks much for this fabulous tutorial. I was trying to extract data from UIDemo app to excel but its not working. I sent you the workflow file in your mailbox. Please check and revert (if possible). Thanks in advance !!
We change UiPath.Core.QueueItem to System.Data.DataRow because we are not using orchastator , we are using from Excel. Can we also use System.Data.DataTable replacing UiPath.Core.QueueItem?
Hi Manish ..... I am adding an If Condition in the Process.xaml to check for Business Rule Exception aa guided in the video..... But as soon as I type IsNumeric and enter the arguments for it I am getting the following error:- Invoke ProcessTransaction workflow: The following errors were encountered while processing the workflow tree: 'Process': The private implementation of activity '1: Process' has the following validation error: Compiler error(s) encountered processing expression "IsNumeric(in_TransactionItem("CashIn")) Or IsNumeric(in_TransactionItem("OnUsCheck")) Or IsNumeric(in_TransactionItem("NotOnUsCheck"))". Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class. Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class. Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class. I am not sure why this is occurring and henceforth in any ReFramework program I’m unable to use IsNumeric condition....Please help
when I use is a numeric function its showing error :- ( compiler error(S) encountered processing expression " IsNumeric(in_TransactionItem("CashIn")) ". cannot refer to an instance member initializer without an explicit instance of the class
hi brother, i am trying to follow the same steps but got many errors. it will really help full if you share the project with me so i can compare it with mine.
hello Sir! if we stop the execution of robot during excel file processing, how can we start the execution from the same Row where the execution was stopped.I understood this problem with Queue,but i don't know how to do with excel. please help in this. thanks
If you use the Reframework it already has the capability to start the process from that where it is left. For better understanding you can learn my Reframework tutorials.
@@UiPathRPA Hi sir, i also have same doubt like dilsher khan asked but i could not understand your reply so in which title of reframework video you explained this logic?
Hi Manish can you please share the UI demo application file the file which I have does not takes credentials please share the one. And you are going great and big.😉
Dear , i'm facing an issue doing this. my throw activity stop the workflow and not work . i know that process is in try catch block. if exception occur in process transaction then it will go to the catches section of process transaction. but it is not going tell me how to solve this issue. thanks in advance Dear Manish sir
@@UiPathRPA i solve this issue. Firstly i debugging the project it will show error. I try run(project) not debug or runfile. The error is gone . I found this solution from forum
Hi sir for each and every video i watched clearly and if got struggle then i commented you in past RE Framework tutorial videos but still you did not reply don't take wrong with me. In this video i did all steps as per your steps but i am getting this error like If: Object reference not set to an instance of an object. System exception.Object reference not set to an instance of an object. at Source: If. the application opened three times but there is no transaction process. so please say the solution asap. Thank you.
Hi Rajesh, Your few comments were in Spam. I don't know how TH-cam moves few comments in likely spam section and hold for review. Object reference not set error occurs when we are using any variable/argument to store the value and using that value somewhere else but it has no value.
@@UiPathRPA Yes sir i resolved finally but you did not assign value for one variable but it was working for you but for me its throwing exception. That is Transaction field 2 LogF you did not assign any value but you got output but not for me so finally i removed that assign activity.
when I use is a numeric function its showing error :- ( compiler error(S) encountered processing expression " IsNumeric(in_TransactionItem("CashIn")) ". cannot refer to an instance member initializer without an explicit instance of the class
Hi, Yes, I hv faced same error while doing another process. Due to some update, now you will have to write it as xyz.IsNumeric to check if the string xyz contains numbers or not.
Thankyou so much !
Wow, definitely the best well explained tutorial for converting REF from reading queue items to excel I've ever seen. Thank you for putting this video out there.
Thank you so much James for appreciating me! Thank you for watching videos!
Very Informativevideo on REframework with excel..use this condition for all columns
IsNumeric(in_TransactionItem("Cash In")) And IsNumeric(in_TransactionItem("On US Check")) And IsNumeric(in_TransactionItem("Not On US Check"))= true
if you are facing issue in the If condition for IsNumeric(in_TransactionItem("CashIn")) then please use below condition
(in_TransactionItem(“CashIn”).ToString).IsNumeric
HI Brother, again excellent video. my friends also started to watch your videos........
i have few questions.....
1. in this video you worked through Excel. in some other video you worked through queues. so my question is ,in real time projects, which one is practically workable and which one is efficient way to process the transactions?
2. pls do one video using retry scope in real time projects....... i have seen your retry scope video,but in that only one simple scenario, take multiple scenario and explain...
Thank you Mastan!
Basically it depends on the company for which you will work.
But most of the company only use Queue or Database.
Very well explained project. It worked for me. Thanks a ton!
Thank you very much. Well explained everything.
Really amazing video, tried and works!!! Great effort and thank you very much :-)
Thank you so much for the compliment!
Thank you ! Detailed explanation.
Thanks for such excellent video.
Great video and a good business process will definitely help someone in there real-time project.
Thank you so much Saahil for great appreciation.
Super ! very helpful
Thankyou for your knowledge🤝🤝
ReFramework Input from Excel and output to the Excel
Hi manish hope you fine appreciate to make this awosome video but most of the people facing compile error while applying "IsNumeric.in_transectionitem.spacificcontent("cashIn"))" condition please give us solution for it😊
Thank you for the video
Why did you use the kill process under close application, I believe you should close application using click activity under the close application workflow. There is a difference between close application and kill application.
Please share your thoughts / input.
Thank you for watching my videos..
Yes we have a close application activity to close the application and Kill Process activity should only be used when there is any error in closing application.
Hi video was nice i have a doubt where you assigned datatable to data row can you explain pls
Great Effort. in this case i want to use both queue & excel. I mean to say that i will take input from excel, add them to queue & and update both excel & Queue item. if possible upload a video or share xaml file for this. Thank You.
I have one more doubt. At which part the DataRow getting the value from the transactionData or the excel file where values are assigned of added to TransactionItem variable.
excellent tutorial, thanks alot mate
Glad it helped
Hintli reis allah razı olsun çok yardımcı oldun, eyvallah
çok teşekkür ederim!
Hello great tutorial for reframework 🙂. Just currious cause im dealing with multiple sheets. does that mean i need to declare another applicationdata and transactionitem datarow and datatable if i will have to look up for value from one datatable to another? This is am confused of
I need help. Is it possible to use both excel updating (as you shown in this video) and queues at the same time. As in my current project it is client’s requirement to update the same information to queues as well. So he needs updated excel and queues as well. If yes, then how? As if we change data type of transactionitem to datarow for excel but also need queueitem for queues?
You can take two variable for each one for queue and second for data row.
Hi Manish, Thankyou for the video. Can u do a video on that where if bot got stopped in the middle and again if we run it should take the next transaction item from where it got stoped earlier. Thankyou
Hey Manish,
If I want to send only the first 10 rows out of 30 rows to process the transaction state, what should be the condition in Get Transaction State?
Hi sir, Please let us know difference between Non production Robot and Development Robot. I seen your previous videos but not cleared. Can you please give some example?
From where u r pasting that data from where can i get it to do the same project for practice?
42:52 showing there expression as object. But u have entered in_transactionitem. It's datarow type. Still it accepted.
In my project. it's not accepting. Showing validation error. Is there any correction to do?
Thank you bro. I have done one by reference this. I think this is amazing explanation. my question is --- (in_TransactionItem(“CashIn”).ToString).IsNumeric or (in_TransactionItem(“OnUsCheck”).ToString).IsNumeric and which you have used like IsNumeric(in_TransactionItem("CashIn")) though code is not working? It showing the error when used yours code.error like-- ......... explicit instance of a class. Please resolve the issue
Instead of OR use AND
@@UiPathRPA bro expecting some real time project
Hi Team, thanks alot for the video it is very helpful.
Just wanna highlight one thing, I did not get where you are filling the transaction item from transaction data
Like in the else part you ar setting it to nothing but in the Then part the TransactionItem should be populated with the transaction data row.
Thank you very much maneesh you have done great work. I jave question i have followed same instruction as you given but when i call transactions items in process workflow with code in_transactionitem.item("collumn").tostring
It throw exception with name "object reference not set to an instance of an object"
Could you please explaim why i am viewing this?
thnks so much you are great
Thank you!
Great efforts you kept in it.
Have a doubt, any how we are not using Queues. So we can design the project in flowchart, instead of RE framework. Is it applicable ?
With dispatcher and performer?
Thanks for explaining so perfectly. Can you please share UIDemo.exe file also to apply in the program.
Thank you so much Shanu! You can download exe from here drive.google.com/file/d/16p98-HjgZQtdivktl-Ln4TfdC098fuZp/view?usp=drivesdk
Pandey ji can you make one separate video , how to design uidemo file and how to import the data from uidemo to excel...your cooperation is required
Here I got a doubt. While updating in excel you have used write cell in workbook activities.
Data is been processed and updating action is also processing but why we didn't get any error. If we use Excel activities we will not get any error.
Yes because Workbook activities works fine in background without opening excel file.
Hi Thanks for video , i have followed same steps but im getting error where you are assigning the data to TransactionItem (Assign TransactionField1: Object reference not set to an instance of an object.)
Really appreciated to your work, Could you provide the same project files along with sample excel sheets if possible . it would helpful.
thank you so much sir
Hello Manish Sir, at 36:12 - is it necessary to change the condition for the "new transaction transition"? i guess the condition "TransactionItem IsNot Nothing" should also work ... please comment - Thank you
I am not sure. Please try with that too. Let me know if it works.
@@UiPathRPA it works. thanks for the video :)
Thank you
You're welcome
Hi... I got Error - Object reference not set to an instance of an object in Process state. can u pls explain
How to get specif data from Orchestrator in REFramewok in Process Transaction Activity. I mean which Variable hold this data, so that I can use it in below format : in_TransactionItem.SpecificContent(“ColumnNameFromOrchestrator”).ToString
excellent
Thanks!
Hello sir
One doubt I have is ..from where did you get the uidemo application?
Hi Snigdha, you can download it from here.
drive.google.com/file/d/16FXkiyrEwk35PwMMHC-OeZjWos4SGr7M/view?usp=drivesdk
Hello manish Ji, thanks much for this fabulous tutorial. I was trying to extract data from UIDemo app to excel but its not working. I sent you the workflow file in your mailbox. Please check and revert (if possible). Thanks in advance !!
Hi,
i'm getting error when i enter"Isnumeric(in_transcationitem("Cashin"). error : "cannot refer to instance of class"
I'm getting the same error. Can you solve it?
We change UiPath.Core.QueueItem to System.Data.DataRow because we are not using orchastator , we are using from Excel.
Can we also use System.Data.DataTable replacing UiPath.Core.QueueItem?
I have not tried with Datatable instead of Datarow. Because I believe it doesn't work.
Type into activity is not selecting the right path it selecting the entire application can I know the solution
Do you have the link to download this file? Thank you.
Hi Manish ..... I am adding an If Condition in the Process.xaml to check for Business Rule Exception aa guided in the video..... But as soon as I type IsNumeric and enter the arguments for it I am getting the following error:-
Invoke ProcessTransaction workflow: The following errors were encountered while processing the workflow tree:
'Process': The private implementation of activity '1: Process' has the following validation error: Compiler error(s) encountered processing expression "IsNumeric(in_TransactionItem("CashIn")) Or IsNumeric(in_TransactionItem("OnUsCheck")) Or IsNumeric(in_TransactionItem("NotOnUsCheck"))".
Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
I am not sure why this is occurring and henceforth in any ReFramework program I’m unable to use IsNumeric condition....Please help
+Ishan Dhaliwal Hi Ishan, instead of OR operator between fields you can use AND operator to check for numeric.
UiPath RPA Thanks Manish but I am getting the error as soon as I type in IsNumeric.... Not sure why because there is no class concept in UIPath
when I use is a numeric function its showing error :- ( compiler error(S) encountered processing expression " IsNumeric(in_TransactionItem("CashIn")) ". cannot refer to an instance member initializer without an explicit instance of the class
Please use "in_TransactionItem("CashIn").IsNumeric".
hi brother, i am trying to follow the same steps but got many errors. it will really help full if you share the project with me so i can compare it with mine.
How to do this using queue
hello Sir!
if we stop the execution of robot during excel file processing, how can we start the execution from the same Row where the execution was stopped.I understood this problem with Queue,but i don't know how to do with excel.
please help in this.
thanks
If you use the Reframework it already has the capability to start the process from that where it is left. For better understanding you can learn my Reframework tutorials.
@@UiPathRPA Hi sir, i also have same doubt like dilsher khan asked but i could not understand your reply so in which title of reframework video you explained this logic?
Can U please share the excell file used for app uidemo
can You Send Sample uidemo Form for download
@UiPath RPA - Thanks mate for such a great explanation.
Could you please help me with the UserName and Password of UiDemo.exe
admin
password
can I get the excel file
how I can check isnumeric for other column please tell me
You can change the name of that column.
What is the difference between In_transaction item and Out_transaction item please tell me
Please watch this video :th-cam.com/video/zrbxNg8QSPg/w-d-xo.html
if
(
IsNumeric(in_TransactionItem.SpecificContent("CashIn"))
)
compiler error
help me
Please use "in_TransactionItem("CashIn").IsNumeric".
GetAppCredentaials. is missing from frameworks in new version. WHat action need to take now.
Go to github page of ReFramework and download the project. You will get it there.
github.com/UiPath/ReFrameWork
or use get credentails activity from activity panel
Hi Manish can you please share the UI demo application file the file which I have does not takes credentials please share the one. And you are going great and big.😉
Are you looking for UIDemo exe?
@@UiPathRPA yes.
drive.google.com/file/d/16p98-HjgZQtdivktl-Ln4TfdC098fuZp/view?usp=drivesdk
Ty so much
business exception error--IsNumeric(in_transactionItem("Cash In").ToString)
it show error compile error. how can i resolve
Do not convert this to String because you are checking for isnumeric and you are using ToString as well.
(in_TransactionItem(“CashIn”).ToString).IsNumeric
bhai hindi mein zyada badhiya hota hai aapke lectures.
Thank you so much! You are right but my lots of followers do not understand Hindi.
Dear , i'm facing an issue doing this. my throw activity stop the workflow and not work . i know that process is in try catch block. if exception occur in process transaction then it will go to the catches section of process transaction. but it is not going tell me how to solve this issue.
thanks in advance Dear Manish sir
You can take a system. Exception in catch and then use catch and pass exception in throw.
@@UiPathRPA i solve this issue. Firstly i debugging the project it will show error. I try run(project) not debug or runfile. The error is gone . I found this solution from forum
I have a doubt, suppose we have 2 different excel file open and now i need to close a particular excel file. How can I do that.
You have to identify that excel with name using Selector.
@@UiPathRPAok, Got it
getAppCredential.xaml file is missing
Where is Out_Transactionitem value assigned
Hi Manish, can you provide this XML file?
Hi sir for each and every video i watched clearly and if got struggle then i commented you in past RE Framework tutorial videos but still you did not reply don't take wrong with me. In this video i did all steps as per your steps but i am getting this error like If: Object reference not set to an instance of an object.
System exception.Object reference not set to an instance of an object. at Source: If. the application opened three times but there is no transaction process. so please say the solution asap. Thank you.
Hi Rajesh, Your few comments were in Spam. I don't know how TH-cam moves few comments in likely spam section and hold for review.
Object reference not set error occurs when we are using any variable/argument to store the value and using that value somewhere else but it has no value.
@@UiPathRPA Yes sir i resolved finally but you did not assign value for one variable but it was working for you but for me its throwing exception. That is Transaction field 2 LogF you did not assign any value but you got output but not for me so finally i removed that assign activity.
how to login uipath demo
Steps have been shown in video
Please share the project files on github
where the files to download
Which files are you looking for?
@@UiPathRPA transaction.xlsx,uidemo
drive.google.com/file/d/16p98-HjgZQtdivktl-Ln4TfdC098fuZp/view?usp=drivesdk
And transaction file you can make your own. It is just sample.
Hi sir, could you please tell us step by step by doing. Because your already derived then explaining so it is not understanding thats y.
How I can install Uidemo.exe please tell me
drive.google.com/file/d/16p98-HjgZQtdivktl-Ln4TfdC098fuZp/view?usp=drivesdk
when I use is a numeric function its showing error :- ( compiler error(S) encountered processing expression " IsNumeric(in_TransactionItem("CashIn")) ". cannot refer to an instance member initializer without an explicit instance of the class
Hi, Yes, I hv faced same error while doing another process. Due to some update, now you will have to write it as xyz.IsNumeric to check if the string xyz contains numbers or not.