This video is an excellent tutorial on how to insert data into a database using UiPath. Mukesh Kala does a great job of explaining the process step-by-step and provides helpful visuals to make it easier to understand. I especially appreciate the tips and tricks he provides to make the process more efficient. This video is a great resource for anyone looking to automate their database processes with UiPath. Highly recommended!
Hi bro, you are doing some great videos. It's really helpful. On this Video I have one doubt. I noticed, In SQL table and excel sheet has headers in same order. Will it required to main the headers/column name in same order. Can we insert the data to corresponding columns of the table even if the alignment/order is different between SQL table and input data table. Please clarify me bro! Thanks in advance ! @Mukesh Kala
Hi Mukesh Kala, This video help a lot for inserting the data into the SQL data base. Is it possible to compare the SQL data and the input data from the Excel and if any duplicates available in the Input sheet no need the add the data into the SQL data base.
YEs you can - so both excel and datatbase would provide you datatable - now we need to compare 2 datatables - see this : th-cam.com/video/y5tVZCeLcjM/w-d-xo.html
Hi, thank you for this series! I am facing a huge distress, could you please look at this? Datatable is not being inserted to sql because of datatype mismatch (string to int). in local DT there is this string column which has the value of "1,000,000,000", meanwhile in sql server it has the value type of decimal(20,2). What can I do to change my DataTable? Thank you!
While inserting the data table into the database, if some of the rows are already exists, then finding the duplicates will be taken care by UiPath? or the SQL server should be designed in that way? Please reply with the activity name
With UiPath we can do it - 1. Read the complete data from DB using execute Query - This would give you a DT 2. Use Lookup datatable activity to search the data before existing 3. Alternatively - we can also use a LINQ Query to see if a Data Exist in DT 4. If Exist : Skip Otherwise :Insert
I have already uploaded a playlist for Support Role , For Interview Questions and Answer - Best would be to appear in a Mock interview with me - I can arrange one - Let me know if that would help
Hi there Mukesh, Im not sure why when i run command activity push single data its a asuccess but when i try using insert activity it prompt error [42000] error in your sql syntax. Using this activitry i cannot check my sql syntax. plus my excel data is straightfoward i dont know why it fail to insert.
Hi Mukesh. I have created table in DB. And used insert activity to insert data but while inserting data getting error as cannot convert string to int32. I checked found that if there is customer column any row value is blank then it gives me this error even if I have allow null value in DB while creating table. Is there any alternative for this? Please revert. Thank you
string to int32 simply means that the column is integer and you are trying to put string - What you can do is - Put Default value as Zero in the DB or in the code , mention if its null / whitespace - Put 0
This video is an excellent tutorial on how to insert data into a database using UiPath. Mukesh Kala does a great job of explaining the process step-by-step and provides helpful visuals to make it easier to understand. I especially appreciate the tips and tricks he provides to make the process more efficient. This video is a great resource for anyone looking to automate their database processes with UiPath. Highly recommended!
Thank you for your Visit , Appreciate Your Feedback 😍
Hi bro, you are doing some great videos. It's really helpful. On this Video I have one doubt. I noticed, In SQL table and excel sheet has headers in same order. Will it required to main the headers/column name in same order. Can we insert the data to corresponding columns of the table even if the alignment/order is different between SQL table and input data table. Please clarify me bro! Thanks in advance ! @Mukesh Kala
Yes we can , in your insert query make sure you map them in the correctorder (col3,col1,col2) values (V_col3, V_Col1, V_Col2)
Hi Mukesh Kala, This video help a lot for inserting the data into the SQL data base. Is it possible to compare the SQL data and the input data from the Excel and if any duplicates available in the Input sheet no need the add the data into the SQL data base.
YEs you can - so both excel and datatbase would provide you datatable - now we need to compare 2 datatables - see this : th-cam.com/video/y5tVZCeLcjM/w-d-xo.html
Hi, thank you for this series! I am facing a huge distress, could you please look at this?
Datatable is not being inserted to sql because of datatype mismatch (string to int). in local DT there is this string column which has the value of "1,000,000,000", meanwhile in sql server it has the value type of decimal(20,2). What can I do to change my DataTable? Thank you!
You have to just convert the datatype in the datatable.
Refer : forum.uipath.com/t/convert-the-data-type-of-column-of-datatable/356139/5
While inserting the data table into the database, if some of the rows are already exists, then finding the duplicates will be taken care by UiPath? or the SQL server should be designed in that way? Please reply with the activity name
With UiPath we can do it -
1. Read the complete data from DB using execute Query - This would give you a DT
2. Use Lookup datatable activity to search the data before existing
3. Alternatively - we can also use a LINQ Query to see if a Data Exist in DT
4. If Exist : Skip Otherwise :Insert
Please upload the interview point of senario based topics for rpa uipath production support role video
I have already uploaded a playlist for Support Role , For Interview Questions and Answer - Best would be to appear in a Mock interview with me - I can arrange one - Let me know if that would help
Hi there Mukesh, Im not sure why when i run command activity push single data its a asuccess but when i try using insert activity it prompt error [42000] error in your sql syntax. Using this activitry i cannot check my sql syntax. plus my excel data is straightfoward i dont know why it fail to insert.
Whatever Query your Automation has created - Put it in SQl Editor and check for Syntax validation
Hi Mukesh. I have created table in DB. And used insert activity to insert data but while inserting data getting error as cannot convert string to int32. I checked found that if there is customer column any row value is blank then it gives me this error even if I have allow null value in DB while creating table. Is there any alternative for this?
Please revert. Thank you
string to int32 simply means that the column is integer and you are trying to put string - What you can do is - Put Default value as Zero in the DB or in the code , mention if its null / whitespace - Put 0