I will be getting excel files every month in which spanish language month names will be added.
For e.g. Employee Details junio 2021.xlsx and I need to process these excel files in next month
June month file will get processed in July month.
How can I check for spanish month names from a file name in a folder?
Step 2: Let’s now define the date of Today and store it in a variable of type Datetime “date_today”, this is because we are going to extract from this variable the desired month (current month -1)
Hi, I’m also having issues with culture info but, in my case, the issue appears when trying to convert the date that I’m reading with the robot.
I read my date from an excel using an “Assign” activity, I assign “Excel_Historico.Sheet(Nombre_Hoja_En_Excel_Historico).Cell(“A2”).ToString” to my variable string “UltimoMovimiento_FechaValor”.
I try to convert the date in order to calculate or compare dates, so I try to assign “DateTime.ParseExact(UltimoMovimiento_Fecha.Replace(“00:00:00”,”“).trim,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture)” to the date variable “UltimoMovimiento_FechaValor_FormatoFecha”.
It worked perfectly in my computer, but when I published the automation for my finances collegue, in her computer she’s having this error:
I finally solved my issue, but this is always complex to manage diferent cultures, if this is a bit complex for me…I can’t imagine what it is for non-informatic users, they become mad with this and this is a basic need to automate, even the most simplest process can need more or less complex dates management.
Why UiPath don’t develops language-culture input and output properties and multi-language functionnalities for activities? (for example, also for selectors, to be able to develop for the same page in multiple languages without needing to change my whole computer language and make a reboot to configure the second language in a parallel branch)
I think it can be a SUPERUSEFUL integration that a lot of people will strongly appreciate!!
I think that this is a basic problem that blocks UiPath grow, when I train people in my company, they always get frustrated by language handling and they don’t like the idea that their automation will only work in a single language or that they need to “duplicate” efforst to develop something that can handle other languages…a lot of people stops using UiPath when they see this point.
Yes, I know, I already submitted the idea some weeks ago, I hope they will like and implement it.
In StudioX we don’t always have acces to the ressources you indicated (for example I tried to detect the computer language but there is no activity for it and using code it don’t works, it always give value “iv”). From my side, I can access Advances Studio as I’m part of IT and I have an advanced developer licence but I always try to automate in StudioX to give more feedback, ideas and examples to the rest of my colleagues who are all using StudioX and having very little knowledges. My ideas are most focused there, on StudioX because they are the ones who are sometimes non-informatic users and who need this kind of helps when they try to create their automations.