we have 30000 records in a excel and everytime the excel crashes when data are uploading in queqe . how can we rectify it .
3.we are migrating bot from dev to production environment and it was working fine in development environment and not in production (web automation ) what are the possible reasons
how to reverse “my name is pooja” if given string is variable=“my name is pooja”
basically output has to be " pooja is name my " how to do this
1 Answer - The Input of the Bulk add Queue Item activity is the datatable. You can add all data in the datatable to queues at a time with out iterating through each row in datatable.
2 Answer - You have to make the data as chunks and iterate the each chunk to add the data to queues, by following this way you can rectify the excel crash. Rather than using the excel activities, use workbook activities.
3 Answer - May be there is a issue with the selectors, fine tune the selectors to make it dynamic then it will work on both development and production environment.
4 Answer - You can achieve it by using the Reverse function. Check the below expression,
- Assign -> Input = "my name is pooja"
- Assign -> Output = String.Join(" ", Input.toString.Split(" "c).Reverse())
5 Answer - You can convert the string to DateTime by using the below syntax,
- Assign -> DateTimeVar = CDate(StrVar)
If the above not works then try to use the below expression,
- Assign -> DateTimeVar = DateTime.ParseExact(StrVar, "Give String Date format here", System.Globalization.Cultureinfo.InvariantCulture)
StrVar is the String datatype variable.
DateTimeVar is the DateTime datatype variable.
I have answered all of your questions, if you have any queries in that let me know.
My friend, the first and last question you can find by yourself. I will give you a tip only for those ok?
1 - In bulk add queqe item what is the input ?
In Studio, for all the input or output you can see by hovering your mouse on the arugment name and waiting a little, otherwise you could click on the expression/value field and pres ctrl+k that a variable of the same type will be created for you:
You can algo press F1 after clicking on the activity to open it help page that can answer your question.
2 - we have 30000 records in a excel and everytime the excel crashes when data are uploading in queqe . how can we rectify it
For this question, we have to take a better look in your development.
30K rows are a lot, and in weak machines can cause trouble if you are reading all of them together.
30K is more than “Bulk Add queue Items” can handle in a single call as well.
3 - we are migrating bot from dev to production environment and it was working fine in development environment and not in production (web automation ) what are the possible reasons.
It depends on what error are you getting. Differences between the machines like processing power, memory and disk space can cause that.
4 - how to reverse “my name is pooja” if given string is variable=“my name is pooja”
You can try to split your string by space, that will give you a array of string, where each position would be equals to a word in your phrase. Now, you use a for each that will walk through your array from the last position, and append this position word to your result variable.
